Windows: After 11i Apps Clone, Unable To Start TNS Listener: TNS-01151: Missing Listener Name (Doc ID 759828.1)

Last updated on DECEMBER 06, 2012

Applies to:

Oracle Net Services - Version 9.2.0.1.0 to 11.1.0.7 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 06-DEC-2012***
This problem can occur on any platform.

Symptoms

-- Problem Statement:
Server: Oracle9i R2 (9.2.0.7) on Microsoft Windows Server 2003 SP2

After cloning the production DB to Test DB to another server, the listener named 'TST' and 'TST' Database instance will not start in the Test Oracle Home.
Try starting listener server - fails with the following error:

TNS-01151: Missing listener name, TST, in LISTENER.ORA
Note: The TNS Listener is not reading the correct listener.ora configuration file, but is looking for the Oracle Net configuration files in a different Oracle Home or TNS_ADMIN location even though the ORACLE_HOME and TNS_ADMIN system environment variables are pointing to
TST Oracle Home location: D:\Oracle\tstdb\9.2.0.

For example:
ORACLE_HOME = D:\Oracle\tstdb\9.2.0
TNS_ADMIN = D:\Oracle\tstdb\9.2.0\network\admin\TST_mistst001

From command line running:

D:\Oracle\tstdb\9.2.0\appsutil\install\TST_mistst001\adsvdlsn.cmd also fails:
LSNRCTL for 32-bit Windows: Version 9.2.0.7.0 - Production on 06-JAN-2009 09:51:46

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 9.2.0.7.0 - Production
System parameter file is E:\oracle\devdb\9.2.0\network\admin\DEV_mistst001\listener.ora
Log messages written to E:\oracle\devdb\9.2.0\network\log\tst.log
TNS-01151: Missing listener name, TST, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

addlnctl.cmd exiting with status 3
ChangeServiceConfig succeeded
adsvdlsn.cmd exiting with status 0
ERRORCODE = 0 ERRORCODE_END

Log file confirms the reported 'TNS-01151: Missing listener name, TST, in LISTENER.ORA' error
message.

Changes

 This is a newly cloned environment.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms