RMAN Disaster Recovery on the same host Oracle 11g
At times, there will be a requirement to restore from an old database backup to extract or to resolve a logical corruption and you may… Read More »RMAN Disaster Recovery on the same host Oracle 11g
Tuning query plan regression using AWR
After changing the available CPU cores on one of the Servers, we have started noticing “enq: TX – row lock contention” wait events taking nearly… Read More »Tuning query plan regression using AWR
RMAN backups fail with ORA-19504 and ORA-27054 errors
While setting up RMAN backups on a new Solaris 11 server with a NAS drive shared over NFS v3, noticed the below errors.. ORA-19504: failed… Read More »RMAN backups fail with ORA-19504 and ORA-27054 errors
SQLcl ezconnect with special characters!@
While connecting to a remote Oracle database using SQLcl ezconnect syntax with special characters in the password, the syntax requires below escape characters (\), especially… Read More »SQLcl ezconnect with special characters!@