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

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <sjaffarhussain@xxxxxxxxx>, <ltiu@xxxxxxxxxxxxx>
  • Date: Tue, 21 Oct 2008 09:59:48 -0400

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 
978.313.3426 
 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.


 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, October 21, 2008 9:32 AM
To: ltiu@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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 <ltiu@xxxxxxxxxxxxx> 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?
        
        Thanks.
        
        --
        Lyndon Tiu
        --
        //www.freelists.org/webpage/oracle-l
        
        
        




-- 
Best Regards,

Syed Jaffar Hussain
Oracle Certified Master (10g)
http://www.oracle.com/technology/ocm/shussain.html
Oracle ACE
http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:
126
OCP 8i,9i & 10g DBA
RAC Certified Expert
Official Oracle RAC SIG Representative for Saudi Arabian region
(http://www.oracleracsig.org/)
I blog at
http://jaffardba.blogspot.com/
--------------------
"Winners don't do different things. They do things differently."

Other related posts:

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