oracle rac ora 12537,RAC ORA-12537 TNS:connection closed.解决方法

当前位置:我的异常网» Oracle管理 » RAC ORA-12537 TNS:connection closed.解决方法

RAC ORA-12537 TNS:connection closed.解决方法

www.myexceptions.net  网友分享于：2015-08-26  浏览：2450次

RAC ORA-12537 TNS:connection closed.

在完成RAC安装，ORACLE 安装后。进行数据库建立。但出错。

ORA-12537 TNS:connection closed.

后面再出错，如下：

由于以下错误，Enterprise Manager 配置失败，用户名/口令无效，或数据库/扫描监听程序末启动，或数据库服务器末注册到扫描监听程序，

有关详细资料，可参考：

opt/app/oracle/cfgtoollogs/dbca/racdb/emConfig.log 中的日志文件。

您可以以后通过手动运行 /opt/app/oracle/product/11.2.0/bin/emca 脚本，重新使用EM 配置此数据。

------------------- opt/app/oracle/cfgtoollogs/dbca/racdb/emConfig.log ------------------------

2011-8-2 14:33:39 oracle.sysman.emcp.EMConfig perform

严重: 用户名/口令无效, 或数据库/扫描监听程序未启动, 或数据库服务未注册到扫描监听程序。

有关详细资料, 请参阅 /opt/app/oracle/cfgtoollogs/dbca/racdb/emConfig.log 中的日志文件。

2011-8-2 14:33:39 oracle.sysman.emcp.EMConfig perform

配置: Stack Trace:

oracle.sysman.emcp.exception.EMConfigException: 用户名/口令无效, 或数据库/扫描监听程序未启动, 或

数据库服务未注册到扫描监听程序。

at oracle.sysman.emcp.EMDBPreConfig.validatePassword(EMDBPreConfig.java:4089)

at oracle.sysman.emcp.EMDBPreConfig.checkConfigParams(EMDBPreConfig.java:1626)

at oracle.sysman.emcp.EMDBPreConfig.checkParameters(EMDBPreConfig.java:1403)

at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:209)

at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)

at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)

at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)

at oracle.sysman.assistants.dbca.backend.PostDBCreationStep.executeImpl(PostDBCreationStep.java:931)

at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)

at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)

at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)

at java.lang.Thread.run(Thread.java:595)

2011-8-2 14:33:39 oracle.sysman.emcp.EMConfig restoreOuiLoc

配置: Restoring oracle.installer.oui_loc to /opt/app/oracle/product/11.2.0/oui

----------------------------------检查监听-----------------------------

[grid@rac1 admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:40:26

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 01-AUG-2011 17:32:24

Uptime 0 days 21 hr. 8 min. 2 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /opt/app/grid/network/admin/listener.ora

Listener Log File /opt/app/oracle/diag/tnslsnr/rac1/listener/alert/log.xml

Listening Endpoints Summary...

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

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.18.121)(PORT=1521)))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "racdb" has 1 instance(s).

Instance "racdb1", status READY, has 1 handler(s) for this service...

Service "racdbXDB" has 1 instance(s).

Instance "racdb1", status READY, has 1 handler(s) for this service...

The command completed successfully

[grid@rac2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 15:55:57

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521)))

文章评论