OraFAQ Forum: Networking and Gateways » Connect Two Oracle server in one client

Home » RDBMS Server » Networking and Gateways » Connect Two Oracle server in one client (Oracle 9i, Linux (Server), Windows XP (Cllent))

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

Connect Two Oracle server in one client [message #388450]

Tue, 24 February 2009 21:50

cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA

Senior Member

Hi,

We two server in our work place.

One has been used for the Oracle database and Oracle Forms and reports Application

the other server has Oracle database and .NET, When we try to connect the both server any one of the database display the TNS Error.

If it possible to connect both server in one PC.

CVS.

Report message to a moderator

Re: Connect Two Oracle server in one client [message #388451 is a reply to message #388450]

Tue, 24 February 2009 21:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>If it possible to connect both server in one PC.
yes

Report message to a moderator

Re: Connect Two Oracle server in one client [message #388467 is a reply to message #388451]

Tue, 24 February 2009 23:47

cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA

Senior Member

Thanks for immediate reply

Please give me the details for it.

One PC have IP address of : 192.9.200.1
One PC have IP address of : 192.9.200.93

Thanks and regards,

CVS

Report message to a moderator

Re: Connect Two Oracle server in one client [message #388469 is a reply to message #388450]

Tue, 24 February 2009 23:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Report message to a moderator

Re: Connect Two Oracle server in one client [message #388487 is a reply to message #388451]

Wed, 25 February 2009 00:40

cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA

Senior Member

Please give me the details for Connect the Two Oracle server in single PC.

The Servers IP Address are:

1) 192.9.200.1
2) 192.9.200.93

CVS

Report message to a moderator

Re: Connect Two Oracle server in one client [message #388488 is a reply to message #388450]

Wed, 25 February 2009 00:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Your IP# do not exists for for me.
SELECT * FROM TBL1@REMOTE1, TBL2@REMOTE2

Report message to a moderator

Re: Connect Two Oracle server in one client [message #388496 is a reply to message #388487]

Wed, 25 February 2009 00:50

aviva4500
Messages: 122
Registered: July 2008
Location: bangalore

Senior Member

@cvs_1984,
Yes, we can connect to the two servers as you mentioned from a single pc.Have a look at tnsnames.orafile

Regards,
Hammer

Report message to a moderator

Previous Topic:	Application Server Network Disconnected
Next Topic:	Oracle DB connection to iHistorian

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 17:15:32 CST 2025