rac19C搭建参考 http://blog.itpub.net/70004783/viewspace-2791938/ openfile参考 http://blog.itpub.net/70004783/viewspace-2791487/ dg配置规划同rac
目录规划
|
Grid infrastructure |
Oracle database |
|
HOME=/home/oracle |
HOME=/home/oracle |
|
ORACLE_BASE=/u01/app/grid |
ORACLE_BASE=/u01/app/oracle |
|
ORACLE_HOME=/u01/app/19c/grid |
ORACLE_HOME=/u01/app/oracle/product/19c/db_1 |
ORACLE SID
|
db_name |
prod |
|
Node instance sid |
proddg |
存储规划
|
dg 节点 |
Lun name |
Asm 磁盘名称 /alias |
Size |
ASM 磁盘组名称 |
冗余类型 |
|
dg |
asmocrvote1 |
1G |
OCRDG |
High/normal | |
|
asmocrvote2 |
1G | ||||
|
asmocrvote3 |
1G | ||||
|
asmdata01 |
20G |
DATADG |
external | ||
|
asmdata02 |
20G | ||||
|
asmarch01 |
10G |
FRADG |
external | ||
|
asmmgmt01 |
30G |
MGMTDG |
external |
安装前配置参考rac
[root@localhost ~]# hostnamectl set-hostname racdg [root@localhost ~]# echo "10.8.98.102 racdg" >> /etc/hosts
前面安装方式参考rac安装,此处只列出不一样的地方rac1 rac2 db_unique_name prod(我rac俩节点的oracle环境变量需要改一下,我原来设的是prodpri)racdg db_unique_name prodstd 8.配置grid和oracle用户的环境变量 dg节点
[grid@racdg ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH PS1="[`whoami`@`hostname`:"'$PWD]$' export PS1 umask 022 alias sqlplus="rlwrap sqlplus" export TMP=/tmp export export TMPDIR=$TMP export ORACLE_HOSTNAME=racdg ORACLE_SID=+ASM; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM ORACLE_BASE=/u01/app/grid; export ORACLE_BASE ORACLE_HOME=/u01/app/19c/grid; export ORACLE_HOME NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin; export PATH THREADS_FLAG=native; export THREADS_FLAG if [ $USER = "oracle" ] || [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022 fi [grid@racdg ~]$
oracle
[oracle@racdg ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH PS1="[`whoami`@`hostname`:"'$PWD]$' alias sqlplus="rlwrap sqlplus" alias rman="rlwrap rman" export PS1 export TMP=/tmp export export TMPDIR=$TMP export ORACLE_HOSTNAME=racdg export ORACLE_UNQNAME=prodstd ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/19c/db_1; export ORACLE_HOME ORACLE_SID=proddg; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG PATH=.:$PATH:$HOME/bin:$ORACLE_BASE/product/19c/db_1/bin:$ORACLE_HOME/bin; export PATH THREADS_FLAG=native; export THREADS_FLAG if [ $USER = "oracle" ] || [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022 fi
12.安装集群软件,创建asm磁盘组,安装oracle软件,dbca建库(只截取重要步骤)
找到cvuqddisk包安装后继续
asmca图形化界面创建asm磁盘组
将oracle安装包放到oracle用户的$ORACLE_HOME目录下解压,并图形安装(仅安装软件)
dbca建库
这样就搭建dg端ok了,下面就是配置RAC+DG参考http://blog.itpub.net/70004783/viewspace-2794573/
