Oracle Database Discussions

Hello All,

I am new to Oracle and I installed the Oracle 10g Express Edition on my windows laptop.

Immediately after installation, it worked great and I was able to look at the tables etc. But after a few days, I cannot seem to log in to my database home page.

When I try to connect through TOAD, the error I get is "ORA-12514:TNS:Listener does not know of service requested in connect descriptor"

This is what I get when I run the status check using "lsnrctl status"

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Message 279 not found; No message file for product=NETWORK, facility=NL
Message 1073 not found; No message file for product=NETWORK, facility=TNS
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
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=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 20-DEC-2007 13:53:19
Uptime 0 days 0 hr. 0 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XYZ)(PORT=1521)))
The listener supports no services
The command completed successfully

This is the status after I have started the listener first and then the database service(OracleServiceXE).

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


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


DEFAULT_SERVICE_LISTENER = (XE)

sqlnet.ORA has:
------------------------
SQLNET.AUTHENTICATION_SERVICES = (NTS)

tnsname.ora has:
------------------------

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(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)
)
)

The one thing I changed in the ora files was the HOST=XYZ parameter and I made it HOST=localhost parameter. And the listener.log file hasnt been updated since the time I installed it.



Please help if you have an idea of what could be wrong!!! I have tried re-installing as well, but that doesnt seem to work either. Even after re-installation, it seems to work immediately after installation but not subsequently.

Any help or direction would be realllly appreciated!!!

Message was edited by:
user603509