Re: Newbie connection, please Help!

From: <james_one_at_my-deja.com>
Date: Mon, 22 Jan 2001 21:11:06 GMT
Message-ID: <94i7l1$923$1@nnrp1.deja.com>

Still getting the error.
Do I need to configure the listener on the client?

In article <94i2q9$42f$1_at_nnrp1.deja.com>,   David Fitzjarrell <oratune_at_aol.com> wrote:
> 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/

>

Sent via Deja.com
http://www.deja.com/ Received on Mon Jan 22 2001 - 15:11:06 CST