12.2 E-Business Suite - After A 12.1.3 To 12.2.5 Upgrade, Attempts To Start The Opmn And Apps Listeners Fail With Error 'TNS-01151: Missing listener name, APPS_TEST, in LISTENER.ORA'
Last updated on JANUARY 18, 2017
Applies to:Oracle Applications DBA - Version 12.2.5 and later
Microsoft Windows x64 (64-bit) - Version: 2008 R2
E-Business Suite 12.2 Applications DBA, Upgrade related issues
After an upgrade to 12.2, starting the opmn and apps listeners fail with the following error:
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 10.1.0.5.0 - Production
System parameter file is E:\oracle\TEST\12.1.0\NETWORK\ADMIN\TEST_db\listener.ora
Log messages written to E:\oracle\TEST\fs1\EBSapps\10.1.2\network\log\apps_test.log
TNS-01151: Missing listener name, APPS_TEST, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
adalnctl.cmd exiting with status 1
The issue can be reproduced at will with the following steps:
1. Upgrade from 12.1.3 to 12.2.5
2. start services
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