RAC DBCA 找不到共享磁盘
来源:互联网 发布:java非运行异常有哪些 编辑:程序博客网 时间:2024/06/02 18:50
(一) 前言:
通过vmware workstation 走iscsi协议,安装RAC 集群架构,DBCA 时不能识别ASM 共享存储(按理来说这一版都是权限的问题)。同时,本想通过RMAN 做单实例 --> 迁移 -->RAC, 单在创建ASM共享存储spfile参数文件时,一直报错,但是涉及的crs 服务,grid,oracle 权限都存在。
(二) 报错信息:
SQL> create spfile='+DATA/DOMINIC/PARAMETERFILE/spfiledominic.ora' from pfile='/u01/soft/spfile_5_04';
create spfile='+DATA/DOMINIC/PARAMETERFILE/spfiledominic.ora' from pfile='/u01/soft/spfile_5_04'
*
ERROR at line 1:
ORA-17502: ksfdcre:4 Failed to create file
+DATA/DOMINIC/PARAMETERFILE/spfiledominic.ora
ORA-01017: invalid username/password; logon denied
---这里,其实 只有真正的spfile参数放在ASM存储里,其他节点RAC1 ....RACn 都只是一个地址的映射。
当权限组正常的话,以上命令是可以执行,同时各节点在$ORACLE_HOME/dbs/initORACLE_SID.ora
echo "SPFILE='+DATA/ANQING/PARAMETERFILE/spfildominic.ora'" > /u01/app/oracle/product/11.2/db_1/dbs/initdominic1.ora
(三) 故障权限排查:
oracle 家目录bin下权限,及所属组
[oracle@dominic3 ~]$ cd /u01/app/oracle/product/11.2/dbhome_1/bin/
[oracle@dominic3 bin]$ ll oracle
-rwxrwxr-x 1 oracle asmadmin 239627031 May 17 17:32 oracle ---注意这里Oracle 权限,组, 路径!
grid 家目录bin下权限,及所属组
[oracle@dominic3 bin]$ cd /u01/app/11.2/grid/bin/
[oracle@dominic3 bin]$ ll oracle
-rwsrwsr-x 1 grid oinstall 209914869 May 17 15:58 oracle ---注意这里Oracle 权限,组, 路径!
[root@dominic3 ~]# ls /dev/oracleasm/disks/* -l
brw-rw---- 1 grid asmadmin 8, 17 May 27 15:37 /dev/oracleasm/disks/DATA01
brw-rw---- 1 grid asmadmin 8, 81 May 27 15:37 /dev/oracleasm/disks/DATA02
brw-rw---- 1 grid asmadmin 8, 97 May 27 15:37 /dev/oracleasm/disks/LOG01
brw-rw---- 1 grid asmadmin 8, 65 May 27 15:37 /dev/oracleasm/disks/LOG02
brw-rw---- 1 grid asmadmin 8, 113 May 27 15:37 /dev/oracleasm/disks/OCR01
brw-rw---- 1 grid asmadmin 8, 33 May 27 15:37 /dev/oracleasm/disks/OCR02
brw-rw---- 1 grid asmadmin 8, 49 May 27 15:37 /dev/oracleasm/disks/OCR03
[root@dominic3 ~]# su - grid
[grid@dominic3 ~]$ sqlplus / as sysasm
SQL> select GROUP_NUMBER,DISK_NUMBER,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,PATH from v$asm_disk;
SQL> /
2 0 CACHED MEMBER ONLINE NORMAL ORCL:DATA01
2 1 CACHED MEMBER ONLINE NORMAL ORCL:DATA02
3 0 CACHED MEMBER ONLINE NORMAL ORCL:LOG01
3 1 CACHED MEMBER ONLINE NORMAL ORCL:LOG02
1 0 CACHED MEMBER ONLINE NORMAL ORCL:OCR01
1 1 CACHED MEMBER ONLINE NORMAL ORCL:OCR02
1 2 CACHED MEMBER ONLINE NORMAL ORCL:OCR03
我把Oracle 及时添加到asmadmin 组也是这样
[grid@dominic3 ~]$ id oracle
uid=1101(oracle) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1300(dba),1301(oper)
[grid@dominic3 ~]$ id grid
uid=1100(grid) gid=1000(oinstall) groups=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper)
-- grid 需要加入DBA 权限组,
最后的结果是: ASMDBA, ASMOPER, ASMADMIN 在创建grid 用户时,权限组设置颠倒所致。
(四) : oracle 数据库 Oracle,grid 用户权限混乱,或者升级后,权限混乱,可以使用relink all 解决。
当Oracle,grid 家目录的权限弄混淆了, 那么在chmod +R 之后,通过 relink all 在 各自的$ORACLE_HOME/bin 目录下执行,关库,关服务的状态下执行。 让ORACLE 自己去匹配,如果自己在ORACLE_HOME/bin 目录下去做,多多少少还会有问题, 所有client 不能连接 实例,即使本地实例,服务都可以起来。
eg:[grid@cifpaydb01 bin]$ relink all
writing relink log to: /dba/app/product/11.2.0.4/install/relink.log[grid@cifpaydb01 bin]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA_DG.dg ONLINE ONLINE cifpaydb01
ora.FRA_DG.dg ONLINE ONLINE cifpaydb01
ora.LISTENER.lsnr ONLINE ONLINE cifpaydb01
ora.OCRVD_DG.dg ONLINE ONLINE cifpaydb01
ora.asm ONLINE ONLINE cifpaydb01 Started
ora.ons OFFLINE OFFLINE cifpaydb01 --->
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cifpay.db 1 ONLINE ONLINE cifpaydb01 Open
ora.cssd 1 ONLINE ONLINE cifpaydb01
ora.diskmon 1 OFFLINE OFFLINE -->ora.diskmon在exadata 下有效
ora.evmd 1 ONLINE ONLINE cifpaydb01
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA_DG.dg ONLINE ONLINE cifpaydb01
ora.FRA_DG.dg ONLINE ONLINE cifpaydb01
ora.LISTENER.lsnr ONLINE ONLINE cifpaydb01
ora.OCRVD_DG.dg ONLINE ONLINE cifpaydb01
ora.asm ONLINE ONLINE cifpaydb01 Started
ora.ons OFFLINE OFFLINE cifpaydb01 --->
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cifpay.db 1 ONLINE ONLINE cifpaydb01 Open
ora.cssd 1 ONLINE ONLINE cifpaydb01
ora.diskmon 1 OFFLINE OFFLINE -->ora.diskmon在exadata 下有效
ora.evmd 1 ONLINE ONLINE cifpaydb01
======================================
[oracle@cifpaydb01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 8 22:08:19 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device
Enter user-name: eixt
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 8 22:08:19 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-09817: Write to audit file failed.
Linux-x86_64 Error: 28: No space left on device
Additional information: 12
ORA-09945: Unable to initialize the audit trail file
Linux-x86_64 Error: 28: No space left on device
Enter user-name: eixt
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
----> 类似这种登陆不了的报错,多半和表空间满了有关。
0 0
- RAC DBCA 找不到共享磁盘
- RAC DBCA 找不到共享磁盘
- RAC DBCA 找不到共享磁盘
- oracle rac集群DBCA找不到磁盘组
- Oracle 11gR2 RAC DBCA时无法发现磁盘组
- Oracle 11gR2 RAC DBCA无法识别ASM磁盘组
- Oracle 11gR2 RAC DBCA无法识别ASM磁盘组
- oracle rac dbca时无法找到磁盘组
- 11g Oracle DBCA时找不到ASM磁盘组
- DBCA建库找不到ASM磁盘一例
- DBCA建库找不到ASM磁盘一例
- VMware Workstation - RAC的共享磁盘设置
- RAC挂载共享磁盘组
- rac创建数据库dbca的时候没发现磁盘组小结
- oracle 12c rac dbca建库,提示无法访问+DATA磁盘组
- 安装grid时找不到ASM共享磁盘
- dbca找不到数据库解决办法
- vmware server 2上搭建RAC共享磁盘问题
- Failed to create keys in the OLR, rc = 127, Message:
- Linux内核的特征
- 12.ios之程序启动原理
- Lua中的table函数库
- ffmpeg开发指南
- RAC DBCA 找不到共享磁盘
- 为Eclipse添加Java和Android SDK源代码
- Spark API编程动手实战-01-以本地模式进行Spark API实战map、filter和collect
- JVM性能调优监控工具jps、jstack、jmap、jhat、jstat使用详解
- 【iOS开发-106】UIPopoverController,[UIPopoverController dealloc] reached while popover is still visible
- 基于DLNA的UPNP协议的分析及实现
- 搭建rac时,DNS检查失败
- python中的异常
- RAC not open OCR/CRS/controlfile 故障