Tag Archives: issue

ASM MEMBER disks showing as CANDIDATE

Some time ago I spent a few hours troubleshooting an issue where some 20 ASM member disks went all to either CANDIDATE or PROVISIONED status after the servers were rebooted. That’s odd because if the disks were really removed from … Continue reading

Posted in Availability, Oracle, Troubleshoot | Tagged , , , , | Leave a comment

Troubleshooting ORA-600[qsmoDropPlans:1] on SPM

Some time ago I got this error message: Errors in file /u01/app/oracle/diag/rdbms/mydb/mydb1/trace/mydb1_m000_15032.trc  (incident=354123): ORA-00600: internal error code, arguments: [qsmoDropPlans:1], [], [], [], [], [], [], [], [], [], [], [] ORA-06512: at “SYS.DBMS_SPM”, line 2444 ORA-06512: at “SYS.DBMS_SPM_INTERNAL”, line 775 … Continue reading

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

Troubleshooting ORA-16632 in RAC + DG + broker.

When you add a RAC node to a Data Guard, or in the case one instance was down when you created the broker configuration and later you bring it up, the broker will try to add the new instance to … Continue reading

Posted in Oracle | Tagged , , | Leave a comment

New Connections to 11gR1 taking too long?

The issue: Sometimes, when you connect to a 11gR1 database remotely (or locally using TCP), it takes a very long time until the connection is established. Once connected, everything works fine. The cause: The DNS servers listed in the database … Continue reading

Posted in Oracle, Performance | Tagged , , | Leave a comment