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 RecipeI 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 RecipeI 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 RecipeLast 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 RecipeRecently 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 RecipeSteps 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 RecipeI 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