Connection to Oracle without using tnsnames

You can use the following syntax to connect

sqlplus user/password@//host:[port]/service_name
sqlplus user/password@//host:[port]/service_name as sysdba

This syntax (known as EZCONNECT) is only available with sqlplus >= v10.2