在虚拟机上做安装练习，重点参考官方文档，但官方文档中也有些错误
操作系统版本 CentOS 6.5
RUEI 版本 13.2.3.1
ORACLE版本 11.2.0.4
前提：
700G空间 16G内存
网卡静态IP地址
配置NTP服务
开始
df -h
system-config-network
配置网络
cd /etc/sysconfig/network-scripts
cat ifcfg-eth0
主要的两个属性
BOOTPROTO=none
ONBOOT=yes
网卡混杂模式设置
ifconfig eth1 promisc 设置网卡为混杂模式
ifconfig eth1 -promisc 取消混杂模式
chkconfig ntpd on
service ntpd start
ntpq -pn
date
Sun Sep 30 12:34:53 CST 2018
\cp -f /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
sed -i "s/HOSTNAME=localhost.localdomain/HOSTNAME=rueiserver/" /etc/sysconfig/network
hostname rueiserver
echo "192.168.146.134 rueiserver">>/etc/hosts
sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/config
setenforce 0
chkconfig iptables off
service iptables stop
rename .repo .bak /etc/yum.repos.d/*.repo
vi /etc/yum.repos.d/public-yum-cl6.repo
[centos6_local]
name = CentOS Linux 6.5
baseurl=file:///media/CentOS_6.5_Final
gpgcheck=0
enabled=1
yum -y install perl-URI
yum -y install perl-XML-Twig
yum -y install net-snmp-utils
yum -y install sendmail-cf
yum -y install httpd
yum -y install mod_ssl
yum -y install php
yum -y install php-ldap
yum -y install php-soap
yum -y install librsvg2
yum -y install xorg-x11-xinit
yum -y install rsync
yum -y install ksh
yum -y install *-fonts
yum -y install wget
yum -y install bc
yum -y install bind-utils
yum -y install hdparm
yum -y install libpcap
yum -y install bridge-utils
yum -y install ncurses
yum -y install zlib
dvd2光盘中单独解压 php-process-5.3.3-26.el6.x86_64.rpm
rpm -Uvh /tmp/php-process-5.3.3-26.el6.x86_64.rpm
ln -s /usr/lib64/libpcap.so.1.4.0 /usr/lib64/libpcap.so.0.9.4
下面的应该都已经装好了
yum -y install binutils compat-libstdc++-33 compat-libstdc++-33.i686 \
elfutils-libelf elfutils-libelf-devel gcc gcc-c++ \
glibc glibc.i686 glibc-common glibc-devel glibc-devel.i686 \
glibc-headers ksh libaio libaio.i686 libaio-devel libaio-devel.i686 \
libgcc libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel make \
sysstat unixODBC unixODBC-devel
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
mkdir /u01
chown oracle:oinstall /u01
passwd oracle
umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=ux
export PATH=.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jdk/bin:$PATH
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
vi /etc/sysctl.conf
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
sysctl -p
vi /etc/security/limits.conf
oracle
soft nproc 2047
oracle
hard nproc 16384
oracle
soft nofile 1024
oracle
hard nofile 65536
oracle
soft stack 10240
vi /etc/pam.d/login
session required /lib/security/pam_limits.so
session required pam_limits.so
vi /etc/centos-release
Red Hat Enterprise Linux AS release 6.5
dbsoft.rsp
ruei_database.dbt
dbsoft.rar
ruei_database.rar
unzip -q p13390677_112040_Linux-x86-64_1of7.zip
unzip -q p13390677_112040_Linux-x86-64_2of7.zip
安装软件需要15分钟，此刻为尿点
./runInstaller -silent -force -noconfig -responseFile /home/oracle/dbsoft.rsp -ignorePrereq
以root用户执行以下脚本:
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/oracle/product/11.2.0/dbhome_1/root.sh
netca -silent -responsefile /home/oracle/database/response/netca.rsp
建库需要1.5小时，可以休息会
dbca -silent -createDatabase -gdbName ux -sid ux -sysPassword abcd_2305 -systemPassword
abcd_2306 \
-characterSet AL32UTF8 -templateName /home/oracle/ruei_database.dbt -databaseType DATA_WAREHOUSING \
-redoLogFileSize 500 -initParams recyclebin=off -initParams audit_trail=none
vi /etc/oratab
ux:/u01/app/oracle/product/11.2.0/dbhome_1:Y
ruyi的安装介质
V971222-01.zip
groupadd moniforce
useradd moniforce -g moniforce -d /var/opt/ruei
chmod -R 750 /var/opt/ruei
chown -R moniforce:moniforce /var/opt/ruei
cp /root/RUEI/extra/ruei.conf /etc/
chmod 644 /etc/ruei.conf
chown moniforce:moniforce /etc/ruei.conf
mkdir /opt/ruei
chown moniforce:moniforce /opt/ruei
vi /etc/ruei.conf
export RUEI_HOME=/opt/ruei
export RUEI_DATA=/var/opt/ruei
export RUEI_USER=moniforce
export RUEI_GROUP=moniforce
export RUEI_DB_INST=ux
export RUEI_DB_TSCONF=UXCONF
export RUEI_DB_TSSTAT=UXSTAT
export RUEI_DB_USER=UXINSIGHT
export RUEI_DB_TNSNAME=uxinsight
export RUEI_DB_TNSNAME_CFG=$RUEI_DB_TNSNAME
export RUEI_DB_TNSNAME_BI=$RUEI_DB_TNSNAME
mkdir -p /usr/java/
chmod 755 /usr/java
cd /usr/java
tar xzf /root/RUEI/Java/jre-8u144-linux-x64.tar.gz
ln -s /usr/java/jre1.8.0_144 /usr/java/jre
chkconfig httpd on
vi /etc/php.d/ruei.ini
session.gc_maxlifetime = 14400
memory_limit = 192M
upload_max_filesize = 128M
post_max_size = 128M
mkdir -p /var/www/.gnome2
sed -i -e 's/^Listen 80/#Listen 80/' /etc/httpd/conf/httpd.conf
sed -i -e 's/^SSLProtocol all -SSLv2/SSLProtocol all -SSLv2 -SSLv3/' /etc/httpd/conf.d/ssl.conf
cd /root/RUEI/IC
rpm -Uhv oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
rpm -Uhv oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
cd /root/RUEI/PHP/OL6
rpm -Uhv php-oci8-12cR1-5.3.3-29.el6_5.x86_64.rpm
cd /root/RUEI/ZendGuardLoader
tar xvf ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz
cp ZendGuardLoader-php-5.3-linux-glibc23-x86_64/php-5.3.x/ZendGuardLoader.so /usr/lib64/php/modules/
chown root:root /usr/lib64/php/modules/ZendGuardLoader.so
chmod 755 /usr/lib64/php/modules/ZendGuardLoader.so
添加到/etc/php.d/ruei.ini
zend_extension=/usr/lib64/php/modules/ZendGuardLoader.so
zend_loader.enable=1
zend.enable_gc = Off
cd /usr/local
tar xzf /root/RUEI/mkstore/mkstore-11.2.0.4.0.tar.gz
ln -s /usr/local/mkstore-11.2.0.4.0 /usr/local/mkstore
修改 /etc/ruei.conf:
export MKSTORE_BIN=/usr/local/mkstore/mkstore
cd /root/RUEI/132
cp -r ruei-check.sh ruei-prepare-db.sh sql_scripts /home/oracle/
chown -R oracle:oinstall /home/oracle/ruei* /home/oracle/sql_scripts
chmod +x /home/oracle/ruei-prepare-db.sh
chmod +x /home/oracle/ruei-check.sh
chmod +x /home/oracle/sql_scripts
以oracle执行
./ruei-prepare-db.sh create
或
alter tablespace USERS default compress;
create tablespace UXCONF datafile 'uxconf01.dbf' size 5M reuse autoextend on default compress;
create tablespace UXSTAT datafile 'uxstat01.dbf' size 5M reuse autoextend on default compress;
create tablespace UXTEMP datafile 'uxtemp01.dbf' size 5M reuse autoextend on default compress;
exec dbms_connection_pool.start_pool;
exec dbms_connection_pool.configure_pool(inactivity_timeout=>3600, max_think_time=>3600);
./ruei-prepare-db.sh sql_packages
create user uxinsight
identified by uxinsight
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT
quota unlimited on USERS;
alter user uxinsight
quota unlimited on UXCONF
quota unlimited on UXSTAT
quota unlimited on UXTEMP;
alter profile DEFAULT
limit PASSWORD_LIFE_TIME unlimited;
grant create session,
create sequence,
create table,
create trigger,
create view,
create synonym,
create type,
create procedure,
create materialized view
to uxinsight;
grant execute on dbms_crypto to uxinsight;
grant execute on ux_dbms_lock to uxinsight;
$RUEI_DATA下 /var/opt/ruei ，创建两个文件，一个是sqlnet.ora， 一个是tnsnames.ora
sqlnet.ora文件加入如下内容
NAMES.DIRECTORY_PATH = (TNSNAMES)
SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION = (SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/var/opt/ruei)))
DIAG_SIGHANDLER_ENABLED = FALSE
tnsnames.ora加入如下内容
uxinsight =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rueirep)
(SERVER=POOLED)
)
)
mkstore -wrl /tmp -create
mkstore -wrl /tmp -createCredential uxinsight uxinsight uxinsight
把/tmp下的两个文件ewallet.p12，cwallet.sso，拷贝到$RUEI_DATA下
cp /tmp/ewallet.p12 /var/opt/ruei
cp /tmp/cwallet.sso /var/opt/ruei
chown moniforce:moniforce /var/opt/ruei/ewallet.p12
chown moniforce:moniforce /var/opt/ruei/cwallet.sso
chmod 600 /var/opt/ruei/ewallet.p12
chmod 640 /var/opt/ruei/cwallet.sso
chown moniforce:moniforce /var/opt/ruei/sqlnet.ora
chown moniforce:moniforce /var/opt/ruei/tnsnames.ora
mkdir -p /home/oracle/bin
cp /root/RUEI/extra/ruei-clean.sh /home/oracle/bin
chmod +x /home/oracle/bin/ruei-clean.sh
su - oracle -c 'echo "10 0 * * * /home/oracle/bin/ruei-clean.sh" | crontab'
mkdir -p /opt/ruei
chmod 750 /opt/ruei
修改用户属性
usermod -aG moniforce apache
usermod -aG uucp apache
usermod -aG uucp moniforce
rpm -Uvh /tmp/php-mbstring-5.3.3-26.el6.x86_64.rpm DVD2中的rpm包
cd /root/RUEI/132
./ruei-install.sh reporter
vi /etc/httpd/conf/httpd.conf
修改80端口 ServerName localhost:80
service httpd restart
添加到 vi /var/opt/ruei/.bash_profile
source /etc/ruei.conf
source $RUEI_HOME/bin/env.sh
cp /opt/ruei/bi-publisher/fonts/* /usr/java/jre/lib/fonts/
vi /etc/mail/sendmail.mc
修改
define('SMART_HOST', 'my.example')dnl
make -C /etc/mail
service sendmail restart
vi /etc/sysconfig/snmpd
去掉 OPTIONS 前的# 然后增加 -u moniforce
service snmpd restart
su - moniforce
set-admin-password
打开firefox
设置邮箱
root@example.com
系统-状态
Problem - Event log shows No interfaces suitable for traffic collection found. (Doc ID 1473657.1)
How to Troubleshoot "No data" in RUEI (Doc ID 1435184.1)
%3AGRE_HOWTO&action=inline
