Oracle Linux 8.4
Oracle Client 19.8
WinCC OA 3.17
安装指南
1 准备情况
1.1 准备软件
· Oracle Linux 8.4 - Oracle 官网下载
· WinCC OA 3.17 p015 REHL-Linux
· LINUX.X64_193000_client.zip / LINUX.X64_193000_client_home.zip
- p6880880_190000_Linux-x86-64.zip
- p31281355_190000_Linux-x86-64.zip
- p28933630_198000DBRU_Linux-x86-64.zip
1.2 工具软件
WinSCP – 管理oracle的文件(sftp)
putty – 指令终端
vncviewer64-1.11.0.exe – 远程桌面环境
2 安装Linux准备
2.1 分配空间
用户路径/home 大小:70%
根路径/ 大小:25%
swap大小:10G
时区:Asia/Shanghai
安装模式:Server with GUI
3 设置Linux的运行环境
3.1 光盘ISO镜像/ 本地源
mkdir /media/cdrom
mount /dev/cdrom /media/cdrom
mkdir /etc/yum.repos.d/bak
mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/bak
vim /etc/yum.repos.d/cdrom.repo
[InstallMedia-BaseOS]
name=BaseOS
metadata_expire=-1
gpgcheck=0
enabled=1
baseurl=file:///media/cdrom/BaseOS/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
[InstallMedia-AppStream]
name= AppStream
metadata_expire=-1
gpgcheck=0
enabled=1
baseurl=file:///media/cdrom/AppStream/
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
chmod 644 /etc/yum.repos.d/cdrom.repo
dnf clean all
dnf makecache
dnf repolist
3.2 安装TigerVNC服务器
yum -y install tigervnc-server tigervnc
echo ':1=root' >> /etc/tigervnc/vncserver.users
echo ':2=admin' >> /etc/tigervnc/vncserver.users
cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@:1.service
cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@:2.service
firewall-cmd --permanent --zone=public --add-port 5901/tcp
firewall-cmd --permanent --zone=public --add-port 5902/tcp
firewall-cmd --reload
//给用户设置远程访问的密码
su – root
vncpasswd
su – admin
vncpasswd
systemctl enable vncserver@:1.service
systemctl start vncserver@:1.service
systemctl enable vncserver@:2.service
systemctl start vncserver@:2.service
systemctl status vncserver@:1.service
systemctl status vncserver@:2.service
ss -atp | grep 5901
ss -atp | grep 5902
reboot
3.3 加载新硬盘
df –h
fdisk –l
找到裸盘的盘符 /dev/sdb
小于2T:
fdisk /dev/sdb
大于2T:
parted /dev/sdb
mklabel gpt
mkpart ext4 0% 100%
quit
[可选]
mkfs.ext4 /dev/sdb1
mkdir /s01
mount /dev/sdb1 /s01
df –h
vim /etc/fstab
/dev/sdb1 /s01 ext4 defaults 0 0
3.4 设置环境变量
vim /etc/profile.d/oracle.sh
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=${ORACLE_BASE}/product/19.8/client_1
export ORACLE_SID=orcl
export TNS_ADMIN=${ORACLE_HOME}/network/admin
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/local/lib:/usr/lib:/opt/WinCC_OA/3.17/bin:${ORACLE_HOME}/lib
export PATH=$PATH:/opt/WinCC_OA/3.17/bin:${ORACLE_HOME}/bin:${ORACLE_HOME}/OPatch
export NLS_LANG=AMERICAN_AMERICA.UTF8
export CV_ASSUME_DISTID=OEL7
#export LC_ALL=zh_CN.utf8
umask 022
source /etc/profile.d/oracle.sh
3.5 添加组与文件目录
groupadd -g 54321 oinstall
groupadd -g 54322 dba
usermod -a -G oinstall,dba,root admin
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oraInventory
chown -R admin:oinstall /u01/app/oraInventory
mkdir -p /u01/app/oracle
chown -R admin:oinstall /u01/app/oracle
chmod -R 775 /u01
3.6 NTP对时(客户端)
dnf install chrony –y
systemctl start chronyd.service
systemctl status chronyd.service
vim /etc/chrony.conf
添加
pool ntp.aliyun.com iburst
systemctl restart chronyd.service
chronyc sources
===============================================
^* 203.107.6.88 2 6 17 14 -27us[ -460us] +
3.7 安装WinCC OA
unzip WinCC_OA_3.18_linux_rhel_x86_64_P006.zip -d winccoa
dnf install CodeMeter-7.30.4820-501.x86_64.rpm WinCCOA-3.18.6-Base-rhel.x86_64.rpm WinCCOA-3.18.6-Help-EN-rhel.x86_64.rpm WinCCOA-3.18.6-OracleLibs-rhel.x86_64.rpm WinCCOA-3.18.6-SpecialFunctions-rhel.x86_64.rpm WinCCOA-3.18.6-SqlDrivers-rhel.x86_64.rpm WinCCOA-3.18.6-API-rhel.x86_64.rpm
3.8 安装Oracle Linux 19客户端
mkdir /u01/app/oracle/product/
mkdir /u01/app/oracle/product/19.8/
mkdir /u01/app/oracle/product/19.8/client_1
unzip LINUX.X64_193000_client_home.zip -d /u01/app/oracle/product/19.8/client_1
cd $ORACLE_HOME
ll
libnsl.so.1 不存在
dnf install libnsl
预原装包
dnf search oracle-database-preinstall-19c.x86_64
dnf install oracle-database-preinstall-19c.x86_64
继续执行安装
./runInstaller
用root账号执行/u01/app/oraInventory/orainstRoot.sh
/u01/app/oraInventory/orainstRoot.sh
3.9 卸载Orcale Client(失败后)
cd $ORACLE_HOME
cd deinstall
./deinstall
3.10 编辑/etc/hosts
vim /etc/hosts
192.168.0.109 oraclesvr
4 补丁包
4.1 p6880880_190000_Linux-x86-64.zip:
在windows系统解压后,上传到$ORACLE_HOME/OPatch这个文件夹下(替换OPatch),WinSCP里面修改文件夹全部文件权限为“可执行”。
4.2 p31281355_190000_Linux.zip:
unzip p31281355_190000_Linux-x86-64.zip -d p31281355
cd p31281355
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
opatch apply
4.3 p28933630_198000DBRU_Linux:
在windows系统解压后,上传到$ORACLE_HOME/lib文件夹,
cd /opt/WinCC_OA/3.17/bin
ln -s $ORACLE_HOME/lib/libocci_gcc53.so.19.1
ln -s $ORACLE_HOME/lib/libclntsh.so.19.1
5 配置oracle 客户端
netmgr
服务名称(可以用tnsping 查询连接的tns名称)。
TCP连接。
测试连接成功。
最后需要点击file-》save
6 配置WinCC OA
config文件的典型配置:
[general]
pvss_path = "/opt/WinCC_OA/3.17"
proj_path = "/home/admin/WinCC_OA_Proj/RDB_TEST"
proj_version = "3.17"
langs = "en_US.utf8"
langs = "zh_CN.utf8"
#lang = "zh_CN.utf8"
useRDBArchive = 1
useRDBGroups = 1
pmonPort = 4999
[data]
[ValueArchiveRDB]
DbUser = "CR_RDB"
Db = "orcl"
oracleClientVersion = 19
[ui]
queryRDBdirect = 1
CtrlDLL = "CtrlRDBArchive"
CtrlDLL = "CtrlRDBCompr"
[ctrl]
queryRDBdirect = 1
CtrlDLL = "CtrlRDBArchive"
CtrlDLL = "CtrlRDBCompr"
首次登录不启动RDB Manager。设置为手动启动。
进入GEDI后,输入账号的密码
然后,设置RDB Manager 为自动启动。
重启项目。