Re: connecting to Oracle without using TNSNAMES.ORA

From: Joe Kazimierczyk <joseph.kazimierczyk_at_bms.com>
Date: 2000/05/18
Message-ID: <3923DD52.A7B5E447@bms.com>#1/1

George Meltser wrote:
>
> Is it possible to connect to Oracle by specifying the connection description
> (host, port, instance_name etc) rather than connect string?
> If yes, what is the correct syntax to do it?

Sure! The syntax is basically the same as what's in your tnsnames.ora. For example:

sqlplus usr/pwd@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMM UNITY=TCP.world)(PROTOCOL=TCP)(Host=ahostname.com)(Port=1 521)))(CONNECT_DATA=(SID=ASIDNAME))) Received on Thu May 18 2000 - 00:00:00 CDT