| 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 |
|
|
|
| Re: Error: ORA-12154 when add standby [message #671400 is a reply to message #671396] |
Tue, 28 August 2018 19:16 |
|
ducnt26
Messages: 10
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 #671430 is a reply to message #671411] |
Wed, 29 August 2018 08:10 |
|
JPBoileau
Messages: 88
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
