Re: Connection with Oracle without TNSNAMES.ORA

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Mon, 06 Dec 1999 08:20:17 -0500
Message-ID: <384BB811.40DD7347@Unforgettable.com>

Andrew Kot wrote:
>
> Is it possible to connect to Oracle instance without having entry in local
> tnsnames.ora ?
>

You can do it like this if you are using sqlplus on a client:

sqlplus
userid/password@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world) (PROTOCOL=TCP)(Host=xxx.xxx.xxx.xx)(Port=1521)))(CONNECT_DATA=(SID=ORCL)))

Just substitute your useid/password, your ip address and your sid. This assumes you have a listener set up for tcp on port 1521. Received on Mon Dec 06 1999 - 07:20:17 CST