问题4: Oracle RAC 11.2.0.4 – RHRL 6.4: DiskGroup resource are not running on nodes. Database instance may not come up on these nodes 解决办法: 请见我写的: RAC_11.2.0.4 – RHRL 6.4 DiskGroup resource.docx
----------------------------------------------------------------- 问题5:DBCA建库找不到ASM磁盘一例
[[email?protected] grid]# su - grid rac2-> cd /u01/app/11.2.0/grid/bin rac1-> ls -l oracle -rwsr-s--x 1 grid oinstall 209836184 Apr 9 17:50 oracle 文件权限正确 -rwxr-x--x 1 grid oinstall 209914519 9月 7 14:42 oracle 文件权限错误 [[email?protected] bin]# chmod 751 oracle [[email?protected] bin]# chmod 6751 oracle
?
[[email?protected] grid]# su - oracle rac2-> cd $ORACLE_HOME/bin /u01/app/oracle/product/11.2.0/db_1/bin rac2-> ls -l oracle -rwsr-s--x 1 oracle oinstall 239501424 Apr 9 20:03 oracle 文件权限正确
修改权限:
-rwsr-s--x 1 oracle asmdba 239626641 Apr 17 14:34 oracle rac1-> chown -R oracle:oinstall oracle rac1-> ls -l oracle -rwxr-x--x 1 oracle oinstall 239626641 Apr 17 14:34 oracle rac1-> chmod 6751 oracle
rac1-> source .bash_profile rac1-> export ORACLE_SID=baydb1 rac1-> sqlplus / as sysdba
=============================================== oracle学习之asm实例的数据库启动方式
1.先启动asm相关服务: crsctl start resource ora.cssd
2.启动asm实例; sqlplus /nolog SQL> conn / as sysasm SQL>startup
3.启动数据库: sqlplus /nolog SQL> conn / as sysdba SQL>startup
?
?
修改1: chmod +s oracle 重新回到DBCA建库界面继续执行,则会成功发现ASM磁盘组,并成功建库。
$ORACLE_HOME/bin/oracle该文件的默认权限为 751权限,有个s权限,如果s权限消失,这时通过OS认证将不能登录到数据库;
----------------------------------------------------------------- 问题6: dbca asm ora 01017错误
修改2:【bayaim注意 坑逼,node1、node2都要执行】 usermod -a -G asmdba,asmadmin,dba,oinstall oracle usermod -a -G asmdba,oinstall grid
通过截图报错查看dbca日志和所示的oraagent_oracle.log
dbca日志 : /u01/app/oracle/cfgtoollogs/dbca
/app/grid/11.2.0/log/rac2/agent/crsd/oraagent_oracle
-----------------------------------------------------------------
ORA-19624 ORA-19870 ORA-19504 ORA-17502 今天做了个很简单的实验,11g asm建库的时候报错如下: 其实就是很简单的权限问题 [[email?protected] dev]# ls -l /dev/sd* brw-rw---- 1 root disk 8,0 Apr 11 13:46 /dev/sda brw-rw---- 1 root disk 8,1 Apr 11 13:46 /dev/sda1 brw-rw---- 1 root disk 8,2 Apr 11 13:46 /dev/sda2 brwxrwxr-x 1 grid asmadmin 8,16 Apr 11 13:47 /dev/sdb brw-rw---- 1 grid asmadmin 8,17 Apr 11 13:47 /dev/sdb1 brwxrwxr-x 1 grid asmadmin 8,32 Apr 11 13:47 /dev/sdc brw-rw---- 1 grid asmadmin 8,33 Apr 11 13:47 /dev/sdc1 brwxrwxr-x 1 grid asmadmin 8,48 Apr 11 13:47 /dev/sdd brw-rw---- 1 grid asmadmin 8,49 Apr 11 13:47 /dev/sdd1 brwxrwxr-x 1 grid asmadmin 8,64 Apr 11 13:47 /dev/sde brw-rw---- 1 grid asmadmin 8,65 Apr 11 13:47 /dev/sde1
[[email?protected] ~]# fdisk -l | grep /dev/sd Disk /dev/sda: 64.4 GB,64424509440 bytes,125829120 sectors /dev/sda1 * 2048 2099199 1048576 83 Linux /dev/sda2 2099200 125829119 61864960 8e Linux LVM Disk /dev/sdb: 1073 MB,1073741824 bytes,2097152 sectors /dev/sdb1 2048 2097151 1047552 83 Linux Disk /dev/sdc: 524 MB,524288000 bytes,1024000 sectors /dev/sdc1 102399 1023999 460800+ 83 Linux Disk /dev/sdd: 8589 MB,8589934592 bytes,16777216 sectors /dev/sdd1 2048 16777215 8387584 83 Linux Disk /dev/sde: 524 MB,1024000 sectors /dev/sde1 2048 1023999 510976 83 Linux [[email?protected] ~]# chown -R grid:asmadmin /dev/sdb [[email?protected] ~]# chown -R grid:asmadmin /dev/sdc [[email?protected] ~]# chown -R grid:asmadmin /dev/sdd [[email?protected] ~]# chown -R grid:asmadmin /dev/sde [[email?protected] ~]# chmod 775 /dev/sdb [[email?protected] ~]# chmod 775 /dev/sdc [[email?protected] ~]# chmod 775 /dev/sdd [[email?protected] ~]# chmod 775 /dev/sde [[email?protected] ~]#
?
?
spfile:+DTA/orcl/spfileorcl.ora
The Database Control URL is http://rac1:1158/em
tnsnames.ora:
[[email?protected] admin]# pwd /u01/app/11.2.0/grid/network/admin
?
rac1-vip-> env | grep ORA ORACLE_SID=+ASM1 ORACLE_BASE=/u01/app/grid ORACLE_TERM=xterm ORACLE_HOME=/u01/app/11.2.0/grid rac1-vip-> cd /u01/app/11.2.0/grid rac1-vip->
[[email?protected] ~]# find / -name crsctl /u01/app/11.2.0/grid/bin/crsctl [[email?protected] bin]# ./crsctl start has
以上has启动命令需要在每个节点分别执行
查看节点状态
/u01/app/11.2.0/grid/bin/crs_stat -t
/u01/app/11.2.0/grid/bin/srvctl
[[email?protected] ~]$ crs_stat -t -v 或者 crsctl status resource -t
2、启动集群(cluster)
[[email?protected] bin]# ./crsctl start has CRS-4123: Oracle High Availability Services has been started.
[[email?protected] bin]# ./crsctl start cluster -all --所有节点同时启动 CRS-5702: Resource ‘ora.evmd‘ is already running on ‘rac1‘ CRS-5702: Resource ‘ora.crsd‘ is already running on ‘rac1‘
[[email?protected] ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster -all --所有节点同时启动
[[email?protected] log]# ll /dev/raw/*
或者只启动指定节点的
# ./crsctl start cluster -n rac1 rac2 --两个节点同时启动
#强制停止节点2的crs
/u01/app/11.2.0/grid/bin/crsctl ./crsctl stop crs -f
[[email?protected] ~]# find / -name crsctl
[[email?protected] ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs
[[email?protected] ~]# /u01/grid/11.2.0.4/bin/crsctl stop crs (分别在两个节点的root用户下执行) .
(4)再次查看两个节点的CRS服务状态: [[email?protected] ~]$ crs_stat -t -v CRS-0184: Cannot communicate with the CRS daemon. (服务已经关闭) [[email?protected] ~]$ crs_stat -t -v CRS-0184: Cannot communicate with the CRS daemon. (服务已经关闭) 当上述操作都执行完成,并且正常关闭后,就可以将服务器的关闭了。
#观察到crs进程已经启动 [email?protected]:/>ps -ef|grep crsd.bin|grep -v grep
#等待一段时间,可以查GI相关的核心后台进程 ps -ef|grep crsd.bin|grep -v grep ps -ef|grep cssd.bin|grep -v grep ps -ef|grep pmon ps -ef|grep pmon|grep -v grep ps -ef|grep evmd.bin ps -ef|grep crsd.bin
#当核心进程都起来时,再次查看crsctl资源情况,发现已经可以正常查询,各资源正在启动 crsctl stat res -t
11g cluster 的启动顺序是: ohash cssd crsd evmd
==========================
问题:
1. 如果虚拟机前期磁盘不够,不要关机增加磁盘,这样磁盘号:sdk* 就变动,进而影响ASM对应规则,一定要在线扩。
?
?
[[email?protected] ~]# ls -lh /u01/app/11.2.0/grid/crf/db/rac2/crfclust.bdb -rw-r----- 1 root root 128K Apr 23 14:59 /u01/app/11.2.0/grid/crf/db/rac2/crfclust.bdb
[[email?protected] /]# cat /dev/null >./root/.xsession-errors You have new mail in /var/spool/mail/root [[email?protected] /]# ls -lh ./root/.xsession-errors-rw------- 1 root root 260K Apr 30 13:26 ./root/.xsession-errors
(编辑:惠州站长网)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|