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
Received on Wed Sep 14 2005 - 13:01:48 CDT
