ruei 13c 安装-凯发app官方网站

在虚拟机上做安装练习，重点参考官方文档，但官方文档中也有些错误
操作系统版本 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
oraclesoft    nproc  2047
oraclehard    nproc  16384
oraclesoft    nofile  1024
oraclehard    nofile  65536
oraclesoft    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



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)
:gre_howto&action=inline