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  |
 |
ducnt26
Messages: 10 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 #671396 is a reply to message #671395] |
Tue, 28 August 2018 08:18   |
 |
JPBoileau
Messages: 88 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
|
|
|
|
|
|
Goto Forum:
Current Time: Thu Jul 17 20:23:47 CDT 2025
|