查看: 3078|回复: 5

[安装] Oracle 12C rac 安装实例无法选择diskgroup问题

[复制链接]
论坛徽章:
0
发表于 2015-1-21 10:19 | 显示全部楼层 |阅读模式
成功安装12c(12.1.0.2),使用udev asm,共两个节点rac1,rac2,未使用gns,还是用hosts文件搞定的。
使用的是esxi 5.5,两个虚拟机跟共享磁盘完成。在grid用户下,asmca可以添加删除挂载,sqlplus进去,也能查看到v$asm_diskgroup,但在oralce用户下dbca操作建立实例的时候,无法选择diskgroup,不清楚原因,球指教:
hosts文件:
  1. [root@rac1 ~]# cat /etc/hosts
  2. # Do not remove the following line, or various programs
  3. # that require network functionality will fail.
  4. 127.0.0.1               localhost.localdomain localhost
  5. ::1             localhost6.localdomain6 localhost6
  6. #public ip
  7. 10.1.51.21              rac1
  8. 10.1.51.22              rac2
  9. #priv ip
  10. 192.168.0.21            rac1prv
  11. 192.168.0.12            rac2prv
  12. #vip ip
  13. 10.1.51.26              rac1vip
  14. 10.1.51.27              rac2vip
  15. #scan ip
  16. 10.1.51.28              racscan
  17. [root@rac1 ~]#
复制代码
udev rules:
  1. [root@rac1 ~]# cat /etc/udev/rules.d/99-oracle.rules
  2. #ASM disks
  3. KERNEL=="sdb1", OWNER="grid", GROUP="asmadmin", MODE="0660"
  4. KERNEL=="sdb2", OWNER="grid", GROUP="asmadmin", MODE="0660"
  5. KERNEL=="sdb3", OWNER="grid", GROUP="asmadmin", MODE="0660"
  6. KERNEL=="sdb4", OWNER="grid", GROUP="asmadmin", MODE="0660"
  7. KERNEL=="sdc", OWNER="grid", GROUP="asmadmin", MODE="0660"
  8. [root@rac1 ~]#
复制代码
udev文件权限:
  1. [root@rac1 ~]# ls -l /dev/sd*
  2. brw-r----- 1 root disk     8,  0 01-21 00:13 /dev/sda
  3. brw-r----- 1 root disk     8,  1 01-21 00:14 /dev/sda1
  4. brw-r----- 1 root disk     8,  2 01-21 00:13 /dev/sda2
  5. brw-r----- 1 root disk     8,  3 01-21 00:13 /dev/sda3
  6. brw-r----- 1 root disk     8, 16 01-21 00:13 /dev/sdb
  7. brw-rw---- 1 grid asmadmin 8, 17 01-21 10:06 /dev/sdb1
  8. brw-rw---- 1 grid asmadmin 8, 18 01-21 10:06 /dev/sdb2
  9. brw-rw---- 1 grid asmadmin 8, 19 01-21 10:06 /dev/sdb3
  10. brw-rw---- 1 grid asmadmin 8, 20 01-21 00:13 /dev/sdb4
  11. brw-rw---- 1 grid asmadmin 8, 32 01-21 10:06 /dev/sdc
  12. [root@rac1 ~]#
复制代码

grid下,diskgroup:
  1. [root@rac1 ~]# su - grid
  2. [grid@rac1:/home/grid]$sqlplus /nolog

  3. SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 21 10:04:20 2015

  4. Copyright (c) 1982, 2014, Oracle.  All rights reserved.

  5. SQL> conn /as sysdba
  6. Connected.
  7. SQL> select name, state from v$asm_diskgroup;

  8. NAME                           STATE
  9. ------------------------------ -----------
  10. DGDATA                         MOUNTED
  11. DATA                           MOUNTED

  12. SQL>
复制代码
asmcmd下,显示diskgroup正常:
  1. [grid@rac1:/home/grid]$asmcmd
  2. ASMCMD> lsdg
  3. State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
  4. MOUNTED  NORMAL  N         512   4096  4194304     18072     8684             6024            1330              0             Y  DATA/
  5. MOUNTED  EXTERN  N         512   4096  4194304     16384    16252                0           16252              0             N  DGDATA/
  6. ASMCMD>
复制代码


oracle用户下,不能正常显示diskgroup:
  1. [oracle@rac1:/home/oracle]$asmcmd
  2. ASMCMD> lsdg
  3. ASMCMD>
复制代码

使用dbca安装用户实例的时候无法选取diskgroup:

diskgroup

diskgroup


