oracle 19c rac搭建

服务器信息

-- 参考机器
00.00.224.50 xxoo180091
00.00.224.51 xxoo180092

-- 部署机器
00.00.229.19 xxoo180105
00.00.229.20 xxoo180106

申请vip

vip
00.00.229.36
00.00.229.37
00.00.229.38

{'ip_addr': '00.00.229.36', 'status': 'unreachable', 'checked': True, 'ip_type': 'VIP', 'target_ci': 59, 'target_list': [{'id': 1615014, 'name': 'oracle-xxoo180105-xxoo180106'}]} oracle-xxoo180105-xxoo180106 成功
{'ip_addr': '00.00.229.37', 'status': 'unreachable', 'checked': True, 'ip_type': 'VIP', 'target_ci': 59, 'target_list': [{'id': 1615014, 'name': 'oracle-xxoo180105-xxoo180106'}]} oracle-xxoo180105-xxoo180106 成功
{'ip_addr': '00.00.229.38', 'status': 'unreachable', 'checked': True, 'ip_type': 'VIP', 'target_ci': 59, 'target_list': [{'id': 1615014, 'name': 'oracle-xxoo180105-xxoo180106'}]} oracle-xxoo180105-xxoo180106 成功

修改host

xxoo180105 00.00.229.19 物理机 Linux OEL7.9 测试环境（UAT） 使用中 1.1.53.1
xxoo180106 00.00.229.20 物理机 Linux OEL7.9 测试环境（UAT） 使用中 1.1.53.2

xxoo180105 00.00.229.19 物理机 Linux OEL7.9 测试环境（UAT） 使用中 1.1.53.1
xxoo180106 00.00.229.20 物理机 Linux OEL7.9 测试环境（UAT） 使用中 1.1.53.2

生产scan：xxoo-cluster-scan
灾备scan：ooxx-cluster-scan

00.00.229.19 xxoo180105
00.00.229.20 xxoo180106

00.00.229.36 xxoo180105-vip
00.00.229.37 xxoo180106-vip
00.00.229.38 xxoo-cluster-scan

1.9.2.1 xxoo180105-priv
1.9.2.2 xxoo180106-priv

修改密码

chage -M 9999 oracle
chage -M 9999 grid

echo ‘oracle’ |passwd --stdin oracle
echo ‘oracle’ |passwd --stdin grid

复制安装介质

软件在堡垒机上，安装包列表：
–grid和db软件
/xxoo/dba/software/oracle_software/19c/server
-rwxrwxrwx 1 padba dba 2.9G Sep 24 2019 LINUX.X64_193000_db_home.zip
-rwxrwxrwx 1 padba dba 2.7G Sep 24 2019 LINUX.X64_193000_grid_home.zip
drwxrwxrwx 4 padba dba 4.0K Jun 4 14:34 patches

–19.15.0 psu和小补丁
/xxoo/dba/software/oracle_software/19c/server/patches/19.15.0
drwxrwxrw- 2 padba dba 4096 May 20 10:09 db_psu
drwxrwxrw- 2 padba dba 4096 May 20 10:08 oneoff_patch
-rw-r–r-- 1 padba dba 2832388023 May 17 13:16 p33803476_190000_Linux-x86-64.zip
-rw-r–r-- 1 padba dba 124109254 May 17 13:17 p6880880_190000_Linux-x86-64.zip

33803476,grid & db psu
6880880,opatch

–19.15.0 oneoff_patch,bug补丁
/xxoo/dba/software/oracle_software/19c/server/patches/19.15.0/oneoff_patch
-rw-r–r-- 1 padba dba 1347583 May 17 13:15 p30978304_1915000DBRU_Generic.zip
-rw-r–r-- 1 padba dba 611576 May 17 13:15 p32455516_1915000DBRU_Linux-x86-64.zip
-rw-r----- 1 padba dba 125785510 May 17 13:16 p33808367_190000_Linux-x86-64.zip
-rw-r–r-- 1 padba dba 1762170 May 17 13:16 p34013305_1915000DBRU_Linux-x86-64.zip
-rw-r–r-- 1 padba dba 69070 Aug 22 16:15 p33848060_1915000DBRU_Linux-x86-64.zip
-rw-r–r-- 1 padba dba 2464054 Oct 13 16:06 p34482043_1915000DBRU_Linux-x86-64.zip

