Redhat 7.5 环境下Oracle12.2.0.1客户端安装及WinCC OA配置
1 安装Oracle Client
1.1 分别输入指令,检查当前软件环境
echo $SHELL
cat /etc/*-release
cat /proc/version
uname -a
umask
echo 192.168.8.117 vm >> /etc/hosts
echo 192.168.232.149 redhat75 >> /etc/hosts
1.2 Swap分区设置
1.2.1 安装Linux过程设置swap分区不用默认大小,应设置至少4G。其他分区可以用系统分配的大小。
1.2.2 设置swap分区大小
free –m
//----
[root@redhat75 ~]# free –m
total used free shared buff/cache available
Mem: 3863568 1278556 2038148 14132 546864 2280896
Swap: 3145724 0 3145724
//----
// Swap Total小于4G都要进行扩充:
dd if=/dev/zero of=/home/swap bs=4096 count=512000
swapoff –a
/sbin/mkswap /home/swap
/sbin/swapon /home/swap
swapon –a
free –m
// --
[root@redhat75 ~]# free -m
total used free shared buff/cache available
Mem: 3773 1252 156 13 2364 2194
Swap: 5071 0 5071
// --
vim /etc/fstab
/home/swap swap swap 0 0
1.3 挂载ISO光盘
mkdir /media/cdrom
mount -o loop -t iso9660 /s01/Redhat7.5/rhel-server-7.5-x86_64-dvd.iso /media/cdrom
1.4 yum环境
1.4.1 使用iso或DVD建立本地repo源
mkdir /etc/yum.repos.d/bak
mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/bak
vim /etc/yum.repos.d/cdrom.repo
1.4.2 填写cdrom.repo:
[cdrom]
name=cdrom
baseurl=file:///media/cdrom
gpgcheck=0
enabled=1
1.4.3 执行更新yum
yum clean all
yum makecache
yum repolist
1.5 关闭防火墙
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
cat /etc/selinux/config | grep 'SELINUX=disabled'
setenforce 0
systemctl stop firewalld
systemctl disable firewalld
systemctl status firewalld
getenforce
1.6 依赖包
有repo源,就可以安装Redhat 7.5 光盘的依赖包:
· compat-libcap1-1.10-7.el7.x86_64.rpm
· gcc-c++-4.8.5-28.0.1.el7.x86_64.rpm
· ksh-20120801-137.0.1.el7.x86_64.rpm
· libaio-devel-0.3.109-13.el7.x86_64.rpm
· libstdc++-devel-4.8.5-28.0.1.el7.x86_64.rpm
yum install compat-libcap1 gcc-c++ ksh.x86_64 libaio-devel libstdc++-devel
1.7 删除Redhat自带的虚拟网卡-可选
yum remove libvirt-*
1.8 oracle用户组
groupadd -g 54321 oinstall
cat /etc/group | grep oinstall
groupadd -g 54322 dba
cat /etc/group | grep dba
usermod -G oinstall,dba,root leee
测试:
id leee
uid=1000(leee) gid=1000(leee) groups=1000(leee),54321(oinstall),54322(dba)
1.9 设置环境变量
建议设置到vim /etc/profile.d/xxx.sh,全部用户生效
vim /etc/profile.d/oracle.sh
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=${ORACLE_BASE}/product/12.2.0/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.16/bin:${ORACLE_HOME}/lib
export PATH=$PATH:/opt/WinCC_OA/3.16/bin:${ORACLE_HOME}/bin
export NLS_LANG=AMERICAN_AMERICA.UTF8
umask 022
1.9.1 注销后执行
export | grep ORACLE_BASE
export | grep ORACLE_SID
export | grep ORACLE_HOME
export | grep LD_LIBRARY_PATH
export | grep 12.2.0
1.1 搭建VNC Server
yum install tigervnc-server
su - leee
vncpasswd
cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@\:1.service
cp /etc/systemd/system/vncserver@\:1.service /etc/systemd/system/vncserver@\:2.service
cp /etc/systemd/system/vncserver@\:1.service /etc/systemd/system/vncserver@\:3.service
sed -i 's/<USER>/leee/' /etc/systemd/system/vncserver@\:1.service
sed -i 's/<USER>/leee/' /etc/systemd/system/vncserver@\:2.service
sed -i 's/<USER>/leee/' /etc/systemd/system/vncserver@\:3.service
systemctl start vncserver@\:1.service
systemctl start vncserver@\:2.service
systemctl start vncserver@\:3.service
systemctl enable vncserver@\:1.service
systemctl enable vncserver@\:2.service
systemctl enable vncserver@\:3.service
退出时直接关闭vnc viewer,千万不要注销(logout)!否则,用root执行:
systemctl restart vncserver@\:1.service
1.1 安装Oracle 12.2.0.1 Client
使用leee用户登录Linux 桌面。
su - leee
./runInstaller
1.2 配置Oracle 本地net服务名配置
使用oracle用户登录Linux 桌面。
先执行
netca
依次配置:Naming Methods Configuration > Select Naming Methods : Local Name + Easy Connect Naming > Save
再执行
netmgr
配置:
Local Service Nameing : orcl_conn
Service Identification Service Name: orcl
Connection Type : Dedicated Server
Address 1 Protocol: TCP
Host Name: vm
Port Number:1521
保存
测试:
tnsping orcl_conn
sqlplus PVSSRDB/Oracle2019@orcl_conn
2 安装WinCC OA
下载依赖包 http://www.winccoa.top/dependency_redhat7_316
安装顺序:
SDL-1.2.15-14.el7.x86_64.rpm
freetype-2.8-14.el7.x86_64.rpm
minizip-1.2.7-18.el7.x86_64.rpm
zlib-1.2.7-18.el7.x86_64.rpm
!注意下面安装的版本号!
yum install SDL-1.2.15-14.el7.x86_64.rpm freetype-2.8-14.el7.x86_64.rpm minizip-1.2.7-18.el7.x86_64.rpm zlib-1.2.7-18.el7.x86_64.rpm
yum install WinCC_OA_3.16-base-rhel-0-16.x86_64.rpm WinCC_OA_3.16-rdb-oracle-libs12-rhel-0-16.x86_64.rpm
其他WinCC OA的安装包视情况而安装。
WinCC_OA_3.16-XXX
3 配置WinCC OA
3.1 config文件配置:
config文件的Db属性应为TNS Name,可以用tnsping通的字符串。
[general]
useRDBArchive = 1
useRDBGroups = 1
[ValueArchiveRDB]
DbUser = "PVSSRDB"
Db = "orcl_conn"
oracleClientVersion = 12
[ui]
queryRDBdirect = 1
CtrlDLL = "CtrlRDBArchive"
CtrlDLL = "CtrlRDBCompr"
[ctrl]
queryRDBdirect = 1
CtrlDLL = "CtrlRDBArchive"
CtrlDLL = "CtrlRDBCompr"
3.2 配置过程:
新建RDBManager -num = 99, 位于Database Manager之后
首次启动为manual,进入Gedi- System Managerment – RDB Archive Manager – Config – password 输入密码
再次关闭项目,设置RDBManager 为automatic启动模式,启动整个项目。
3.3 无法启动RDBManager,找不到libocci.so.12.1
新建文件夹
/home/leee/WinCC_OA_Proj/supportLibs/
将/u01/app/oracle/product/12.2.0/client_1/lib/的下面列的文件拷贝到/home/leee/WinCC_OA_Proj/supportLibs/文件夹里面来:
libclntsh.so.12.1
libclntshcore.so.12.1
libipc1.so
libmql1.so
libnnz12.so
libocci.so.12.1
libons.so
cp /u01/app/oracle/product/12.2.0/client_1/lib/libclntsh.so.12.1 /home/leee/WinCC_OA_Proj/supportLibs
cp /u01/app/oracle/product/12.2.0/client_1/lib/libclntshcore.so.12.1 /home/leee/WinCC_OA_Proj/supportLibs
cp /u01/app/oracle/product/12.2.0/client_1/lib/libipc1.so /home/leee/WinCC_OA_Proj/supportLibs
cp /u01/app/oracle/product/12.2.0/client_1/lib/libmql1.so /home/leee/WinCC_OA_Proj/supportLibs
cp /u01/app/oracle/product/12.2.0/client_1/lib/libnnz12.so /home/leee/WinCC_OA_Proj/supportLibs
cp /u01/app/oracle/product/12.2.0/client_1/lib/libocci.so.12.1 /home/leee/WinCC_OA_Proj/supportLibs
cp /u01/app/oracle/product/12.2.0/client_1/lib/libons.so /home/leee/WinCC_OA_Proj/supportLibs
在/etc/ld.so.conf 添加
/home/leee/WinCC_OA_Proj/supportLibs
echo /home/leee/WinCC_OA_Proj/supportLibs >> /etc/ld.so.conf
cat /etc/ld.so.conf
重启或者:
使用root用户执行
ldconfig
指令ldconfig –p | grep 12.1 查看是否把上述3个文件已经调入到了系统。
启动WinCC OA项目。
3.4 Oracle 账号锁定
使用SQLPLUS,用管理员SYSTEM登陆,解锁账号:
SQL> alter user test account unlock;
3.5 修改Oracle 账号有效期
alter profile default limit password_life_time unlimited;