Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> connect using host:port:sid
This Works :-
1>sqlplus /nolog
2>conn
scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=inponi)(Port=1521))(CO
NNECT_DATA=(SID=iasdb))) @script_name.sql parameter1 parameter2
3>
This Does not Work :-
1>sqlplus
scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=inponi)(Port=1521))(CO
NNECT_DATA=(SID=iasdb))) @script_name.sql parameter1 parameter2
2>
Is there any way I can connect to sqlplus and pass parameters to a script without using /nolog first, If I only have the host, port and sid information and not the tnsnames entry.
Thanks,
Sunil.
Received on Tue Nov 26 2002 - 07:08:07 CST