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)))’