Re: Newbie connection, please Help!

From: <james_one_at_my-deja.com>
Date: Wed, 24 Jan 2001 14:46:28 GMT
Message-ID: <94mps0$4j3$1@nnrp1.deja.com>

You we're correct, the SID was wrong.
Thank you for all your help.

In article <94i9vl$b3h$1_at_nnrp1.deja.com>,   David Fitzjarrell <oratune_at_aol.com> wrote:
> In our last gripping episode james_one_at_my-deja.com wrote:
> > That did something, it takes much longer, but now I get a new error:
> >
> > 12154 - TNS could not resolve service name.
> >
> > Here is what Net 8 easy config generated:
> >
> > ABC =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SID = ABC)
> > )
> > )
> >
> > In article <94i843$9bb$1_at_nnrp1.deja.com>,
> >
> > David Fitzjarrell <oratune_at_aol.com> wrote:
> > > In our last gripping episode james_one_at_my-deja.com wrote:
> > > > 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/
> > > >
> > >
> > > The client shouldn't have a listener, unless the client is another
> > > instance.
> > >
> > > Try using the Net8 Easy Config utility (I shall presume your
 client
 is
> > > an NT/W2K machine) to configure the TNSNAMES.ORA entry. My guess
 is
> > > you're using the 8i client to access the 7.3 database and you
 haven't
> > > configured the TNSNAMES.ORA to access an Oracle 8 or earlier
 database.
> > >
> > > --
> > > David Fitzjarrell
> > > Oracle Certified DBA
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> > >
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >

>

> Verify the information provided to you. Then go back through the Net8
> Easy Config and test the connection. I imagine that one or more
 pieces
> of information supplied to you are incorrect as the TNSNAMES.ORA entry
> generated by the utility should allow you to successfully connect.

>

> --
> David Fitzjarrell
> Oracle Certified DBA

>

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

>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 08:46:28 CST