论坛徽章:
183
生肖徽章:狗
日期:2006-11-23 04:26:03生肖徽章:羊
日期:2007-09-26 17:08:21生肖徽章:马
日期:2007-09-26 17:08:49授权会员
日期:2007-12-31 19:14:41生肖徽章2007版:牛
日期:2008-03-28 10:02:30奥运会纪念徽章:柔道
日期:2008-04-30 16:28:44奥运会纪念徽章:垒球
日期:2008-05-12 21:28:28奥运会纪念徽章:体操
日期:2008-06-26 10:00:41奥运会纪念徽章:沙滩排球
日期:2008-07-27 12:41:59奥运会纪念徽章:艺术体操
日期:2008-07-30 11:09:47
发表于 2015-1-21 10:24 | 显示全部楼层
看看是不是权限问题?
http://www.itpub.net/thread-1783419-1-1.html

使用道具 举报

回复
论坛徽章:
0
 楼主| 发表于 2015-1-21 10:55 | 显示全部楼层
jieyancai 发表于 2015-1-21 10:24
看看是不是权限问题?
http://www.itpub.net/thread-1783419-1-1.html

好像访问各个目录权限都正常的,grid用户有的组,oracle用户都已经添加上了。
  1. [root@rac1 ~]# id grid
  2. uid=61001(grid) gid=60001(oinstall) groups=60001(oinstall),60002(dba),60003(oper),60007(asmdba),60008(asmoper),60009(asmadmin)
  3. [root@rac1 ~]# id oracle
  4. uid=61002(oracle) gid=60001(oinstall) groups=60001(oinstall),60002(dba),60003(oper),60004(backupdba),60005(dgdba),60006(kmdba),60007(asmdba),60008(asmoper),60009(asmadmin)
  5. [root@rac1 ~]#
复制代码


使用道具 举报

回复
论坛徽章:
183
生肖徽章:狗
日期:2006-11-23 04:26:03生肖徽章:羊
日期:2007-09-26 17:08:21生肖徽章:马
日期:2007-09-26 17:08:49授权会员
日期:2007-12-31 19:14:41生肖徽章2007版:牛
日期:2008-03-28 10:02:30奥运会纪念徽章:柔道
日期:2008-04-30 16:28:44奥运会纪念徽章:垒球
日期:2008-05-12 21:28:28奥运会纪念徽章:体操
日期:2008-06-26 10:00:41奥运会纪念徽章:沙滩排球
日期:2008-07-27 12:41:59奥运会纪念徽章:艺术体操
日期:2008-07-30 11:09:47
发表于 2015-1-21 11:00 | 显示全部楼层
namgking 发表于 2015-1-21 10:55
好像访问各个目录权限都正常的,grid用户有的组,oracle用户都已经添加上了。

跟踪查看dbca创建过程的日志(每次dbca都会输出一个日志的):
cd /home/oracle/cfgtoollogs/dbca
ls -lt
看看有没有发现

使用道具 举报

回复
论坛徽章:
0
 楼主| 发表于 2015-1-21 12:38 | 显示全部楼层
本帖最后由 namgking 于 2015-1-21 12:39 编辑
jieyancai 发表于 2015-1-21 11:00
跟踪查看dbca创建过程的日志(每次dbca都会输出一个日志的):
cd /home/oracle/cfgtoollogs/dbca
ls -lt
...

