Home » RDBMS Server » Server Administration » Heartbeat failed to connect to standby ORA-12160: TNS:internal error: Bad e (11gR2)
Heartbeat failed to connect to standby ORA-12160: TNS:internal error: Bad e [message #474128] Fri, 03 September 2010 00:45 Go to next message
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 &apos;bddipdrs&apos;. 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

Re: Heartbeat failed to connect to standby ORA-12160: TNS:internal error: Bad e [message #474210 is a reply to message #474128] Fri, 03 September 2010 09:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Does either Primary or Standby reside in/on/with any type of Operating System virtualization software?
Re: Heartbeat failed to connect to standby ORA-12160: TNS:internal error: Bad e [message #474248 is a reply to message #474128] Fri, 03 September 2010 22:10 Go to previous message
Bangla
Messages: 49
Registered: August 2008
Member
In both ends, there is 2 nodes RAC and RHEL 5
Previous Topic: Database Startup Problem
Next Topic: General question about server.
Goto Forum:
  


Current Time: Sun May 19 21:08:56 CDT 2024