This content has been marked as final. Show 2 replies
For connecting to non-local database / from different (client) machine you need to install oracle client software
Post which you can run netca utility from command prompt to configure TNS entry in $ORACLE_HOME/net/admin/tnsnames.ora which will help you to connect destination DB
Make sure DB server IP & port are accessible using ping <IP> or telnet <IP> <port>
Using the instant client will probably be the simplest solution.