Oracle 10G RAC集群安装

时间:2022-02-07 14:55:33

一,基本环境配置

  01,hosts

 cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.0.240 SHLPDBWX01
192.168.0.241 SHLPDBWX02
172.168.0.240 SHLPDBWX01-priv
172.168.0.241 SHLPDBWX02-priv
192.168.0.243 SHLPDBWX01-vip
192.168.0.244 SHLPDBWX02-vip
192.168.0.242 dgwxpdb dgwxpdb.localdomain

  02,用户环境配置

groupadd –g 501 oinstall
useradd oracle –u 500 –g oinstall

echo 123456|passwd --stdin oracle

  03,配置目录

cat .bash_profile

PATH=$PATH:$HOME/bin
ORACLE_BASE=/u01/app/oracle
export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=WXPDB01
export PATH=$PATH:$ORA_CRS_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:.
alias sqlplus='rlwrap sqlplus' # oracle sqlpls
alias rman='rlwrap rman' # oracle rman
alias ggsci='rlwrap ggsci' # oracle goldengate
stty erase ^h
export PATH


创建目录授予权限

mkdir /u01/app/oracle/product/10.2.0/db_1 -p
chown -R oracle.oinstall /u01/
chmod -R 755 /u01/

  04,磁盘配置

见https://www.cnblogs.com/kingle-study/p/10972214.html

  05,配置参数

vi /etc/sysctl.conf

kernel.core_uses_pid = 1
fs.file-max = 65536
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
kernel.shmmni = 4096
kernel.sem = 500 64000 100 128
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_tw_recycle = 1
vi /etc/security/limits.conf
oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536

  06,安装包检测

检测
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils \
compat-libstdc++ \
elfutils-libelf-devel \
elfutils-libelf-devel-static \
gcc \
gcc-c++ \
glibc \
glibc-common \
glibc-devel \
glibc-headers \
kernel-headers \
ksh \
libaio \
libaio-devel \
libgcc \
libgomp \
libstdc++ \
libstdc++-devel \
make \
sysstat \
unixODBC \
unixODBC-devel \
libXp


缺少的对应安装 10C的包可能有的需要i686
通过RPm包安装

  07,配置互信

[oracle@SHLPDBWX01 ~]$ mkdir ~/.ssh
mkdir: cannot create directory `/home/oracle/.ssh': File exists
[oracle@SHLPDBWX01 ~]$  chmod 700 ~/.ssh
[oracle@SHLPDBWX01 ~]$ cd .ssh/

下面这命令双截点操作(就下面一条)
[oracle@SHLPDBWX01 .ssh]$ ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/home/oracle/.ssh/id_rsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /home/oracle/.ssh/id_rsa. Your public key has been saved in /home/oracle/.ssh/id_rsa.pub. The key fingerprint is: b1:17:b3:dd:7b:43:8b:8b:7c:06:22:58:c0:29:aa:0a oracle@SHLPDBWX01 The key
's randomart image is: +--[ RSA 2048]----+ | . . | | . + | | . . . . o | | . . o = . | |. o S o . .. | |E . . o . o..| |o . . ...o.| |. . .o...| | oo. | +-----------------+
[oracle@SHLPDBWX01 .ssh]$ ssh SHLPDBWX01 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys The authenticity of host 'shlpdbwx01 (192.168.0.240)' can't be established. RSA key fingerprint is 11:46:62:ee:23:09:da:62:5f:ae:92:ee:19:6e:0c:4a. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'shlpdbwx01,192.168.0.240' (RSA) to the list of known hosts. oracle@shlpdbwx01's password: [oracle@SHLPDBWX01 .ssh]$ ssh SHLPDBWX02 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys The authenticity of host 'shlpdbwx02 (192.168.0.241)' can't be established. RSA key fingerprint is 11:46:62:ee:23:09:da:62:5f:ae:92:ee:19:6e:0c:4a. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'shlpdbwx02,192.168.0.241' (RSA) to the list of known hosts. oracle@shlpdbwx02's password: [oracle@SHLPDBWX01 .ssh]$ chmod 600 ~/.ssh/authorized_keys [oracle@SHLPDBWX01 .ssh]$ scp authorized_key SHLPDBWX02:/home/oracle/.ssh/ oracle@shlpdbwx02's password: authorized_key: No such file or directory [oracle@SHLPDBWX01 .ssh]$ scp authorized_keys SHLPDBWX02:/home/oracle/.ssh/ oracle@shlpdbwx02's password: authorized_keys 100% 798 0.8KB/s 00:00 [oracle@SHLPDBWX01 .ssh]$ ssh SHLPDBWX01 date Wed Jun 5 16:36:06 CST 2019 [oracle@SHLPDBWX01 .ssh]$ ssh SHLPDBWX02 date Wed Jun 5 16:36:09 CST 2019