Re: ORA-12514 with 10g Install

From: Scout <scout1024_at_gmail.com>
Date: Wed, 26 Dec 2007 09:44:32 -0800 (PST)
Message-ID: <9a1789ac-6ee5-403c-853b-080eef54efab@s48g2000hss.googlegroups.com>

Thanks for all your inputs. Hope you all had a wonderful holiday!!!

David,

1. I have XP professional.
2. Here is a clarification on the listener startup. When I reboot, the listener is always not started and the OracleServiceXE is. On manual startup of the listener, it does start,but with some errors. And it fails to bind to the database instance. Here is the output of the lsnrctl start:

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 26- DEC-2007 10:50:53 Copyright (c) 1991, 2005, Oracle. All rights reserved.

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                26-DEC-2007 10:50:57
Uptime                    0 days 0 hr. 4 min. 46 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.domain.com)
(PORT=1521)))

The listener supports no services
The command completed successfully.

Arch,

3. I do have a copy of the listener.ora file before I edited it. And I did try to restore it and the tnsnames.ora and try them , but I get the same result.

Shakespeare,

4. You mentioned "Instead of using localhost (IIRC that won't work) you should use a local
loopback adapter with a fixed ip address. On windows, it should be the last
installed network device (for it will show up as first for the installer).
Put this one fully qualified in your host-file (first entry) and run the
installer. "

How do I do that? Received on Wed Dec 26 2007 - 11:44:32 CST