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

In reading through the 10.2 documentation on tahiti, I see no reference in support of EZCONNECT in Oracle utilities other the sqlplus . My tests on Linux x86-64 (10.2.0.3) failed as well.

http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/naming.htm#ABC524382SRI12

I also had a failure from an 11.1.0.6 client.

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
        direction."

• William Feather

On Tue, Oct 28, 2008 at 10:27 AM, Lyndon Tiu <ltiu_at_alumni.sfu.ca> wrote:

> Hi guys,
>
> Question:
>
>
> If this works:
>
> sqlplus user/pass@
> "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SID=MYORA)))"
>
>
> Why does this not work:
>
> exp user/pass@
> "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SID=MYORA)))"
>
>
> Error:
>
> LRM-00116: syntax error at 'ADDRESS' following '('
>
>
> Any tips and suggestions greatly appreciated.
>
> Thanks.
>
>
> --
> Lyndon Tiu
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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