oracle dg 报监听错误,oracle配置DG的时候,碰到监听无法启动的问题及解决方法

[oracle@dg-01 admin]$lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-JUN-2010 02:35:37

Copyright (c) 1991, 2005, Oracle.All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start

Starting /u01/oracle/product/database/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production

System parameter file is /u01/oracle/product/database/network/admin/listener.ora

Log messages written to /u01/oracle/product/database/network/log/listener.log

Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-12560:TNS:protocoladapter error

TNS-00583: Valid node checking: unable to parse configuration parameters

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

造成以上错误的原因为:配置监听和手动创建数据库的顺序倒了,应该在先安装完数据库软件后,再配置网络监听,接下来再进行数据库的手动创建工作。

把之前创建的数据库test1,用DBCA图形工具删除,再用netca命令重新配置网络监听,即可。

48180_100623093841.jpg

[oracle@dg-01 admin]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-JUN-2010 16:28:17

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg-01.primary.com)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production

Start Date 23-JUN-2010 16:22:49

Uptime 0 days 0 hr. 5 min. 29 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/oracle/product/database/network/admin/listener.ora

Listener Log File /u01/oracle/product/database/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg-01.primary.com)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值