Oracle
1Z0-052 · Question #253
1Z0-052 Question #253: Real Exam Question with Answer & Explanation
The correct answer is D: change the port number to an unused port number and restart the listener process. The TNS-12542 error indicates port 8899 is already bound by another process, so listener L1 cannot start on that address.
Configuring the Oracle Network Environment
Question
You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While starting up the listener process, you get the following error message: LSNRCTL> start l1 Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 10.1.0.2.0 - Production System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=144.23.230.185)(port=8899)) TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use Listener failed to start. See the error message(s) above... What action would you take to overcome this error without disrupting any existing database communications?
Options
- Astop and restart the listener process
- Bset the TNS_ADMIN environmental variable
- Cstop all running listener processes and restart the listener process
- Dchange the port number to an unused port number and restart the listener process
- Echange the IP address to host machine name in the LISTENER.ORA file and restart the listener
Explanation
The TNS-12542 error indicates port 8899 is already bound by another process, so listener L1 cannot start on that address.
Common mistakes.
- A. Stopping and restarting L1 does not resolve the conflict because port 8899 is held by a different process, not L1 itself.
- B. TNS_ADMIN controls where Oracle searches for network configuration files and has no effect on an OS-level port binding conflict.
- C. Stopping all listeners would free port 8899 only if another Oracle listener owns it, but the underlying listener.ora still assigns port 8899 to L1, so the conflict recurs on the next start.
- E. The error is a port binding failure, not a hostname resolution issue; substituting a hostname for the IP address does not release port 8899 or fix the conflict.
Concept tested. Oracle listener port conflict resolution TNS-12542
Reference. https://docs.oracle.com/cd/B19306_01/network.102/b14213/listener.htm
Topics
#listener configuration#TNS-12542 port conflict#listener.ora#port number
Community Discussion
No community discussion yet for this question.