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