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

In BASH you may need to escape the ( )
sqlplus
user/pass@\(DESCRIPTION=\(ADDRESS_LIST=\(ADDRESS=\(PROTOCOL=TCP\)\(HOST= xxx.xxx.xxx.xxx\)\(PORT=1521\)\)\)\(CONNECT_DATA=\(SERVICE_NAME=MyOraDB\ )\)\)

sth like that works on my linux shell

hth

Guillermo Alan Bort
DBA / DBA Main Team

EDS, an HP company
ITO
Arias 1851
Ciudad Autonoma de Buenos Aires (C1429DXC) Argentina

Tel: +54 11 4704-3132
E-mail: guillermo.bort_at_eds.com

We deliver on our commitments
so you can deliver on yours.

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

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

Hi guys,

Thanks for all the tips.

I got this to work on Windows DOS:

sqlplus
user/pass@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx x.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MyOraDB)))

But, I could not get it to work on Linux Shell. I am getting shell errors.

"bash: syntax error near unexpected token `('"

Any ideas?

--

Lyndon Tiu
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 21 2008 - 09:39:48 CDT