Tag Archives: 11g

11g: handling error ORA-00752 – lost write of a data block in the PRIMARY database

With the recent (11gR1) addition of lost write detection techniques, Oracle has one more tool to help avoid data losses. Prerequisites to it are having a physical standby database applying logs and the parameters enabled in both the primary and … Continue reading

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

Troubleshooting ORA-600[qsmoDropPlans:1] on 11.1.0.7 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

How to confine a set of users to the Active Data Guard DB only

Active Data Guard is a new (paid) feature of Oracle 11g where a physical standby database can be open for read-only access while Redo Apply is simultaneously active. With the objective of relieving the production database from a group of … Continue reading

Posted in Oracle, Performance | 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