Troubleshoot

In the following post we’ll go through every possible scenario where we loose REDO, one by one. REDO is the most crucial part when we talk about recovery and contains …

 Incorrect environment. ORACLE_HOME for grid should be pointing to grid directory and ORACLE_SID for ASM should be +ASM. Try this: export ORACLE_HOME=$GRID_HOME export $ORACLE_SID=+ASM export PATH=$GRID_HOME/bin:$PATH

 How to resolve the error   RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause ? Error:Starting Duplicate Db at 9-SEP-14RMAN-00571: ===========================================================RMAN-00569: =============== …

 This error normally occur  because of the INDEX or table structure is in consistent mode. Analyze the index structure and tables.If index structure is failed in analyze , drop the …

 💡 While setting up the standby database in Oracle, the archives are not being shipped to the standby and we were continuously getting this alert when queried the V$ARCHIVE_DEST view. …

Make sure that your ORACLE_HOME and ORACLE_SID are correct To see the current values in windows, at the command prompt type echo %ORACLE_HOME% Then echo %ORACLE_SID% If the values are …

💡 Recently I tried to setup some new physical standby databases and got the following strange message: DGMGRL> ADD DATABASE “XXXX” as connect identifier is “XXXX” maintained as physical; Error: …

 <aside> 💡 The Oracle database has been upgraded from 11.2.0.4 to 12.2.0.1 and the standby database (physical) was able to synchronize the data; but we see the error “ORA-16795: the …

 💡 Do không tìm thấy thư mục datafile trên máy auxiliary database server (có thể do server primary datafile để ở nhiều thư mục khác nhau) hoặc do do k …

💡 [INS-32025] The chosen installation conflicts with software already installed in the given Oracle home Resolved 1. Locate your central inventory location @ /etc/oraInst.loc 2 cd <oraInventory path>/oraInventory/ContextXML (In windows …