在完成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 statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:40:26Copyright (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 statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 15:55:57Copyright (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 racdb1TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:02:20Copyright (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 racdb2TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:02:23Copyright (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 racdbTNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:02:24Copyright (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)
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 statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:40:26Copyright (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 statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 15:55:57Copyright (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 racdb1TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:02:20Copyright (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 racdb2TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:02:23Copyright (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 racdbTNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-AUG-2011 14:02:24Copyright (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)
解决方案 »
- linux oracle 下 存储过程调用java执行系统命令失败
- 怎么给sybase数据库中的select取别名
- [求助]Oracle中如何在select语句中写条件判断语句?
- 问一个oracle10i的sql查询
- 尝试加载 Oracle 客户端库时引发 BadImageFormatException。如果在安装 32 位 Oracle 客户端组件的情况下以 64 位模式运
- 为啥不行啊ORA-00933: SQL command not properly ended
- oracle客户端问题!~高手救救我吧!~
- 嵌套查询和连接的区别?????????????????
- 創建 Oracle Trigger 時出錯??When Instering ……
- Oracle字符集的问题!高分求解!
- 请问游标取数据的顺序?
- 按完数据库后,我机子可以连接别人的机子但是别人连不上我的数据库
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
# listener.ora.rac1 Network Configuration File: /opt/app/grid/network/admin/listener.ora.rac1
# Generated by Oracle configuration tools.ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ONENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ONLISTENER_SCAN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))
)
)-----------------------------------------------------------------------
[root@rac1 ~]# cat /opt/app/oracle/product/11.2.0/network/admin/listener.ora
# listener.ora Network Configuration File: /opt/app/oracle/product/11.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1 = ONLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.101)(PORT = 1521))
)
)ADR_BASE_LISTENER = /opt/app/oracle
---------------------------------------------------# listener.ora Network Configuration File: /opt/app/oracle/product/11.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER1 = ONLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.103)(PORT = 1521))
)
)ADR_BASE_LISTENER = /opt/app/oracle