052-235(新增70题2018)

本文介绍了一种常见数据库监听器启动错误TNS-12542的解决方案,当指定的监听地址已被使用时,通过更改端口号为未使用的端口并重启监听器过程,可以有效避免此问题。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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?

A. stop and restart the listener process

B. set the TNS_ADMIN environmental variable

C. stop all running listener processes and restart the listener process

D. change the port number to an unused port number and restart the listener process

E. change the IP address to host machine name in the LISTENER.ORA file and restart the listener process

Answer: D

TNS-12542: TNS:address already in use

Cause: Specified listener address is already being used.
Action: Start your listener with a unique address.

 

转载于:https://www.cnblogs.com/Babylon/p/8622257.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值