AnolisOS-8.6安装EM13C&Agent部署&EM常用命令&集群数据库添加

系统：AnolisOS 8.6
数据库：Oracle 19.16
说明：此安装文档选择的是Advanced Installaioin，内存要求10G.安装EM前需了解相关参数要求.

1、安装数据库
1.1、去除虚拟嵌套虚拟机功能
yum remove libvirt-libs
1.2、关闭防火墙
systemctl stop firewalld
systemctl disable firewalld
1.3、修改selinux参数
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
1.4、修改/etc/hosts文件
# vi /etc/hosts
添加如下：
192.168.133.196 liujun.sztech.com liujun  (说明：后面创建EM需要使用fully qualified domain name)
1.5、建立用户&组&目录
groupadd dba
groupadd oper
groupadd oinstall
useradd -g oinstall -G dba,oper oracle
echo "oracle_4U"|passwd --stdin oracle
mkdir -p /u01/app/oracle/product/19.16.0/db_1
1.6、权限设置
chown -R oracle:oinstall /u01/app
chmod -R 775 /u01/app
ls -ltr -R /u01/app  #查看各级权限
1.7、上传介质
mkdir -p /u01/setup/db
sftp> cd /u01/setup/db
sftp> lcd F:\installmedium\19c
sftp> put LINUX.X64_1916_db_home.zip
mkdir -p /u01/setup/em13c
sftp> cd /u01/setup/em13c
sftp> lcd F:\installmedium\em13c
sftp> put em13*
说明：
LINUX.X64_1916_db_home.zip 放/u01/setup/db

em13500_linux64-2.zip
em13500_linux64-3.zip
em13500_linux64-4.zip
em13500_linux64-5.zip
em13500_linux64.bin   放/u01/setup/em13c
#查看解压文件
unzip -l LINUX.X64_1916_db_home.zip
1.8、设置oracle环境变量
su - oracle
$ cat <<EOF>>.bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/19.16.0/db_1
export ORACLE_SID=emrep
export PATH=\$ORACLE_HOME/bin:\$PATH
EOF

$ source .bash_profile
env  #认一次
env | grep ORACLE_  #check
1.9、配Yum源
# mount /dev/sr0 /mnt
[root@liujun ~]# cd /etc/yum.repos.d
[root@liujun yum.repos.d]# mkdir bak
[root@liujun yum.repos.d]# mv *.repo bak
[root@liujun yum.repos.d]# vi AnolisOS.repo
添加如下内容：
[AppStream]
name=AnolisOS-AppStream
baseurl=file:///mnt/AppStream/
enabled=1
gpgcheck=0

[BaseOS]
name=AnolisOS-BaseOS
baseurl=file:///mnt/BaseOS/
enabled=1
gpgcheck=0

[root@liujun yum.repos.d]# yum makecache
1.10、安装包
# yum -y install bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make policycoreutils policycoreutils-python-utils smartmontools sysstat nfs-utils gcc iotop
检查安装包情况
# rpm -q bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make policycoreutils policycoreutils-python-utils smartmontools sysstat nfs-utils gcc iotop | grep "not installed"

sftp> lcd F:\package
sftp> put glibc-devel-2.17-317.el7.i686.rpm
[root@liujun ~]# rpm -ivh glibc-devel-2.17-317.el7.i686.rpm --nodeps --force

1.11、修改内核参数
# cat <<EOF>>/etc/sysctl.conf
kernel.shmmax = 8589934591
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
fs.file-max = 6815744

kernel.shmall = 2097152
net.ipv4.ip_local_port_range = 11000 65000
net.ipv4.tcp_tw_reuse = 1
net.core.somaxconn = 262144
net.ipv4.tcp_max_orphans = 262144
net.ipv4.tcp_max_syn_backlog = 262144
net.ipv4.tcp_synack_retries = 2
net.ipv4.tcp_syn_retries = 1
net.ipv4.tcp_fin_timeout = 1
net.ipv4.tcp_keepalive_time = 30
net.ipv4.tcp_keepalive_probes = 6
net.ipv4.tcp_keepalive_intvl = 5
net.ipv4.tcp_timestamps = 0
fs.aio-max-nr = 1048576
EOF

# /sbin/sysctl -p
2、安装DB软件
[oracle@liujun db_1]$ unzip -q LINUX.X64_1916_db_home.zip -d $ORACLE_HOME
[oracle@liujun db_1]$ export DISPLAY=192.168.133.1:0.0
[oracle@liujun db_1]$ nm-connection-editor #测试是否能调出图形界面
[oracle@liujun db_1]$ pwd
/u01/app/oracle/product/19.16.0/db_1
[oracle@liujun db_1]$ ./runInstaller

点击“Yes”

# watch df –h 实时查看磁盘变化
3、创建DB实例
[oracle@liujun db_1]$ dbca 
注意：此次oracle 19.16实例安装过程中有同时安装监听的选项，可以不用提前安装监听.

注意：此时可点击创建监听.