Home » RDBMS Server » Networking and Gateways » TNS Names (Oracle 10g ,OS Windows server 2003)
TNS Names [message #430298] Mon, 09 November 2009 23:51 Go to next message
goms
Messages: 1
Registered: November 2009
Location: US
Junior Member
Oracle 10g resides on one machine(Machine 1) and oracle 11g server resides on another machine(Machine 2).clients will be connected with machine 1...then i try to create one database in machine 2 .this machine will act as server..if i create one database on machine 2 ,how users make use of that database...
how to connect with client machine
Re: TNS Names [message #430382 is a reply to message #430298] Tue, 10 November 2009 04:46 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
If you that machine2 sid entry in your machine 1 tns names your clients can connect..

conn Username/Password@machine2_tnsentry

sriram Smile

[Updated on: Tue, 10 November 2009 04:48]

Report message to a moderator

Previous Topic: TOAD:TNS listner not found error.
Next Topic: Cannot start Listener
Goto Forum:
  


Current Time: Thu Mar 28 17:45:10 CDT 2024