Home » SQL & PL/SQL » SQL & PL/SQL » connect to the remote machine
connect to the remote machine [message #23476] Wed, 11 December 2002 18:10 Go to next message
Nina
Messages: 113
Registered: March 2000
Senior Member
What is the way of connecting to a remote machine in order to start a sql session?

Report message to a moderator

Re: connect to the remote machine [message #23477 is a reply to message #23476] Wed, 11 December 2002 19:13 Go to previous messageGo to next message
Amit Chauhan
Messages: 74
Registered: July 1999
Member
You should have the database entry in tnsnames.ora file, and then use that connect string :)

Thanks
Amit

Report message to a moderator

Re: connect to the remote machine [message #23484 is a reply to message #23476] Thu, 12 December 2002 08:00 Go to previous message
vivek
Messages: 59
Registered: October 2001
Member
In the tnsnames.ora file of the remote machine add the following entry

oracle=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SID)
)
)

where:
hostname is the name of the computer on which u're database is installed.
1521 is the default port number
SID is the name of u're database

then u can connect saying
connect username/password@oracle

Report message to a moderator

Previous Topic: Undo an update made on a column.
Next Topic: Transfer Data
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 20:53:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.