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

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

13

积分

0

好友

0

主题
1#
发表于 2012-3-3 15:52:42 | 查看: 8125| 回复: 9
cat alertszhxydbsvr2.log
2012-03-01 23:21:23.361
[client(14247)]CRS-1006:The OCR location /dev/raw/raw2 is inaccessible. Details in /opt/oracle/crs/log/szhxydbsvr2/client/ocrconfig_14247.log.
2012-03-01 23:21:23.369
[client(14247)]CRS-1006:The OCR location /dev/raw/raw2 is inaccessible. Details in /opt/oracle/crs/log/szhxydbsvr2/client/ocrconfig_14247.log.
2012-03-01 23:21:23.376
[client(14247)]CRS-1006:The OCR location /dev/raw/raw2 is inaccessible. Details in /opt/oracle/crs/log/szhxydbsvr2/client/ocrconfig_14247.log.
2012-03-01 23:21:23.423
[client(14247)]CRS-1001:The OCR was formatted using version 2.
2012-03-01 23:21:30.751
[client(14293)]CRS-1801:Cluster crs configured with nodes szhxydbsvr2 szhxydbsvr1 .
2#
发表于 2012-3-3 15:53:58
/opt/oracle/crs/root.sh
WARNING: directory '/opt/oracle' is not owned by root
Checking to see if Oracle CRS stack is already configured

Setting the permissions on OCR backup directory
Setting up NS directories
Oracle Cluster Registry configuration upgraded successfully
WARNING: directory '/opt/oracle' is not owned by root
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node <nodenumber>: <nodename> <private interconnect name> <hostname>
node 1: szhxydbsvr2 szhxydbsvr2-private szhxydbsvr2
node 2: szhxydbsvr1 szhxydbsvr1-private szhxydbsvr1
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Now formatting voting device: /dev/raw/raw3
Format of 1 voting devices complete.
Startup will be queued to init within 90 seconds.
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.
Failure at final check of Oracle CRS stack.
10

回复 只看该作者 道具 举报

3#
发表于 2012-3-3 15:55:08
cat ocrconfig_14247.log
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle.  All rights reserved.
2012-03-01 23:21:23.267: [ OCRCONF][46847744]ocrconfig starts...
2012-03-01 23:21:23.268: [ OCRCONF][46847744]Upgrading OCR data
2012-03-01 23:21:23.360: [  OCRRAW][46847744]propriogid:1: INVALID FORMAT
2012-03-01 23:21:23.362: [  OCRRAW][46847744]ibctx:1:ERROR: INVALID FORMAT
2012-03-01 23:21:23.362: [  OCRRAW][46847744]proprinit:problem reading the bootblock or superbloc 22

2012-03-01 23:21:23.364: [ default][46847744]a_init:7!: Backend init unsuccessful : [22]
2012-03-01 23:21:23.364: [ OCRCONF][46847744]Exporting OCR data to [OCRUPGRADEFILE]
2012-03-01 23:21:23.364: [  OCRAPI][46847744]a_init:7!: Backend init unsuccessful : [33]
2012-03-01 23:21:23.364: [ OCRCONF][46847744]There was no previous version of OCR. error:[PROC-33: Oracle Cluster Registry is not configured]
2012-03-01 23:21:23.369: [  OCRRAW][46847744]propriogid:1: INVALID FORMAT
2012-03-01 23:21:23.370: [  OCRRAW][46847744]ibctx:1:ERROR: INVALID FORMAT
2012-03-01 23:21:23.370: [  OCRRAW][46847744]proprinit:problem reading the bootblock or superbloc 22

2012-03-01 23:21:23.372: [ default][46847744]a_init:7!: Backend init unsuccessful : [22]
2012-03-01 23:21:23.376: [  OCRRAW][46847744]propriogid:1: INVALID FORMAT
2012-03-01 23:21:23.376: [  OCRRAW][46847744]ibctx:1:ERROR: INVALID FORMAT
2012-03-01 23:21:23.376: [  OCRRAW][46847744]proprinit:problem reading the bootblock or superbloc 22

