Re: Oracle 8i (8.1.5) ORA-12500

Make sure that the entry in tnsnames.ora is labelled in the form <sid.domain>. The domain
being the default domain name as defined in the names.default_domain parameter in the sqlnet.ora
file, this defaults to world.

For example, if the SID of the instance is FRED, the tnsnames entry must be named FRED.world.

Regards,
Mark Brayshaw
Consultant,
Interim Technology
Level 4, 11 Harvest Terrace, West Perth WA 6005, AUSTRALIA Perth: Ph: +61 8 9481 0488 Fax: +61 8 9481 6576 Mobile: 0409 405 411
mailto:markbrayshaw_at_interim.com
http://www.interimtechnology.com.au

Transforming the way people work with technology with PERFORMANCE - TEAMWORK - LEARNING - INNOVATION - INTEGRITY

<eloos_at_atsecure.net> wrote in message news:82jmfs$ne6$1_at_nnrp1.deja.com...
> Thanks for the reply. Yes, we can TNSPING80 the server by its IP
> address and by its name. What should we try next?
>
> In article <zWD14.269$dX3.20088_at_typ11.nn.bcandid.com>,
> "Van Messner" <vmessner_at_netaxis.com> wrote:
> > Is your listener started? Are your NT services started?
> Yes. Yes.
> > If yes then try pinging the server from the client. If you can't
> ping talk
> > to the syadmin or network admin.
> > If you can ping then try tnspinging - first by ip, second by alias.
> Yes. Yes.
> > If you can't tnsping by ip, you probably have a problem in your
> tnsnames. on
> > the client or server or both or in the listener.ora on the server or
> just
> > maybe on the sqlnet.ora on the server.
> > If you can ping by ip but not by name then you may have a problem in
> one of
> > the three files above or you may have a problem with name
> resolution. Talk
> > to the sysadmin or network admin.
> >
> > <eloos_at_atsecure.net> wrote in message
> news:826cci$jnd$1_at_nnrp1.deja.com...
> > > We have just installed Oracle 8i on one of our servers and cannot
> seem
> > > to connect from a client PC. We keep getting the ORA-12500 error
> (The
> > > listener was unable to start a dedicated process connecting the
> user to
> > > the database.) I've tried looking at LISTENER.ORA and TNSNAMES.ORA
> but
> > > haven't solved the problem. What are the likely problems with a very
> > > basic install? (Oracle 7 was not this much trouble. SQL Svr 7
> installed
> > > like a charm.)
> > >
> > > Eric Loos
> > > Advanced Technologies
> > > eloos_at_atsigma.com
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 08 1999 - 01:52:08 CST