Saturday, April 27, 2013

ORA-600 [],[],[],[],[] - Now what to do

›
ORA -600 -  What to do ? ORA-600  is an internal error generated by the generic kernel code of the Oracle RDBMS software. Step 1    ...

ORA-7445 Followed By ORA-1000 "MAXIMUM OPEN CURSORS EXCEEDED" Error

›
ORA-7445 Followed By ORA-1000 "MAXIMUM OPEN CURSORS EXCEEDED" Error I see the errors : ORA-07445: exception encountered: cor...

ORA-12154: TNS:could not resolve the connect identifier specified - [Oracle support Note ID 114085.1]

›
Troubleshooting Guide for the TNS-12154 Error (Also Applies to Troubleshooting TNS-03505)     The TNS-12154 (ORA-12154) means th...

ASM ORA-00020: maximum number of processes

›
ASM - ORA-00020: maximum number of processes The Oracle parameter PROCESSES has been exceeded as a result of multiple database ins...

Procedure - Startup and Stopping Oracle Database - Oracle Support Note ID 1020192.6

›
The Startup Procedure There are three stages in starting an Oracle database: · Start the instance · Mount the database · Open the ...

Shutdown of Database quickly based on how much rollback is needed for clean shutdown

›
Quick way to shutdown cleanly when multiple sessions are active Obviously SHUTDOWN ABORT  is the fastest way to shutdown an Oracle da...

DBCA Does Not Display ASM Disk Groups In 11g

›
Problem -  When I launched DBCA as Database home owner e.g. oradb the DBCA gets to the screen to select the disk groups but no Disk Groups...

Debugging / Tracing DBCA

›
1. Do a copy of the original dbca file in $ORACLE_HOME/bin. For example: cp $ORACLE_HOME/bin/dbca $ORACLE_HOME/bin/dbca.ori 2...

RMAN-06004 RMAN-20001: target database not found in recovery catalog

›
RMAN-06004 RMAN-20001: target database not found in recovery catalog RMAN commands are failing with RMAN-20001 error message. RMA...