S8

## Skillset 8
### TASKS:
---

#### 1. Installation of Grid Infrastructure
安装 Grid 基础设施

1.1 The installation media of GI is placed in the directory of /stage/grid :  
   安装介质放置在 /stage/grid 目录中：
- ORACLE_BASE=/u01/app/grid  
- ORACLE_HOME=/u01/app/11.2.0/grid

```bash
ifconfig eth 0 修改ip

#配置解析
cat /etc/resolv.conf
;generated by /sbin/dhclient-script 
search example.com
nameserver 192.0.2.11
#配置环境变量
vi .bash_profile
# .bash_profile 
#Get the aliases and functions 
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
#User specific environment and startup programs 
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/u01/app/grid 
export ORACLE_HOME=/u01/app/11.2.0/grid 
export PATH=$ORACLE_HOME/bin:$PATH 
export ORACLE_SID=+ASM1

mkdir -p /u01/app/grid 
mkdir -p /u01/app/11.2.0/grid/bin

#检查裸设备
/etc/init.d/oracleasm listdisks

#检查dns是否正常
nslookup cluster01-scan.example.com

检查hosts
cat /etc/hosts

;	Do not remove the following line, or various programs
;	that require network functionality will fail.
127.0.0.1	localhost.localdomain localhost
::1	localhost6.localdomain6 localhost6
##Public Network	
192.0.2.101	host01.example.com	host01
192.0.2.102	host02.example.com	host02
##Public Virtual IP (VIP) addresses	
192.0.2.103	host01-vip.example.com  host01-vip
192.0.2.104	host02-vip.example.com  host02-vip
##Private Interconnect	
192.168.0.101	host01-priv.example.com host01-priv
192.168.0.102	host02-priv.example.com host02-priv
##Scanip 如果nslook不通 手动添加
192.0.2.111 cluster01-scan.example.com

#检查用户组、用户
grep oinstall /etc/group
grep oracle /etc/group 
grep oracle /etc/passwd

#安装
cd /stage/grid
unzip p10404530_112030_LINUX_3of7.zip
xhost +
./runInstaller

```
1.2 Create a disk group DATA, use the normal mode, used for OCR and VOTE ASMDISK1, ASMDISK2, ASMDISK3, ASMDISK4.  
   创建一个磁盘组 DATA，使用正常模式，用于 OCR 和投票，使用 ASMDISK1、ASMDISK2、ASMDISK3、ASMDISK4。
```
#安装途中
#修改磁盘路径
/dev/oracleasm/disks/*
选择1234

```
1.3 Create a disk group FRA, use the external method, is used to store the flashback ASMDISK5, ASMDISK6, ASMDISK7, ASMDISK8.  
   创建一个磁盘组 FRA，使用外部方法，用于存储闪回，使用 ASMDISK5、ASMDISK6、ASMDISK7、ASMDISK8。
```
asmca
名字FRA
选择external
56

```
1.4 Create an ACFS disk group, use the external mode, volume name: ADVM ASMDISK9, ASMDISK10, ASMDISK11, ASMDISK12.  
   创建一个 ACFS 磁盘组，使用外部模式，卷名为：ADVM，使用 ASMDISK9、ASMDISK10、ASMDISK11、ASMDISK12。
```
asmca
ACFS
选择external
9-12

volumes
ADVM
5G
```
1.5 Create the ACFS file system, volume name is db_files, the size of 2G, used for ACFS. Mount point is /u01/app/oracle/acfs.  
   创建 ACFS 文件系统，卷名为 db_files，大小为 2G，用于 ACFS。挂载点为 /u01/app/oracle/acfs。
```
asm cluster file systems
volumes   --create volumes
volumes name -- db_files
ok

general purposr file system
选择/u01/app/oracle/acfs目录
ok

show
挂载目录

```
---

#### 2. Manage Grid Infrastructure
#### 2. 管理 Grid 基础设施

2.1 FOR OCR MIRROR, use the FRA disk group.  
   对于 OCR 镜像，使用 FRA 磁盘组。
```
检查状态信息
/u01/app/11.2.0/grid/bin/ocrcheck

/u01/app/11.2.0/grid/bin/ocrconfig -add +FRA

两个节点分别查看
/u01/app/11.2.0/grid/bin/ocrcheck
```
2.2 Copy the db_images.zip file to the ACFS, file in the /home/oracle directory.  
   将 db_images.zip 文件复制到 ACFS，文件位于 /home/oracle 目录中。
```
创建文件
zip -k db_images.zip *

/sbin/acfsutil info fs
df -h

/sbin/mount.acfs -o all

ll /u01/app/oracle/acfs/

另个节点查看
```
2.3 ACFS snapshot, the name of the ACFS_SNAP01, on the ACFS file system.  
   在 ACFS 文件系统上创建 ACFS 快照，名称为 ACFS_SNAP01。
```
/sbin/acfsutil snap create ACFS_SNAP1 /u01/app/oracle/acfs/

ll /u01/app/oracle/acfs/.ACFS/snaps/ACFS_SNAP/

--删除
 /sbin/acfsutil snap delete ACFS_SNAP /u01/app/oracle/acfs/
```
2.4 Dump Oracle Local Registry for the first node known as MYOLR, on the /home/oracle.  
   在 /home/oracle 上转储第一个节点的 Oracle 本地注册表，称为 MYOLR。
```
1、2节点全部执行    
/u01/app/11.2.0/grid/bin/ocrdump -local /home/oracle/MYOLR

ll /home/oracle

```
2.5 Turn off the automatic start function of GI.  
   关闭 GI 的自动启动功能。
```
1\2节点全部关闭自启
/u01/app/11.2.0/grid/bin/crsctl disable has CRS
```
---

DBLOG

导航1234

最近发表

友情链接