Search
Tag Cloud
10.2.0.5 10g 11.1 11.2 ADR agent alertlog ASM base64 bug bundle patch codetable constraint database database appliance digest diskgroup encryption enterprise manager gi grid control grid infrastructure hashes LinkedIn listener monitoring oak oakcli ODA OEM ORA oracle oracle database appliance password patch bundle PLSQL privileges RAC sha1 solaris timestamp troubleshooting unwrap wrap zipCategories
-
Recent Posts
Blogroll
Category Archives: RAC
ORA-600 [kkpo_rcinfo_defstg:objnotfound] on a 11.2 RAC instance
RECOMMENDATION: Set the deferred_segment_creation parameter to FALSE for 11.2 RAC databases! Recently our monitoring picked up an ORA-600 from the alertlog of one of our 11.2 RAC instances. ORA-00600: internal error code, arguments: [kkpo_rcinfo_defstg:objnotfound],[87421], [], [], [], [], [], [], … Continue reading
Oracle RAC – granting SYSDBA or SYSOPER is instance specific
The default location for the password file is $ORACLE_HOME/dbs which in most cases (if you don’t have your ORACLE_HOME on a shared disk) is on a non-shared filesystem. Whenever you grant SYSDBA or SYSOPER to a database user Oracle will … Continue reading
Posted in RAC
Tagged 11.2, database, database appliance, LinkedIn, ODA, oracle, oracle database appliance, password, password file, privileges, RAC, SYSDBA, SYSOPER
Leave a comment
ORA-00245: control file backup operation failed
A snapshot controlfile is a read consistent copy of a database controlfile which RMAN creates because the controlfile is changed constantly. As of Oracle 11.2 (11.2.0.2 to more precise) the snapshot controlfile must be on a location shared by all … Continue reading
Posted in RAC
Tagged 11.2, 11.2.0.2.0, alertlog, database, database appliance, LinkedIn, ODA, ORA, oracle, RAC, troubleshooting
1 Comment