Nov 12, 2012
53 Views
0 0

Connecting to a remote Oracle Database.

Written by

Local database

Connecting to a local database is easy, just use:

$ sqlplus dbUser/dbPassword@dbSid
Here’s the  syntax for connecting to a remote database using its SID:

$ sqlplus dbUser/dbPassword@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=remoteServer)(PORT=1521)))(CONNECT_DATA=(SID=dbSid)))’

Article Categories:
Databases

Leave a Comment

Your email address will not be published. Required fields are marked *