My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.