Home » RDBMS Server » Networking and Gateways » connectivity
connectivity [message #66226] Wed, 06 February 2002 21:06 Go to next message
akshay
Messages: 12
Registered: December 2001
Junior Member
How can I access a database from one machine to another
Kindly tell the steps briefly.
Akshay
Re: connectivity [message #66228 is a reply to message #66226] Thu, 07 February 2002 09:35 Go to previous messageGo to next message
Balaji
Messages: 102
Registered: October 2000
Senior Member
Steps:

1. Start listener on machine 1 and 2
2. Update tnsnames.ora (located in $ORACLE_HOME/network/admin) on both machines
to point to services on the other machine.
3. Now you should be able to connect to
databases on these machines from
each other - using sqlplus or other tools

Balaji
Re: connectivity [message #66235 is a reply to message #66226] Tue, 12 February 2002 00:51 Go to previous message
akshay
Messages: 12
Registered: December 2001
Junior Member
The test did not succeed.
ORA-12224: TNS:no listener
Previous Topic: query speed
Next Topic: Re: i could install oracle8i successfully !!!!!
Goto Forum:
  


Current Time: Wed Apr 24 19:34:47 CDT 2024