RE: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "ltiu@xxxxxxxxxxxxx" <ltiu@xxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 28 Oct 2008 11:38:29 -0400
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@xxxxxxxxxxxx
www.proquest.com
www.csa.com
ProQuest...Start here.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Lyndon Tiu
Sent: Tuesday, October 28, 2008 11:27 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//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)