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!

TNS-12547: TNS: lost contact

user9961203Jul 18 2012 — edited Jul 19 2012

Hi!

I was unable to find a better category for this thread, so I put it in General.

I have a problem with database connection. The db server is a virtual machine (runs on VMWare Player) with Windows XP and Oracle 10.2.0.4, bridged network connections, own IP address, unique hostname. It has one Oracle instance. When I tnsping it from vm host, it works (result shows 0-10 ms). But when I tnsping it from other machine, I receive TNS-12547: TNS: lost contact error. I can ping the db server though, it works perfectly fine.

I checked solutions from article 555565.1 ( Remote Connections section), but it didn't help - there were no mentioned parameters set in sqlnet.ora. Setting SQLNET.INBOUND_CONNECT_TIMEOUT=0, INBOUND_CONNECT_TIMEOUT_listener_name=0 and restarting the listener didn't help.

I tried searching for solutions on the Internet, but to no avail. Can anyone suggest anything?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2012

Added on Jul 18 2012

#connection, #database, #error, #general-database-discussions, #windows

13 comments

5,763 views