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

From: Tim Gorman <tim_at_evdbt.com>
Date: Tue, 21 Oct 2008 14:40:10 +0000
Message-ID: <W9997229273212761224600010@webmail41>

Throw some double-quotes around the TNS string. First one right after @, the closing one at the end of the line.

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

From: Lyndon Tiu [mailto:ltiu_at_alumni.sfu.ca] Sent: Tuesday, October 21, 2008 08:34 AM 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.xxx.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:40:10 CDT

This message: [ Message body ]
Next message: Newman, Christopher: "Centralized auditing question"
Previous message: Bort, Guillermo: "RE: Connecting to Oracle using sqlplus, bypass tnsnames.ora question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message