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…
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…
OEM13c : Admin Server Port is occupied by another process. Please stop process to free port
I know since most of us still working from home, I always suggest firing commands which takes more than 2 mins in Background. Today, one of my colleague complained while starting oms service. He is getting -“Admin Server Port is occupied by another process. Please stop process to free port“. error while stopping oms service….
Expdp using VIEWS_AS_TABLES in Oracle 19c
I got a chance to test views_as_tables recently. My friend wanted to take backup of few views which will have content in it. Since database version for her was Oracle 12c, I suggested for VIEWS_AS_TABLES. But here is the catch – She wanted to export specific rows from the view. Traditional way of doing this…
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…
Temporary Tablespace | Sparse files | alter session set events=’60063′
Today we will cover everything about Temporary Tablespace, Sparse files, alter session set events=’60063′ . Everyone might know this – Temporary Tablespace are used for sorting operation in Oracle database. But Have you ever noticed ? Why creating a temporary tablespace with a size of 10gb is faster then creating a data tablespace with a…
How to Migrate OCR , Vote File , ASM SPFILE and ASM Password file to new Diskgroup in Oracle 19c
Similar to Database, storage also comes with support timelines, and this is one of the major reason storage team will ask you to migrate asm disks from old to new. Adding a disks and removing the old disks can be done with minor change in size for external redundancy diskgroups but not for high or…
How to Deinstall Oracle 19c Grid Infrastructure
Today we will cover how to deinstall oracle 19c grid infrastructure. Deinstallation of Grid Infrastructure is one of the most rarest request you will come across as Oracle DBA. When Deinstallation of Oracle 19c Grid Infrastructure will come ? When requestor want to de-induct the server and they want all services to be deleted from…
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…