RE: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
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.
Senior Oracle DBA
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.
[mailto:oracle-l-bounce_at_freelists.org] 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:
Example: sqlplus scott/tiger@//host1:1521/ORCL
On Tue, Oct 21, 2008 at 4:20 PM, Lyndon Tiu <ltiu_at_alumni.sfu.ca> wrote:
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 -- http://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/ --------------------Received on Tue Oct 21 2008 - 08:59:48 CDT
"Winners don't do different things. They do things differently."