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…
Read Full Recipe
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…
Read Full Recipe
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…
Read Full Recipe
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…
Read Full Recipe
Oracle 11gR2 DBMS_STATS introduced useful function report_col_usage to report column usage i.e if column is being used for equality,like predicates. I came to know it while reading Optimizer whitepaper .As per…
Read Full Recipe
I have been using firefox on a linux desktop since last week. Lot of sites on internet are using flash player on it , so everytime I hit the site,…
Read Full Recipe