Sample Header Ad - 728x90

How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora

109 votes
4 answers
1021841 views
I want to connect to an oracle database located on another host using sqlplus. [This page](http://thomas.eibner.dk/oracle/sqlplus/) suggested adding an item on my tnsnames to connect to that database local_SID = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= hostname.network)(Port= 1521)) (CONNECT_DATA = (SID = remote_SID)) ) and then use that in sqlplus sqlplus user/pass@local_SID However, in my circumstances modifying the local tnsnames is not possible. Is it possible to connect to a remote database just by using sqlplus argument without having to change tnsnames? Something like sqlplus user/pass@remote_SID@hostname.network ;( I know, this one is not valid)
Asked by Louis Rhys (1285 rep)
Feb 15, 2012, 07:48 AM
Last activity: May 23, 2023, 12:04 AM