Re: ORA-12514 with 10g Install (LONG...)

From: Scout <scout1024_at_gmail.com>
Date: Wed, 23 Jan 2008 07:50:11 -0800 (PST)
Message-ID: <edf9274e-0aa2-4177-ae9b-a338ad59ecdf@i72g2000hsd.googlegroups.com>


>
> OK - your network seems to be defined,oraclewise. Your
> tnsnames.ora file know about ORCL, and so does the listener.
> Remains to be seem if orcl exists.

Today, the issues are different. Today, there are issues with the listener. Here are the results of my first tnsping orcl

Results of tnsping



C:\>tnsping orcl
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 23-JAN-2008 10:32:17
Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files:
C:\oracle\product\10.2.0\db\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = scout.domain.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICAT ED) (SERVICE_NAME = orcl)))
TNS-12541: TNS:no listener

And then I checked and it looked like the listener was down. So I tried to start it via services, and that didnt work. From the services, It prompted "The OracleOraDb10g_home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts Service". This has happened with the XE install too. But usually, when I use the command line to start it, it has worked. But today was different. Here are the results:

Results of listener start



C:\>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 23- JAN-2008 10:32:23
Copyright (c) 1991, 2005, Oracle. All rights reserved. Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production NL-00280: Message 280 not found; No message file for product=NETWORK, facility=NL [C:\oracle\product\10.2.0\db\network\log \listener.log]
 NL-00278: Message 278 not found; No message file for product=NETWORK, facility=NL
  SNL-00016: Message 16 not fou
Listener failed to start. See the error message(s) above... C:\>

I also checked the listener.log, and the last log was about 3 days ago.

Last lines of listener.log that are different


20-JAN-2008 18:36:37 * service_update * orcl * 0
20-JAN-2008 18:41:28 * service_update * orcl * 0
20-JAN-2008 18:43:07 * service_update * orcl * 0
20-JAN-2008 18:46:58 * service_update * orcl * 0
20-JAN-2008 18:51:49 * service_update * orcl * 0
20-JAN-2008 18:57:13 * service_update * orcl * 0
20-JAN-2008 19:00:28 * service_update * orcl * 0
20-JAN-2008 19:01:34 * service_update * orcl * 0
20-JAN-2008 19:04:01 * service_update * orcl * 0
20-JAN-2008 19:05:39 * service_died * orcl * 12547
TNS-12547: TNS:lost contact
20-JAN-2008 19:05:40 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle \product\10.2.0\db\bin\emagent.exe)(HOST=scout)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.222.222)(PORT=3717)) * establish * orcl * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
20-JAN-2008 19:05:55 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle \product\10.2.0\db\bin\emagent.exe)(HOST=scout)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.222.222)(PORT=3720)) * establish * orcl * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

Interestingly, there is also another log file in the same folder, called me1tnslistener.log, which I havent seen before.

All contents of me1tnslistener.log



TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 22- JAN-2008 08:59:51 Copyright (c) 1991, 2005, Oracle. All rights reserved.

Log messages written to C:\oracle\product\10.2.0\db\network\log \me1tnslistener.log
Trace information written to C:\oracle\product\10.2.0\db\network\trace \me1tnslistener.trc
Trace level is currently 0

Started with pid=1112
TNS-01151: Missing listener name, me1TNSListener, in LISTENER.ORA

> >> - can you:
> >> -- open a command prompt ("DOS box")
> >> -- type "set oracle_sid=orcl"
> >> -- type "sqlplus / as sysdba"
> >> both times without the quotes.
> >> Post the results of that.
>
> > Results of SQLPLUS/ as sysdba:
> > ------------------------------------------------
Yes, I am positive that I set the oracle_sid before. I repeated the exercise, but since the listener is down, the behaviour is different. C:\>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 23 10:40:50 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name: SYSDBA
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:

> Are you on a domain (sometimes, not always?), by any chance?
yes I am.

> Could you inspect your path variable and see if anything from
> previous installs is still there? DOS used to have a limit of 128
> characters, but XP uses 4k (iirc) - if you have installed/de-installed
> a lot, you may have crossed that boundary...Oracledoes not do a good
> job cleaning up on de-installs...

I did a good cleanup job, including clearing the registry etc. I followed the instructions that Oracle gave for uninstalling, which did include a log of manual tasks. Since my past history with Oracle hasnt been the best, I was careful to follow every little detail.

> Check if C:\oracle\product\10.2.0\db is in your path (preferably at the
> beginning)

I dont have C:\oracle\product\10.2.0\db, but I have C:\oracle\product \10.2.0\db\bin in the path, and yes, at the beginning!!

This is getting more challenging, isnt it? You inspire me to not give up!! Received on Wed Jan 23 2008 - 09:50:11 CST

Original text of this message