Today I Learned: collection of notes, tips and tricks and stuff I learn from day to day working with computers and technology as an open source contributor and product manager

View project on GitHub

How to pass host and port parameters

Using the following command one can pass hostname, port, servicename and SID parameters to connect to a database without having an entry in tnsnames.ora

$ sqlplus username/password@hostname:port/SERVICENAME
$ sqlplus username
Enter password: password@//hostname:port/SERVICENAME
$ sqlplus /nolog
SQL> connect username/password@hostname:port/SERVICENAME