Skip to main content
RAC

Troubleshooting Conversation With Friend on RAC Standby Database – How it resolved

By May 15, 2023No Comments5 min read

Here’s an issue that I have been asked to solve and for which I used a successful strategy that I want to share with you via this blog post. One of my friends was having an issue between a RAC primary Database and RAC Standby (you need to precise exactly what oracle release and what exact issue). The issue started popping up after duplicating……. (you need to complete). Below I am going to reproduce the discussion we have had before I succeed to solve the issue

My friend:  LNS process not started on standby

Me:  can you give me parameter settings

My friend:  LNS process is not started on standby

Me: and one wrong setting which I asked him to change

My friend: alter system set….

My friend: But I now have the following error 

[oracle@linuxrac1 admin]$ sqlplus sys@IRDRC

SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 4 10:02:39 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:

At this step I realized that after they have duplicated the database they have tried to start MRP but unfortunately they were unable to connect to the Oracle instance using the Oracle Net service. They are using a SCAN listener

Me: can you issue the following command (explain what this is command is)

            $srvctl config database

My friend: There is no out pout given by the above command.

Me            : I was expecting from this command to get the database name. So what is happening here?

Me            : could you please add the database name to srvctl (explain a little bit here)

My friend: database name added to srvctl but I am still getting the same issue

Me            : Are you using VIP or SCAN? 

My friend: We are using both. By the way I have tried VIP and SCAN and they have been of no help 

Me        : What elements are offline in crs_stat? I asked this question in order to check the status of daemons and services

Then, I stopped this Q&A with my friend for about 10 minutes in order to read the MOS document n°IDxxxx and came back to my friend with the following question

Me:  what is the status of the service?

My friend: there is no service 

Me: could you please add a service

My friend: service added

Me:  Once the service has been added could you please now remove REMOTE_LISTENER? If their Standby has been implemented in a RAC configuration then the REMOTE_LISTENER would have been necessary

At this step I realized that after they have duplicated the database they have tried to start MRP but unfortunately they were unable to connect to the Oracle instance using the Oracle Net service. They are using a SCAN listener

Me: can you issue the following command (explain what this is command is)

            $srvctl config database

My friend: There is no out pout given by the above command.

Me            : I was expecting from this command to get the database name. So what is happening here?

Me            : could you please add the database name to srvctl (explain a little bit here)

My friend: database name added to srvctl but I am still getting the same issue

Me            : Are you using VIP or SCAN? 

My friend: We are using both. By the way I have tried VIP and SCAN and they have been of no help 

Me        : What elements are offline in crs_stat? I asked this question in order to check the status of daemons and services

Then, I stopped this Q&A with my friend for about 10 minutes in order to read the MOS document n°IDxxxx and came back to my friend with the following question

Me:  what is the status of the service?

My friend: there is no service 

Me: could you please add a service

My friend: service added

Me:  Once the service has been added could you please now remove REMOTE_LISTENER? If their Standby has been implemented in a RAC configuration then the REMOTE_LISTENER would have been necessary

My friend: Thanks a lot Nassyam. Now I am able to successfully connect from standby to primary and vice versa

Bottom line: when trouble shooting such a kind of issue remotely you need to gather as much information as possible from the target database and then proceed to the trouble shooting step by step

Leave a Reply