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

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

61

积分

0

好友

1

主题
1#
发表于 2012-4-25 11:50:54 | 查看: 7383| 回复: 9
刘大  你好
我安装11G R2 linux X64 平台的RAC

现在在第一个节点执行root.sh的时候总是失败,我不知道该从哪入手找原因 能帮我看下嘛 ,我还要提供什么信息给你呢?

望回复

[ 本帖最后由 Metadata 于 2012-4-25 12:05 编辑 ]

root.sh.txt

6.01 KB, 下载次数: 647

手动执行srvctl.txt

698 Bytes, 下载次数: 662

Desktop.rar

78.46 KB, 下载次数: 738

2#
发表于 2012-4-25 11:56:17
/u01/app/11.2.0/grid/product/db_1/bin/srvctl start nodeapps -n 11g_rac01 ... failed

上传 $CRS_HOME/log/$HOSTNAME  下的  crsd.log cssd.log 和   racg目录下的日志

回复 只看该作者 道具 举报

3#
发表于 2012-4-25 12:18:48
ODM DATA:

Oracle Database 11g Clusterware Release 11.2.0.1.0            On Linux

crsd.log :


2012-04-25 11:48:24.961: [   CRSPE][1556601152] Got agent-specific msg: CRS-5016: Process "/u01/app/11.2.0/grid/product/db_1/bin/scrctl" spawned by agent "/u01/app/11.2.0/grid/product/db_1/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/11.2.0/grid/product/db_1/log/11g_rac01/agent/crsd/oraagent_grid/oraagent_grid.log"

2012-04-25 11:48:24.961: [   CRSPE][1556601152] Received reply to action [Start] message ID: 3262
2012-04-25 11:48:24.962: [UiServer][1560803648] Container [ Name: ORDER
        MESSAGE:
        TextMessage[CRS-5016: Process "/u01/app/11.2.0/grid/product/db_1/bin/scrctl" spawned by agent "/u01/app/11.2.0/grid/product/db_1/bin/oraagent.bin" for action "start" failed: details at "(:CLSN00010:)" in "/u01/app/11.2.0/grid/product/db_1/log/11g_rac01/agent/crsd/oraagent_grid/oraagent_grid.log"]
        MSGTYPE:
        TextMessage[1]
        OBJID:
        TextMessage[ora.eons]
        WAIT:
        TextMessage[0]
]

oraagent启动 nodeapps  的ora.eons 多次失败 导致root.sh不能正常运行

回复 只看该作者 道具 举报

4#
发表于 2012-4-25 12:20:21

回复 3# 的帖子

那现在该怎么办啊 刘大?

回复 只看该作者 道具 举报

5#
发表于 2012-4-25 13:06:19
这是 11.2.0.1 Grid Infrastructure的一个bug , 安装GI后 EONS资源可能无法启动

Bug 9952929: FAILED TO START RESOURCE ORA.EONS AFTER GRID INSTALLATION

Hdr: 9952929 11.2.0.1 PCW 11.2.0.1 EVM PRODID-5 PORTID-212
Abstract: FAILED TO START RESOURCE ORA.EONS AFTER GRID INSTALLATION


PROBLEM:
--------
Failed to start resource ora.eons after Grid installation with following
errors
====
CRS-2674: Start of 'ora.eons' on 'btpcvc03' failed
PRCR-1013 : Failed to start resource ora.eons
PRCR-1064 : Failed to start resource ora.eons on node btpcvc03
CRS-5016: Process "/u01/crs/oracle/product/11.2.0/crs/bin/scrctl" spawned by
agent "/u01/crs/oracle/product/11.2.0/crs/bin/oraagent.bin" for action
"start" failed: details at "(:CLSN00010:)" in
"/u01/crs/oracle/product/11.2.0/crs/log/btpcvc03/agent/crsd/oraagent_oracle/or
aagent_oracle.log"
CRS-2674: Start of 'ora.eons' on 'btpcvc03' failed
=====

Asked him to do the following
===
1. Change the following parameter in file:
<GRID_HOME>/srvm/admin/logging.properties to:
oracle.eons.level=FINER
From oraagent_oracle.log

Then restart nodeapps, still eons didnt came online

DIAGNOSTIC ANALYSIS:
--------------------
From oraagent_oracle.log
====
2010-07-28 12:25:33.439: [    AGFW][3607] Executing command: check for
resource: ora.prod.db 2 1
2010-07-28 12:25:33.440: [ora.prod.db][3607] [check] Gimh::check condition
(GIMH_NEXT_NUM) 9 exists
2010-07-28 12:25:33.440: [    AGFW][3607] check for resource: ora.prod.db 2 1
completed with status: ONLINE
2010-07-28 12:25:33.618: [ USRTHRD][4657] Thread:[EonsSub FAN] run: waiting
on connecting to event server: ons_subscriber_status() returns WAITING
2010-07-28 12:25:33.879: [ USRTHRD][3344] Thread:[EonsSub EONS] run: waiting
on connecting to event server: ons_subscriber_status() returns WAITING
2010-07-28 12:25:33.926: [ USRTHRD][2711] Thread:[EonsSub ONS] run: waiting
on connecting to event server: ons_subscriber_status() returns WAITING

From eonsout.log
===
[main] [ 2010-07-28 12:12:03.729 CDT ]
[ClusterFactoryImpl.getEONSRegistryURL:987]  
eonsRegistryURL://btpcvc02:2017/oracle.supercluster.impl.cluster.EONSServerImp
l
SCLC-1030 : eons server is not running
error during JRMP connection establishment; nested exception is:
        java.io.EOFException
[main] [ 2010-07-28 12:12:04.199 CDT ] [EONSCTL.main:325]  INFO: SCLC-1030 :
eons server is not running
error during JRMP connection establishment; nested exception is:
        java.io.EOFException
[main] [ 2010-07-28 12:12:04.199 CDT ] [EONSCTL.main:327]  EONS command
status =false

WORKAROUND:
-----------

RELATED BUGS:
-------------
9765069

回复 只看该作者 道具 举报

6#
发表于 2012-4-25 13:07:27
建议:

11.2.0.2之后 GI/RDBMS支持out of place upgrade, 即直接可以安装 11.2.0.3 GI/RDBMS 而不需要11.2.0.1 的base Installation,  建议你直接安装 11.2.0.3 的Grid Infrastructure ,  11.2.0.1 的GI 安装bug较多

回复 只看该作者 道具 举报

7#
发表于 2012-4-25 13:41:27

回复 6# 的帖子

刘大 我不太懂,我下到p10404530 这个补丁不是要在安装GI11.2.0.1的基础上升级的吗,你的意思是我下好补丁后,不删除11.2.0.1直接安装是吧?

回复 只看该作者 道具 举报

8#
发表于 2012-4-25 13:42:33
11.2.0.3 Patchset补丁集 是可以直接安装的 , 不需要 11.2.0.1 做 base release

回复 只看该作者 道具 举报

9#
发表于 2012-4-25 13:51:20

回复 8# 的帖子

刘大 谢谢你的热心回复 !

回复 只看该作者 道具 举报

10#
发表于 2012-4-26 18:05:50

回复 8# 的帖子

问题已经解决了,换成11.2.0.3一次性安装通过

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-12-24 09:40 , Processed in 0.053789 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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