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

  • From: "Tim Gorman" <tim@xxxxxxxxx>
  • To: ltiu@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 21 Oct 2008 14:40:10 +0000

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@xxxxxxxxxxxxx]
Sent: Tuesday, October 21, 2008 08:34 AM
To: oracle-l@xxxxxxxxxxxxx
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--//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2008