Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: connect using host:port:sid
Sunil wrote:
> 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>
>
what error do you get ?
on which operating system are you ?
Unix ? which shell do you use ?
>
> 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:14:25 CST