Full Database Export Failing With ORA-00980
While trying to do a full export for 10.2.0.3 database, we were getting following errors About to export the entire database ... . exporting tablespace definitions . exporting profiles .…
Read Full RecipeTag: 10g
Question:Sizing ASM LUN
We received following question from Mr Orlando through our Contact Page How about a discussion on how to size our LUNS to use with ASM. For instance we have a…
Read Full Recipe
How To Recover From Corrupted OCR Disk
It is very common where a DBA is left with corrupted OCR disk without having any good backup. The same situation was experienced by me few days back. One node…
Read Full Recipe
Issues with CLUSTER_DATABASE parameter
Yesterday, I faced an interesting scenario while upgrading 2 Node RAC Database. I tried setting up CLUSTER_DATABASE=FALSE in spfile from Node 1,but it displayed value as TRUE after restarting database.Same was…
Read Full Recipe
Using RDA As RDBMS Pre-Install Check Tool
Many of us would have come across RDA (Remote Diagnostic Agent) while working on a ticket with Oracle support. In case you have not heard about it, I would recommend…
Read Full Recipe
Checking Database Feature Usage Stats
Today I came across view DBA_FEATURE_USAGE_STATISTICS (10g) which let's us know whether particular Database Feature has been used till now or not. If yes, then it also let's us know…
Read Full Recipe