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)))
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 22 hr. 23 min. 33 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/rac2/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.123)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "racdb" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
Service "racdbXDB" has 1 instance(s).
Instance "racdb2", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@rac1 ~]$ /opt/app/grid/bin/crs_stat -t
Name Type Target State Host
------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE rac1
ora.DATA.dg ora....up.type ONLINE ONLINE rac1
ora....ER.lsnr ora....er.type ONLINE ONLINE rac1
ora....N1.lsnr ora....er.type ONLINE ONLINE rac1
ora....VERY.dg ora....up.type ONLINE ONLINE rac1
ora.asm ora.asm.type ONLINE ONLINE rac1
ora.eons ora.eons.type ONLINE ONLINE rac1
ora.gsd ora.gsd.type ONLINE ONLINE rac1
ora....network ora....rk.type ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type ONLINE ONLINE rac1
ora.ons ora.ons.type ONLINE ONLINE rac1
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type ONLINE ONLINE rac2
ora.racdb.db ora....se.type ONLINE ONLINE rac1
ora.scan1.vip ora....ip.type ONLINE ONLINE rac1
----------------------------------TNS PING ---------------------------------------------
[grid@rac2 ~]$ tnsping racdb1
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:02:20
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/opt/app/oracle/product/11.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = racdb1)))
OK (0 msec)
[grid@rac2 ~]$ tnsping racdb2
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:02:23
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/opt/app/oracle/product/11.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = racdb2)))
OK (0 msec)
[grid@rac2 ~]$ tnsping racdb
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:02:24
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/opt/app/oracle/product/11.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)) (LOAD_BALANCE = yes)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = racdb) (TYPE = session) (METHOD = basic) (RETRIES = 180) (DELAY = 5)))
OK (10 msec)
[解决办法]
TNS没有配置正确。