33808367,ojvm psu
33848060,adg bug,ORA-00600[ktrgtc2:objdchk_kcbgtcr_5]
34482043,gc bug

安装环境上创建目录
mkdir -p /oracle_xxoo/software/{server,19.15.0}
chown -R grid:oinstall /oracle_xxoo/software
chmod 777 -R /oracle_xxoo/software

mkdir -p /oracle_xxoo/dumpdir
chmod 777 -R /oracle_xxoo/dumpdir

从堡垒机拷贝介质
host1=00.00.229.19
host2=00.00.229.20
cd /oracle_xxoo/software/server
scp *.zip test@host1:/oraclexxoo/software/server/scp∗.ziptest@{host1}:/oracle_xxoo/software/server/
scp *.zip test@host1:/oraclex​xoo/software/server/scp∗.ziptest@{host2}:/oracle_xxoo/software/server/

cd /oracle_xxoo/software/
scp -r 19.15.0/* test@host1:/oraclexxoo/software/19.15.0/scp−r19.15.0/∗test@{host1}:/oracle_xxoo/software/19.15.0/
scp -r 19.15.0/* test@host1:/oraclex​xoo/software/19.15.0/scp−r19.15.0/∗test@{host2}:/oracle_xxoo/software/19.15.0/

修改介质属主

chown -R grid:oinstall /oracle_xxoo/software/server
chown -R grid:oinstall /oracle_xxoo/software/19.15.0

配置用户profile

su - grid
vi ~/.bash_profile
#.bash_profile
#Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
#User specific environment and startup programs
PATH=PATH:PATH:PATH:HOME/.local/bin:$HOME/bin
export PATH

umask 022
export TMP=/tmp
export TMPDIR=/tmp
export ORACLE_BASE=/oracle_grid/app/oracle
export ORACLE_HOME=/oracle_grid/19c/grid
export ORACLE_SID=+ASM1
export ORA_CRS_HOME=ORACLEHOMEexportPATH=ORACLE_HOME
export PATH=ORACLEH​OMEexportPATH=ORACLE_HOME/bin:$PATH

su - oracle
vi ~/.bash_profile
#.bash_profile
#Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
#User specific environment and startup programs
PATH=PATH:PATH:PATH:HOME/.local/bin:$HOME/bin
export PATH

umask 022
export TERM=vt100
export EDITOR=vi
#export ORACLE_SID=
export ORACLE_BASE=/paic/app/oracle/rdbms
export ORACLE_HOME=/paic/app/oracle/rdbms/19c
export PATH=ORACLEHOME/bin:.:ORACLE_HOME/bin:.:ORACLEH​OME/bin:.:HOME/sh:/oracle_grid/19c/grid/bin:/sbin:/usr/sbin:/opt/VRTS/bin:/opt/VRTSvcs/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
#export PS1="hostname:ORACLESID>"exportORACLEDOC=ORACLE_SID > "
export ORACLE_DOC=ORACLES​ID>"exportORACLED​OC=ORACLE_BASE/doc
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TMP=/tmp
export ORA_ENCRYPT_LOGIN=true
export SHELL_PATH=/etc/paic/shell
export NLS_DATE_FORMAT=‘yyyy-mm-dd hh24:mi:ss’
#export NLS_LANG=american_america.AL32UTF8
#export NLS_LANG=american_america.AL32UTF8

创建目录

su - root

#grid base
mkdir -p /oracle_grid/app
mkdir -p /oracle_grid/app/oracle
chown -R grid:oinstall /oracle_grid/app
chmod -R 775 /oracle_grid/app

#grid home
mkdir -p /oracle_grid/19c
mkdir -p /oracle_grid/19c/grid
chown -R grid:oinstall /oracle_grid/19c
chmod -R 775 /oracle_grid/19c

#inventory
mkdir -p /oracle_grid/app/oraInventory
chown -R grid:oinstall /oracle_grid/app/oraInventory
chmod -R 775 /oracle_grid/app/oraInventory

#oracle home
chown oracle:oinstall /paic/app/oracle/rdbms
mkdir -p /paic/app/oracle/rdbms/19c
chown oracle:oinstall -R /paic/app/oracle/rdbms/19c
chmod 755 /paic/app/oracle/rdbms/19c

配置ssh互信（grid,oracle）

所有节点上执行
注意.ssh目录和authorized_keys文件的权限，不然可能登陆不了
在grid,oracle用户下执行

su - grid
oracle

ip1=00.00.229.19
ip2=00.00.229.20
host1=xxoo180105
host2=xxoo180106

ssh-keygen -t rsa

ssh-copy-id $ip1
ssh-copy-id $ip2
chmod 755 ~/.ssh
chmod 644 ~/.ssh/authorized_keys

ssh $ip1 date
ssh $ip2 date
ssh $host1 date
ssh $host2 date

su - oracle
数据库用户也执行以上操作

解压grid软件

只需在执行安装的节点解压，另外节点$ORACLE_HOME为空目录
su - grid
cd $ORACLE_HOME
unzip /oracle_xxoo/software/server/LINUX.X64_193000_grid_home.zip -d ./

------------------------------------------------------------------------ 检查网卡绑定的ip是否一致

安装grid预检查

su - grid
host1=xxoo180105
host2=xxoo180106

cd $ORACLE_HOME
./runcluvfy.sh stage -pre crsinst -n $host1,$host2 -verbose|grep -i failed

[grid@xxoo180105 grid]$ ./runcluvfy.sh stage -pre crsinst -n $host1,$host2 -verbose|grep -i failed
xxoo180106 soft 8192 10240 failed
xxoo180105 soft 8192 10240 failed
Verifying Soft Limit: maximum stack size ...FAILED (PRVG-0449)
xxoo180105 137438953472 137438953472 270225319936 failed Current value incorrect. Configured value incorrect.
xxoo180106 137438953472 137438953472 270225319936 failed Current value incorrect. Configured value incorrect.
Verifying OS Kernel Parameter: shmmax ...FAILED (PRVG-1205, PRVG-1201)
Verifying Users With Same UID: 0 ...FAILED (PRVF-4132)
xxoo180105 10.11.86.15 IPv4 failed
xxoo180105 10.37.90.15 IPv4 failed
xxoo180106 10.11.86.15 IPv4 failed
xxoo180106 10.37.90.15 IPv4 failed
Verifying resolv.conf Integrity ...FAILED (PRVG-10048)
Verifying zeroconf check ...FAILED (PRVE-10077)
Verifying Soft Limit: maximum stack size ...FAILED
Verifying OS Kernel Parameter: shmmax ...FAILED
Verifying Users With Same UID: 0 ...FAILED
Verifying resolv.conf Integrity ...FAILED
Verifying zeroconf check ...FAILED
[grid@xxoo180105 grid]$

--------------------------------------------------------
cat /etc/security/limits.conf
grid soft nofile 1024000
grid hard nofile 1024000
oracle soft nofile 1024000
oracle hard nofile 1024000
oracle soft memlock unlimited
oracle hard memlock unlimited
grid soft memlock unlimited
grid hard memlock unlimited

[grid@xxoo180105 grid]$ cat /etc/sysctl.conf
kernel.sysrq = 1
kernel.unknown_nmi_panic = 1
kernel.shmall = 4294967296
kernel.shmmni = 8192
kernel.sem = 256 1048576 256 4096
fs.aio-max-nr = 6291456
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ipfrag_low_thresh = 15728640
net.ipv4.ipfrag_high_thresh = 16777216
kernel.shmmax = 137438953472
vm.nr_hugepages = 153600
[grid@xxoo180105 grid]$

[root@xxoo180106 test]# cat /etc/sysctl.conf
kernel.sysrq = 1
kernel.unknown_nmi_panic = 1
kernel.shmall = 4294967296
kernel.shmmni = 8192
kernel.sem = 256 1048576 256 4096
fs.aio-max-nr = 6291456
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ipfrag_low_thresh = 15728640
net.ipv4.ipfrag_high_thresh = 16777216
kernel.shmmax = 137438953472
vm.nr_hugepages = 153600
[grid@xxoo180106 grid]$

-- 检查并生成fixp脚本
./runcluvfy.sh stage -pre crsinst -n $host1,$host2 -verbose -fixup

-- 显示结果 提示执行 用root用户执行之后 再ENTER
Execute "/tmp/CVU_19.0.0.0.0_grid/runfixup.sh" as root user on nodes "xxoo180105,xxoo180106" to perform the fix up operations manually

Press ENTER key to continue after execution of "/tmp/CVU_19.0.0.0.0_grid/runfixup.sh" has completed on nodes "xxoo180105,xxoo180106"

Fix: Soft Limit: maximum stack size

Node Name Status
------------------------------------ ------------------------
xxoo180106 successful
xxoo180105 successful
Result:
"Soft Limit: maximum stack size" was successfully fixed on all the applicable nodes

Fix: OS Kernel Parameter: shmmax

Node Name Status
------------------------------------ ------------------------
xxoo180106 successful
xxoo180105 successful
Result:
"OS Kernel Parameter: shmmax" was successfully fixed on all the applicable nodes

Fix: zeroconf check

Node Name Status
------------------------------------ ------------------------
xxoo180106 successful
xxoo180105 successful
Result:
"zeroconf check" was successfully fixed on all the applicable nodes

Fix up operations were successfully completed on all the applicable nodes
NOTE:
Log out of the current session and Re-Login to nodes "xxoo180105" for the fix-up operations to be effective.

安装grid

编辑/etc/passwd，注释paroot用户那一行

只需要在一个节点执行安装
su - grid
#export DISPLAY=10.17.183.12:5.0
export DISPLAY=00.00.224.179:0.0
cd $ORACLE_HOME
./gridSetup.sh
选择configure oracle grid infrastructure for a new cluster，next
选择configure an oracle standalone custer，next
保持默认Create Local SCAN信息，next
xxoo-cluster
xxoo-cluster-scan
1521
添加另一个主机public ip、vip信息，测试ssh互相，next
私网从private调整为asm & private，next
主网选26.开头的
ASM和私网1.开头的；172.开头是大数据抽数用的，不要选
选择use oracle flex asm for storage，next
选择no，19c提供了关闭grid infrastructure management repository选项，next
创建OCRVG_DG asm磁盘组，redundancy选择normal，选择磁盘发现路径为/dev/oracleasm/disks，选择OCR_x格式的磁盘（3个），next
输入标准密码，next Yshssjx#2019 Yshssjx#2019
选择do not use intelligence platform management interface，next
默认不启用EM，next
默认用户组配置，asm administrator对应asmadmin，asm dba对应asmdba，asm opr留空，next
默认oracle base环境变量目录，/oracle_grid/app/oracle，next
默认oracle inventory目录，/oracle_grid/app/oraInventory，next
默认不配置root信息，next
安装检查，忽略scan warning和dns/nis failed，rpm package management database info是19c新增检查，勾选ignore，next
选择install
执行root脚本
安装到32%，提示需要root用户执行脚本，依次按顺序执行脚本。
在两个节点执行（修改oraInventory属组、权限，执行很快）
/oracle_grid/app/oraInventory/orainstRoot.sh
在两个节点执行
/oracle_grid/19c/grid/root.sh
执行完成root用户脚本后，选择ok继续安装
出现oracle cluster verification utility failed提示，选择ok，选择skip，选择ok
选择close，完成安装

检查grid bin权限

su - grid
ls -l $ORACLE_HOME/bin
ls -l $ORACLE_HOME/bin/oracle
-rwsr-s–x 1 grid oinstall 425091656 Dec 14 13:31 oracle

安装database预检查

在oracle用户下执行grid的runcluvfy.sh脚本

su - oracle
host1=xxoo180105
host2=xxoo180106

cd /oracle_grid/19c/grid
./runcluvfy.sh stage -pre dbinst -n host1,host1,host1,host2 -verbose|grep -i failed

检查并生成fixp脚本
./runcluvfy.sh stage -pre dbinst -n host1,host1,host1,host2 -verbose -fixup

在两个节点运行上面产生的fixup脚本
/tmp/CVU_19.0.0.0.0_oracle/runfixup.sh

解压database软件

只需在执行安装的节点解压
su - oracle
cd $ORACLE_HOME
unzip /oracle_xxoo/software/server/LINUX.X64_193000_db_home.zip -d ./

安装database

只需要在一个节点执行安装
su - oracle
export DISPLAY=00.00.224.179:0.0
cd $ORACLE_HOME
./runInstaller
选择set up software only，next
选择oracle real application clusters database installation，next
默认两个安装节点机器都是勾选的，next
选择enterprise edition，next
oracle base默认环境变量路径/paic/app/oracle/rdbms，next
选择database operator group（osoper）为oinstall，其他默认都是dba，next
不填写root信息，next
先决条件检查
解决检查中的问题，点击fix&check again，按提示在root用户执行脚本
/tmp/InstallActions2020-06-10_01-05-43PM/CVU_19.0.0.0.0_oracle/runfixup.sh
忽略scan和dns/nis failed，勾选ignore，next
install
在两个节点执行
在安装到92%提示需要root用户执行脚本
/paic/app/oracle/rdbms/19c/root.sh
两个节点完成后点击ok，选择close完成安装。

复制oui-patch.xml

节点1的运行了安装程序，会生产oui-patch.xml，节点2没运行没有这个文件，没有这个文件打补丁会有问题；
su - grid
host2=xxoo180106
cd /oracle_grid/app/oraInventory/ContentsXML
scp -rp oui-patch.xml $host2:/oracle_grid/app/oraInventory/ContentsXML/

更新grid opatch

在两个节点执行，grid的oracle home属主是root:oinstall，需要root用户执行
su - root
cd /oracle_grid/19c/grid
mv OPatch OPatch_20231030
unzip /oracle_xxoo/software/19.15.0/p6880880_190000_Linux-x86-64.zip -d ./
chown grid:oinstall -R OPatch

更新database opatch

在两个节点执行，grid的oracle home属主是root:oinstall，需要root用户执行
su - oracle
cd $ORACLE_HOME
mv OPatch OPatch_20231030
unzip /oracle_xxoo/software/19.15.0/p6880880_190000_Linux-x86-64.zip -d ./

应用grid psu (33803476,gi & db)

逐个节点执行

psu补丁程序解压后目录属主需为grid用户或者使用grid用户解压；
patch psu补丁程序前先analyze分析完成后再apply；
逐个节点完成opatchauto，lspatches确认；
apply过程：
两个节点起着，它会停掉当前节点crs，另外节点的crs要起着
两个节点crs停着，就不使用滚动升级，加-nonrolling参数，如果另一个节点没停，这个启动会报补丁级别不一致

节点1启、节点2停crs

su - root
/oracle_grid/19c/grid/bin/crsctl stop crs

解压psu
su - grid
rm -rf /oracle_xxoo/software/19.15.0/p33803476
mkdir -p /oracle_xxoo/software/19.15.0/p33803476
cd /oracle_xxoo/software/19.15.0/p33803476
unzip /oracle_xxoo/software/19.15.0/p33803476_190000_Linux-x86-64.zip -d ./

在grid home应用

逐个节点应用

su - root

/oracle_grid/19c/grid/OPatch/opatchauto apply
/oracle_xxoo/software/19.15.0/p33803476/33803476
-oh /oracle_grid/19c/grid
-analyze
-nonrolling

/oracle_grid/19c/grid/OPatch/opatchauto apply
/oracle_xxoo/software/19.15.0/p33803476/33803476
-oh /oracle_grid/19c/grid
-nonrolling
-norestart

中间会启动crs然后停下来，可能停不干净，最好再停一次
/oracle_grid/19c/grid/bin/crsctl stop crs

日志输出
--------------------------------Summary--------------------------------
==Following patches were SUCCESSFULLY applied:
Patch: /oracle_xxoo/software/19.15.0/p33803476/33803476/33575402
Patch: /oracle_xxoo/software/19.15.0/p33803476/33803476/33806152
Patch: /oracle_xxoo/software/19.15.0/p33803476/33803476/33815596
Patch: /oracle_xxoo/software/19.15.0/p33803476/33803476/33815607
Patch: /oracle_xxoo/software/19.15.0/p33803476/33803476/33911149

su - grid
export PATH=PATH:PATH:PATH:ORACLE_HOME/OPatch
opatch lspatches

在database home应用

两个节点的crs启动起来
/oracle_grid/19c/grid/bin/crsctl start crs

逐个节点应用

su - root
/paic/app/oracle/rdbms/19c/OPatch/opatchauto apply
/oracle_xxoo/software/19.15.0/p33803476/33803476
-oh /paic/app/oracle/rdbms/19c
-analyze

/paic/app/oracle/rdbms/19c/OPatch/opatchauto apply
/oracle_xxoo/software/19.15.0/p33803476/33803476
-oh /paic/app/oracle/rdbms/19c
-nonrolling

日志输出
--------------------------------Summary--------------------------------
==Following patches were SUCCESSFULLY applied:
Patch: /oracle_xxoo/software/19.15.0/p33803476/33803476/33806152
Patch: /oracle_xxoo/software/19.15.0/p33803476/33803476/33815596

su - oracle
export PATH=PATH:PATH:PATH:ORACLE_HOME/OPatch
opatch lspatches

应用其他bug补丁

逐个节点执行

rm -rf /oracle_xxoo/software/19.15.0/oneoff_patch/napply
mkdir -p /oracle_xxoo/software/19.15.0/oneoff_patch/napply
chown -R grid:oinstall /oracle_xxoo/software/19.15.0/oneoff_patch/napply
chmod 777 /oracle_xxoo/software/19.15.0/oneoff_patch/napply

两个节点起crs
su - root
/oracle_grid/19c/grid/bin/crsctl start crs

检查ASM进程
runtime=“5 minute”
endtime=(date−ud"(date -ud "(date−ud"runtime" +%s)
while [[ $(date -u +%s) -le $endtime ]]
do
echo "Time Now: date +%H:%M:%S"
ps -ef|grep pmon|grep -v grep
sleep 10
done

30978304,32455516,33808367,34013305（db）

p30978304_1915000DBRU_Generic.zip
p32455516_1915000DBRU_Linux-x86-64.zip
p33808367_190000_Linux-x86-64.zip
p34013305_1915000DBRU_Linux-x86-64.zip

解压
su - oracle
cd /oracle_xxoo/software/19.15.0/oneoff_patch/napply
unzip /oracle_xxoo/software/19.15.0/oneoff_patch/p30978304_1915000DBRU_Generic.zip -d ./
unzip /oracle_xxoo/software/19.15.0/oneoff_patch/p32455516_1915000DBRU_Linux-x86-64.zip -d ./
unzip /oracle_xxoo/software/19.15.0/oneoff_patch/p33808367_190000_Linux-x86-64.zip -d ./
unzip /oracle_xxoo/software/19.15.0/oneoff_patch/p34013305_1915000DBRU_Linux-x86-64.zip -d ./
unzip /oracle_xxoo/software/19.15.0/oneoff_patch/p33848060_1915000DBRU_Linux-x86-64.zip -d ./
unzip /oracle_xxoo/software/19.15.0/oneoff_patch/p34482043_1915000DBRU_Linux-x86-64.zip -d ./

export PATH=PATH:PATH:PATH:ORACLE_HOME/OPatch
export PATCHES_BASE=/oracle_xxoo/software/19.15.0/oneoff_patch
opatch napply -oh $ORACLE_HOME -local $PATCHES_BASE/napply -id 33808367
opatch napply -oh $ORACLE_HOME -local $PATCHES_BASE/napply -id 30978304,32455516,34013305,33848060,34482043

检查patch

su - oracle
export PATH=PATH:PATH:PATH:ORACLE_HOME/OPatch
opatch lspatches

检查oracle bin权限

ls -l $ORACLE_HOME/bin
ls -l $ORACLE_HOME/bin/oracle
-rwsr-s–x 1 op12c asmadmin 449478144 May 15 14:44 /paic/app/oracle/rdbms/19c/bin/oracle

取消passwd注释

编辑/etc/passwd，取消paroot用户那一行注释

修改监听器的参数

su - grid
vi $ORACLE_HOME/network/admin/sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.EXPIRE_TIME=10
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10

su - oracle
vi /$ORACLE_HOME/network/admin/sqlnet.ora
SQLNET.EXPIRE_TIME=10
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10

配置sqlplus登陆标识

su - oracle
vi $ORACLE_HOME/sqlplus/admin/glogin.sql
set sqlprompt "_user’@’_connect_identifier> "

调整asm内存参数

su - grid
sqlplus / as sysasm
alter system set memory_max_target=4096M scope=spfile sid=’*’;

#alter system set memory_target=4096M scope=spfile sid=’’;
#alter system set sga_max_size=3072M scope=spfile sid=’’;
#alter system reset memory_target scope=spfile sid=’’;
#alter system reset sga_max_size scope=spfile sid=’’;

/oracle_grid/19c/grid/bin/crsctl stop crs
/oracle_grid/19c/grid/bin/crsctl start crs

/oracle_grid/19c/grid/bin/crsctl stat res -t

检查ASM进程
runtime=“5 minute”
endtime=(date−ud"(date -ud "(date−ud"runtime" +%s)
while [[ $(date -u +%s) -le $endtime ]]s
do
echo "Time Now: date +%H:%M:%S"
ps -ef|grep pmon|grep -v grep
sleep 10
done

创建数据库磁盘组

su - grid

export DISPLAY=00.00.224.179:0.0
asmca

DATA_DG, FRA_DG
redundancy External

netca dbca出不来 因为用的端口不对

export DISPLAY=00.00.224.179:2.4

xxoo180105:xxoouat1 > netca
Oracle Net Services Configuration:
Authorization required, but no authorization protocol specified
Error: null
Check the trace file for details: /paic/app/oracle/rdbms/cfgtoollogs/netca/trace_OraDB19Home1-23103110AM5945.log
Oracle Net Services configuration failed. The exit code is 1

xxoo180105:xxoouat1 > dbca
Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11.XToolkit
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at java.awt.Toolkit$2.run(Toolkit.java:860)
at java.awt.Toolkit$2.run(Toolkit.java:855)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:854)
at com.jgoodies.looks.LookUtils.isLowResolution(LookUtils.java:484)
at com.jgoodies.looks.LookUtils.(LookUtils.java:249)
at com.jgoodies.looks.plastic.PlasticLookAndFeel.(PlasticLookAndFeel.java:135)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:348)
at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1879)
at javax.swing.UIManager.setLookAndFeel(UIManager.java:582)
at oracle.install.commons.util.Application.startup(Application.java:976)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:198)
at oracle.assistants.common.base.driver.AssistantApplication.startup(AssistantApplication.java:336)
at oracle.assistants.dbca.driver.DBConfigurator.startup(DBConfigurator.java:378)
at oracle.assistants.dbca.driver.DBConfigurator.main(DBConfigurator.java:513)

后续创建数据库

监听器

su - oracle
export DISPLAY=00.00.224.179:0.0
netca
listener configuration
add
listrener name,填入dbname,大写
protocols默认tcp
端口，要知道已使用的端口，排上去
no,不配置其他监听
启动

数据库

profile要添加NLS_LANG变量

su - oracle
export DISPLAY=00.00.224.179:0.0
dbca
create a database
advanced configuration
oracle real application cluster(rac) database,admin managed,custom database
默认勾选两个节点
输入database name、sid,不选create as container database
fbms

存储类型asm,数据文件路径+DATA_DG/{DB_UNIQUE_NAME},使用omf
fra填+FRA_DG,size 200GB,enable archiving; 测试环境不勾选fra,也不启用归档;
组件除了oracle jvm,其他取消

*.pga_aggregate_target=21474836480
*.shared_pool_size=8589934592
*.db_cache_size=48318382080

参数
memory
shared pool size, prd 25g, uat 6g
buffer cache size, prd 30g, uat 6g
java pool size, prd 1gb, uat 1g
large pool size, prd 2gb, uat 1g
pga size, prd 20gb, uat 6g
size
block size,8192
processes，prd 6000, uat 3000
character sets
字符集按实际系统要求
其他界面默认
不运行cvu check,不配置em
输入标准sys、system用户密码 Yshssjx#2019
创建选项默认create basebase，点击customize storage locations
control files,最大文件数填 2048, 点apply
redo log groups,增加到12组,每个实例6组,大小2048mb
预检查，勾选ignore all
Finish,开始创建数据库

修改参数

修改local_lisenter,remote_local_lisenter
sqlplus /nolog
conn / as sysdba

实例名要用小写
alter system set local_listener=’(ADDRESS=(PROTOCOL=TCP)(HOST=00.00.235.155)(PORT=1524))’ scope=both sid=‘xxx1’;
alter system set local_listener=’(ADDRESS=(PROTOCOL=TCP)(HOST=00.00.235.156)(PORT=1524))’ scope=both sid=‘xxx2’;
alter system set remote_listener=’(ADDRESS=(PROTOCOL=TCP)(HOST=00.00.235.156)(PORT=1524))’ scope=both sid=‘xxx1’;
alter system set remote_listener=’(ADDRESS=(PROTOCOL=TCP)(HOST=00.00.235.155)(PORT=1524))’ scope=both sid=‘xxx2’;

srvctl stop database -d xxx -o immediate
srvctl start database -d xxx

跑初始化脚本

申请备份san zone

配置cron

自动录入cmdb、清理aduit、自动启监听器、清理归档

新建xxoouat 块8k AL32UTF8

xxoouat 块16k AL32UTF8

netca

-- netca创建监听
alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=00.00.229.36)(PORT=1522)))' scope=both sid='ipsdbuat1';
alter system set remote_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=00.00.229.37)(PORT=1522)))' scope=both sid='ipsdbuat1';

alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=00.00.229.37)(PORT=1522)))' scope=both sid='ipsdbuat2';
alter system set remote_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=00.00.229.36)(PORT=1522)))' scope=both sid='ipsdbuat2';

-- 检查redo数量和大小
@add_logfile.sql

alter database add logfile thread 1 group 5 size 1073741824;
alter database add logfile thread 1 group 6 size 1073741824;
alter database add logfile thread 1 group 7 size 1073741824;
alter database add logfile thread 1 group 8 size 1073741824;
alter database add logfile thread 2 group 9 size 1073741824;
alter database add logfile thread 2 group 10 size 1073741824;
alter database add logfile thread 2 group 11 size 1073741824;
alter database add logfile thread 2 group 12 size 1073741824;

select l.THREAD#,l.GROUP#,l.BYTES from v$log l order by l.THREAD#,l.GROUP#;

--

@init19c_uat.sql

--
srvctl stop database -d xxoouat
srvctl status database -d xxoouat
srvctl start database -d xxoouat
srvctl status database -d xxoouat

xxoouat_19c =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 00.00.229.36)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = 00.00.229.37)(PORT = 1522))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxoouat)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)

netca