Soluții

Cum rezolvam „Eroarea 0xc000021a” in Windows

Blue Screen of Death, aka BSOD, aceste erori sunt considerate a fi cel mai rau tip de erori de tratat. Ele apar in principal din cauza unei erori de sistem sau a unei erori fatale si pot cauza probleme grave, cum ar fi instabilitatea sistemului, potentiala pierdere de date si multe altele.
In majoritatea conditiilor, aceste erori BSOD ne impiedica sa accesam sistemul de operare Windows. Prin urmare, rezolvarea acestor erori devine foarte importanta si dificila. Acelasi lucru se Intampla cu eroarea codului de oprire 0xc000021a pe Windows.
Acest cod de eroare 0xc000021a si alte erori BSOD pot aparea din mai multe motive:
-Dispozitive externe incompatibile
-Sectoare de hard disk corupte
-Virusi sau programe malware
-Intrari din registry Windows configurate gresit
Acestea sunt cele mai frecvente motive care declanseaza acest cod de eroare BSOD 0xc000021a. De multe ori, ramanem blocati in bucla de pornire si nu putem porni computerul daca avem de-a face cu codul de eroare BSOD 0xc000021a.

[mai mult...]

Find Blocked Sessions

1. find blocked sessions and blocking session

SQL>
select l1.sid “blocking session”, l2.sid “blocked session”
from v$lock l1, v$lock l2
where l1.sid != l2.sid and l1.id1 = l2.id1 and l1.id2 = l2.id2 and
l2.request > 0 and l1.block = 1;

2. find how long the blocked session is waiting:

SQL>
select
blocking_session “blocking_session”,
sid “blocked_session”,
serial# “blocked_serial#”,
seconds_in_wait/60 “wait_time(min)”
from v$session
where blocking_session is not null
order by blocking_session;

3. find which SQL command is waiting

SQL>
select s.sid, s.serial# ser#, s.process os_id, s.status, sql.sql_fulltext
from v$session s, v$sql sql, v$process p
where
s.sql_id=sql.sql_id and
s.sql_hash_value=sql.hash_value and
s.paddr=p.addr and
s.sid=&enter_blocked_session_sid;

4. resolving locks
If the Blocking session do not issue COMMIT, ROLLBACK or disconnects from the database,
Then you can kill that session — After having the approval from the owner of the sql such application team if is involved user/app schema, DBA/Oracle Support if the sql is database internal).

SQL>
alter system kill session ‘SID,Serial#’;

[mai mult...]

Oracle 19c: how to dump events for a session

sqlplus as / sysdba

SELECT pid, spid FROM v$process where addr IN (SELECT paddr FROM V$session where sid = 131);

oradebug setorapid <PID from v$process>
oradebug eventdump session ;
oradebug tracefile_name
quit

Next, go to the file and search for “eventdump session” and/or “Dumping Event (group=SESSION”

[mai mult...]

Cum remediati „Eroarea 0x80072ee7” pentru o experienta fara intreruperi in Windows

Intampinarea erorii 0x80072ee7 este o problema comuna pentru numerosi utilizatori Windows. Aceasta eroare frustranta poate aparea in timpul incercarii de a accesa Magazinul Microsoft, la actualizarea aplicatiilor sau chiar la instalarea actualizarilor Windows. Aceasta eroare impiedica accesul la Magazin, ceea ce face dificila descarcarea de software sau actualizarea aplicatiilor existente.
Daca ne confruntam cu acest cod de eroare si nu putem rula cea mai recenta versiune a sistemului de operare sau a unei aplicatii, putem incerca sa o remediem. Eroarea 0x80072ee7 este o problema comuna intalnita de utilizatorii Windows 11, 10 si alte versiuni. In ciuda prevalentei sale, cauza exacta a acestei erori ramane necunoscuta. Un posibil motiv pentru aparitia acestuia ar putea fi setarile incorecte TCP/IPv4 de pe sistem.
Cand apare aceasta eroare, sistemul nostru nu poate gasi adresa IP corespunzatoare pentru a stabili o conexiune cu serverul Windows Update. In consecinta, atat site-urile web Windows Update, cat si Microsoft Update devin inaccesibile, ceea ce duce la afisarea mesajului de eroare 0x80072ee7 atunci cand incercam sa cautam actualizari ale sistemului de operare si actualizari de aplicatii disponibile in Microsoft Store. De altfel si alte probleme de sistem pot contribui la declansarea acestei erori. Pentru a remedia aceasta problema windows trebuie sa parcurgem urmatorii pasi.

[mai mult...]

How to screen-mirror an iPhone to a Samsung TV

1. Go to the Settings on your Samsung TV

First, you’ll need to tap the Settings button at the top of your remote to bring up the hovering menu option. Next, use the circle at the top of your remote to move your cursor all the way to the right, where you’ll find the option to choose “All Settings”.

2. Scroll to the General tab

Next up, you’ll need to scroll down to the Connection tab, where you’ll find the Apple AirPlay Settings option that we’ve been seeking from the very start. From there, a black screen will appear with an AirPlay logo and four gray boxes on the right side of the screen, allowing you to toggle AirPlay on or off (it’s on by default), whether to choose a code for logging on, and more.

3. Turn AirPlay on and adjust settings

While there are four gray boxes on the screen, you will only need to adjust the top three settings based on your preference. Turn on AirPlay, and adjust the Require Code and Subtitles and Captioning settings based on your personal preference.

4. Open the app on your iPhone that you want to stream or mirror

The AirPlay logo is a TV with the Wi-Fi logo diagonal across it. When you see that logo on your app, click the button and a drop-down menu will appear where you can select the TV you wish to stream on.

If this is your first time setting up AirPlay on your Samsung TV, it may require a code on your iPhone. If this is the case, once you select the TV from the AirPlay menu, a code will appear on the TV screen prompting you to enter it on your iPhone. Simply input the code and wait a split second while Apple verifies it’s the same as the one displayed on your TV.

[mai mult...]