当前位置: 代码迷 >> Oracle管理 >> RAC ORA-12537 TNS:connection closed.解决方法
  详细解决方案

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

热度:91   发布时间:2016-04-24 05:28:54.0
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)))
  相关解决方案