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

Oracle version?

OS?

OS version?

--

Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lyndon Tiu Sent: Tuesday, October 28, 2008 11:27 AM To: oracle-l_at_freelists.org
Subject: Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question

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 Received on Tue Oct 28 2008 - 10:38:29 CDT