IKerr. wrote:
> 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
>>
>
>
>
You got some stuff pretty mixed up then....
Is there anything like OracleServiceXXXXX (where XXXXX is anything
between 4 and 8 characters; ORCL would be an oracle default)
--
Regards, Frank van Bortel
Received on Sun Mar 16 2003 - 06:27:45 CST
