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

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

0

积分

1

好友

1

主题
1#
发表于 2013-8-27 17:24:15 | 查看: 5663| 回复: 3
本帖最后由 xuxhua100 于 2013-8-27 17:24 编辑

VMware Workstation
os:redhat 5.5
oracle grid infrastructure 11.2.0.1.0 for standalone server

报错界面见图片

[grid@db_node1 db_node1]$ tail /u01/app/oraInventory/logs/installActions2013-08-22_08-07-45AM.log
INFO: Read: ASMSNMP_PASSWORD_PROMPT
INFO: Processing: ASMSNMP_PASSWORD_PROMPT for argument tag -asmMonitorPassword
INFO: End of argument passing to stdin
INFO: Read:
INFO: Read: Configuring ASM failed with the following message:
INFO: Read: Configuring HA resource failed. The following error occured:
INFO: Read: PRCR-1079 : Failed to start resource ora.asm
INFO: Read: CRS-2674: Start of 'ora.cssd' on 'db_node1' failed
INFO: Read:
INFO: Completed Plugin named: Automatic Storage Management Configuration Assistant

[grid@db_node1 db_node1]$ pwd
/u01/app/oracle/product/grid/log/db_node1
[grid@db_node1 db_node1]$ tail alertdb_node1.log
2013-08-21 08:19:37.866
[client(17692)]CRS-1001:The OCR was formatted using version 3.
2013-08-22 08:20:07.098
[client(8660)]CRS-1006:The OCR location /u01/app/oracle/product/grid/cdata/localhost/local.ocr is inaccessible. Details in /u01/app/oracle/product/grid/log/db_node1/client/crsctl.log.
2013-08-22 08:20:07.912
[client(8660)]CRS-1001:The OCR was formatted using version 3.
2013-08-23 07:51:45.926
[client(8300)]CRS-1006:The OCR location /u01/app/oracle/product/grid/cdata/localhost/local.ocr is inaccessible. Details in /u01/app/oracle/product/grid/log/db_node1/client/crsctl.log.
2013-08-23 07:51:46.305
[client(8300)]CRS-1001:The OCR was formatted using version 3.
[grid@db_node1 db_node1]$
[grid@db_node1 db_node1]$
[grid@db_node1 db_node1]$ tail /u01/app/oracle/product/grid/log/db_node1/client/crsctl.log
2013-08-23 07:51:45.927: [  OCROSD][922278304]utread:3: Problem reading buffer 12fbf000 buflen 4096 retval 0 phy_offset 102400 retry 4
2013-08-23 07:51:45.927: [  OCROSD][922278304]utread:3: Problem reading buffer 12fbf000 buflen 4096 retval 0 phy_offset 102400 retry 5
2013-08-23 07:51:45.927: [  OCRRAW][922278304]propriogid:1_1: Failed to read the whole bootblock. Assumes invalid format.
2013-08-23 07:51:46.305: [  OCRRAW][922278304]iniconfig:No 92 configuration
2013-08-23 07:51:46.305: [  OCRAPI][922278304]a_init:6a: Backend init successful
2013-08-23 07:51:46.306: [  CRSCTL][922278304]crsctlcss_GetEnvVar: Environment variable NLS_LANG not found
2013-08-23 07:51:46.310: [  CRSCTL][922278304]crsctlcss_GetEnvVar: Error 21101 in getting environment variable ORACLE_HOME
2013-08-23 07:51:46.315: [  CRSCTL][922278304]crsctlcss_doclusterkeys: the current number of pinned nodes 0, set is 1

2013-08-23 07:51:50.208: [  CRSCTL][922278304]crsctl_pin_ocr: set OCR keys succ.
[grid@db_node1 db_node1]$


[grid@db_node1 ~]$ id
uid=502(grid) gid=501(oinstall) groups=501(oinstall),502(dba),600(asmadmin),601(asmoper),602(asmdba)
[grid@db_node1 ~]$ ll /dev/asm*
brw-rw---- 1 grid oinstall 8, 16 Aug 27 02:15 /dev/asm-disk1
brw-rw---- 1 grid oinstall 8, 80 Aug 27 02:15 /dev/asm-disk2
brw-rw---- 1 grid oinstall 8, 64 Aug 27 02:15 /dev/asm-disk3
[grid@db_node1 ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.0.121           dbnode1_domain db_node1
127.0.0.1               localhost.localdomain localhost
#::1            localhost6.localdomain6 localhost6
[grid@db_node1 ~]$

google 搜索到一个类似的问题 https://forums.oracle.com/thread/965106,但按上面的还是没能解决问题,请各位大侠帮忙看下

clipboard.png (81.31 KB, 下载次数: 395)

clipboard.png

2#
发表于 2013-8-27 18:55:36
这个一般可以忽略的,可能是scan没有配置dns,所以验证失败

回复 只看该作者 道具 举报

3#
发表于 2013-8-27 19:51:32
最后的检测 可忽略, 但建议    只装 11.2.0.3

回复 只看该作者 道具 举报

4#
发表于 2013-8-27 20:47:28
11.2.0.3安装单机版的,小心BUG。

Oracle Restart: srvctl fails to start database with error CRS-5010 if RDBMS and Grid under different users (文档 ID 1335607.1)

回复 只看该作者 道具 举报

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

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

GMT+8, 2025-1-4 06:54 , Processed in 0.048094 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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