标红的这一段感觉很可疑,为什么会移除(Removing TYPE_ASMDISKGROUP from numValidTypes) ,奇怪。[Thread-24] [ 2015-01-21 10:12:57.378 CST ] [sStorageUtil.getSupportedFileTypes:211]  fileType=RAC_DATA_FILES; release=12.1; considerASMStorage=false
[Thread-24] [ 2015-01-21 10:12:57.380 CST ] [sStorageUtil.getSupportedFileTypes:310]  Supported storage types for 'RAC_DATA_FILES' in release '12.1' =NFS, ASM Disk Group, OCFS2, VXFS, ACFS
[Thread-24] [ 2015-01-21 10:12:57.380 CST ] [sStorageUtil.getDiscoveryTypes:153]  s_nonDiscoverableTypes=VXFS, File System
[Thread-24] [ 2015-01-21 10:12:57.380 CST ] [sStorageUtil.getDiscoveryTypes:165]  Removing type VXFS from list of discoverable types
[Thread-24] [ 2015-01-21 10:12:57.380 CST ] [sStorageUtil.getDiscoveryTypes:193]  Returning discovery types=NFS, ASM Disk Group, OCFS2, ACFS
[Thread-24] [ 2015-01-21 10:12:57.380 CST ] [VerifyStorage.getStorageInfo:692]  Number of valid types: 4
[Thread-24] [ 2015-01-21 10:12:57.381 CST ] [VerifyStorage.getStorageInfo:703]  Removing TYPE_ASMDISKGROUP from numValidTypes
[Thread-24] [ 2015-01-21 10:12:57.381 CST ] [VerifyStorage.getStorageInfo:697]  Removing TYPE_ACFS from numValidTypes
[Thread-24] [ 2015-01-21 10:12:57.381 CST ] [VerifyStorage.getStorageInfo:718]  Deciding strategy for  type 'NFS'

  1. [Thread-24] [ 2015-01-21 10:12:57.326 CST ] [ResultSet.traceResultSet:429]  

  2. Before return from checkDestLoc with #succNodes=2;#failNodes=0;#nodes=2
  3.         Overall Status->SUCCESSFUL

  4.         rac2-->SUCCESSFUL
  5.         rac1-->SUCCESSFUL


  6. [Thread-24] [ 2015-01-21 10:12:57.329 CST ] [ResultSet.getSuccNodes:647]  Checking for Success nodes from the total list of nodes in the resultset
  7. [Thread-24] [ 2015-01-21 10:12:57.329 CST ] [ResultSet.getSuccNodes:660]  Adding node rac2 to list of Succ nodes
  8. [Thread-24] [ 2015-01-21 10:12:57.330 CST ] [ResultSet.getSuccNodes:660]  Adding node rac1 to list of Succ nodes
  9. [Thread-24] [ 2015-01-21 10:12:57.335 CST ] [Task.<init>:393]  oracle.ops.verification.framework.engine.task.TaskSharedStorageAccess::nodeList='rac1,rac2'
  10. [Thread-24] [ 2015-01-21 10:12:57.335 CST ] [Task.perform:491]  
  11. TaskSharedStorageAccess:Shared Storage Discovery[SHARED_STORAGE]:TASK_START
  12. [Thread-24] [ 2015-01-21 10:12:57.336 CST ] [VerificationUtil.getVariableValue:9815]  getting variable: VAR = ORA_DISABLED_CVU_CHECKS VALUE=null
  13. [Thread-24] [ 2015-01-21 10:12:57.337 CST ] [Task.setupNodesForBigCluster:1153]  START: m_nodeList=rac1,rac2
  14. [Thread-24] [ 2015-01-21 10:12:57.337 CST ] [Task.perform:513]  m_nodeList='rac1,rac2'
  15. [Thread-24] [ 2015-01-21 10:12:57.338 CST ] [TaskSharedStorageAccess.performTask:366]  Performing SharedStorage Accessibility verification task...
  16. [Thread-24] [ 2015-01-21 10:12:57.351 CST ] [VerifyStorage.findSharedStorage:629]  fileType=RAC_DATA_FILES; release=12.1; considerASMStorage=false
  17. [Thread-24] [ 2015-01-21 10:12:57.351 CST ] [VerifyStorage.findSharedStorage:651]  _st_:>>About to call getStorageInfo
  18. [Thread-85] [ 2015-01-21 10:12:57.360 CST ] [StreamReader.run:61]  In StreamReader.run
  19. [Thread-84] [ 2015-01-21 10:12:57.361 CST ] [StreamReader.run:61]  In StreamReader.run
  20. [Thread-84] [ 2015-01-21 10:12:57.372 CST ] [StreamReader.run:65]  OUTPUT>5
  21. [Thread-24] [ 2015-01-21 10:12:57.373 CST ] [sVerificationUtil.getUniqueDistributionID:449]  Successfully executed command: '/bin/sh -c /bin/rpm -q --whatprovides --qf  %{V} oraclelinux-release'
  22. [Thread-24] [ 2015-01-21 10:12:57.373 CST ] [sVerificationUtil.getUniqueDistributionID:463]  The command output is: '5'
  23. [Thread-24] [ 2015-01-21 10:12:57.373 CST ] [sVerificationUtil.getUniqueDistributionID:537]  ==== Distribution Id determined to be OEL5
  24. [Thread-24] [ 2015-01-21 10:12:57.377 CST ] [ConfigUtil.isDefined:200]  ==== Is CV_RAW_CHECK_ENABLED defined? : true
  25. [Thread-24] [ 2015-01-21 10:12:57.377 CST ] [ConfigUtil.getConfiguredValue:178]  ==== CV_RAW_CHECK_ENABLED is defined as : TRUE
  26. [Thread-24] [ 2015-01-21 10:12:57.378 CST ] [StorageUtil.isRawDiscoveryEnabled:350]  RawDiscovery enabled? true
  27. [Thread-24] [ 2015-01-21 10:12:57.378 CST ] [sStorageUtil.getDiscoveryTypes:137]  fileType=RAC_DATA_FILES; release=12.1; considerASMStorage=false; RAW_ENABLED=true
  28. [Thread-24] [ 2015-01-21 10:12:57.378 CST ] [sStorageUtil.getSupportedFileTypes:211]  fileType=RAC_DATA_FILES; release=12.1; considerASMStorage=false
  29. [Thread-24] [ 2015-01-21 10:12:57.380 CST ] [sStorageUtil.getSupportedFileTypes:310]  Supported storage types for 'RAC_DATA_FILES' in release '12.1' =NFS, ASM Disk Group, OCFS2, VXFS, ACFS
  30. [Thread-24] [ 2015-01-21 10:12:57.380 CST ] [sStorageUtil.getDiscoveryTypes:153]  s_nonDiscoverableTypes=VXFS, File System
  31. [Thread-24] [ 2015-01-21 10:12:57.380 CST ] [sStorageUtil.getDiscoveryTypes:165]  Removing type VXFS from list of discoverable types
  32. [Thread-24] [ 2015-01-21 10:12:57.380 CST ] [sStorageUtil.getDiscoveryTypes:193]  Returning discovery types=NFS, ASM Disk Group, OCFS2, ACFS
  33. [Thread-24] [ 2015-01-21 10:12:57.380 CST ] [VerifyStorage.getStorageInfo:692]  Number of valid types: 4
  34. [Thread-24] [ 2015-01-21 10:12:57.381 CST ] [VerifyStorage.getStorageInfo:703]  Removing TYPE_ASMDISKGROUP from numValidTypes
  35. [Thread-24] [ 2015-01-21 10:12:57.381 CST ] [VerifyStorage.getStorageInfo:697]  Removing TYPE_ACFS from numValidTypes
  36. [Thread-24] [ 2015-01-21 10:12:57.381 CST ] [VerifyStorage.getStorageInfo:718]  Deciding strategy for  type 'NFS'
  37. [Thread-24] [ 2015-01-21 10:12:57.381 CST ] [sCommandHandler.genInfoCmd:236]  type=NFS; node=rac1
  38. [Thread-24] [ 2015-01-21 10:12:57.381 CST ] [VerificationUtil.getDestLoc:3712]  ==== CV_DESTLOC(pre-fetched value): '/tmp/'
  39. [Thread-24] [ 2015-01-21 10:12:57.382 CST ] [VDMUtil.getCmd4RemExec:144]  ==== getCmd4RemExec() called...
  40. [Thread-24] [ 2015-01-21 10:12:57.382 CST ] [VDMUtil.getCmd4RemExec:151]  ==== PROP_REM_COMMAND = 'exectask.sh'
  41. [Thread-24] [ 2015-01-21 10:12:57.382 CST ] [VerificationUtil.getCmd4RemExec:3825]  ==== Remote Exec name: exectask.sh
  42. [Thread-24] [ 2015-01-21 10:12:57.382 CST ] [VDMUtil.getCmdFiles4RemExec:165]  ==== getCmdFiles4RemExec() called...
  43. [Thread-24] [ 2015-01-21 10:12:57.382 CST ] [VDMUtil.getCmdFiles4RemExec:170]  ==== PROP_REM_CDMFILES = 'cv/remenv/runfixup.sh,cv/remenv/orarun.sh,cv/remenv/cvuqdisk-1.0.9-1.rpm,cv/remenv/exectask.sh,cv/remenv/exectask,cv/remenv/pluggable,cv/remenv/fixup,cv/remenv/cvuhelper,cv/remenv/jlib'
  44. [Thread-24] [ 2015-01-21 10:12:57.382 CST ] [VerificationUtil.listRecursiveFiles:1719]  InputList=cv/remenv/runfixup.sh,cv/remenv/orarun.sh,cv/remenv/cvuqdisk-1.0.9-1.rpm,cv/remenv/exectask.sh,cv/remenv/exectask,cv/remenv/pluggable,cv/remenv/fixup,cv/remenv/cvuhelper,cv/remenv/jlib
  45. [Thread-24] [ 2015-01-21 10:12:57.412 CST ] [VerificationUtil.listRecursiveFiles:1776]  OutputList=cv/remenv/runfixup.sh,cv/remenv/orarun.sh,cv/remenv/cvuqdisk-1.0.9-1.rpm,cv/remenv/exectask.sh,cv/remenv/exectask,cv/remenv/cvuhelper,cv/remenv/pluggable/check_network_bonding.sh,cv/remenv/pluggable/css_reboot_time.sh,cv/remenv/pluggable/check_tcp_packet_retransmit.sh,cv/remenv/pluggable/common_include.sh,cv/remenv/pluggable/check_bpf_devices.sh,cv/remenv/pluggable/checkramfs.sh,cv/remenv/pluggable/css_diagwait.sh,cv/remenv/pluggable/check_network_param.sh,cv/remenv/pluggable/checkGSDResourceStatus.sh,cv/remenv/pluggable/shutdown_hwclock_sync.sh,cv/remenv/pluggable/checktmpfs.sh,cv/remenv/pluggable/ASMDiskInfo.sql,cv/remenv/pluggable/listener_naming_convention.sh,cv/remenv/pluggable/check_network_packet_reassembly.sh,cv/remenv/pluggable/zeroconf.sh,cv/remenv/pluggable/bdump_dest_trace_analyzer.sh,cv/remenv/pluggable/checkportavail.sh,cv/remenv/pluggable/hangchecktimer.sh,cv/remenv/pluggable/checksyslog.sh,cv/remenv/pluggable/check_rp_filter.sh,cv/remenv/pluggable/getASMDiskInfo.sh,cv/remenv/pluggable/checkIOCPDeviceStatus.sh,cv/remenv/pluggable/check_symvers.sh,cv/remenv/pluggable/ora_00600_errors_analyzer.sh,cv/remenv/pluggable/ora_07445_errors_analyzer.sh,cv/remenv/pluggable/checksshd.sh,cv/remenv/pluggable/check_disk_asynch_io_linking.sh,cv/remenv/pluggable/core_dump_dest_analyzer.sh,cv/remenv/pluggable/hangcheck_reboot.sh,cv/remenv/pluggable/checkIPHostModel.sh,cv/remenv/pluggable/check_vip_restart_attempt.sh,cv/remenv/pluggable/check_e1000.sh,cv/remenv/pluggable/alert_log_file_size_analyzer.sh,cv/remenv/pluggable/hangcheck_margin.sh,cv/remenv/pluggable/checkcorefile.sh,cv/remenv/pluggable/hangcheck_tick.sh,cv/remenv/pluggable/mus_check.sh,cv/remenv/pluggable/check_vmm.sh,cv/remenv/pluggable/checkhugepage.sh,cv/remenv/pluggable/check_non_routable_network_interconnect.sh,cv/remenv/pluggable/css_disk_timeout.sh,cv/remenv/pluggable/checkmemlock.sh,cv/remenv/pluggable/check_default_gateway.sh,cv/remenv/pluggable/getNICSpeed.sh,cv/remenv/pluggable/check_jumbo_frames.sh,cv/remenv/pluggable/css_misscount.sh,cv/remenv/jlib/cvuhelper112.jar,cv/remenv/jlib/cvuhelper111.jar,cv/remenv/jlib/cvuhelper121.jar,cv/remenv/jlib/cvuhelper102.jar
  46. [Thread-24] [ 2015-01-21 10:12:57.412 CST ] [VerificationUtil.getDestLoc:3712]  ==== CV_DESTLOC(pre-fetched value): '/tmp/'
  47. [Thread-24] [ 2015-01-21 10:12:57.412 CST ] [NativeResult.<init>:91]  NativeResult: The String obtained is0
  48. [Thread-24] [ 2015-01-21 10:12:57.412 CST ] [NativeResult.<init>:99]  The status string is: 0
  49. [Thread-24] [ 2015-01-21 10:12:57.412 CST ] [RemoteExecCommand.printIvarValues:835]  Ivar values:
复制代码



使用道具 举报

回复
招聘 : 数据库管理员
论坛徽章:
19
2011新春纪念徽章
日期:2011-02-18 11:42:48目光如炬
日期:2017-09-03 22:00:01山治
日期:2016-09-29 21:06:15秀才
日期:2015-10-26 09:55:08射手座
日期:2015-07-19 16:27:41沸羊羊
日期:2015-06-17 14:02:04沸羊羊
日期:2015-05-31 14:22:50暖羊羊
日期:2015-03-24 16:20:262015年新春福章
日期:2015-03-06 11:58:18美羊羊
日期:2015-03-04 14:52:28
发表于 2015-1-27 10:09 | 显示全部楼层
看看grid用户下的oracle权限是什么,如果没有s,加上s

su - grid
cd $GRID_HOME/bin
ls -l oracle


chmod +s oracle

使用道具 举报

回复

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

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 
京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表