OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » ORA-12547 in my case

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12547 in my case [message #467917]

Wed, 28 July 2010 04:53

zhjie374
Messages: 5
Registered: July 2010

Junior Member

Hi all

My env:
PC1: 192.168.12.1 Oracle 10g Server
PC2: 192.168.12.2 Oracle 10g Express Edition and Oracle 10g Client
PC3: 192.168.12.3 Oracle 10g Client
OS are Windows.

I use PC2 to connect to PC1, But I always get ORA-12547 error.
I use PC3 to connect to PC1, OK!
I use PC3 to connect to PC2(Express' database),OK

So, can anyone give me some advices to solve the problem about PC2 connecting PC1.

Thanks.

Report message to a moderator

Re: ORA-12547 in my case [message #467920 is a reply to message #467917]

Wed, 28 July 2010 05:01

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-12547: TNS:lost contact
 *Cause: Partner has unexpectedly gone away, usually during process
 startup.
 *Action: Investigate partner application for abnormal termination. On an
 Interchange, this can happen if the machine is overloaded.

Regards
Michel

Report message to a moderator

Re: ORA-12547 in my case [message #467924 is a reply to message #467920]

Wed, 28 July 2010 05:07

zhjie374
Messages: 5
Registered: July 2010

Junior Member

Hi

Thanks for your reply.
But PC3->PC1 is OK. So I think PC1's configuration is right.

Report message to a moderator

Re: ORA-12547 in my case [message #467957 is a reply to message #467924]

Wed, 28 July 2010 06:08

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think you're wrong but as you didn't show us anything of you've done, can't say more.

Regards
Michel

Report message to a moderator

Re: ORA-12547 in my case [message #468096 is a reply to message #467957]

Wed, 28 July 2010 19:56

zhjie374
Messages: 5
Registered: July 2010

Junior Member

Hi

So, can you give me some advise on detecting the problem?

Report message to a moderator

Re: ORA-12547 in my case [message #468098 is a reply to message #468096]

Wed, 28 July 2010 19:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

is any type of Operating System Virtualization installed on any of these systems?
If so, what & where?

Report message to a moderator

Re: ORA-12547 in my case [message #468100 is a reply to message #468098]

Wed, 28 July 2010 20:11

zhjie374
Messages: 5
Registered: July 2010

Junior Member

Hi

PC1 is a VM installed on PC2.

Report message to a moderator

Re: ORA-12547 in my case [message #468101 is a reply to message #468100]

Wed, 28 July 2010 20:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>PC1 is a VM installed on PC2.
I am NOT surprised.
This flavor of error frequently occurs when VM/OS/Networking is mis-configured.
The solution is external to Oracle.
Oracle is the victim; not the culprit.

Report message to a moderator

Re: ORA-12547 in my case [message #468103 is a reply to message #468101]

Wed, 28 July 2010 20:28

zhjie374
Messages: 5
Registered: July 2010

Junior Member

Hi

Thanks for your answer.

Report message to a moderator

Previous Topic:	Re: listener could not find available handler for requested type of server
Next Topic:	Some general questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 21:53:04 CST 2025