|
问题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
（编辑：惠州站长网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
