To connect oracle database from oracle client without having TNS entry.

Open the sql prompt.

If the port no. is different from default port 1521. You have to specify the port No as the client understands database is listening on default port.

 conn userid/password@IP address:Port No./sid

SQL> conn system/manager@XX.XX.XX.XX:1527/test4

Connected.

Keep smiling