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

From: Goulet, Richard <>
Date: Tue, 21 Oct 2008 09:59:48 -0400
Message-ID: <>

AH vestiges of SQL*Net V1 still running around. Back then it was
"T:hostname:sid" where T stood for TCP/IP. Also Oracle recommended that
SID's should be "case insensitive". Try to figure that one out.  

Dick Goulet
Senior Oracle DBA
PAREXEL International
 information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.  

[] On Behalf Of Syed Jaffar Hussain Sent: Tuesday, October 21, 2008 9:32 AM
Subject: Re: Connecting to Oracle using sqlplus, bypass tnsnames.ora question

You can do it (I guess from 10gR1), something called, 'connection less configuration'as follows:

 sqlplus username/password@//hostname/ipaddres:PORT/SID

Example: sqlplus scott/tiger@//host1:1521/ORCL

On Tue, Oct 21, 2008 at 4:20 PM, Lyndon Tiu <> wrote:

        Hi guys,         

        Is there a way to use sqlplus and connect to a database without using tnsnames.ora?         

        Specify the whole connect string in the command line?         


	Lyndon Tiu

Best Regards,

Syed Jaffar Hussain
Oracle Certified Master (10g)
Oracle ACE
OCP 8i,9i & 10g DBA
RAC Certified Expert
Official Oracle RAC SIG Representative for Saudi Arabian region
I blog at

"Winners don't do different things. They do things differently."
Received on Tue Oct 21 2008 - 08:59:48 CDT

Original text of this message