错误信息如下:
[02 三月 2010 10:55:12,640] ERROR (SwapProjEndManager.java:59) - java.sql.SQLExc
eption: ORA-29701: unable to connect to Cluster Managerjava.sql.SQLException: ORA-29701: unable to connect to Cluster Manager at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:817)
at oracle.jdbc.driver.T4C8TTIClob.write(T4C8TTIClob.java:412)
at oracle.jdbc.driver.T4CConnection.putChars(T4CConnection.java:2054)
at oracle.sql.CLOB.putChars(CLOB.java:400)
at oracle.sql.CLOB.setString(CLOB.java:824)根据网上搜寻的信息 排除udump满了的影响,因为我已将udump内的文件清空了也有人这样说:
启动实例
报错,ORA-29701: unable to connect to Cluster Manager
查google,查不到
再查metalink,原来是因为安装完10g以后,就直接把/etc/inittab中的
h1:35:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1 这句注释了
原来这就是10g内置的cluster manager
取消注释
重新启动系统
再次启动实例,OK但我没有找到我的inittab这个文件求各位高手帮忙解决,谢谢。
[02 三月 2010 10:55:12,640] ERROR (SwapProjEndManager.java:59) - java.sql.SQLExc
eption: ORA-29701: unable to connect to Cluster Managerjava.sql.SQLException: ORA-29701: unable to connect to Cluster Manager at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:817)
at oracle.jdbc.driver.T4C8TTIClob.write(T4C8TTIClob.java:412)
at oracle.jdbc.driver.T4CConnection.putChars(T4CConnection.java:2054)
at oracle.sql.CLOB.putChars(CLOB.java:400)
at oracle.sql.CLOB.setString(CLOB.java:824)根据网上搜寻的信息 排除udump满了的影响,因为我已将udump内的文件清空了也有人这样说:
启动实例
报错,ORA-29701: unable to connect to Cluster Manager
查google,查不到
再查metalink,原来是因为安装完10g以后,就直接把/etc/inittab中的
h1:35:respawn:/etc/init.d/init.cssd run >/dev/null 2>&1 这句注释了
原来这就是10g内置的cluster manager
取消注释
重新启动系统
再次启动实例,OK但我没有找到我的inittab这个文件求各位高手帮忙解决,谢谢。
服务面板里去找oracle CM的服务,设置其为开机自动启动。
Versions of cluster manager previous to Oracle Database 10g were sometimes referred to as "Cluster Manager". In Oracle Database 10g, this function is performed by an Oracle Clusterware component known as Cluster Synchronization Services (CSS). The OracleCSService, OracleCRService, and OracleEVMService replace the service known previous to Oracle Database 10g as OracleCMService9i.
这边情况这样的:
Oracle Object Service
OracleClusterVolumeService
OracleCRService
OracleCSService
OracleDBConsoleorcl1
OracleEVMService
OracleOraDb10gHome1TNSListenerLISTENERDATA_01
OracleServiceORCL1
这些都是已经启动的OracleJobSchedulerORCL1
这个我是禁用的,不明白Oracle CM这个服务是哪个。。
// *Action: Verify that the CM was started. If the CM was not started,
// start it and then retry the database startup. If the CM died
// or is not responding, check the Oracle and CM trace files for
// errors.已经启动了,还无法连接,估计有问题了。看看该服务跟踪文件,是否有错误信息。
很多文件都根据PID来命名,各系统不一样,所以我无法告诉你确切文件名。‘另外,个人的一点建议。研究RAC环境,已经是很输入的东西了,最好看看管方文档,否则真的是事倍功半!!!
Trace dumping is performing id=[cdmp_20100301235732]
Tue Mar 02 01:01:22 2010
Trace dumping is performing id=[cdmp_20100302005808]
Tue Mar 02 02:00:46 2010
Trace dumping is performing id=[cdmp_20100302015732]
Tue Mar 02 03:00:18 2010
Trace dumping is performing id=[cdmp_20100302025703]
Tue Mar 02 04:00:55 2010
Trace dumping is performing id=[cdmp_20100302035740]
Tue Mar 02 05:00:29 2010
Trace dumping is performing id=[cdmp_20100302045715]
Tue Mar 02 06:01:03 2010
Trace dumping is performing id=[cdmp_20100302055749]
Tue Mar 02 07:00:36 2010
Trace dumping is performing id=[cdmp_20100302065721]
Tue Mar 02 08:01:10 2010
Trace dumping is performing id=[cdmp_20100302075756]
Tue Mar 02 09:00:34 2010
Trace dumping is performing id=[cdmp_20100302085720]
Tue Mar 02 10:01:11 2010
Trace dumping is performing id=[cdmp_20100302095757]
Tue Mar 02 11:00:40 2010
Trace dumping is performing id=[cdmp_20100302105725]今天的信息只有上面这些之前有关于CSS的信息是这个:
Mon Mar 01 21:34:15 2010
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V5.2 Service Pack 1
CPU : 16 - type 8664, 4 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:15217M/16378M, Ph+PgF:17171M/17813M
Mon Mar 01 21:34:15 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
WARNING: No cluster interconnect has been specified. Depending on
the communication driver configured Oracle cluster traffic
may be directed to the public interface of this machine.
Oracle recommends that RAC clustered databases be configured
with a private interconnect for enhanced security and
performance.
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as d:\oracle\product\10.2.0\db_1\RDBMS
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
OracleCSService
这两个服务启动了没有。检查一下$CRS_HOME/log/下的有关crs和css的日志,看有没有问题。贴上来看看,。
[ CSSD]2010-03-02 14:55:36.718 [2060] >TRACE: clssgmClientConnectMsg: Connect from con(0000000002D471D0) proc(0000000002D37720) pid() proto(10:2:1:1)
[ CSSD]2010-03-02 14:56:00.281 [2060] >TRACE: clssgmClientConnectMsg: Connect from con(0000000002D46D70) proc(0000000002D37720) pid() proto(10:2:1:1)
而 D:\oracle\product\10.2.0\crs\log\data01\crsd的日志中没有今天的信息