Oracle Database Express Edition (XE)

Hi All

I have installed Oracle 10g Express edition on my PC having windows XP as OS.
Now when i try to goto database homepage, it's gives 'No pages Displayed' error.

When i checked the listner service using LSNRCTL.exe, the result is as below:


{color:#0000ff}C:\>LSNRCTL.exe{color}


{color:#0000ff}LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-MAR-2009 12:18
:47{color}


{color:#0000ff}Copyright (c) 1991, 2005, Oracle. All rights reserved.{color}


{color:#0000ff}Welcome to LSNRCTL, type "help" for information.{color}


{color:#0000ff}LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 11-MAR-2009 09:06:38
Uptime 0 days 3 hr. 12 min. 16 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=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=L8Q3JPB1.CED.CORP)(PORT=
1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=L8Q3JPB1.CED.CORP)(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 BLOCKED, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
{color}
After going through few post on this forum i tried to OPEN the database, it's seems that the database in not mounted.


so i tried as below:


I get the results:
{color:#0000ff}SQL>connect / as sysdba;
Connected{color}


{color:#0000ff}SQL>select count(*) from hr.employees;
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only{color}


{color:#0000ff}SQL>alter database open;
*
ERROR at line 1:
ORA-01507: database not mounted{color}


{color:#0000ff}SQL>alter database mount;
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info
{color}
I have preety much free space on the hard drive.

So what would be the possible work around for this problem.

Please give me guideline.

Thanks,
Onkar