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>
>
> 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.

How about

(ksh)
print "
conn ...
@blah.sql" | sqlplus /nolog

that way - no one will see your password on the process listing...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."