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:
- » Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » RE: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » RE: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » RE: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » RE: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- » Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question- Shastry(DBA)