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 ?

Improve this question
8
  • 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, 2016 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, 2016 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, 2016 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, 2016 at 20:45
  • Can anyone help me ?
    – saeed.sh
    Feb 25, 2016 at 7:23

1 Answer 1

Reset to default
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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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