Tag Archives: troubleshooting

Oracle Database Appliance – Installing Patch Bundle 2.1.0.3.0

Posted on March 22, 2012 by marcel

We just finished installing ODA Patch Bundle 2.1.0.3.0 on one of our ODA’s….. There goes one of the key features for the ODA – Simple one-button patch installation. As a DBA (and I think all administrators) are very reserved when … Continue reading →

Posted in Database Appliance | Tagged , , , , , , , , , , , , , , , | Leave a comment

ORA-00245: control file backup operation failed

Posted on January 9, 2012 by marcel

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 , , , , , , , , , , | 1 Comment

Solaris SMF Oracle Grid agent service killing Oracle instance

Posted on August 22, 2011 by marcel

In the last couple of months we had some strange problems with all processes of Oracle database and ASM instances just disappearing. The shared memory segment was still there and you could connect internally to the instance, even execute some … Continue reading →

Posted in Enterprise Manager | Tagged , , , , , , , , , , | Leave a comment

adrci – No ADR base is set

Posted on May 23, 2011 by marcel

Some time ago we had a problem using the adrci (ADR Command Interpreter) to look into some diagnostic information for a listener. After staring up the tool it came back with the warning “No ADR base is set”, even while … Continue reading →

Posted in Database | Tagged , , , , , , | 3 Comments

Simulating ORA-errors

Posted on May 12, 2011 by marcel

Sometimes it can be useful to simulate a problem in your database by simulating an ORA-error. After we had a nasty bug with Grid Control (GC suddenly wasn’t able to monitor the alertlog of 10.2.0.5 databases anymore, see my post … Continue reading →

Posted in Database | Tagged , , , , , , , , , , | Leave a comment

Constraint Exceptions

Posted on March 26, 2011 by marcel

When adding or enabling a constraint on a table, it is possible that an error occurs because of an constraint violation.  If for example you are trying to add a unique constraint to a column (or combination of columns) of … Continue reading →

Posted in Database | Tagged , , , , | Leave a comment