Re: ORA-12514 with 10g Install

On Dec 20, 2:47 pm, scout1..._at_gmail.com wrote:
> 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!!!

I'll ask if you're using dynamic IP assignment.

David Fitzjarrell Received on Thu Dec 20 2007 - 16:03:07 CST