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 -> Re: connect using host:port:sid

Re: connect using host:port:sid

From: Matthias Rogel <rogel_at_web.de>
Date: Tue, 26 Nov 2002 14:14:25 +0100
Message-ID: <arvs3h$mekvq$1@ID-86071.news.dfncis.de>


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

Original text of this message

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