Re: Newbie connection, please Help!

From: David Fitzjarrell <oratune_at_aol.com>
Date: Mon, 22 Jan 2001 19:48:29 GMT
Message-ID: <94i2q9$42f$1@nnrp1.deja.com>

In ouir last gripping episode james_one_at_my-deja.com wrote:
> I need to connect to an Oracle db over the internet. I've been
 provided
> with the following info: (altered for question)
>
> > > Version 7.3
> > > IP address: 1.2.3.4
> > > Username: user
> > > Password: password
> > > Connect string / database alias: ABC
>
> I've set up a service name in the net 8 configuration called ABC, with
> a hostname of ABC using TCP/IP and the standard port of 1521. My
> Tnsnames.ora file looks like this:
>
> ABC =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = ABC)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ABC)
> )
> )
>
> When I try to connect through SQL plus using the username and password
> and ABC as my host string, I get the following error:
>
> ORA-12505: TNS: Listener could not resolve SID given in connect
> descriptor.
>
> What am I doing wrong here?
> I also tried putting ABC in my hosts file. Now I can ping it by name,
> but I still can't connect through sql plus.
>
> Please help! Thanks to all in advance.
>
> Sent via Deja.com
> http://www.deja.com/
>

Use this definition instead:

 ABC =
   (DESCRIPTION =

     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SID = ABC)
     )

   )

8i uses service names. All other releases utilise the SID. Also your HOST should be the IP address provided. ABC is the Oracle SID, not the hostname.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/

Received on Mon Jan 22 2001 - 13:48:29 CST