8.0.6 SQLPLUS Connection string.

From: RAAZ <yoursraju007_at_gmail.com>
Date: Mon, 7 Apr 2008 09:52:46 -0400
Message-ID: <7f411f4e0804070652o5770ba57if183ae8444842e69@mail.gmail.com>


I have an unix script in 10g, which connects to remote database whose connection string is NOT defined in tnsnames.ora, as described below.

sqlplus -s user/password@"(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = $dbhost)(PORT = $dbport))) (CONNECT_DATA =
(SERVICE_NAME = $sid.corporate.ge.com)))" << EOF
EOF Now, I have moved the script to another machine, where oracle client version is 8.0.6. Unfortunately, sqlplus (of 8.0.6) doesn't like this syntax.

Has anyone got an workaround to connect to remote db without having an entry in TNS Entry in 8.0.6 ?

Thank you!

Received on Mon Apr 07 2008 - 08:52:46 CDT

Original text of this message