Database Administration (MOSC)

MOSC Banner

oracle 12c TNS-12518 TNS-12547 TNS-12560 TNS-00517 Error on ODA 12.1.2.6 server

edited Mar 26, 2016 5:00AM in Database Administration (MOSC) 1 commentAnswered

Hello. I have error about listener, services. I can't connect from another database. And I got error in listener_log.xml

msg time='2016-03-18T15:38:53.853+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='orcl0'
 host_addr='192.168.30.170'>
 <txt>18-MAR-2016 15:38:53 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.30.170)(PORT=35018)) * establish * orcl * 12518
 </txt>
</msg>
<msg time='2016-03-18T15:38:53.853+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='orcl0'
 host_addr='192.168.30.170'>
 <txt>TNS-12518: TNS:listener could not hand off client connection
 TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
    Linux Error: 32: Broken pipe
 </txt>
</msg>
<msg time='2016-03-18T15:38:54.217+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='orcl0'
 host_addr='192.168.30.170'>
 <txt>18-MAR-2016 15:38:54 * (CONNECT_DATA=(SID=orcl1)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.30.170)(PORT=17596)) * establish * orcl1 * 12518
 </txt>
</msg>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center