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

  • From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
  • To: ltiu@xxxxxxxxxxxxx
  • Date: Tue, 28 Oct 2008 11:27:41 -0500

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@xxxxxxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2008