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

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