Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

16

积分

0

好友

1

主题
1#
发表于 2012-6-7 20:32:16 | 查看: 8557| 回复: 3
节点2正常,目前节点1 crs无法启动
节点1启crs报错:
[root@paydb1:/]#crsctl start crs
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.

检查进程,发现只有ohasd,无cssd等进程
#ps -ef|grep ohasd
    root 3211294       1   0 13:52:19      -  0:00 /bin/sh /etc/init.ohasd run
    root 6029554 7929954   0 15:14:37  pts/2  0:00 grep ohasd
    root 8847396       1   0 15:11:22      -  0:00 /mboss/database/app/11.2.0/grid/bin/ohasd.bin reboot

日志信息:
/mboss/database/app/11.2.0/grid/log/paydb1/alertpaydb1.log中有如下报错:
2012-06-07 15:23:52.056
[client(6029396)]CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not ru
nning).

无cssd日志。

使用rootcrs.pl -verbose -deconfig -force

rootcrs.pl -verbose -deconfig -force
Using configuration parameter file: ./crsconfig_params
Usage: srvctl <command> <object> [<options>]
    commands: enable|disable|start|stop|status|add|remove|modify|getenv|setenv|unsetenv|config
    objects: database|service|asm|diskgroup|listener|home|ons
For detailed help on each command and object and its options use:
  srvctl <command> -h or
  srvctl <command> <object> -h
PRKO-2012 : nodeapps object is not supported in Oracle Restart
ACFS-9200: Supported
CRS-4046: Invalid Oracle Clusterware configuration.
CRS-4000: Command Stop failed, or completed with errors.
CRS-4046: Invalid Oracle Clusterware configuration.
CRS-4000: Command Stop failed, or completed with errors.
You must kill crs processes or reboot the system to properly
cleanup the processes started by Oracle clusterware
This may take several minutes. Please wait ...
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
0518-307 odmdelete: 1 objects deleted.
Successfully deconfigured Oracle clusterware stack on this node
运行
[root@paydb1:/mboss/database/app/11.2.0/grid]#./root.sh

Running Oracle 11g root script...


The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /mboss/database/app/11.2.0/grid


Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.


Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /mboss/database/app/11.2.0/grid/crs/install/crsconfig_params

The oracle binary is currently linked with RAC disabled.
Please execute the following steps to relink oracle binary
and rerun the command with RAC enabled:
   setenv ORACLE_HOME <crshome>
   cd <crshome>/rdbms/lib
   make -f ins_rdbms.mk rac_on ioracle



按提示执行命令,结果比较长,已经上传 relink.TXT (269.06 KB, 下载次数: 747)


再次执行root.sh还是提示一样的需要relink,请教大神该如何处理?多谢
2#
发表于 2012-6-11 11:56:47
就 relink的日志来看 :

        mv /mboss/database/app/11.2.0/db/rdbms/lib/oracle /mboss/database/app/11.2.0/db/bin/oracle
        chmod 6751 /mboss/database/app/11.2.0/db/bin/oracle

oracle binary 文件已经编译好了 , root.sh在等待其他东西

上传 $GI_HOME/log 下的日志

回复 只看该作者 道具 举报

3#
发表于 2012-6-11 17:15:27
刘大,我当时看了$GI_HOME/log 下的日志,都没有什么新的日志 ,现在日志已经不在了。我再次执行root.sh还是提示一样的需要relink,您说的
root.sh在等待其他东西,这个信息一般在哪个日志有体现?或者有没有方法强制让root.sh执行下去?



多谢!

回复 只看该作者 道具 举报

4#
发表于 2012-6-11 21:22:44
metalink上没有太多可用的信息

1. 使用strace 或者truss debug 执行root.sh 的进程, 进一步诊断

2. 彻底删除 RAC1上的GI ,通过addnode 将节点添加回去

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-11-15 21:27 , Processed in 0.064709 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569