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 previous message
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

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


Current Time: Tue Apr 23 01:46:47 CDT 2024