Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#general-database-discussions
8 comments
34,874 views