Categories
Databases

Connecting to a remote Oracle Database.

Local database

Connecting to a local database is easy, just use:

$ sqlplus dbUser/[email protected]
Here’s the ┬ásyntax for connecting to a remote database using its SID:

$ sqlplus dbUser/[email protected]'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=remoteServer)(PORT=1521)))(CONNECT_DATA=(SID=dbSid)))’

Leave a Reply

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