Heartbeat failed to connect to standby ORA-12160: TNS:internal error: Bad e [message #474128] |
Fri, 03 September 2010 00:45  |
Bangla
Messages: 49 Registered: August 2008
|
Member |
|
|
From alert log,
<msg time='2010-09-03T11:37:46.548+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='24310'>
<txt>Error 12160 received logging on to the standby
</txt>
</msg>
<msg time='2010-09-03T11:37:46.548+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='24310'>
<txt>Errors in file /u01/app/oracle/diag/rdbms/bddipdc/bddipdc1/trace/bddipdc1_arcq_24310.trc:
ORA-12160: TNS:internal error: Bad error number
</txt>
</msg>
<msg time='2010-09-03T11:37:46.548+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='24310'>
<txt>PING[ARCq]: Heartbeat failed to connect to standby 'bddipdrs'. Error is 12160.
</txt>
</msg>
From trace file,
[oracle@DC-DB-01 ~]$ less /u01/app/oracle/diag/rdbms/bddipdc/bddipdc1/trace/bddipdc1_arcq_24310.trc
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12160 and errmsg is 'ORA-12160: TNS:internal error:
Bad error number
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12160 and errmsg is 'ORA-12160: TNS:internal error:
Bad error number
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12160 and errmsg is 'ORA-12160: TNS:internal error:
Bad error number
'
*** 2010-09-03 11:37:46.548 4132 krsh.c
Error 12160 received logging on to the standby
*** 2010-09-03 11:37:46.548 869 krsu.c
Error 12160 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'bddipdrs'
Error 12160 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'bddipdrs'
ORA-12160: TNS:internal error: Bad error number
*** 2010-09-03 11:37:46.548 4132 krsh.c
PING[ARCq]: Heartbeat failed to connect to standby 'bddipdrs'. Error is 12160.
*** 2010-09-03 11:37:46.548 2747 krsi.c
krsi_dst_fail: dest:2 err:12160 force:0 blast:1
|
|
|
|
|