ORA-12514 with 10g Install

From: <scout1024_at_gmail.com>
Date: Thu, 20 Dec 2007 12:47:19 -0800 (PST)
Message-ID: <0090c12b-be7c-4ec5-a452-fa5fd524cf13@w40g2000hsb.googlegroups.com>

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

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. I tried with and without the hostname as well as with the IP address with no luck.

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!!! Received on Thu Dec 20 2007 - 14:47:19 CST