加入收藏 | 设为首页 | 会员中心 | 我要投稿 惠州站长网 (https://www.0752zz.com.cn/)- 办公协同、云通信、物联设备、操作系统、高性能计算!
当前位置: 首页 > 站长百科 > 正文

bay——安装_RAC11g_LC_测试环境-rehat6+udev.txt

发布时间:2021-01-18 02:43:07 所属栏目:站长百科 来源:网络整理
导读:副标题#e# ★★★____★☆★〓〓〓〓→ VMware vSphere Client6.0 https://10.20.4.200/ 下载Vwmare IP:10.20.4.200 -------账号:root -------密码:password --------------------------------------------- 机器1: root/bayaim oracle/oracle grid/grid


问题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

(编辑:惠州站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

推荐文章
    热点阅读