Re: Forming an SQL*Plus connect string?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 13 Jan 2006 08:25:08 -0800
Message-ID: <1137169508.358530.238720@g43g2000cwa.googlegroups.com>

laredotornado_at_zipmail.com wrote:
> Hi,
>
> Simple question, so hopefully there's a simple answer. I just
> installed Oracle 9i client (9.2.0.1.0) for Windows XP. I fired up
> SQL*Plus and am trying to connect to our db server. I am asked for
> username, password, and host connect string. How do I build that? Our
> admin gave us this tnsnames entry
>
> myserver.mydomain.com =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 155.155.122.122)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = myservername1)
> )
> )
>
> How do I use the above information to build a host connect string?
>
> Thanks, -Dave

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/qstart.htm#970614

Regards
/Rauf Received on Fri Jan 13 2006 - 10:25:08 CST