Today, there was IP change activity on 4 node RAC cluster, and while updating the new netmask in cluster I got following error – CRS-02325: Unable to get Grid Plug and Play (GPnP) profile from requested cluster nodes. So I tried to execute gpnptool get to check if it is working for me or not…
Category: Oracle-Error
Post Patch PRCR-1105 : Failed to relocate resource ora.mgmtdb to node oracledbworld02 PRCR-1089 : Failed to relocate resource ora.mgmtdb Oracle 19c
Yesterday, we were applying Oracle Oct 2022 PSU patch on grid home when we got following error on node 2. Our node 1 patching was successful but it failed on node 2. Just to check, we tried to manually relocate MGMTDB on node 2. That didn’t work for us. With old learning we knew that…
MRP0: Incarnation has changed! Retry recovery… in Oracle 19c | datafile 1 belongs to an orphan incarnation in Oracle 19c | ORA-19906: recovery target incarnation changed during recovery
Recently my colleague complaint about incarnation change on the DR server. Incarnation change was recorded in alert log and MRP process was interrupted. Now if you try to start the MRP on changed incarnation DR database then it will fail with “datafile 1 belongs to an orphan incarnation“ We have database sync status report. And…
ORA-00221: error on write to control file | ORA-00206: error in writing (block xx, # blocks xx) of control file | ORA-27063: number of bytes read/written is incorrect | De-multiplexing of Control file and Redo log members in Oracle
Last week we had an incident were one of the storage went down. Just to give you clear idea, we have 2 different storage for Redo logs and controlfiles. This way we have multiplexing on database and so at Storage level too. My second shift started with following issue where one of the production database…
ORA-00600: internal error code, arguments: [kzpcpw:Invaid verifier type] in Oracle 19c
Today, we faced an issue while changing the user’s password. Oracle Version Reported – 19.14. Generally it is recommended to raise an SR just to confirm if ORA-600 matches with your error dump. You have option provided by Oracle Support named Ora-600 lookup tool, You can always try it. It is quite fast in listing…
srvctl start database Fails with CRS-5802: Unable to start the agent process in Oracle 19c
Today, We faced above issue where srvctl start database was failing on one node. It was failing with “CRS-5802: Unable to start the agent process” . There was no clue in database alert log what was causing the problem. Following issue was reported on Sun Solaris OS / 19.11 Binary Version If you check database’s…
ORA-00059: Maximum Number Of DB_FILES Exceeded
Known issues:When using Pluggable Database (PDB)/Container in 12c, create and drop of a single PDB might repeatedly fail with ORA-59.If ORA-59 error is reported even when the total number of files is less than the value of db_files, then this could be due to Bug 17461374.Download and apply the interim patch if it exists for your…
root.sh – CLSRSC-196: ACFS driver install actions failed in Oracle 19c
Yesterday, one of my colleague reported an issue where we were doing HAS installation. It was an AIX 7.1 OS on which were trying to install 19.14 Grid Infra and Oracle Binary. All prechecks were completed. And everything was looking good. But when we executed root.sh it failed with – CLSRSC-196: ACFS driver install actions…
ORA-12547: TNS:lost contact in Oracle 19c
Today, we faced an issue with one of recently upgraded database where sqlplus “/ as sysdba” on node 1 was working and sqlplus “/ as sysdba” was not working on node 2. It was giving following error – Problem Statement – ORA-12547: TNS:lost contact On Node 2, sqlplus “/ as sysdba” has problem and end…
DBMS_AUDIT_MGMT invalid Post Downgrade from 19c to 11g | PL/SQL: ORA-00947: not enough values
Hey Readers, We had a request to downgrade a oracle database from 19c to 11g. It’s very rare when you have a request to downgrade a system back to square zero. Reason usually are dependent upon functionality of the application. In my case, application had a separate tool which is used once in a quarter…