ORA-12514 due to DNS issue

A User reported ORA-12514 error from JDBC application connecting to RAC database ORA-12514: TNS:listener does not currently know of service requested in connect descriptor To troubleshoot it, a)I checked following…

Continue Reading ORA-12514 due to DNS issue

Sqlplus HTML reports

I was working on setting up monitoring for application team to monitor AQ and wanted html formatting of table data. On searching I found this link from Ittichai Chammavanijakul  which makes…

Continue Reading Sqlplus HTML reports

11gR2:Oracle Online Patching

Online patching is new feature introduced in 11.1.0.6 and oracle started delivering patches with 11.2.0.2. This patch allows you to apply patch to live database i.e we do not need…

Continue Reading 11gR2:Oracle Online Patching

11gr2-Formatted crsctl output

If you don't like crsctl status res –t output then try using below :) Can also download here crsstat11g. I have tried this on linux crsctl status res |grep -v "^$"|awk…

Continue Reading 11gr2-Formatted crsctl output