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 ?

8
  • Your TNS entry in tnsnames.ora contains an incorrect service name that the listener does not know of. Fix that, and try again. 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. 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
0

In your tnsnames.ora on the standby side the needed tns alias for 'rac' is missing. In a data guard configuration it is extremely important that all members can resolve all other members.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.