Re: newbie needs help: ORA-12541 & ORA-12500 TNS listener probblems

From: IKerr. <i.b.kerr.n.o-spam_at_leeds.ac.uk>
Date: Sat, 15 Mar 2003 11:08:17 -0000
Message-ID: <1VDca.1791$Gk6.9965@newsfep4-glfd.server.ntli.net>

Hi,

I tried

C:\>net start OracleServiceMyGlobal
The service name is invalid.

More help is available by typing NET HELPMSG 2185.

and went to control panel and services. I couldn't find a service called MYGLOBAL (the name of the db), I did manually start the OracleDEFAULT_HOMETNSListener, but there was no change in the error.

Iain

"Frank" <fvanbortel_at_netscape.net> wrote in message news:3E723FE1.20207_at_netscape.net...
> IKerr. wrote:
> > Hi,
> > I had a w2k crash which needed a partial re-install. I have also
> > re-installed Oracle 9 & Oracle DS. This is on a local desktop machine.
> > Towards the very end of the install there was a glitch (possibly because
I
> > didn't know how to answer some net setup questions ?). Now when I try
and
> > startup my old db I get
> >
> > ORA-12541: TNS: no listener
> >
> > I have searched on the newsgroups and tried this
> >
> > c:\> lsnrctl
> >
> > and then:
> >
> > LSNRCTL> start
> > Starting tnslsnr: please wait...
> > TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
> > System parameter file is C:\orant\network\admin\listener.ora
> > Log messages written to C:\orant\network\log\listener.log
> > Listening on:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521))
> > Connecting to

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))
> > STATUS of the LISTENER
> > ------------------------
> > Alias LISTENER
> > Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Prod
> > tion
> > Start Date 12-MAR-2003 12:01:29
> > Uptime 0 days 0 hr. 0 min. 2 sec
> > Trace Level off
> > Security OFF
> > SNMP OFF
> > Listener Parameter File C:\orant\network\admin\listener.ora
> > Listener Log File C:\orant\network\log\listener.log
> > Listening Endpoints Summary...
> > (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
> > Services Summary...
> > Service "PLSExtProc" has 1 instance(s).
> > Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
> > Service "myGlobal" has 1 instance(s).
> > Instance "myGlobal", status UNKNOWN, has 1 handler(s) for this
service...
> > The command completed successfully
> > LSNRCTL>
> >
> > When I try to logon to the db in Enterprise Manager Console
(standalone). I
> > get:
> >
> > ORA-12500: TNS listener failed to start a dedicated server process.
> >
> <SNIP!> Irrelevant

>

> You did not start the oracleservice; reading your thread, it should
> be called OracleServiceMyGlobal

>

> Either run: net start OracleServiceMyGlobal from the prompt,
> or start in your services panel
> --
> Regards, Frank van Bortel

> Received on Sat Mar 15 2003 - 05:08:17 CST