0

I have oracle database 11.2.0.3 with RAC feature , with 2 node on oracle linux 6.4 :

ol6-112-rac1 and ol6-112-rac2

I want to create active data guard with RAC feature from this database , these active dataguard with rac option has 2 node :

ol6-rac1-guard,ol6-rac2-guard

I want to use this document for creation active data guard from rac database to rac database :

http://www.oracledba.org/11gR2/dr/11gR2_dataguard_RAC_to_RAC.html#Create_Physical_Standby

I do the steps in this document , all of things is ok but in step " Start the Managed Recovery Process " after i want to switch log in primary , switch log is not occurred on standby database . After " tail of alert log " on standby database and executing " Switch log " on primary , this error is occurred :

tail -f  /ora01/app/oracle/diag/rdbms/racguard/racguard1/trace/alert_racguard1.log
Wed Feb 17 04:37:57 2016
Media Recovery Waiting for thread 1 sequence 76
Error 12154 received logging on to the standby
FAL[client, USER]: Error 12154 connecting to rac for fetching gap sequence

This is my mistake , can any one help me ?

  • Your TNS entry in tnsnames.ora contains an incorrect service name that the listener does not know of. Fix that, and try again. – Balazs Papp Feb 24 '16 at 11:56
  • Can you explain more ? because in primary tnsnames.ora , i have entered the information for standby1 and standby2 (node of standby db ) , in tnsnames.ora of standby db , i have entered information about primary database . is it wrong ? – saeed.sh Feb 24 '16 at 19:37
  • Post the contents of tnsnames.ora and lsnrctl status for your listeners and scan listeners. Somewhere in tnsnames.ora you specified a SERVICE_NAME that does not exist at the corresponding destination. – Balazs Papp Feb 24 '16 at 20:01
  • ok , i do them and the information of that on below link : workupload.com/archive/wp539s8N , is it ok ? – saeed.sh Feb 24 '16 at 20:45
  • Can anyone help me ? – saeed.sh Feb 25 '16 at 7:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.