Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LISTENER: TNS-12545 ... No such file or directory

Przemek POct 6 2011 — edited Oct 10 2011
Hi. I have a 11.2.0 database. This database was migrated from 10.2.0.4 recently. We are now testing if this test migration is ok.

At the beginning noone had problem with connection but after a while I couldn't connect via sql developer, or make any remote connection. No new connections are allowed. How can i deal with it ?

Sql developer throws this error:

Got minus one from a read call
Vendor code 17002

Listener throws this erro (sorry for xml format)r:

<msg time='2011-10-06T14:04:43.440+02:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='fake_database'
host_addr='10.50.150.58'>
<txt>06-OCT-2011 14:04:43 * (CONNECT_DATA=(SID=SPBUFOR)(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=wrpiprtr01))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.2.3.97)(PORT=56011)) * establish * SPBUFOR * 12518
</txt>
</msg>
<msg time='2011-10-06T14:04:43.441+02:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='fake_database'
host_addr='10.50.150.58'>
<txt>TNS-12518: TNS:listener could not hand off client connection
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 2: No such file or directory
This post has been answered by sb92075 on Oct 6 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2011
Added on Oct 6 2011
8 comments
35,077 views