XE service lost after windows server 2003 restart - must start repair
724528Sep 25 2009 — edited Aug 3 2010I have a problem with Oracle XE 10g on Windows 2003 SP2.
Installation went fine, I could use database, go to home page, add tables, views, functions etc.., link database to sql server and query tables from several sql several sql servers on the network etc.
In general everything was fine, but...
After windows 2003 restart XE service does not start, db home page is not accessible and
lsnrctl stat
is giving me:
***************************************************************************************
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-RUJ-2009 22:46
:26
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(OVO NE RADI) (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR
_XE))(ADDRESS=(PROTOCOL=TCP)(HOST=sql-server-test.ie.local)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 25-RUJ-2009 22:45:56
Uptime 0 days 0 hr. 0 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sql-server-test.ie.local)(PORT=1521)
)(OVO NE RADI) (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
***************************************************************************************
There is no sign of XE, XEXBD nor XE_XPT service.
I restarted installation and performed repair and everything went back to normal.
After repair
lsnrctl stat
is giving
***************************************************************************************
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-RUJ-2009 23:11
:40
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(OVO NE RADI) (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR
_XE))(ADDRESS=(PROTOCOL=TCP)(HOST=sql-server-test.ie.local)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 25-RUJ-2009 22:45:56
Uptime 0 days 0 hr. 25 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sql-server-test.ie.local)(PORT=1521)
)(OVO NE RADI) (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=
HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully
***************************************************************************************
After repair all is good but I must not restart server.
If I do this the story repeats itself.
No XE, XEXBD etc services, no access to database nor to homepage.
Starting install/repair - everything works. After restart same story again....
I could not find the way to aviod constant repair after restart.
Is there any way out of this?