Oracle Database Discussions

I recently tried to install Oracle-XE on an Ubuntu 8.04 based workstation via a .deb package.
It seemed to install fine, in the sense that I could see the http://localhost:8080/apex page.
Sadly, not long after I installed it we had a power outage.

When I rebooted the system, I could no longer connect to the http://localhost:8080/apex
It seems that service does not start up. I edited the /etc/init.d/oracle-xe script to see the startup
messages and I figure it has something to do with ORA-01221 message.
I don't know what to do about that.
Since I haven't actually done anything with oracle beyond install it, I could simply reinstall.
But, power outages happen from time to time, so it would be nice to know how to recover
from this for next time, when and if it happens.

I am a complete oracle, SQL and database newbie, so please assume I know nothing.
If there is something I should be reading then please don't hesitate to say so.

Thanks
Doug

P.S. for the record, it is running in a Xen VM with 1Gb ram allocated and 2GB swap.


Starting Oracle Net Listener.

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-OCT-2008 09:03:38

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 23-OCT-2008 09:03:40
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Starting Oracle Database 10g Express Edition Instance.
ORACLE instance started.

Total System Global Area 293601280 bytes
Fixed Size 1258512 bytes
Variable Size 92277744 bytes
Database Buffers 197132288 bytes
Redo Buffers 2932736 bytes
Database mounted.
ORA-01221: data file 1 is not the same file to a background process