Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> connect using host:port:sid

connect using host:port:sid

From: Sunil <sunil_franklin_at_hotmail.com>
Date: Tue, 26 Nov 2002 18:38:07 +0530
Message-ID: <ppKE9.2$Ws2.85@news.oracle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US