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….
Tag: how to
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…
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…
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…
How to Change Scan Listener Port in Oracle RAC 19c | Modify Scan Listener Port in Oracle RAC 19c
Welcome back, recently I have shared how to change local listener port in Oracle 19c, Similarly today I will cover how to modify scan listener port in Oracle RAC 19c. To be honest with you, I never got such request from application team / Any team as of now. But recently my colleague forgot to…
How to Change Listener Port in Oracle 19c
Changing of Listener Port is not a regular activity. But Application team can request you to change it. Today, we are going to learn how to change Local listener port in Oracle 19c RAC and Non Rac. Why to Change Local Listener Port in Oracle 19c You might be wondering what makes application team to…
Multiplex Control file in Oracle RAC database 19c
If you are working for Financial/Banking domain, you will have a Guidelines given by the Auditors and doesn’t matter if you are restoring a fresh database or making a copy of it. You need to follow it. So recently we had a request to restore a database for PUC purpose, but since it was on…
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…