Re: ORA-12514 with 10g Install

<scout1024_at_gmail.com> schreef in bericht news:0090c12b-be7c-4ec5-a452-fa5fd524cf13_at_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!!!

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.

Shakespeare Received on Sat Dec 22 2007 - 13:19:28 CST