Database Software

It seems I can never leave this group, but many thanks to those who've got us this far.

I recently recovered our 9i database in Windows XP. I was initially able to open and view the database via sql and the enterprise manager. However after a restart I can no longer open it, though I can mount it. Upon attempting to open it I get ORA 01092, Oracle instance terminated, disconnection forced.

I've checked that:

1) the tnsnames.ora and listener.ora files all have the same entry for HOST (although in the listener status below I see several values, I don't know if this is related to this problem. I also notice that the status for our database is listed as 'unknown' in the listener status. When I was initially able to log in via enterprise manager it also reported the same thing.)
2) ORACLE_SID is set= <SID>.
3) There aren't any errors being reported in /RDBMS/TRACE/alert_<sid>.log. Are they going elsewhere?
4) I am able to tnsping our SID.
5) Under Services, there is a OracleService<sid> that is started and set to start upon startup.

Any ideas? Thanks!

From lsnrctl status:

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 14-MAR-2010 22:30:21

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST>)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
Start Date 14-MAR-2010 22:09:43
Uptime 0 days 0 hr. 20 min. 39 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File D:\oracle\ora90\network\admin\listener.ora
Listener Log File D:\oracle\ora90\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<longer host name than shown above, possibly contains domain info?>)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "<SID>" has 1 instance(s).
Instance "<SID>", 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

The tnsnames.ora file is:
####################################
# TNSNAMES.ORA Configuration File:D:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Fri Aug 01 11:00:03 PDT 2003
####################################

AGI =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <HOST>)(PORT = 1521))
)
(CONNECT_DATA = (SID = <SID>)(SERVER = DEDICATED))
)

The listener.ora file is:

# LISTENER.ORA Network Configuration File: D:\oracle\ora90\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <HOST>)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(Global_DBNAME = <SID>)
(ORACLE_HOME = D:\oracle\ora90)
(SID_NAME = <SID>)
)
)