How to connect SQLPlus without tnsnames.ora

Open RUN (window + R) and copy the following command (replacing database properties)

sqlplus user/pwd@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostName)(Port=portNumber))(CONNECT_DATA=(SID=systemId)))"