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