Home » RDBMS Server » Networking and Gateways » Connect Two Oracle server in one client (Oracle 9i, Linux (Server), Windows XP (Cllent))
Connect Two Oracle server in one client [message #388450] Tue, 24 February 2009 21:50 Go to next message
cvs_1984
Messages: 133
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.
Re: Connect Two Oracle server in one client [message #388451 is a reply to message #388450] Tue, 24 February 2009 21:55 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
>If it possible to connect both server in one PC.
yes
Re: Connect Two Oracle server in one client [message #388467 is a reply to message #388451] Tue, 24 February 2009 23:47 Go to previous messageGo to next message
cvs_1984
Messages: 133
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
Re: Connect Two Oracle server in one client [message #388469 is a reply to message #388450] Tue, 24 February 2009 23:50 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
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.
Re: Connect Two Oracle server in one client [message #388487 is a reply to message #388451] Wed, 25 February 2009 00:40 Go to previous messageGo to next message
cvs_1984
Messages: 133
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
Re: Connect Two Oracle server in one client [message #388488 is a reply to message #388450] Wed, 25 February 2009 00:44 Go to previous messageGo to next message
BlackSwan
Messages: 23191
Registered: January 2009
Senior Member
Your IP# do not exists for for me.
SELECT * FROM TBL1@REMOTE1, TBL2@REMOTE2

Re: Connect Two Oracle server in one client [message #388496 is a reply to message #388487] Wed, 25 February 2009 00:50 Go to previous message
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
Previous Topic: Application Server Network Disconnected
Next Topic: Oracle DB connection to iHistorian
Goto Forum:
  


Current Time: Sun Dec 28 09:57:30 CST 2014

Total time taken to generate the page: 0.12125 seconds