APEX

Hi,

I practiced with APEX till yesterday.
Today I'm not able to start OracleXETNSListener, thus not able to open APEX workspace.
Whenever I tried to start the listener I got the message below:

"The OracleXETNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

FYS, I have very limited knowledge about database.
I read about the solutions posted in this forum but couldn't understand.

Below are the files in ..\NETWORK\ADMIN\.
Would appreciate your help.

C:\OraXe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\listener.ora
------------------------------------------------------------------------------------------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\OraXe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\OraXe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = GYEON)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)



***************************************************************************************
..\sqlnet.ora
------------------------------------------------------------------------------------------------------------
SQLNET.AUTHENTICATION_SERVICES = (NTS)

(I changed (NTS) into (NONE) after reading one article but did not work out. So I changed back to the original setting.)

***************************************************************************************
..\tnsnames.ora
------------------------------------------------------------------------------------------------------------
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = GYEON)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

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

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

Thanks,
Guy

Message was edited by:
GUY

Message was edited by:
GUY