Oracle DataGuard - Cofiguration

[Former Member]

Hello

I am trying to configure the dataguard for our client disaster recovery system. I have setup the init<SID>.ora at primary and DR side both for DR setup and dataguard POC. I have modified the listener.ora and tnsnames.ora at both side primary and DR side and .The system detail
are as follow:

  Primary Production Server
  ========================
     1. Hostname        : KTMHPRD
     2. Host IP Address : 172.25.4.33
     3. Operating System: Window 2008 R2
     4. Database : Oracle 11.2.0.3
     5. SAP Version  : SAP ERP 6.0 EHP5

  Disaster Recovery Server
  ========================
     1. Hostname        : KTMHPDR
     2. Host IP Address : 172.25.4.34
     3. Operating System: Window 2008 R2
     4. Database : Oracle 11.2.0.3
     5. SAP Version  : SAP ERP 6.0 EHP5

I am getting Below results after such configuration :

     1. Listaner started sucessfully on both Primary and DR server
     2. tnsping RQ9 Successfully
     3. tnsping RQ9_DRS successfully
     4. R3trans -d successfull return code (0000)

Error
=====

     1. Dialog process not getting started at primary server ( Error as " B  ***LOG BY0=> ORA-12154: TNS:could not resolve the connect identifier specified")

     2. Redolog shipment not successfull from primary to Disaster recovery system

I am attaching below two log sets , request you to check and let us now the problem

(A) Production Server Details
     - initRQ9.ora
     - listener.ora
     - tnsnames.ora
     - work directory log

(B) Disaster Recovery Server Details
     - initRQ9.ora
     - listener.ora
     - tnsnames.ora

Regards

Vimal

[former_member207464]

Hi Vimal,

It seems the error you are getting fits the situation described in following document:

1701375 - ORA-12154 connecting to Standby database

It should help you in solve the error.

Regards,

Adriano

[Former Member]

Dear Adriano

My primary database is working fine. I have started the standby DR database.

I can successfully ping the DR services from primary and primary tns services from DR.

Hope I have maintained correctly.

Pl please note that when I have login on DR server and trying to setup as below:

DGMGRL> connect sys@RQ9

DGMGRL> create configuration 'standby_config' as

    > primary database is 'RQ9'

    > connect identifier is 'RQ9';  Successful

DGMGRL> show configuration;

DGMGRL> add database 'RQ_STNDBY' as

    > connect identifier is RQ9_DRS;

Here I am getting error as "ORA-12154: TNS:could not resolve the connect identifier specified"

Pl help to resolved

Regards

Vimal Pathak

[Former Member]

Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.

[Former Member]

Hi Vimal,

Please check the configuration mentioned in the link below. Hope this will solve your problem.

http://www.oracle-base.com/articles/11g/data-guard-setup-11gr2.php

If you have made all configuration as per the link and still issue persisting then we would be requiring the relevant logs for understanding the issue.

Please confirm if you have made all configuration mentioned in the link.

Regards,

Shashi

[Former Member]

Hi Shashi

I have followed the same link. But not working. I am doubting that there is problem with my tnsnames.ora and listener.ora on both system PRD and DR. because adding service from DR I am getting below error.

Login to DR system and execute below command;

Followed link as http://catherinedevlin.pythoneers.com/dg.html

==================================================

DGMGRL> connect sys@RQ9

DGMGRL> create configuration 'standby_config' as

    > primary database is 'RQ9'

    > connect identifier is 'RQ9';  Successful

DGMGRL> show configuration;

DGMGRL> add database 'RQ_STNDBY' as

    > connect identifier is RQ9_DRS;

Here I am getting error as "ORA-12154: TNS:could not resolve the connect identifier specified

Please share ur email-id i will share the both files for review

Regards

Vimal

[Former Member]

HI Vimal,

Please send the logs on w.shashi@gmail.com

Regards,

Shashi

[Former Member]

Hi Shashi

I have mailed the tnsnames.ora & listener.ora for both PRD and DR system

Regards

Vimal

[Former Member]

Hi Vimal,

Thanks for the mail. I have checked the files and I think some changes needs to be made.

1. Make the DB_UNIQUE_NAME=RQ9_PRD for Primary database.

2. Make the DB_UNIQUE_NAME=RQ9_DRS for the Standby Database.

then restart the database. I think the issue should get resolved.

Also please also send me a newly created PFILE from SPFILE from both server if issue persists.

Regards,

Shashi

[Former Member]

Dear Shashi

I have done the changes but getting same error.

I have already send the data (initRQ9.ora & spfile) from PRD and DR system to you

Regards

vimal

[Former Member]

Hi Vimal,

I have sent you the listener and tnsnames files. Please replace these from the existing ones and restart the Listener for both servers.

Hope this will solve the issue.

Regards,

Shashi

[Former Member]

Hi Vimal,

I have found that you have not configured the LOG_ARCHIVE_DEST_2 parameter.

Also the LOG_ARCHIVE_DEST_2 should be enabled for the Standby database to become active.

The standby control file needs to be generated from primary database and should be placed in standby database server.

Please paste the output of following command:

SQL>show parameter LOG_ARCHIVE_DEST_2;

SQL>show parameter LOG_ARCHIVE_DEST_STATE_2;

Also please make sure that you have copied the passwd file from production server to standby server.

Regards,

Shashi

[Former Member]

Hi Shashi

Just First Reply for previous Message as (listener.ora & tnsnames.ora)

Before replacing, with old tnsnames.ora and listener.ora , the SAP POC Production system is working Fine. But after replacement of tnsnames.ora and listener.ora at SAP POC production, the dialog processes  started but after 1 minutes processes get died and become gray in MMC. The error getting recorded in dev_W0 is as below

LOG BYo=> ORA-12154: TNS: could not resolve the connect identifier specified

I have observed that when I am trying R3trans -d, in trans.log file it try to connect as /@RQ9. So  at any points it considering the connect string as RQ9 , please let us know how to remove. I have  added earlier local_listener in initRQ9.ora (pl check the log given to you) is required or need to be removed. Does it the reason of TMS configuration which I have not initialized.

Regards

Vimal

[Former Member]

Hi Vimal,

First you have to check for the DB_unique_name for both Oracle database. Both database should have different name.

SQL>show parameter db_unique_name

Please paste the output of following SQL command from Primary database:

SQL> select status, error from v$archive_dest where dest_id=2;

The output should be Valid if everything is defined correctly.

[Former Member]

Hi Shashi

Primary POC Server (Hostname : KTMHPRD)

===================================

a) The db_unique_Name : RQ9

b) SQL> select status, error from v$archive_dest where dest_id=2;

STATUS           ERROR

=======           ==========================================

INACTIVE

DR POC Server (Hostname : KTMHPRD)

===============================

a) The db_unique_Name : RQ9_STNDBY

b) SQL> select status, error from v$archive_dest where dest_id=2;

STATUS           ERROR

=======           ==========================================

INACTIVE

Please suggest that how to check that the primary and DR is connecting with each other. Please share your email-id so that log can be shared.

Please suggested ...

Regards

Vimal Pathak