Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question

2008/10/21 Lyndon Tiu <ltiu_at_alumni.sfu.ca>

> Hi guys,
>
> Thanks for all the tips.
>
> I got this to work on Windows DOS:
>
> sqlplus user/pass@
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MyOraDB)))
>
> But, I could not get it to work on Linux Shell. I am getting shell errors.
>
> "bash: syntax error near unexpected token `('"
>
> Any ideas?
>
> --
>

I did no tested it but may be

sqlplus user/pass@
"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MyOraDB)))"

may work

avoid white spaces, too

D

--
http://www.freelists.org/webpage/oracle-l