RE: Connecting to Oracle using sqlplus, bypass tnsnames.ora question
Date: Tue, 21 Oct 2008 09:59:48 -0400
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F1EBAEE6F@US-BOS-MX011.na.pxl.int>
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain
Sent: Tuesday, October 21, 2008 9:32 AM
To: ltiu_at_alumni.sfu.ca
Cc: oracle-l_at_freelists.org
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_at_alumni.sfu.ca> 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 -- 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."
-- http://www.freelists.org/webpage/oracle-l