2012-03-01 23:21:23.382: [  OCRRAW][46847744]propriogid:1: INVALID FORMAT
2012-03-01 23:21:23.403: [  OCRRAW][46847744]propriowv: Vote information on disk 0 [/dev/raw/raw2] is adjusted from [0/0] to [2/2]
2012-03-01 23:21:23.423: [  OCRRAW][46847744]propriniconfig:No 92 configuration
2012-03-01 23:21:23.423: [  OCRAPI][46847744]a_init:6a: Backend init successful
2012-03-01 23:21:23.464: [ OCRCONF][46847744]Initialized DATABASE keys in OCR
2012-03-01 23:21:23.478: [ OCRCONF][46847744]Successfully set skgfr block 0
2012-03-01 23:21:23.478: [ OCRCONF][46847744]Exiting [status=success]...

回复 只看该作者 道具 举报

4#
发表于 2012-3-3 15:55:50
[root@szhxydbsvr2 szhxydbsvr2]# ll /dev/raw
总用量 0
crw-rw-r-- 1 oracle dba      162, 1  3月  2 2012 raw1
crw-r----- 1 root   oinstall 162, 2  3月  1 23:21 raw2
crw-r--r-- 1 oracle oinstall 162, 3  3月  1 23:21 raw3
crw-rw-r-- 1 oracle dba      162, 4  3月  2 2012 raw4
crw-rw-r-- 1 oracle dba      162, 0  3月  2 2012 rawctl
[root@szhxydbsvr2 szhxydbsvr2]#

回复 只看该作者 道具 举报

5#
发表于 2012-3-3 15:56:44
RHEL 5都没在 10g 10.2.0.1 上经过Oracle的认证, 更不用说 RHEL 6.2了。

不知道你是出于何种目的一定要在 6.2上安装, 从稳定性和实用的角度出发 这是在浪费时间。

如果你有兴趣进一步诊断该问题, 执行以下命令:

diagcollection.pl --collect                              

---diagcollection.pl  在 $ORA_CRS_HOME/bin 目录下

将生成的完整 TAR 包上传。

回复 只看该作者 道具 举报

6#
发表于 2012-3-3 16:02:14
css.log 中 :
2012-03-01 23:32:32.468: [ CSSCLNT][276281088]clsssInitNative: connect failed, rc 9

2012-03-01 23:32:33.480: [ CSSCLNT][276281088]clsssInitNative: connect failed, rc 9

2012-03-01 23:32:34.491: [ CSSCLNT][276281088]clsssInitNative: connect failed, rc 9

2012-03-01 23:32:35.503: [ CSSCLNT][276281088]clsssInitNative: connect failed, rc 9

2012-03-01 23:32:36.514: [ CSSCLNT][276281088]clsssInitNative: connect failed, rc 9

2012-03-01 23:32:37.526: [ CSSCLNT][276281088]clsssInitNative: connect failed, rc 9

2012-03-01 23:32:38.538: [ CSSCLNT][276281088]clsssInitNative: connect failed, rc 9

2012-03-01 23:32:39.549: [ CSSCLNT][276281088]clsssInitNative: connect failed, rc 9

2012-03-01 23:32:40.561: [ CSSCLNT][276281088]clsssInitNative: connect failed, rc 9

回复 只看该作者 道具 举报

7#
发表于 2012-3-3 16:08:41
附件 是 系统生成的 tar

ocrData_szhxydbsvr2.tar.gz

1.35 KB, 下载次数: 1024

crsData_szhxydbsvr2.tar.gz

5.27 KB, 下载次数: 1028

回复 只看该作者 道具 举报

8#
发表于 2012-3-3 16:19:00
1.
cat /etc/hosts

贴出以上输出内容

2.


# rm -f /usr/tmp/.oracle/*
# rm -f /tmp/.oracle/*
# rm -f /var/tmp/.oracle/*

删除以上tmp 目录下的socket

3.
再次 运行root.sh

如果失败 打包上传 完整的ocssd.log

回复 只看该作者 道具 举报

9#
发表于 2012-3-3 16:57:29
127.0.0.1   localhost localhost.localdomain loopback

172.16.5.161    szhxydbsvr1
192.168.99.11   szhxydbsvr1-private
172.16.5.163    szhxydbsvr1-vip

172.16.5.162    szhxydbsvr2
192.168.99.12   szhxydbsvr2-private
172.16.5.164    szhxydbsvr2-vip

回复 只看该作者 道具 举报

10#
发表于 2012-3-3 16:58:36
先 换成 rhel 5.4  看看  再说 ! 谢谢了 !

回复 只看该作者 道具 举报

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

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

GMT+8, 2024-12-24 00:37 , Processed in 0.064370 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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