Home » Server Options » Data Guard » Error: ORA-12154 when add standby
Error: ORA-12154 when add standby [message #671393] Tue, 28 August 2018 04:48 Go to next message
ducnt26
Messages: 8
Registered: April 2016
Location: Hanoi
Junior Member

I have error when add physical standby:
Quote:
DGMGRL> add database O12_o12cvm2 as connect identifier is o12_o12cvm2 maintained as physical;
Error: ORA-12154: TNS:could not resolve the connect identifier specified
The log_archive_dest_state parameter:
Quote:

SQL> ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=MEMORY;

SQL> select status, Error from V$ARCHIVE_DEST where dest_id=2;

STATUS ERROR
--------- -----------------------------------------------------------------
INACTIVE
Pls help me!!

[Updated on: Tue, 28 August 2018 05:04]

Report message to a moderator

Re: Error: ORA-12154 when add standby [message #671395 is a reply to message #671393] Tue, 28 August 2018 06:17 Go to previous messageGo to next message
John Watson
Messages: 8082
Registered: January 2010
Location: Global Village
Senior Member
What if you give O12_o12cvm2.localdomain as the connect identifier?
Re: Error: ORA-12154 when add standby [message #671396 is a reply to message #671395] Tue, 28 August 2018 08:18 Go to previous messageGo to next message
JPBoileau
Messages: 81
Registered: September 2017
Member
"ORA-12154: TNS:could not resolve the connect identifier specified" means that the dataguard manager (dgmgrl) cannot find the "o12_o12cvm2" entry in the TNSNAMES.ORA file in the ORACLE_HOME that you are using.

First, make sure that your ORACLE_HOME is set to the source database's directory.

Second, make sure that you can TNSPING the o12_o12cvm2 standby database.

Third, make sure that the o12_o12cvm2 standby database can TNSPING your source database.

JP

[Updated on: Tue, 28 August 2018 08:18]

Report message to a moderator

Re: Error: ORA-12154 when add standby [message #671400 is a reply to message #671396] Tue, 28 August 2018 19:16 Go to previous messageGo to next message
ducnt26
Messages: 8
Registered: April 2016
Location: Hanoi
Junior Member

I tried:
DGMGRL> add database O12_o12cvm2.localdomain as connect identifier is o12_o12cvm2 maintained as physical;
Error: ORA-12154: TNS:could not resolve the connect identifier specified

Tnsping:
$ tnsping O12_o12cvm2.localdomain
TNS Ping Utility for Linux: Version 12.2.0.1.0 
Used parameter files:
/u01/app/oracle/product/12.1.0.2/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.34.1.14) (PORT = 1521))) (CONNECT_DATA = (SID = O12) (SERVICE_NAME= O12_o12cvm2)))
OK (110 msec)

$ tnsping O12_o12cvm1.localdomain

TNS Ping Utility for Linux: Version 12.2.0.1.0

Used parameter files:
/u01/app/oracle/product/12.1.0.2/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.34.1.13) (PORT = 1521))) (CONNECT_DATA = (SID = O12) (SERVICE_NAME = O12_o12cvm1)))
OK (10 msec)

[Updated on: Tue, 28 August 2018 19:32]

Report message to a moderator

Re: Error: ORA-12154 when add standby [message #671411 is a reply to message #671400] Wed, 29 August 2018 01:37 Go to previous messageGo to next message
John Watson
Messages: 8082
Registered: January 2010
Location: Global Village
Senior Member
I told you to correct the connect identifier, not to chance the database name.
Re: Error: ORA-12154 when add standby [message #671430 is a reply to message #671411] Wed, 29 August 2018 08:10 Go to previous message
JPBoileau
Messages: 81
Registered: September 2017
Member
I'm not sure why you're insisting on having ".localdomain" in the connect string. It's not needed. Call your database by a single name. No reason to have the extension as it's not a domain name.

That being said, I'm not sure it's the source of the problem.

JP
Previous Topic: RAC - DG
Next Topic: ORA-00308: -- DR looking for older archive logfiles
Goto Forum:
  


Current Time: Wed Dec 11 19:02:32 CST 2019