vi /etc/hostname
cdb04101
vi /etc/hosts
127.0.0.1 localhost.localdomain localhost
#public ip
10.5.68.101 cdb04101
10.5.68.102 cdb04102
#priv ip
192.168.68.101 cdb04101-priv
192.168.68.102 cdb04102-priv
#vip ip
10.5.68.104 cdb04101-vip
10.5.68.105 cdb04102-vip
#scan ip
10.5.68.108 scan4.sncenter.cn
10.5.68.109 scan4.sncenter.cn
10.5.68.110 scan4.sncenter.cn
网卡参数
DNS1=10.5.66.66
vi /etc/resolv.conf
search sncenter.cn loacldomain
nameserver 10.5.66.66
options timeout:2
options attempts:5
vi /etc/host.conf
order bind,hosts
multi on
echo “export LANG=en_US” >> ~/.bash_profile
source ~/.bash_profile
/usr/sbin/groupadd -g 5001 oinstall
/usr/sbin/groupadd -g 5002 dba
/usr/sbin/groupadd -g 5003 oper
/usr/sbin/groupadd -g 5004 asmadmin
/usr/sbin/groupadd -g 5005 asmoper
/usr/sbin/groupadd -g 5006 asmdba
/usr/sbin/useradd -u 6001 -g oinstall -G dba,asmdba,asmadmin,oper oracle
/usr/sbin/useradd -u 6002 -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
passwd grid
passwd oracle
mkdir -p /opt/grid
mkdir -p /opt/19.3.0/grid
chown -R grid:oinstall /opt/grid
chown -R grid:oinstall /opt/19.3.0/grid
chmod -R 775 /opt
mkdir -p /opt/oraInventory
chown -R grid:oinstall /opt/oraInventory
chmod -R 775 /opt
mkdir -p /opt/oracle
mkdir -p /opt/oracle/product/19.3.0/db_1
chown -R oracle:oinstall /opt/oracle
chmod -R 775 /opt
#mount /dev/cdrom /mnt
#cd /etc/yum.repos.d
#mkdir bk
#mv *.repo bk/
#echo “[EL]” >> /etc/yum.repos.d/itpux.repo
#echo “name =Linux 7.x DVD” >> /etc/yum.repos.d/itpux.repo
#echo “baseurl=file:///mnt” >> /etc/yum.repos.d/itpux.repo
#echo “gpgcheck=0” >> /etc/yum.repos.d/itpux.repo
#echo “enabled=1” >> /etc/yum.repos.d/itpux.repo
yum clean all
yum repolist
cat /etc/yum.repos.d/itpux.repo
yum -y install autoconf
yum -y install automake
yum -y install binutils
yum -y install binutils-devel
yum -y install bison
yum -y install cpp
yum -y install dos2unix
yum -y install ftp
yum -y install gcc
yum -y install gcc-c++
yum -y install lrzsz
yum -y install python-devel
yum -y install compat-db*
yum -y install compat-gcc-34
yum -y install compat-gcc-34-c++
yum -y install compat-libcap1
yum -y install compat-libstdc+±33
yum -y install compat-libstdc+±33.i686
yum -y install glibc-*
yum -y install glibc-.i686
yum -y install libXpm-.i686
yum -y install libXp.so.6
yum -y install libXt.so.6
yum -y install libXtst.so.6
yum -y install libXext
yum -y install libXext.i686
yum -y install libXtst
yum -y install libXtst.i686
yum -y install libX11
yum -y install libX11.i686
yum -y install libXau
yum -y install libXau.i686
yum -y install libxcb
yum -y install libxcb.i686
yum -y install libXi
yum -y install libXi.i686
yum -y install libgcc_s.so.1
yum -y install libstdc++.i686
yum -y install libstdc+±devel
yum -y install libstdc+±devel.i686
yum -y install libaio
yum -y install libaio.i686
yum -y install libaio-devel
yum -y install libaio-devel.i686
yum -y install ksh
yum -y install libXp
yum -y install libaio-devel
yum -y install numactl
yum -y install numactl-devel
yum -y install make -y
yum -y install sysstat -y
yum -y install unixODBC
yum -y install unixODBC-devel
yum -y install elfutils-libelf-devel-0.97
yum -y install elfutils-libelf-devel
yum -y install redhat-lsb-core
yum -y install unzip
yum -y install vnc
vi /etc/security/limits.conf
#ORACLE SETTING 512G
grid soft nproc 16384
grid hard nproc 16384
grid soft nofile 65536
grid hard nofile 65536
grid soft stack 32768
grid hard stack 32768
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft stack 32768
oracle hard stack 32768
oracle hard memlock 480000000
oracle soft memlock 480000000
echo “* - nproc 16384” > /etc/security/limits.d/20-nproc.conf
echo “session required pam_limits.so” >> /etc/pam.d/login
cat /etc/pam.d/login
vi /etc/sysctl.conf
#ORACLE SETTING 512G
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
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 = 1048586
kernel.panic_on_oops = 1
vm.nr_hugepages = 205000
kernel.shmmax = 440234147840
kernel.shmall = 104857600
kernel.shmmni = 4096
vm.swappiness = 10
min_free_kbytes = 524288
sysctl -p
vi /etc/rc.d/rc.local
if test -f /sys/kernel/mm/transparent_hugepage/enabled;
then echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag;
then echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
chmod +x /etc/rc.d/rc.local
cat /sys/kernel/mm/transparent_hugepage/defrag
numactl --hardware
vi /etc/grub2-efi.cfg
vi /etc/default/grub
numa=off
grub2-mkconfig -o /etc/grub2.cfg
grub2-mkconfig -o /etc/grub2-efi.cfg
numactl --hardware
echo “none /dev/shm tmpfs defaults,size=410G 0 0” >>/etc/fstab
mount -o remount /dev/shm
echo “SELINUX=disabled” > /etc/selinux/config
echo "#SELINUXTYPE=targeted " >> /etc/selinux/config
setenforce 0
systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl status firewalld.service
echo “NOZEROCONF=yes” >> /etc/sysconfig/network
vi /etc/nsswitch.conf
hosts: files dns myhostname nis
systemctl stop avahi-daemon.socket avahi-daemon.service
systemctl disable avahi-daemon.socket avahi-daemon.service
systemctl stop ntpd
systemctl disabled ntpd
systemctl status ntpd
ln -sf /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
hwclock
第一台：
su - grid
PS1="[whoami@hostname:"’
P
W
D
]
PWD]
PWD]’
export PS1
umask 022
#alias sqlplus=“rlwrap sqlplus”
export TMP=/tmp
export LANG=en_US
export TMPDIR=
T
M
P
O
R
A
C
L
E
S
I
D
=
+
A
S
M
1
;
e
x
p
o
r
t
O
R
A
C
L
E
S
I
D
O
R
A
C
L
E
T
E
R
M
=
x
t
e
r
m
;
e
x
p
o
r
t
O
R
A
C
L
E
T
E
R
M
O
R
A
C
L
E
B
A
S
E
=
/
o
p
t
/
g
r
i
d
;
e
x
p
o
r
t
O
R
A
C
L
E
B
A
S
E
O
R
A
C
L
E
H
O
M
E
=
/
o
p
t
/
19.3.0
/
g
r
i
d
;
e
x
p
o
r
t
O
R
A
C
L
E
H
O
M
E
N
L
S
D
A
T
E
F
O
R
M
A
T
=
"
y
y
y
y
−
m
m
−
d
d
H
H
24
:
M
I
:
S
S
"
;
e
x
p
o
r
t
N
L
S
D
A
T
E
F
O
R
M
A
T
P
A
T
H
=
.
:
TMP ORACLE_SID=+ASM1; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM ORACLE_BASE=/opt/grid; export ORACLE_BASE ORACLE_HOME=/opt/19.3.0/grid; export ORACLE_HOME NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT PATH=.:
TMPORACLESID=+ASM1;exportORACLESIDORACLETERM=xterm;exportORACLETERMORACLEBASE=/opt/grid;exportORACLEBASEORACLEHOME=/opt/19.3.0/grid;exportORACLEHOMENLSDATEFORMAT="yyyy−mm−ddHH24:MI:SS";exportNLSDATEFORMATPATH=.:PATH:
H
O
M
E
/
b
i
n
:
HOME/bin:
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
su - oracle
第二台：
su - grid
PS1="[whoami@hostname:"’
P
W
D
]
PWD]
PWD]’
export PS1
umask 022
#alias sqlplus=“rlwrap sqlplus”
export TMP=/tmp
export LANG=en_US
export TMPDIR=
T
M
P
O
R
A
C
L
E
S
I
D
=
+
A
S
M
2
;
e
x
p
o
r
t
O
R
A
C
L
E
S
I
D
O
R
A
C
L
E
T
E
R
M
=
x
t
e
r
m
;
e
x
p
o
r
t
O
R
A
C
L
E
T
E
R
M
O
R
A
C
L
E
B
A
S
E
=
/
o
p
t
/
g
r
i
d
;
e
x
p
o
r
t
O
R
A
C
L
E
B
A
S
E
O
R
A
C
L
E
H
O
M
E
=
/
o
p
t
/
19.3.0
/
g
r
i
d
;
e
x
p
o
r
t
O
R
A
C
L
E
H
O
M
E
N
L
S
D
A
T
E
F
O
R
M
A
T
=
"
y
y
y
y
−
m
m
−
d
d
H
H
24
:
M
I
:
S
S
"
;
e
x
p
o
r
t
N
L
S
D
A
T
E
F
O
R
M
A
T
P
A
T
H
=
.
:
TMP ORACLE_SID=+ASM2; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM ORACLE_BASE=/opt/grid; export ORACLE_BASE ORACLE_HOME=/opt/19.3.0/grid; export ORACLE_HOME NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT PATH=.:
TMPORACLESID=+ASM2;exportORACLESIDORACLETERM=xterm;exportORACLETERMORACLEBASE=/opt/grid;exportORACLEBASEORACLEHOME=/opt/19.3.0/grid;exportORACLEHOMENLSDATEFORMAT="yyyy−mm−ddHH24:MI:SS";exportNLSDATEFORMATPATH=.:PATH:
H
O
M
E
/
b
i
n
:
HOME/bin:
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
su - oracle
PS1="[whoami@hostname:"’
P
W
D
]
PWD]
PWD]’
#alias sqlplus=“rlwrap sqlplus”
#alias rman=“rlwrap rman”
export PS1
export TMP=/tmp
export LANG=en_US
export TMPDIR=
T
M
P
e
x
p
o
r
t
O
R
A
C
L
E
U
N
Q
N
A
M
E
=
O
R
A
C
L
E
B
A
S
E
=
/
o
p
t
/
o
r
a
c
l
e
;
e
x
p
o
r
t
O
R
A
C
L
E
B
A
S
E
O
R
A
C
L
E
H
O
M
E
=
TMP export ORACLE_UNQNAME= ORACLE_BASE=/opt/oracle; export ORACLE_BASE ORACLE_HOME=
TMPexportORACLEUNQNAME=ORACLEBASE=/opt/oracle;exportORACLEBASEORACLEHOME=ORACLE_BASE/product/19.3.0/db_1; export ORACLE_HOME
ORACLE_SID=opt; 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=.:
P
A
T
H
:
PATH:
PATH:HOME/bin:
O
R
A
C
L
E
B
A
S
E
/
p
r
o
d
u
c
t
/
l
9.3.0
/
d
b
1
/
b
i
n
:
ORACLE_BASE/product/l9.3.0/db_1/bin:
ORACLEBASE/product/l9.3.0/db1/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
#IP SAN模式
#mount /dev/cdrom /mnt
#rpm -ivh /mnt/Packages/iscsi-initiator-utils-6.2.0.874-10.el7.x86_64.rpm
#cat /etc/iscsi/initiatorname.iscsi
##查看本地iscsi名字
#echo “options=–whitelisted --replace-whitespace” > /etc/scsi_id.config
##获取wwid脚本写入文件
#systemctl enable iscsi
#systemctl start iscsi
#iscsiadm -m discovery -t st -p 192.168.0.136
#iscsiadm -m discovery -t st -p 192.168.0.137
#iscsiadm -m discovery -t st -p 192.168.0.138
#iscsiadm -m discovery -t st -p 192.168.0.139
#iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.0.136-erpdb -p 192.168.0.136:3260 -l
#iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.0.136-erpdb -p 192.168.0.137:3260 -l
#iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.0.136-erpdb -p 192.168.0.138:3260 -l
#iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.0.136-erpdb -p 192.168.0.139:3260 -l
#iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.0.139-fgerpbackup -p 192.168.0.136:3260 -l
#iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.0.139-fgerpbackup -p 192.168.0.137:3260 -l
#iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.0.139-fgerpbackup -p 192.168.0.138:3260 -l
#iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:192.168.0.139-fgerpbackup -p 192.168.0.139:3260 -l
#tail -200f /var/log/messages
#lsblk
#iscsiadm -m session -P 3
#cd /var/lib/iscsi/nodes/
#ls -1R
FC SAN模式
ls /sys/class/scsi_host/ | while read host ; do echo “- - -” > /sys/class/scsi_host/$host/scan ; done
echo “- - -” /sys/class/scsi_host/host15/scan
echo “- - -” /sys/class/scsi_host/host15/scan
ls -l /dev/disk/by-id
rpm -qa |grep multipath
modprobe dm-multipath
modprobe dm-round-robin
lsmod |grep dm_multipath
systemctl enable multipathd
systemctl start multipathd
multipath -v2
/sbin/mpathconf --enable
echo > /etc/multipath.conf
multipath -v2
multipath -ll |grep policy |wc -l
#iscsiadm -m session -P 3 |grep “Attached”
fdisk -l |grep “751.6 GB”
#DATA1 wwid
360002ac000000000000001bd000239ae
#DATA2 wwid
360002ac000000000000001be000239ae
#DATA3 wwid
360002ac000000000000001bf000239ae
fdisk -l |grep “537.7 GB”
#ARCH1
360002ac000000000000001c0000239ae
#ARCH2
360002ac000000000000001c1000239ae
#ARCH3
360002ac000000000000001c2000239ae
fdisk -l |grep “53.7 GB”
#REDO1
360002ac000000000000001c6000239ae
#REDO2
360002ac000000000000001c7000239ae
fdisk -l |grep “10.7 GB”
#OCR1 wwid
360002ac000000000000001c5000239ae
#OCR2 wwid
360002ac000000000000001c3000239ae
#OCR3 wwid
360002ac000000000000001c4000239ae
ls -l /dev/disk/by-id
vi /etc/multipath.conf
#node1
blacklist {
wwid 3600605b00f1e202025f1d6a73449a859
wwid 3600605b00f1e202025f1d6c836467c60
}
devices {
device {
vendor “3PARdata”
product “VV”
path_grouping_policy “group_by_prio”
path_selector “service-time 0”
path_checker “tur”
features “0”
hardware_handler “1 alua”
prio “alua”
failback immediate
rr_weight “uniform”
no_path_retry 18
fast_io_fail_tmo 10
dev_loss_tmo “infinity”
}
}
multipaths {
multipath {
wwid 360002ac000000000000001bd000239ae
alias 3p_data1
}
multipath {
wwid 360002ac000000000000001be000239ae
alias 3p_data2
}
multipath {
wwid 360002ac000000000000001bf000239ae
alias 3p_data3
}
multipath {
wwid 360002ac000000000000001c0000239ae
alias 3p_arch1
}
multipath {
wwid 360002ac000000000000001c1000239ae
alias 3p_arch2
}
multipath {
wwid 360002ac000000000000001c2000239ae
alias 3p_arch3
}
multipath {
wwid 360002ac000000000000001c6000239ae
alias 3p_redo1
}
multipath {
wwid 360002ac000000000000001c7000239ae
alias 3p_redo2
}
multipath {
wwid 360002ac000000000000001c5000239ae
alias 3p_ocr1
}
multipath {
wwid 360002ac000000000000001c3000239ae
alias 3p_ocr2
}
multipath {
wwid 360002ac000000000000001c4000239ae
alias 3p_ocr3
}
}
#node2
blacklist {
wwid 3600605b00f2789f025f1d6012dbfa47d
wwid 3600605b00f2789f025f1d6182f28f639
}
multipathmul -F
multipath -v2
systemctl start multipathd
multipath -F
multipath -v2
dmsetup ls |grep 3p
3p_redo1 (253:10)
3p_arch3 (253:9)
3p_arch2 (253:8)
3p_arch1 (253:7)
3p_ocr3 (253:13)
3p_ocr2 (253:12)
3p_ocr1 (253:5)
3p_data3 (253:6)
3p_data2 (253:4)
3p_data1 (253:3)
3p_redo2 (253:11)
#asmlib模式（不推荐）
udev方式
for i in 3p_data1 3p_data2 3p_data3 3p_arch1 3p_arch2 3p_arch3 3p_redo1 3p_redo2 3p_ocr1 3p_ocr2 3p_ocr3;
do
printf “%s %s\n” “
i
"
"
i" "
i""(udevadm info --query=all --name=/dev/mapper/$i |grep -i dm_uuid)”;
done
asm-dggrid1 E: DM_UUID=mpath-20f9f6743b424eb10
asm-dggrid2 E: DM_UUID=mpath-22c4528d3ce73fd4b
asm-dggrid3 E: DM_UUID=mpath-28f7a1bfaec71cd9c
asm-dggrid4 E: DM_UUID=mpath-289408d24651f77ca
asm-dggrid5 E: DM_UUID=mpath-2c4c1cfe1261523d2
asm-dggrid6 E: DM_UUID=mpath-25dae279f8e546617
asm-dgsystem01 E: DM_UUID=mpath-286478f79c58e7c5f
asm-dgrecovery01 E: DM_UUID=mpath-26f584938df32c3f3
asm-dgdata01 E: DM_UUID=mpath-2a4f9d5e5f7cb26ff
asm-dgdata02 E: DM_UUID=mpath-2a3dbb7a2fa70523d
7.x
vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL==“dm-",ENV{DM_UUID}“mpath-360002ac000000000000001bd000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-”,ENV{DM_UUID}“mpath-360002ac000000000000001be000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-",ENV{DM_UUID}“mpath-360002ac000000000000001bf000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-",ENV{DM_UUID}“mpath-360002ac000000000000001c0000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-",ENV{DM_UUID}“mpath-360002ac000000000000001c1000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-",ENV{DM_UUID}“mpath-360002ac000000000000001c2000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-",ENV{DM_UUID}“mpath-360002ac000000000000001c6000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-",ENV{DM_UUID}“mpath-360002ac000000000000001c7000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-",ENV{DM_UUID}“mpath-360002ac000000000000001c5000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-",ENV{DM_UUID}“mpath-360002ac000000000000001c3000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-*",ENV{DM_UUID}==“mpath-360002ac000000000000001c4000239ae”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL==“dm-",ENV{DM_UUID}“mpath-2b9827e5cdd775394”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL"dm-”,ENV{DM_UUID}==“mpath-22aa8cbecde11a884”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
6.x/7.x
vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL==“dm-",NAME=“asm-dggrid1”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL=="dm-”,NAME=“asm-dggrid2”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL==“dm-",NAME=“asm-dggrid3”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL=="dm-”,NAME=“asm-dggrid4”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL==“dm-",NAME=“asm-dggrid5”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL=="dm-”,NAME=“asm-dggrid6”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL==“dm-",NAME=“asm-dgsystem”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
KERNEL=="dm-”,NAME=“asm-dgdata”,OWNER=“grid”,GROUP=“asmadmin”,MODE=“0660”
/sbin/udevadm control --reload-rules
/sbin/udevadm trigger --type=devices --action=change
ls -lsa /dev/dm*
##配置SSH互信
开始安装grid软件
(见截图)
打补丁时
root用户
vi ~/.bash_profile
PATH=
P
A
T
H
:
/
o
r
a
c
l
e
/
a
p
p
/
19.3.0
/
g
r
i
d
/
b
i
n
:
PATH:/oracle/app/19.3.0/grid/bin:
PATH:/oracle/app/19.3.0/grid/bin:HOME/bin
source ~/.bash_profile
ASM磁盘组配置:asmca
(见截图)
配置检查
ocrcheck
OCR镜像配置
ocrconfig -add +dggrid2
su - grid
crs_stat -t
crs_stat -p |more
crsctl check crs
查看asm磁盘组
asmcmd
lsdg
监听查看
su - grid
lsnrctl status
监听配置文件存放：/oracle/app/19.3.0/grid/network/admin/endpoints_listener.ora
oracle软件安装
数据库创建注意事项
oracle用户下dbca
3.Admin-Managed
4.EM,
5.实例密码(db用户密码)
6.Storage Type:ASM, redo and control file 多路复用
7.归档和闪回先不开
8.组件选项
9.Memory:Custom 设置SGA,PGA大小(80%x80%,80%x20%法则)
sizing:进程数 2000
Character Sets:字符集 ZHS16GBK
Con Mode:Deri Mode
游标参数设置为和进程数一致(open_cursors)
10.Controlfile:Maximum Datafiles 8192
Tablespaces: SYSAUX,SYSTEM,TEMP,UNDOTBS1,UNDOTBS2 生产环境大小都设置为20G
同时关闭自动扩展,USERS设置为5G
实验环境:650M 650M 200M ,users 100M
Redo log groups: 6-10组,每组200M-2G
11.保存模板,脚本保存,路径选择
查看crsctl status res -t
1154
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
