Home » Server Options » Data Guard » Physical Standby Error (Oracle 9.2.0.8, HP UX 11.23)
Physical Standby Error [message #501539] Tue, 29 March 2011 14:56 Go to next message
firedup123
Messages: 3
Registered: March 2011
Location: USA
Junior Member
Hello All,

I am trying to configure physical standby(s) across two boxes. I am getting the errors

ORA-12154: TNS:could not resolve service name
ORA-16055: FAL request rejected

I am able to communicate between the two servers, tnsping both of them, sqlplus to each of the instances, but getting the TNS issue. Can you please point me to something which i am missing.

Please let me know if you would need more details.

Please find the alert log details:

Tue Mar 29 13:21:55 2011
ARC0: Evaluating archive log 6 thread 1 sequence 73594
ARC0: Destination LOG_ARCHIVE_DEST_2 archival not expedited
ARC0: Beginning to archive log 6 thread 1 sequence 73594
Creating archive destination LOG_ARCHIVE_DEST_3: '/tmp_archive_dest/DLXMTY/arch_
DLXMTY_1_73594.dbf'
Creating archive destination LOG_ARCHIVE_DEST_1: '/archives/DLXMTY/arch_DLXMTY_1
_73594.dbf'
Invoking non-expedited destination LOG_ARCHIVE_DEST_2 thread 1 sequence 73594 ho
st DLXMTY_phm460mx
ARC0: Completed archiving log 6 thread 1 sequence 73594
Tue Mar 29 13:22:01 2011
ARC1: Begin FAL noexpedite archive (thread 1 sequence 73594 destination DLXMTY_p
hm460mx)
Creating archive destination LOG_ARCHIVE_DEST_2: 'DLXMTY_phm460mx'
ARC1: FAL archive, error 12154 creating remote archivelog file 'DLXMTY_phm460mx'
Tue Mar 29 13:22:01 2011
Errors in file /u01/dba/oracle/admin/DLXMTY/bdump/dlxmty_arc1_10336.trc:
ORA-12154: TNS:could not resolve service name
ARC1: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
Tue Mar 29 13:22:01 2011
ORACLE Instance DLXMTY - Archival Error. Archiver continuing.
ARCH: Connecting to console port...
Tue Mar 29 13:22:01 2011
ORA-16055: FAL request rejected
ARCH: Connecting to console port...
Tue Mar 29 13:22:01 2011
Errors in file /u01/dba/oracle/admin/DLXMTY/bdump/dlxmty_arc1_10336.trc:
ORA-16055: FAL request rejected
Tue Mar 29 13:23:28 2011
Errors in file /u01/dba/oracle/admin/DLXMTY/bdump/dlxmty_arc1_10336.trc:
ORA-12154: TNS:could not resolve service name
.....

Thankyou
Re: Physical Standby Error [message #501551 is a reply to message #501539] Tue, 29 March 2011 17:08 Go to previous message
BlackSwan
Messages: 26701
Registered: January 2009
Location: SoCal
Senior Member
>ORA-12154: TNS:could not resolve service name
ERROR means that the connect string could not be resolved (on local node).
Typically it means the @TNS_ALIAS could not be found in local tnsnames.ora file
Previous Topic: Data Broker fails to enable databse
Next Topic: Disaster Recovery Best Practice With SAN
Goto Forum:
  


Current Time: Tue May 26 22:28:37 CDT 2020