Oracle Database Express Edition (XE)

Hi Guys,

I am using Oracle XE 11g with Apex 4.2 installed. It was working fine till yesterday. Suddenly today morning I received the ORA-12541: TNS:no listener when tried to open Apex url.
I had gone through many threads in this forum and tried many suggested workaround but unfortunately nothing worked. So I am completely lost now.
Here is the various o/p of the issues. I am on Windows 7 x64. Its my own laptop so no host named changed from yesterday.

Listener file
----------------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = F:\Apex_Installed\app\oracle\product\11.2.0\server)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\Apex_Installed\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\Apex_Installed\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

-------------------------------------------------------------------

TNS Ora file


XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
----------------------------------------------------------------------------
After running LSNRCTL.exe o/p is below:

C:\Users\Rocks>lsnrctl.exe

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 07-MAY-2013 19:53
:24

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL> start
Starting tnslsnr: please wait...

TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error
LSNRCTL>

--------------------------------------------------------------------
I am able to connect SYSTEM user but when trying to connect XE database its throwing error.

C:\Users\Rocks>sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Tue May 7 19:39:03 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> connect system
Enter password:
Connected.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> alter system register;

System altered.

SQL> connect suvendu@xe
Enter password:
ERROR:
ORA-12541: TNS:no listener


Warning: You are no longer connected to ORACLE.
SQL> connect admin@xe
Enter password:
ERROR:
ORA-12541: TNS:no listener

SQL> exit
-----------------------------------------------------------------
Here is the o/p of different Environment variable.

C:\Users\Rocks>set|sort
ALLUSERSPROFILE=C:\ProgramData
APPDATA=C:\Users\Rocks\AppData\Roaming
CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
CommonProgramFiles=C:\Program Files\Common Files
CommonProgramW6432=C:\Program Files\Common Files
COMPUTERNAME=ROCKS-LAPI
ComSpec=C:\Windows\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Users\Rocks
LOCALAPPDATA=C:\Users\Rocks\AppData\Local
LOGONSERVER=\\ROCKS-LAPI
NUMBER_OF_PROCESSORS=4
ORACLE_HOME=F:\Apex_Installed\app\oracle\product\11.2.0\server
ORACLE_SID=XE
ORACLE_UNQNAME=XE
OS=Windows_NT
Path=F:\Apex_Installed\app\oracle\product\11.2.0\server\bin;F:\Apex_Installed\ap
p\oracle\product\11.2.0\server\bin;F:\Apex_Installed\app\oracle\product\11.2.0\s
erver\bin;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS
Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\Syste
m32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Co
mponents\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:
\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program
Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x8
6)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\
x64;C:\Program Files (x86)\Hewlett-Packard\HP ProtectTools Security Manager\Bin\

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTURE=AMD64
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 42 Stepping 7, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=2a07
ProgramData=C:\ProgramData
ProgramFiles(x86)=C:\Program Files (x86)
ProgramFiles=C:\Program Files
ProgramW6432=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
PTSMInstallPath_X86=C:\Program Files (x86)\Hewlett-Packard\HP ProtectTools Secur
ity Manager\
PUBLIC=C:\Users\Public
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\Windows
TEMP=C:\Users\Rocks\AppData\Local\Temp
TMP=C:\Users\Rocks\AppData\Local\Temp
USERDOMAIN=Rocks-Lapi
USERNAME=Rocks
USERPROFILE=C:\Users\Rocks
windir=C:\Windows
windows_tracing_flags=3
windows_tracing_logfile=C:\BVTBin\Tests\installpackage\csilogfile.log

--------------------------------------------------------------------------------------------------------
In Windows Services Menu I have only two services.

OracleJobSchedulerXE
OracleServiceXE

No Listener Service ---- hopefully this won't be an issue.
--------------------------------------------------

Everything looks fine to me but not sure why its not working. I am working on a project in Apex so cant uninstall the data application right now.
May I request you to help me please?

Thanks in advance.

Regards,
Suvendu