Hello Readers, You are here because you faced ORA-00257: Archiver error. Connect AS SYSDBA only until resolved error ? Lets come to point -> ORA-00257: Archiver error. Connect AS SYSDBA only until resolved error means archiver process is stuck because of various reasons due to which redo logs are not available for further transaction as…
Category: Oracle-Error
Prerequisite check “CheckActiveFilesAndExecutables” failed.
When you are patching RDBMS home/ Grid home, sometimes you might have encountered Prerequisite check “CheckActiveFilesAndExecutables” failed. error where your opatch failed . Similarly you have came across when you actually fired opatch apply and command came out as an error – In this example – I was patching RDBMS home 19c with April 2021…
ORA-38701:Flashback database log 1 seq 1 thread 1 and ORA-27037: unable to obtain file status
Hello Readers, I know I was away from blog due to personal issues. Now it is resolved and we are back to posting. Today, we found an issues on UAT server where someone removed the /FRA mount point which was given to us for Flashback logs. Background story 1 DB had 1 restore point2 DB…
Scan Listener – Not All Endpoints Registered
Hello Readers, today we faced a new issue where one of our scan listener after reboot were giving us error. Resource was in Intermediate state. Rest all the scan listener were online. Scan Listener – Not All Endpoints Registered And there was no services were registered to Scan listener 1 . We have changed the…
How to recreate Central Inventory in Oracle
Recently, we upgraded the database, as part of upgrade and which gave us error. The issue was additional “/” which caused the problem for us. Database connect failed with: ORA-12547: TNS:lost contact (DBD ERROR: OCIServerAttach) Here we had to recreate central inventory before upgrading the database. Here we are “How to recreate Central Inventory in…
Database Upgrade : Database connect failed with: ORA-12547: TNS:lost contact (DBD ERROR: OCIServerAttach)
Today, we we were doing database upgrade from 11.2.0.4 to 19c. 19c binaries installation was clean, while upgrade 107 phases was clean to until we got error during datapatch. Let me provide the error reported – Database connect failed with: ORA-12547: TNS:lost contact (DBD ERROR: OCIServerAttach) ISSUE Error: prereq checks failed! is known issue when…
Diskgroup name with a Special Character
Today, one issue was reported where diskgroup got created successfully but disk group had a special character in it. Diskgroup name with special character caused an issue for us as no operation were allowed Later we could identify diskgroup name with special character. Here is how we found it out. When we fired select we…