How to connect using sqlplus client and without tnsnames.ora

ensure ORACLE_HOME is already defined

ensure sqlplus is in path

In Unix environment, use the following

$ sqlplus 'username/password@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbhostname)(PORT=dbport)))(CONNECT_DATA=(SERVICE_NAME=SID)))'