Problems starting new TNS Listener
Date: Thu, 7 May 2009 01:11:03 -0700 (PDT)
Message-ID: <88196777-c81c-4523-a74b-171bda61e5b3_at_g19g2000vbi.googlegroups.com>
Hi folks,
I've a strange problem occurring on Windows after the DBUA.
I've an automated application (written with c#) which, among other things, silently launches the Oracle DBUA tool (for upgrading an Oracle XE to an Oracle SE), and then create a new listener for the newly created instance with the following command:
%ORACLE_DIR%\bin\netca.bat /silent /responsefile C:\scripts\netca.rsp
(if you need the complete rsp script I can post it)
After that I've a Windows service named
OracleMX_ORAH10203TNSListenerSE, which points to C:\oracle\product
\10.2.0\db_1\BIN\TNSLSNR
Everything seems to be OK and all the system variables are set
correctly:
ORACLE_HOME = C:\oracle\product\10.2.0\db_1
ORACLE_SID = SE
Nonetheless the listener doesn't automatically starts up, and when I
launch the following command:
C:\oracle\product\10.2.0\db_1\bin\lsnrctl start SE
it gives me this output:
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 07- MAG-2009 09:53:55 Copyright (c) 1991, 2006, Oracle. All rights reserved.
Avvio di tnslsnr: attendere...
TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Production
Il file dei parametri di sistema Þ C:\oraclexe\app\oracle\product
\10.2.0\server\network\admin\listen
er.ora
Messaggi di log registrati in C:\oraclexe\app\oracle\product
\10.2.0\server\network\log\se.log
TNS-01151: Manca il nome del listener, SE, in LISTENER.ORA
Avvio listener non riuscito. Vedere i messaggi di errore sopra riportati...
Sorry for the messages in Italian, but I think that the important things to notice is the fact that it tries to start the wrong (old) XE listener from the wrong path ("C:\oraclexe"), instead of the newly created SE one ("C:\oracle\").
Even more strange: if I reboot Windows the SE listener starts
correctly.
Even more strange: with Windows Vista everything works well, the
problem is only on WinXP.
I'm struggling to find a way (a parameter to pass to lsnrctl for example) for starting the listener specifying where to read the listener.ora from.
I have these two conditions: 1) I cannot reboot the machine. 2) the creation of the new listener must remain silent (with the rsp file)
Thank you in advance! Received on Thu May 07 2009 - 03:11:03 CDT