Re: ORA-12514 with 10g Install

From: Scout <scout1024_at_gmail.com>
Date: Fri, 28 Dec 2007 15:13:51 -0800 (PST)
Message-ID: <60c60eff-fefd-42c2-becc-468f84f4a90e@p69g2000hsa.googlegroups.com>

Also,

Please note that a successful listener start messages look like:

---

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server
\network\admin\listener.ora

Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server
\network\log\listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
\EXTPROC_FOR_XEipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=<host>.domain.com)(PORT=1521)))

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                28-DEC-2007 12:38:27
Uptime                    0 days 0 hr. 0 min. 1 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\admin\listener.ora

Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server
\network\log\listener.log

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
\EXTPROC_FOR_XEipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST==<host>.domain.com) (PORT=1521)))
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...
The command completed successfully

Whereas the unsuccessful attempt looks like:

---

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 Received on Fri Dec 28 2007 - 17:13:51 CST