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…
Read Full RecipeTag: 10g
10gR2 Silent Install with 11gr2 CRS fails
I was trying to perform a 10.2 silent install with 11gR2 CRS. While doing pre-checks installer failed with following error Check complete: Failed <<<< Problem: The 'active' version of Oracle…
Read Full Recipe
Effect Of Multiple SHMMAX Settings
Last week I saw a warning message at database startup time saying: WARNING: EINVAL creating segment of size 0x000000000f0020xx fix shm parameters in /etc/system or equivalent It is an Oracle…
Read Full Recipe
Physical Corruption: ORA-1578 part 3
Recently we encountered a block corruption issue in 10g database on Linux x86 64 bit and using ASM for storing database files. Saurabh had earlier written articles on ora-1578. http://askdba.org/weblog/2008/04/physical-corruption-ora-1578-part-1/…
Read Full Recipe
Cloning RAC Database with RMAN fails with error
Steps for cloning a RAC database with RMAN is similar to cloning a single instance database. But while using rman duplicate in 10g, you will get following errors RMAN-00571: ===========================================================…
Read Full Recipe
DBMS_SCHEDULER jobs not running?
I came across this posting on OTN which lists down things to check in case your scheduler job is not . This is quite old and many of you would…
Read Full Recipe