Sunday, December 30, 2018

Error 3113 in Primary Database while connecting Standby


Sometime you may see following error stack in your primary database alert log file.
Wed May 31 08:02:37 2017
LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)
LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Error 3113 for archive log file 9 to 'standby_db'
Errors in file D:\ORACLE\11203\diag\rdbms\standby_db\mydb\trace\mydb_nsa2_3544.trc:
ORA-03113: end-of-file on communication channel
LNS: Failed to archive log 9 thread 1 sequence 61239 (3113)

Thursday, December 6, 2018

Fatal NI connect error 12541

If you see this error message in the alert log file of your primary database in a dataguard environment, it is most likely that listener on the standby database host(s) is not running. As a result, primary database will not be able to ship redo data to the standby database. This failure of log shipping will add lines similar to the following in the alert log file of the primary database.

Popular Posts - All Times