Re: 10g server won't start on XP

Jeff C wrote:
> Hello everyone,
>
> I downloaded and installed the Oracle 10g database
> Enterprise Edition for Windows XP on my home computer
> back in June, and used in for an online class.
> After the class was over, I didn't use it for a while,
> and then I noticed that it seems to have partially crashed,
> and won't start again:
>
> In XP's Administrative Tools --> Services I want
> to start:
>
> OracleServicesJeffDB1 (this starts ok)
> OracleOraDb10g_home1TNSListener (starts, but quickly dies)
> OracleDBConsoleJeffDB1 (won't start)
>
> Of course, I rebooted, etc... but this
> made no improvement. Here are some excerpts from the
> logs (sorry, probably a lot of irrelevant stuff):
>
>
> **************************************************************
> .../sysman/log/OracleDBConsoleJeffDB1srvc.log:
> ***************************************************************
>
> -------------- [OracleDBConsoleJeffDB1] ------------
> EMDROOT=D:\oracle\product\10.1.0\Db_1
> ORACLE_HOME=D:\oracle\product\10.1.0\Db_1
> EMDSTATE=D:\oracle\product\10.1.0\Db_1\<my_ip_addr>_JeffDB1
> CONSOLE_CFG=dbconsole
> TRACE_LEVEL=16
> TIMEOUT=15
> 07/29/05 15:58:43 Start pending...
> 07/29/05 15:58:43 Verifying dbconsole is not started already. Command
> line "D:\oracle\product\10.1.0\Db_1\bin\emctl.bat" istatus dbconsole
> 07/29/05 15:59:05 dbconsole launch commandline is
> "D:\oracle\product\10.1.0\Db_1\bin\emctl.bat" istart dbconsole
> 07/29/05 15:59:05 Tracking process launch...
> 07/29/05 15:59:41 Did not hear back from emctl istatus.
> 07/29/05 15:59:41 Waiting a further 5 secs...
> 07/29/05 15:59:46 Did not hear back from emctl istatus.
> 07/29/05 15:59:46 Waiting a further 5 secs...
> 07/29/05 15:59:51 Did not hear back from emctl istatus.
> 07/29/05 15:59:51 Waiting a further 5 secs...
> 07/29/05 15:59:53 Received exitCode 3 from emctl istatus
> 07/29/05 15:59:53 dbconsole started
> 08/01/05 00:53:57 Recieved ServCtrlHdlr command, 5
> 08/01/05 00:53:57 Stopping dbconsole
> 08/01/05 00:53:57 Launching stop EMD process...
> 08/01/05 00:53:58 Waiting for stop EMD process to exit. numRetries=74
> 08/01/05 00:54:03 Waiting for stop EMD process to exit. numRetries=73
> 08/01/05 00:54:07 Stop process has exited with exitCode: 0
> 08/01/05 00:54:07 Waiting for emwd process to exit. numRetries=74
> 08/01/05 00:54:12 Waiting for emwd process to exit. numRetries=73
> 08/01/05 00:54:17 Waiting for emwd process to exit. numRetries=72
>
> -------------- [OracleDBConsoleJeffDB1] ------------
> EMDROOT=D:\oracle\product\10.1.0\Db_1
> ORACLE_HOME=D:\oracle\product\10.1.0\Db_1
> EMDSTATE=D:\oracle\product\10.1.0\Db_1\<my_ip_addr>_JeffDB1
> CONSOLE_CFG=dbconsole
> TRACE_LEVEL=16
> TIMEOUT=15
> 08/01/05 15:49:27 Start pending...
> 08/01/05 15:49:27 Verifying dbconsole is not started already. Command
> line "D:\oracle\product\10.1.0\Db_1\bin\emctl.bat" istatus dbconsole
> 08/01/05 15:49:53 dbconsole launch commandline is
> "D:\oracle\product\10.1.0\Db_1\bin\emctl.bat" istart dbconsole
> 08/01/05 15:49:53 Tracking process launch...
> 08/01/05 15:50:26 Received exitCode 3 from emctl istatus
> 08/01/05 15:50:26 dbconsole started
>
> -------------- [OracleDBConsoleJeffDB1] ------------
> EMDROOT=D:\oracle\product\10.1.0\Db_1
> ORACLE_HOME=D:\oracle\product\10.1.0\Db_1
> EMDSTATE=D:\oracle\product\10.1.0\Db_1\<my_ip_addr>_JeffDB1
> CONSOLE_CFG=dbconsole
> TRACE_LEVEL=16
> TIMEOUT=15
> 08/04/05 18:16:28 Start pending...
> 08/04/05 18:16:28 Verifying dbconsole is not started already. Command
> line "D:\oracle\product\10.1.0\Db_1\bin\emctl.bat" istatus dbconsole
> 08/04/05 18:16:46 dbconsole launch commandline is
> "D:\oracle\product\10.1.0\Db_1\bin\emctl.bat" istart dbconsole
> 08/04/05 18:16:46 Tracking process launch...
> 08/04/05 18:17:16 dbconsole exited with retCode 2.
> 08/04/05 18:17:16 Check
> D:\oracle\product\10.1.0\Db_1\sysman\log\OracleDBConsoleJeffDB1.nohup
> for details
> *******************AND THAT .nohup FILE DOES NOT EXIST ***************
>
>
> ************************************************************************
> listener.log
> ************************************************************************
>
> TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production on
> 10-SEP-2005 13:50:42
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> System parameter file is
> D:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
> Log messages written to
> D:\oracle\product\10.1.0\Db_1\network\log\listener.log
> Trace information written to
> D:\oracle\product\10.1.0\Db_1\network\trace\listener.trc
> Trace level is currently 0
>
> Started with pid=1016
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
> Error listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=(<my_ip_addr>)(PORT=1521)))
> TNS-12545: Connect failed because target host or object does not exist
> TNS-12560: TNS:protocol adapter error
> TNS-00515: Connect failed because target host or object does not
> exist
> 32-bit Windows Error: 49: Unknown error
> No longer listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
>
>
>
> So maybe this is a network error unrelated to Oracle??
> Other programs seem to be able to access the internet ok...
>
> Any help would be appreciated.
>
> --Jeff

Looks from your services that the db itself is ok. What does the alert.log say?

You have your listener configured for s specific IP address?? And this is on your home computer? Where do you get your IP address? DHCP and assigned by you ISP? If so, you're probably not running under the same IP address as when you first set up. I believe that would be consistent with the TNS- error msgs in your listener log. Received on Wed Sep 14 2005 - 13:14:07 CDT