Monthly Archives: February 2008

Resolving ORA-16714 / ORA-16792

Problem: In an environment, where Data Guard Broker is configured, parameter MAX_EVENTS_RECORDED is changed using SQL*Plus ALTER DATABASE STOP LOGICAL STANDBY APPLY; EXECUTE DBMS_LOGSTDBY.APPLY_SET (‘MAX_EVENTS_RECORDED’, ‘5000’); ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE; On the primary database, we see following … Continue reading

Posted in Oracle Data Guard, Oracle Logical Data Guard | Tagged | 1 Comment

Monitoring SQL APPLY process

+Current state of Logical standby SELECT INST_ID, SESSION_ID, STATE FROM GV$LOGSTDBY_STATE / INST_ID,SESSION_ID,STATE ==================== 1,22,NULL 2,22,APPLYING +Current active processes assiciated with SQL APPLY SELECT SID, SERIAL#, SPID, TYPE FROM GV$LOGSTDBY_PROCESS / SID,SERIAL#,SPID,TYPE ================= 376,14368,1904,COORDINATOR 363,8,14936,READER 364,5,14942,BUILDER 368,21,14948,PREPARER 365,5,14950,PREPARER 378,1540,14952,PREPARER 366,9,14954,PREPARER … Continue reading

Posted in Oracle Data Guard, Oracle Logical Data Guard | Tagged | Leave a comment

Resolving ORA-29913 in RAC environment

Problem: Select from external table returns following error stack ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-04040: file TEST.TXT in TEST_DIR not found ORA-06512: at “SYS.ORACLE_LOADER”, line 19 Let’s simulate the problem $ sqlplus / as sysdba … Continue reading

Posted in Oracle External Tables | Tagged | 2 Comments

Logical standby SQL Apply Troubleshooting

Problem: After starting the SQL APPLY it stops at initializing stage. Following messages are logged in alert.log LOGSTDBY Parameter: MAX_SGA = 1024 LOGSTDBY Parameter: DISABLE_APPLY_DELAY = LOGSTDBY Parameter: REAL_TIME = Completed: ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE Mon Dec … Continue reading

Posted in Oracle Data Guard, Oracle Logical Data Guard | Tagged | 3 Comments

Stale optimizer statistics on logical standby

Problem: Stale optimizer statistics for tables & indexes on logical standby Normally ‘Automatic Optimizer Statistics Collection’ feature introduced in 10g should take care of updating the statistics by scheduled maintenance job in Database control or Grid control. But in logical … Continue reading

Posted in Oracle Data Guard, Oracle Logical Data Guard | Tagged | Leave a comment

TNS-04404 / TNS-04414 / TNS-04612

Problem description 1. While creating a cluster database, dbca error out with TNS-04404, TNS-04414 & TNS-04612 errors. 2. Similar problem is faced, when netca is used to add new services Utility tnsping does not report this problem. Cause Probable cause … Continue reading

Posted in Oracle Database Creation Assistant | Tagged | 3 Comments

Oracle Dead Connection Detection (DCD)

When the application is not used for a significant amount of time, the firewall setting between database & application server closes physical connection between application & database. This will invalidate the connection in connection pool. To detect such dead connections … Continue reading

Posted in Oracle Connectivity | Tagged | Leave a comment