RUEI for rhel6.4 64bit oracle11g 安装手册
Real User Experience Insight (RUEI)
系统：
rhel 6.4 64 bit
下载地址：
数据库：
oracle 11g r2
下载地址：
数据库类型，选择data warehouse
字符集选择 AL32UTF8
软件：
ruei
p20545175_121070_Linux-x86-64.zip
下载地址：
百度网盘地址:
http://pan.baidu.com/s/1hqiqRXE
oracle地址：
RUEI介质获取
http://www.oracle.com/technetwork/oem/downloads/real-user-experience-insight-098009.html
参考文档的获取
http://www.oracle.com/technetwork/documentation/realuserei-091455.html
RUEI相关的Data sheets, White papers, Trainings and Tutorials
http://www.oracle.com/technetwork/oem/uxinsight/realuserexperienceinsight-085193.html
一：
系统安装： 略
数据库安装： 略
数据库base目录
$ORACLE_BASE : /app/oracle
数据库home目录
$ORACLE_HOME : $ORACLE_BASE/ora11g
ruei home目录
$RUEI_HOME : /opt/ruei
ruei data目录
$RUEI_DATA : /var/opt/ruei
ruei安装介质解压位置
$RUEI_MEDIA : /root/RUEI/
Reporter Database实例名
$ORACLE_SID : testdb
主机名
Hostname ： szruei
二：
RUEI安装必须的系统包
rpm ‐qa | httpd
rpm ‐qa | grep libpcap
rpm ‐qa | grep apr
rpm ‐qa | grep apr‐util
rpm ‐qa | grep php
rpm ‐qa | grep mod_ssl
rpm ‐qa | grep distcache
rpm ‐qa | grep php‐common
rpm ‐qa | grep php‐cli
rpm ‐qa | grep php‐mbstring
rpm ‐qa | grep php‐ldap
rpm ‐qa | grep gmp
rpm ‐qa | grep postgresql‐libs
rpm ‐qa | grep lm_sensors
rpm ‐qa | grep net‐snmp
rpm ‐qa | grep net‐snmp‐utils
rpm ‐qa | grep perl‐XML‐Twig
rpm ‐qa | grep perl‐XML‐Parser
rpm ‐qa | php‐soap‐5.1.6‐27.el5_5.3.x86_64.rpm（最新版本11.2.0.3以上需要）
如果配置了yum，可以使用yum来安装
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‐mbstring
yum ‐y install php‐ldap
yum ‐y install bitstream‐vera‐fonts
yum ‐y install librsvg2
yum ‐y install xorg‐x11‐xinit
yum ‐y install fonts‐*
需要安装字体包
rpm -Uhv fonts-*
三：
配置网络
[root@szruei ~]# cd /etc/sysconfig/ network‐scripts
[root@szruei network‐scripts]# cat ifcfg‐eth0
主要的两个属性
BOOTPROTO=none
ONBOOT=yes
网卡混杂模式设置
ifconfig eth1 promisc 设置网卡为混杂模式
ifconfig eth1 ‐promisc 取消混杂模式
可以查看当前的网卡模式
eth1 Link encap:Ethernet HWaddr 00:21:28:46:DB:7B
UP BROADCAST PROMISC MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
Memory:faae0000‐fab00000
四：
创建用户和组
RUEI使用的用户
groupadd moniforce
useradd moniforce ‐g moniforce ‐d /var/opt/ruei
chmod ‐R 750 /var/opt/ruei
chown ‐R moniforce:moniforce /var/opt/ruei
五：
修改ruei.conf文件
cp $RUEI_MEDIA/extra/ruei.conf /etc/
chmod 644 /etc/ruei.conf
chown moniforce:moniforce /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=testdb
export RUEI_DB_USER=uxinsight
export RUEI_DB_TNSNAME=uxinsight
export RUEI_DB_TNSNAME_CFG=$RUEI_DB_TNSNAME
RUEI配置默认目录结构需求
六：
安装java
cd $RUEI_MEDIA/Java
chmod +x ./jre‐1_5_0_22‐linux‐amd64‐rpm.bin
./jre‐1_5_0_22‐linux‐amd64‐rpm.bin
ln ‐s /usr/java/jre1.5.0_22 /usr/java/jre
七：
升级libXML2
rpm ‐qa | grep libxml2
cd $RUEI_MEDIA/libxml2
rpm ‐Uhv libXML*
八：
PHP配置
/sbin/chkconfig httpd on
编辑/etc/sysconfig/httpd ，添加如下一行
source /etc/ruei.conf
vi /etc/php.d/ruei.ini 文件，添加如下内容
session.gc_maxlifetime = 14400
memory_limit = 96M
upload_max_filesize = 128M
post_max_size = 128M
九：
回避RSVG警告信息
mkdir ‐p /var/www/.gnome2
十：
securing Apache Web Server
sed ‐i ‐e 's/^Listen 80/#Listen 80/' /etc/httpd/conf/httpd.conf
启动Apache时，如果提示错误Could not reliably determine the server's fully qualified domain name, using
可以修改
/etc/httpd/conf/httpd.conf
指定其中的servername hostname:80
servername szruei:80
十一：
安装oracle database instant 客户端
cd $RUEI_MEDIA/IC
rpm ‐Uhv oracle‐instantclient11.2‐basic‐11.2.0.3.0‐1.x86_64.rpm
rpm ‐Uhv oracle‐instantclient11.2‐sqlplus‐11.2.0.3.0‐1.x86_64.rpm
十二：
安装php-oci8 module
cd $RUEI_MEDIA/PHP
如果操作系统是5.7或者以后版本
rpm ‐Uhv php‐oci8‐11gR2‐5.1.6‐27.el5_7.4.x86_64.rpm
如果操作系统是更早的版本，那么安装
rpm ‐Uhv php‐oci8‐11gR2‐5.1.6‐27.el5.x86_64.rpm
因为本次实验用的是rhel6.4，需要安装
php-mbstring-5.3.3-22.el6.x86_64.rpm 包，百度网盘地址有提供该包
十三：
安装Zend Optimizer
cd $RUEI_MEDIA/ZendOptimizer
tar zxvf ZendOptimizer‐3.3.3‐linux‐glibc23‐x86_64.tar.gz
cd ZendOptimizer‐3.3.3‐linux‐glibc23‐x86_64
./install
接着全部选择默认就行了
十四：
解压 ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz
tar zxvf ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz
cp -r $RUEI_MEDIA/ZendGuardLoader /usr/local/
chown -R minoforce:moniforce
十五：
安装完毕之后，软件会安装到/usr/local/Zend/目录下，同时修改了/etc/php.ini,增加了一些内容，修改完毕之后，
将/etc/php.ini 移动到了/usr/local/Zend/etc下，又做了一个软连接指向/usr/local/Zend/etc/php.ini
# ls ‐l /etc/php.ini
lrwxrwxrwx 1 root root 27 Sep 4 22:46 /etc/php.ini ‐> /usr/local/Zend/etc/php.ini
十六：
对/etc/php.ini增加了如下内容
[Zend]
zend_extension_manager.optimizer=/usr/local/Zend/lib/Optimizer‐3.3.3
zend_extension_manager.optimizer_ts=/usr/local/Zend/lib/Optimizer_TS‐3.3.3
zend_optimizer.version=3.3.3
zend_extension=/usr/local/ZendGuardLoader/ZendGuardLoader-php-5.3-linux-glibc23-x86_64/php-5.3.x/ZendGuardLoader.so
zend_extension_ts=/usr/local/Zend/lib/ZendExtensionManager_TS.so
十七：
为了性能，建议关闭recyclebin和 audit
alter system set audit_trail=none scope=spfile;
alter system set recyclebin=off deferred;
十八：
安装报表数据库实例 （脚本安装）
将/ root / RUEI / 121下的ruei-prepare-db.sh，ruei-check.sh和目录sql_scripts拷贝到数据库实例下,并对oracle用户可执行。
# cd /root/RUEI/121/
# cp -r ruei-check.sh ruei-prepare-db.sh sql_scripts /home/oracle/
# chown -R oracle:oinstall /home/oracle/
# 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
[oracle@~]$ ./ruei-prepare-db.sh create
[oracle@~]$ ./ruei-prepare-db.sh create
Wed Sep 4 16:26:06 CST 2013: started database setup: create
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
____________________________________________________________
create ...
____________________________________________________________
____________________________________________________________
system_check ...
____________________________________________________________
Before setting up the database, we will need to perform a system check to
verify that the hardware has been set up correctly. You will be prompted
for the root password.
Run the system check (requires root password) (y/n)? y
Password:
Please specify which role(s) this system will perform.
Use commas to separate multiple roles. For example, 1,2,4
1 - Reporter
2 - Processing Engine
3 - Collector
4 - Database
Enter role(s): 1,2,3
Running checks for: Reporter Processor Collector
Checking for 16 GB of RAM: [FAIL]
Found 1999 MB
Please increase the amount of RAM in this server to assure proper system functionality
Checking for 100 GB of disk space available in /var/opt/ruei: [FAIL]
Found 63 GB free, 1 MB used
Additional disk space is required for the RUEI system to work properly
Checking transfer speed for device containing /var/opt/ruei [WARN]
Disk speed: 105 MB/s
Checking for sniffable interfaces: [FAIL]
eth0 UP with IP address 192.168.72.128
eth1 UP with IP address 192.168.72.132
lo UP with IP address 127.0.0.1
No sniffable interfaces found
Please configure your network devices as described in the Installation Guide.
Checking if hostname and DNS agree: [WARN]
Your local DNS server does not resolve the host name of this machine (weisr) to its IP address (127.0.0.1). Please verify your DNS server configuration and the hostname configured on this machine
Checking if ntpd is configured to start automatically: [FAIL]
Please enable ntpd by running the following command as root:
# /sbin/chkconfig ntpd on
Checking if ntpd is running: [FAIL]
Please start ntpd by running the following command as root:
# /sbin/service ntpd start
Checking if directory /var/www/.gnome2 exists: [FAIL]
Please create /var/www/.gnome2
You should fix all issues before proceeding, otherwise you will almost
certainly end up with a nonfunctional system.
Do you want to proceed? [y/n]: y
system_check done
____________________________________________________________
create_database ...
____________________________________________________________
The database instance 'ux' will be created. Please specify a password
for the SYS/SYSTEM users.
Specify a password for the SYS/SYSTEM users:
The password must be between 8 and 30 characters, must be a combination of
letters and numbers, and may not contain white space or double quotes (").
Specify a password for the SYS/SYSTEM users:
Confirm password:
Specify the global database name which must have the form
"db_name.db_domain". For example "sales.us.example.com". If this database
will be part of a distributed deployment, the name must be unique within
that system.
global database name [ux.localhost.localdomain]:
Creating database 'ux.localhost.localdomain' and instance 'ux' ...
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
33% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ux/ux.log" for further details.
create_database done
____________________________________________________________
create_tablespaces ...
____________________________________________________________
PL/SQL procedure successfully completed.
Tablespace altered.
Tablespace altered.
Tablespace altered.
Tablespace altered.
Tablespace altered.
Tablespace altered.
create_tablespaces done
____________________________________________________________
enable_connection_pooling ...
____________________________________________________________
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
enable_connection_pooling done
____________________________________________________________
reschedule_maintenance ...
____________________________________________________________
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
reschedule_maintenance done
____________________________________________________________
sql_packages ...
____________________________________________________________
Package created.
Package body created.
Synonym created.
Package created.
Package body created.
Synonym created.
sql_packages done
____________________________________________________________
create_user ...
____________________________________________________________
The database user UXINSIGHT will be created. Please choose a password
for this user.
Choose a password for UXINSIGHT:
Confirm password:
passwords do not match; please try again
Choose a password for UXINSIGHT:
Confirm password:
PL/SQL procedure successfully completed.
User altered.
create_user done
____________________________________________________________
user_grants ...
____________________________________________________________
User altered.
Profile altered.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
user_grants done
____________________________________________________________
create_triggers ...
____________________________________________________________
Trigger created.
create_triggers done
____________________________________________________________
create_wallet ...
____________________________________________________________
Choose a password for the wallet:
Confirm password:
creating wallet...
A tnsnames.ora file with the connection configuration for this database
will be generated. Please specify the hostname of the DB server to
connect to.
Enter the hostname of the DB server [weisr]:
If you have changed the listener port from the default 1521, or are
going to do so, then please specify which listener port to configure in
the tnsnames.ora file:
Listener port to connect to [1521]:
cwallet.sso
ewallet.p12
sqlnet.ora
tnsnames.ora
If the RUEI installation will be on this same server, then the database
configuration for user moniforce can be automatically completed. You
will be prompted for the root password.
Complete the installation automatically (requires root password) (y/n)? y
Password:
completing the RUEI database setup...
create_wallet done
create done
使用RUEI提供的脚步创建数据库
复制$RUEI_MEDIA/121/ruei‐prepare‐db.sh 和$RUEI_MEDIA/121/ruei‐check.sh 两个文件，以及$RUEI_MEDIA/121/sql_scripts 目录，到oracle用户有访问权限的目录下，例如/home/oracle，然后用oracle用户登录,确保ORACLE_HOME设置正确，检查/etc/ruei.conf各参数配置，此脚本将根据$RUEI_DB_INST的值创建数据库实例。
chmod +x ruei‐prepare‐db.sh ruei‐check.sh
./ruei‐prepare‐db.sh create
提示输入密码时，请输入与/etc/ruei.conf中配置的一致的密码
这一个脚本将会完成创建数据库，创建表空间，创建数据库用户，配置数据库连接，创建ORACLE Wallet，用户授权，激活DRCP连接池，创建RUEI需要的packages全部操作
接下来在reporter系统上配置数据库连接（如果Reporter 和 Reporter DB在同一台主机上，此步骤可以省略）
上一个脚本执行完毕之后，会产生一个文件 /tmp/ruei‐database‐configuration.tar，将这个文件copy到reporter系统的/var/opt/ruei目录下，解压，修改属性
cd /var/opt/ruei
tar ‐xvf ruei‐database‐configuration.tar
chown moniforce:moniforce cwallet.sso ewallet.p12 sqlnet.ora tnsnames.ora
（非脚本安装）
修改和创建必要的表空间
ruei数据库用户的默认表空间建议修改为compress，以users为例
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;
激活DRCP连接池
exec dbms_connection_pool.start_pool;
exec dbms_connection_pool.configure_pool(inactivity_timeout=>3600, max_think_time=>3600);
创建RUEI需要的packages
复制$RUEI_MEDIA/121/ruei‐prepare‐db.sh 和$RUEI_MEDIA/121/ruei‐check.sh 两个文件，以及$RUEI_MEDIA/121/sql_scripts 目录，到oracle用户有访问权限的目录下，例如/home/oracle，然后用oracle用户登录
chmod +x ./ruei‐prepare‐db.sh
./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;
配置数据库连接串
如果Reporter 和 Reporter DB在同一台主机上，此步骤可以省略
在$RUEI_DATA下，创建两个文件，一个是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 = ruei)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ruei)
(SERVER=POOLED)
)
)
创建ORACLE Wallet
如果Reporter 和 Reporter DB在一台主机上，此步骤可以省略
mkstore ‐wrl /tmp ‐create
输入一个wallet的密码，之后会在/tmp下生成两个文件ewallet.p12，cwallet.sso
Wallet创建完之后，向wallet中添加RUEI_DB_TNSNAME 和 RUEI_DB_USER
mkstore ‐wrl /tmp ‐createCredential uxinsight uxinsight uxinsight
先输入uxinsight的密码，然后再输入wallet的密码
把/tmp下的两个文件ewallet.p12，cwallet.sso，拷贝到$RUEI_DATA下，
必须修改属主和属性
mv /tmp/ewallet.p12 /var/opt/ruei
mv /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
十九：
配置crontab定时删除不必要的文件
# 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'
# su - oracle
[oracle@~]$ crontab -l
10 0 * * * /home/oracle/bin/ruei-clean.sh
二十：
安装报表系统软件
建目录并赋权限
# mkdir -p /opt/ruei
# chmod 750 /opt/ruei
修改用户属性
# /usr/sbin/usermod -aG moniforce apache
# /usr/sbin/usermod -aG uucp apache
# /usr/sbin/usermod -aG uucp moniforce
安装报表系统软件
# ./ruei-install.sh reporter
Preparing... ########################################### [100%]
Upgrade: waiting for background collector processes to terminate
Upgrade: stopping all running appsensor instances.
1:ux-collector ########################################### [ 5%]
Removing environment from /var/opt/ruei/.bash_profile.
Adding environment to /opt/ruei/bin/env.sh.
Adding path /opt/ruei/collector/lib64 to /etc/ld.so.conf.d
Installing crontab for user moniforce.
2:ux-core ########################################### [ 10%]
3:ux-generic ########################################### [ 14%]
4:ux-bi-publisher ########################################### [ 19%]
5:ux-gui ########################################### [ 24%]
6:ux-ipdb ########################################### [ 29%]
7:ux-wlp ########################################### [ 33%]
8:ux-adf ########################################### [ 38%]
9:ux-suites-ebs ########################################### [ 43%]
10:ux-suites-flex ########################################### [ 48%]
11:ux-suites-fus ########################################### [ 52%]
12:ux-suites-jde ########################################### [ 57%]
13:ux-suites-psft ########################################### [ 62%]
14:ux-suites-sbl ########################################### [ 67%]
15:ux-lang-de_de ########################################### [ 71%]
16:ux-lang-en ########################################### [ 76%]
17:ux-lang-es_es ########################################### [ 81%]
18:ux-lang-fr_fr ########################################### [ 86%]
19:ux-lang-ja_jp ########################################### [ 90%]
20:ux-lang-ko_kr ########################################### [ 95%]
21:ux-lang-zh_cn ########################################### [100%]
重启apache web服务器
# /sbin/service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
以root用户修改$RUEI_USER的.bash_profile
# vi /var/opt/ruei/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
source /etc/ruei.conf
source $RUEI_HOME/bin/env.sh
二十一：
校验RUEI是否正确安装
# cd /root/RUEI/121/
# chmod +x ./ruei-check.sh
# ./ruei-check.sh postinstall
Running checks for: Reporter Processor Collector
Checking for installed RPMs: [ OK ]
ux-bi-publisher 12.1.0 version
ux-gui 12.1.0 version
ux-lang-de_de 12.1.0 version
ux-lang-en 12.1.0 version
ux-lang-es_es 12.1.0 version
ux-lang-fr_fr 12.1.0 version
ux-lang-zh_cn 12.1.0 version
Checking for installed RPMs: [ OK ]
ux-core 12.1.0 version
ux-generic 12.1.0 version
ux-ipdb 12.1.0 version
ux-wlp 12.1.0 version
ux-adf 12.1.0 version
ux-suites-ebs 12.1.0 version
ux-suites-flex 12.1.0 version
ux-suites-fus 12.1.0 version
ux-suites-jde 12.1.0 version
ux-suites-psft 12.1.0 version
ux-suites-sbl 12.1.0 version
Checking ownership and permissions of /var/opt/ruei/cwallet.sso: [ OK ]
Checking ownership and permissions of /var/opt/ruei/ewallet.p12: [ OK ]
Checking for installed RPMs: [ OK ]
ux-collector 12.1.0 version
Running checks for: Reporter Processor Collector
Checking if the java shared objects can be found [ OK ]
ERROR: cannot verify weisr's certificate, issued by `/C=--/ST=SomeState/L=SomeCity/O=SomeOrganization/OU=SomeOrganizationalUnit/CN=localhost.localdomain/emailAddress=root@localhost.localdomain':
Self-signed certificate encountered.
ERROR: certificate common name `localhost.localdomain' doesn't match requested host name `weisr'.
To connect to weisr insecurely, use `--no-check-certificate'.
Unable to establish SSL connection.
WARNING: cannot verify weisr's certificate, issued by `/C=--/ST=SomeState/L=SomeCity/O=SomeOrganization/OU=SomeOrganizationalUnit/CN=localhost.localdomain/emailAddress=root@localhost.localdomain':
Self-signed certificate encountered.
WARNING: certificate common name `localhost.localdomain' doesn't match requested host name `weisr'.
Checking if https://weisr/ruei/ can be fetched successfully [WARN]
Site is using an invalid or self-signed certificate!
Running checks for: Reporter Processor Collector
Checking if the core binaries are in the $PATH: [ OK ]
以moniforce用户登录设置RUEI管理用户密码：
[moniforce@weisr ~]$ set-admin-password
Choose a password for the admin user:
Confirm password:
Note：密码至少八位字符，至少包含一个非字符（如$, @, &, !）
七天后密码失效，必须设置新密码
用户名和密码都区分大小写
二十二：
配置系统reboot时数据库自动启动
修改/etc/oratab
ruei:/u01/app/oracle/product/11.2.0/dbhome_1:Y
cp $RUEI_MEDIA/extra/oracledb /etc/init.d/
vi /etc/init.d/oracledb
根据软件具体安装位置，修改ORACLE_BASE ORACLE_HOME等变量的值
chmod +x /etc/init.d/oracledb
/sbin/chkconfig ‐‐add oracledb
测试启停
/sbin/service oracledb start
/sbin/service oracledb stop
、 安装reporter 和 collector
mkdir ‐p /opt/ruei
chmod 750 /opt/ruei
/usr/sbin/usermod ‐aG moniforce apache
/usr/sbin/usermod ‐aG uucp apache
/usr/sbin/usermod ‐aG uucp moniforce
cd $RUEI_MEDIA/121
chmod +x ruei‐install.sh
安装reporter
./ruei‐install.sh reporter
安装collector
./ruei‐install.sh collector
安装日志如下：
[root@ruei 121]# ./ruei‐install.sh collector
Preparing... ########################################### [100%]
1:ux‐collector ########################################### [100%]
Adding environment to /var/opt/ruei/.bash_profile.
Adding path /opt/ruei/collector/lib64 to /etc/ld.so.conf.d
Installing crontab for user moniforce.
[root@ruei 121]# ./ruei‐install.sh reporter
Preparing... ########################################### [100%]
Upgrade: waiting for background collector processes to terminate
Upgrade: stopping all running appsensor instances.
1:ux‐collector ########################################### [ 5%]
Adding environment to /var/opt/ruei/.bash_profile.
Adding path /opt/ruei/collector/lib64 to /etc/ld.so.conf.d
Installing crontab for user moniforce.
2:ux‐core ########################################### [ 10%]
3:ux‐generic ########################################### [ 14%]
4:ux‐bi‐publisher ########################################### [ 19%]
5:ux‐gui ########################################### [ 24%]
6:ux‐ipdb ########################################### [ 29%]
7:ux‐wlp ########################################### [ 33%]
8:ux‐adf ########################################### [ 38%]
9:ux‐suites‐ebs ########################################### [ 43%]
10:ux‐suites‐flex ########################################### [ 48%]
11:ux‐suites‐fus ########################################### [ 52%]
12:ux‐suites‐jde ########################################### [ 57%]
13:ux‐suites‐psft ########################################### [ 62%]
14:ux‐suites‐sbl ########################################### [ 67%]
15:ux‐lang‐de_de ########################################### [ 71%]
16:ux‐lang‐en ########################################### [ 76%]
17:ux‐lang‐es_es ########################################### [ 81%]
18:ux‐lang‐fr_fr ########################################### [ 86%]
19:ux‐lang‐ja_jp ########################################### [ 90%]
20:ux‐lang‐ko_kr ########################################### [ 95%]
21:ux‐lang‐zh_cn ########################################### [100%]
安装报错如下
path /var/opt/ruei in package ux‐bi‐publisher‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐collector‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐core‐12.1.0.1.1‐20120702.x86_64 is not relocatable
path /opt/ruei in package ux‐generic‐12.1.0.1.1‐20120702.x86_64 is not relocatable
path /var/opt/ruei in package ux‐gui‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐de_de‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐en‐12.1.0.1.1‐20120629.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐es_es‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐fr_fr‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐ja_jp‐12.1.0.1.1‐20120628.x86_64 is not relocatable
解决办法：
编辑ruei‐install.sh脚本
找到如下内容
install_rpms()
{
local rpms="$@"
rpm ‐Uvh ${args} ‐‐replacepkgs ‐‐oldpackage \
‐‐relocate /opt/ruei=$RUEI_HOME \
‐‐relocate /var/opt/ruei=$RUEI_DATA \
${rpms} || die "installation failed"
}
将其中的两个”‐‐relocate”去掉，也就是修改为如下
install_rpms()
{
local rpms="$@"
rpm ‐Uvh ${args} ‐‐replacepkgs ‐‐oldpackage \
${rpms} || die "installation failed"
}
安装后需要执行的
重启apache
/sbin/service httpd restart
vi ~moniforce/.bash_profile ,添加两行
source /etc/ruei.conf
source $RUEI_HOME/bin/env.sh
moniforce用户登录，设置ruei控制台admin用户的密码
su ‐ moniforce
set‐admin‐password
如果出现如下错误，PHP Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 1920 bytes) in /opt/ruei/gui/include/data/cube.inc.php on line 0
可以通过修改/etc/php.ini来解决，打开php.ini文件，找到一行memory_limit = 16M，将值改大即可，比如memory_limit = 96M
将ruei安装的字体，拷贝到java字体下
cp /opt/ruei/bi‐publisher/fonts/* /usr/java/jre/lib/fonts/
访问首页
https://ip_address/ruei
用户名是admin，密码是使用set‐admin‐password命令设置的密码
二十三：
访问export.php控制
默认配置情况下，禁止任何对export.php发起的http请求，控制文件配置是
/etc/httpd/conf.d/uxinsight.conf，文件中如下内容
Deny from all
我们可以修改为根据用户名和密码认证的方式来访问export.php，
第一步需要修改上述的uxinsight.conf文件， 找到
Deny from all
替换为如下内容
Order deny,allow
AuthUserFile /opt/ruei/.credentials
AuthName "Exports"
AuthType Digest
# Uncomment line below in case of IE6
# BrowserMatch "MSIE" AuthDigestEnableQueryStringHack=On
Require valid‐user
Allow from all
第二步，需要创建用户名和密码，使用htdigest工具
htdigest -c /opt/ruei/.credentials "Exports" username
Real User Experience Insight (RUEI)
系统：
rhel 6.4 64 bit
下载地址：
数据库：
oracle 11g r2
下载地址：
数据库类型，选择data warehouse
字符集选择 AL32UTF8
软件：
ruei
p20545175_121070_Linux-x86-64.zip
下载地址：
百度网盘地址:
http://pan.baidu.com/s/1hqiqRXE
oracle地址：
RUEI介质获取
http://www.oracle.com/technetwork/oem/downloads/real-user-experience-insight-098009.html
参考文档的获取
http://www.oracle.com/technetwork/documentation/realuserei-091455.html
RUEI相关的Data sheets, White papers, Trainings and Tutorials
http://www.oracle.com/technetwork/oem/uxinsight/realuserexperienceinsight-085193.html
一：
系统安装： 略
数据库安装： 略
数据库base目录
$ORACLE_BASE : /app/oracle
数据库home目录
$ORACLE_HOME : $ORACLE_BASE/ora11g
ruei home目录
$RUEI_HOME : /opt/ruei
ruei data目录
$RUEI_DATA : /var/opt/ruei
ruei安装介质解压位置
$RUEI_MEDIA : /root/RUEI/
Reporter Database实例名
$ORACLE_SID : testdb
主机名
Hostname ： szruei
二：
RUEI安装必须的系统包
rpm ‐qa | httpd
rpm ‐qa | grep libpcap
rpm ‐qa | grep apr
rpm ‐qa | grep apr‐util
rpm ‐qa | grep php
rpm ‐qa | grep mod_ssl
rpm ‐qa | grep distcache
rpm ‐qa | grep php‐common
rpm ‐qa | grep php‐cli
rpm ‐qa | grep php‐mbstring
rpm ‐qa | grep php‐ldap
rpm ‐qa | grep gmp
rpm ‐qa | grep postgresql‐libs
rpm ‐qa | grep lm_sensors
rpm ‐qa | grep net‐snmp
rpm ‐qa | grep net‐snmp‐utils
rpm ‐qa | grep perl‐XML‐Twig
rpm ‐qa | grep perl‐XML‐Parser
rpm ‐qa | php‐soap‐5.1.6‐27.el5_5.3.x86_64.rpm（最新版本11.2.0.3以上需要）
如果配置了yum，可以使用yum来安装
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‐mbstring
yum ‐y install php‐ldap
yum ‐y install bitstream‐vera‐fonts
yum ‐y install librsvg2
yum ‐y install xorg‐x11‐xinit
yum ‐y install fonts‐*
需要安装字体包
rpm -Uhv fonts-*
三：
配置网络
[root@szruei ~]# cd /etc/sysconfig/ network‐scripts
[root@szruei network‐scripts]# cat ifcfg‐eth0
主要的两个属性
BOOTPROTO=none
ONBOOT=yes
网卡混杂模式设置
ifconfig eth1 promisc 设置网卡为混杂模式
ifconfig eth1 ‐promisc 取消混杂模式
可以查看当前的网卡模式
eth1 Link encap:Ethernet HWaddr 00:21:28:46:DB:7B
UP BROADCAST PROMISC MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)
Memory:faae0000‐fab00000
四：
创建用户和组
RUEI使用的用户
groupadd moniforce
useradd moniforce ‐g moniforce ‐d /var/opt/ruei
chmod ‐R 750 /var/opt/ruei
chown ‐R moniforce:moniforce /var/opt/ruei
五：
修改ruei.conf文件
cp $RUEI_MEDIA/extra/ruei.conf /etc/
chmod 644 /etc/ruei.conf
chown moniforce:moniforce /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=testdb
export RUEI_DB_USER=uxinsight
export RUEI_DB_TNSNAME=uxinsight
export RUEI_DB_TNSNAME_CFG=$RUEI_DB_TNSNAME
RUEI配置默认目录结构需求
六：
安装java
cd $RUEI_MEDIA/Java
chmod +x ./jre‐1_5_0_22‐linux‐amd64‐rpm.bin
./jre‐1_5_0_22‐linux‐amd64‐rpm.bin
ln ‐s /usr/java/jre1.5.0_22 /usr/java/jre
七：
升级libXML2
rpm ‐qa | grep libxml2
cd $RUEI_MEDIA/libxml2
rpm ‐Uhv libXML*
八：
PHP配置
/sbin/chkconfig httpd on
编辑/etc/sysconfig/httpd ，添加如下一行
source /etc/ruei.conf
vi /etc/php.d/ruei.ini 文件，添加如下内容
session.gc_maxlifetime = 14400
memory_limit = 96M
upload_max_filesize = 128M
post_max_size = 128M
九：
回避RSVG警告信息
mkdir ‐p /var/www/.gnome2
十：
securing Apache Web Server
sed ‐i ‐e 's/^Listen 80/#Listen 80/' /etc/httpd/conf/httpd.conf
启动Apache时，如果提示错误Could not reliably determine the server's fully qualified domain name, using
可以修改
/etc/httpd/conf/httpd.conf
指定其中的servername hostname:80
servername szruei:80
十一：
安装oracle database instant 客户端
cd $RUEI_MEDIA/IC
rpm ‐Uhv oracle‐instantclient11.2‐basic‐11.2.0.3.0‐1.x86_64.rpm
rpm ‐Uhv oracle‐instantclient11.2‐sqlplus‐11.2.0.3.0‐1.x86_64.rpm
十二：
安装php-oci8 module
cd $RUEI_MEDIA/PHP
如果操作系统是5.7或者以后版本
rpm ‐Uhv php‐oci8‐11gR2‐5.1.6‐27.el5_7.4.x86_64.rpm
如果操作系统是更早的版本，那么安装
rpm ‐Uhv php‐oci8‐11gR2‐5.1.6‐27.el5.x86_64.rpm
因为本次实验用的是rhel6.4，需要安装
php-mbstring-5.3.3-22.el6.x86_64.rpm 包，百度网盘地址有提供该包
十三：
安装Zend Optimizer
cd $RUEI_MEDIA/ZendOptimizer
tar zxvf ZendOptimizer‐3.3.3‐linux‐glibc23‐x86_64.tar.gz
cd ZendOptimizer‐3.3.3‐linux‐glibc23‐x86_64
./install
接着全部选择默认就行了
十四：
解压 ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz
tar zxvf ZendGuardLoader-php-5.3-linux-glibc23-x86_64.tar.gz
cp -r $RUEI_MEDIA/ZendGuardLoader /usr/local/
chown -R minoforce:moniforce
十五：
安装完毕之后，软件会安装到/usr/local/Zend/目录下，同时修改了/etc/php.ini,增加了一些内容，修改完毕之后，
将/etc/php.ini 移动到了/usr/local/Zend/etc下，又做了一个软连接指向/usr/local/Zend/etc/php.ini
# ls ‐l /etc/php.ini
lrwxrwxrwx 1 root root 27 Sep 4 22:46 /etc/php.ini ‐> /usr/local/Zend/etc/php.ini
十六：
对/etc/php.ini增加了如下内容
[Zend]
zend_extension_manager.optimizer=/usr/local/Zend/lib/Optimizer‐3.3.3
zend_extension_manager.optimizer_ts=/usr/local/Zend/lib/Optimizer_TS‐3.3.3
zend_optimizer.version=3.3.3
zend_extension=/usr/local/ZendGuardLoader/ZendGuardLoader-php-5.3-linux-glibc23-x86_64/php-5.3.x/ZendGuardLoader.so
zend_extension_ts=/usr/local/Zend/lib/ZendExtensionManager_TS.so
十七：
为了性能，建议关闭recyclebin和 audit
alter system set audit_trail=none scope=spfile;
alter system set recyclebin=off deferred;
十八：
安装报表数据库实例 （脚本安装）
将/ root / RUEI / 121下的ruei-prepare-db.sh，ruei-check.sh和目录sql_scripts拷贝到数据库实例下,并对oracle用户可执行。
# cd /root/RUEI/121/
# cp -r ruei-check.sh ruei-prepare-db.sh sql_scripts /home/oracle/
# chown -R oracle:oinstall /home/oracle/
# 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
[oracle@~]$ ./ruei-prepare-db.sh create
[oracle@~]$ ./ruei-prepare-db.sh create
Wed Sep 4 16:26:06 CST 2013: started database setup: create
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
____________________________________________________________
create ...
____________________________________________________________
____________________________________________________________
system_check ...
____________________________________________________________
Before setting up the database, we will need to perform a system check to
verify that the hardware has been set up correctly. You will be prompted
for the root password.
Run the system check (requires root password) (y/n)? y
Password:
Please specify which role(s) this system will perform.
Use commas to separate multiple roles. For example, 1,2,4
1 - Reporter
2 - Processing Engine
3 - Collector
4 - Database
Enter role(s): 1,2,3
Running checks for: Reporter Processor Collector
Checking for 16 GB of RAM: [FAIL]
Found 1999 MB
Please increase the amount of RAM in this server to assure proper system functionality
Checking for 100 GB of disk space available in /var/opt/ruei: [FAIL]
Found 63 GB free, 1 MB used
Additional disk space is required for the RUEI system to work properly
Checking transfer speed for device containing /var/opt/ruei [WARN]
Disk speed: 105 MB/s
Checking for sniffable interfaces: [FAIL]
eth0 UP with IP address 192.168.72.128
eth1 UP with IP address 192.168.72.132
lo UP with IP address 127.0.0.1
No sniffable interfaces found
Please configure your network devices as described in the Installation Guide.
Checking if hostname and DNS agree: [WARN]
Your local DNS server does not resolve the host name of this machine (weisr) to its IP address (127.0.0.1). Please verify your DNS server configuration and the hostname configured on this machine
Checking if ntpd is configured to start automatically: [FAIL]
Please enable ntpd by running the following command as root:
# /sbin/chkconfig ntpd on
Checking if ntpd is running: [FAIL]
Please start ntpd by running the following command as root:
# /sbin/service ntpd start
Checking if directory /var/www/.gnome2 exists: [FAIL]
Please create /var/www/.gnome2
You should fix all issues before proceeding, otherwise you will almost
certainly end up with a nonfunctional system.
Do you want to proceed? [y/n]: y
system_check done
____________________________________________________________
create_database ...
____________________________________________________________
The database instance 'ux' will be created. Please specify a password
for the SYS/SYSTEM users.
Specify a password for the SYS/SYSTEM users:
The password must be between 8 and 30 characters, must be a combination of
letters and numbers, and may not contain white space or double quotes (").
Specify a password for the SYS/SYSTEM users:
Confirm password:
Specify the global database name which must have the form
"db_name.db_domain". For example "sales.us.example.com". If this database
will be part of a distributed deployment, the name must be unique within
that system.
global database name [ux.localhost.localdomain]:
Creating database 'ux.localhost.localdomain' and instance 'ux' ...
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
33% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ux/ux.log" for further details.
create_database done
____________________________________________________________
create_tablespaces ...
____________________________________________________________
PL/SQL procedure successfully completed.
Tablespace altered.
Tablespace altered.
Tablespace altered.
Tablespace altered.
Tablespace altered.
Tablespace altered.
create_tablespaces done
____________________________________________________________
enable_connection_pooling ...
____________________________________________________________
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
enable_connection_pooling done
____________________________________________________________
reschedule_maintenance ...
____________________________________________________________
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
reschedule_maintenance done
____________________________________________________________
sql_packages ...
____________________________________________________________
Package created.
Package body created.
Synonym created.
Package created.
Package body created.
Synonym created.
sql_packages done
____________________________________________________________
create_user ...
____________________________________________________________
The database user UXINSIGHT will be created. Please choose a password
for this user.
Choose a password for UXINSIGHT:
Confirm password:
passwords do not match; please try again
Choose a password for UXINSIGHT:
Confirm password:
PL/SQL procedure successfully completed.
User altered.
create_user done
____________________________________________________________
user_grants ...
____________________________________________________________
User altered.
Profile altered.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
user_grants done
____________________________________________________________
create_triggers ...
____________________________________________________________
Trigger created.
create_triggers done
____________________________________________________________
create_wallet ...
____________________________________________________________
Choose a password for the wallet:
Confirm password:
creating wallet...
A tnsnames.ora file with the connection configuration for this database
will be generated. Please specify the hostname of the DB server to
connect to.
Enter the hostname of the DB server [weisr]:
If you have changed the listener port from the default 1521, or are
going to do so, then please specify which listener port to configure in
the tnsnames.ora file:
Listener port to connect to [1521]:
cwallet.sso
ewallet.p12
sqlnet.ora
tnsnames.ora
If the RUEI installation will be on this same server, then the database
configuration for user moniforce can be automatically completed. You
will be prompted for the root password.
Complete the installation automatically (requires root password) (y/n)? y
Password:
completing the RUEI database setup...
create_wallet done
create done
使用RUEI提供的脚步创建数据库
复制$RUEI_MEDIA/121/ruei‐prepare‐db.sh 和$RUEI_MEDIA/121/ruei‐check.sh 两个文件，以及$RUEI_MEDIA/121/sql_scripts 目录，到oracle用户有访问权限的目录下，例如/home/oracle，然后用oracle用户登录,确保ORACLE_HOME设置正确，检查/etc/ruei.conf各参数配置，此脚本将根据$RUEI_DB_INST的值创建数据库实例。
chmod +x ruei‐prepare‐db.sh ruei‐check.sh
./ruei‐prepare‐db.sh create
提示输入密码时，请输入与/etc/ruei.conf中配置的一致的密码
这一个脚本将会完成创建数据库，创建表空间，创建数据库用户，配置数据库连接，创建ORACLE Wallet，用户授权，激活DRCP连接池，创建RUEI需要的packages全部操作
接下来在reporter系统上配置数据库连接（如果Reporter 和 Reporter DB在同一台主机上，此步骤可以省略）
上一个脚本执行完毕之后，会产生一个文件 /tmp/ruei‐database‐configuration.tar，将这个文件copy到reporter系统的/var/opt/ruei目录下，解压，修改属性
cd /var/opt/ruei
tar ‐xvf ruei‐database‐configuration.tar
chown moniforce:moniforce cwallet.sso ewallet.p12 sqlnet.ora tnsnames.ora
（非脚本安装）
修改和创建必要的表空间
ruei数据库用户的默认表空间建议修改为compress，以users为例
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;
激活DRCP连接池
exec dbms_connection_pool.start_pool;
exec dbms_connection_pool.configure_pool(inactivity_timeout=>3600, max_think_time=>3600);
创建RUEI需要的packages
复制$RUEI_MEDIA/121/ruei‐prepare‐db.sh 和$RUEI_MEDIA/121/ruei‐check.sh 两个文件，以及$RUEI_MEDIA/121/sql_scripts 目录，到oracle用户有访问权限的目录下，例如/home/oracle，然后用oracle用户登录
chmod +x ./ruei‐prepare‐db.sh
./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;
配置数据库连接串
如果Reporter 和 Reporter DB在同一台主机上，此步骤可以省略
在$RUEI_DATA下，创建两个文件，一个是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 = ruei)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ruei)
(SERVER=POOLED)
)
)
创建ORACLE Wallet
如果Reporter 和 Reporter DB在一台主机上，此步骤可以省略
mkstore ‐wrl /tmp ‐create
输入一个wallet的密码，之后会在/tmp下生成两个文件ewallet.p12，cwallet.sso
Wallet创建完之后，向wallet中添加RUEI_DB_TNSNAME 和 RUEI_DB_USER
mkstore ‐wrl /tmp ‐createCredential uxinsight uxinsight uxinsight
先输入uxinsight的密码，然后再输入wallet的密码
把/tmp下的两个文件ewallet.p12，cwallet.sso，拷贝到$RUEI_DATA下，
必须修改属主和属性
mv /tmp/ewallet.p12 /var/opt/ruei
mv /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
十九：
配置crontab定时删除不必要的文件
# 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'
# su - oracle
[oracle@~]$ crontab -l
10 0 * * * /home/oracle/bin/ruei-clean.sh
二十：
安装报表系统软件
建目录并赋权限
# mkdir -p /opt/ruei
# chmod 750 /opt/ruei
修改用户属性
# /usr/sbin/usermod -aG moniforce apache
# /usr/sbin/usermod -aG uucp apache
# /usr/sbin/usermod -aG uucp moniforce
安装报表系统软件
# ./ruei-install.sh reporter
Preparing... ########################################### [100%]
Upgrade: waiting for background collector processes to terminate
Upgrade: stopping all running appsensor instances.
1:ux-collector ########################################### [ 5%]
Removing environment from /var/opt/ruei/.bash_profile.
Adding environment to /opt/ruei/bin/env.sh.
Adding path /opt/ruei/collector/lib64 to /etc/ld.so.conf.d
Installing crontab for user moniforce.
2:ux-core ########################################### [ 10%]
3:ux-generic ########################################### [ 14%]
4:ux-bi-publisher ########################################### [ 19%]
5:ux-gui ########################################### [ 24%]
6:ux-ipdb ########################################### [ 29%]
7:ux-wlp ########################################### [ 33%]
8:ux-adf ########################################### [ 38%]
9:ux-suites-ebs ########################################### [ 43%]
10:ux-suites-flex ########################################### [ 48%]
11:ux-suites-fus ########################################### [ 52%]
12:ux-suites-jde ########################################### [ 57%]
13:ux-suites-psft ########################################### [ 62%]
14:ux-suites-sbl ########################################### [ 67%]
15:ux-lang-de_de ########################################### [ 71%]
16:ux-lang-en ########################################### [ 76%]
17:ux-lang-es_es ########################################### [ 81%]
18:ux-lang-fr_fr ########################################### [ 86%]
19:ux-lang-ja_jp ########################################### [ 90%]
20:ux-lang-ko_kr ########################################### [ 95%]
21:ux-lang-zh_cn ########################################### [100%]
重启apache web服务器
# /sbin/service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]
以root用户修改$RUEI_USER的.bash_profile
# vi /var/opt/ruei/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
source /etc/ruei.conf
source $RUEI_HOME/bin/env.sh
二十一：
校验RUEI是否正确安装
# cd /root/RUEI/121/
# chmod +x ./ruei-check.sh
# ./ruei-check.sh postinstall
Running checks for: Reporter Processor Collector
Checking for installed RPMs: [ OK ]
ux-bi-publisher 12.1.0 version
ux-gui 12.1.0 version
ux-lang-de_de 12.1.0 version
ux-lang-en 12.1.0 version
ux-lang-es_es 12.1.0 version
ux-lang-fr_fr 12.1.0 version
ux-lang-zh_cn 12.1.0 version
Checking for installed RPMs: [ OK ]
ux-core 12.1.0 version
ux-generic 12.1.0 version
ux-ipdb 12.1.0 version
ux-wlp 12.1.0 version
ux-adf 12.1.0 version
ux-suites-ebs 12.1.0 version
ux-suites-flex 12.1.0 version
ux-suites-fus 12.1.0 version
ux-suites-jde 12.1.0 version
ux-suites-psft 12.1.0 version
ux-suites-sbl 12.1.0 version
Checking ownership and permissions of /var/opt/ruei/cwallet.sso: [ OK ]
Checking ownership and permissions of /var/opt/ruei/ewallet.p12: [ OK ]
Checking for installed RPMs: [ OK ]
ux-collector 12.1.0 version
Running checks for: Reporter Processor Collector
Checking if the java shared objects can be found [ OK ]
ERROR: cannot verify weisr's certificate, issued by `/C=--/ST=SomeState/L=SomeCity/O=SomeOrganization/OU=SomeOrganizationalUnit/CN=localhost.localdomain/emailAddress=root@localhost.localdomain':
Self-signed certificate encountered.
ERROR: certificate common name `localhost.localdomain' doesn't match requested host name `weisr'.
To connect to weisr insecurely, use `--no-check-certificate'.
Unable to establish SSL connection.
WARNING: cannot verify weisr's certificate, issued by `/C=--/ST=SomeState/L=SomeCity/O=SomeOrganization/OU=SomeOrganizationalUnit/CN=localhost.localdomain/emailAddress=root@localhost.localdomain':
Self-signed certificate encountered.
WARNING: certificate common name `localhost.localdomain' doesn't match requested host name `weisr'.
Checking if https://weisr/ruei/ can be fetched successfully [WARN]
Site is using an invalid or self-signed certificate!
Running checks for: Reporter Processor Collector
Checking if the core binaries are in the $PATH: [ OK ]
以moniforce用户登录设置RUEI管理用户密码：
[moniforce@weisr ~]$ set-admin-password
Choose a password for the admin user:
Confirm password:
Note：密码至少八位字符，至少包含一个非字符（如$, @, &, !）
七天后密码失效，必须设置新密码
用户名和密码都区分大小写
二十二：
配置系统reboot时数据库自动启动
修改/etc/oratab
ruei:/u01/app/oracle/product/11.2.0/dbhome_1:Y
cp $RUEI_MEDIA/extra/oracledb /etc/init.d/
vi /etc/init.d/oracledb
根据软件具体安装位置，修改ORACLE_BASE ORACLE_HOME等变量的值
chmod +x /etc/init.d/oracledb
/sbin/chkconfig ‐‐add oracledb
测试启停
/sbin/service oracledb start
/sbin/service oracledb stop
、 安装reporter 和 collector
mkdir ‐p /opt/ruei
chmod 750 /opt/ruei
/usr/sbin/usermod ‐aG moniforce apache
/usr/sbin/usermod ‐aG uucp apache
/usr/sbin/usermod ‐aG uucp moniforce
cd $RUEI_MEDIA/121
chmod +x ruei‐install.sh
安装reporter
./ruei‐install.sh reporter
安装collector
./ruei‐install.sh collector
安装日志如下：
[root@ruei 121]# ./ruei‐install.sh collector
Preparing... ########################################### [100%]
1:ux‐collector ########################################### [100%]
Adding environment to /var/opt/ruei/.bash_profile.
Adding path /opt/ruei/collector/lib64 to /etc/ld.so.conf.d
Installing crontab for user moniforce.
[root@ruei 121]# ./ruei‐install.sh reporter
Preparing... ########################################### [100%]
Upgrade: waiting for background collector processes to terminate
Upgrade: stopping all running appsensor instances.
1:ux‐collector ########################################### [ 5%]
Adding environment to /var/opt/ruei/.bash_profile.
Adding path /opt/ruei/collector/lib64 to /etc/ld.so.conf.d
Installing crontab for user moniforce.
2:ux‐core ########################################### [ 10%]
3:ux‐generic ########################################### [ 14%]
4:ux‐bi‐publisher ########################################### [ 19%]
5:ux‐gui ########################################### [ 24%]
6:ux‐ipdb ########################################### [ 29%]
7:ux‐wlp ########################################### [ 33%]
8:ux‐adf ########################################### [ 38%]
9:ux‐suites‐ebs ########################################### [ 43%]
10:ux‐suites‐flex ########################################### [ 48%]
11:ux‐suites‐fus ########################################### [ 52%]
12:ux‐suites‐jde ########################################### [ 57%]
13:ux‐suites‐psft ########################################### [ 62%]
14:ux‐suites‐sbl ########################################### [ 67%]
15:ux‐lang‐de_de ########################################### [ 71%]
16:ux‐lang‐en ########################################### [ 76%]
17:ux‐lang‐es_es ########################################### [ 81%]
18:ux‐lang‐fr_fr ########################################### [ 86%]
19:ux‐lang‐ja_jp ########################################### [ 90%]
20:ux‐lang‐ko_kr ########################################### [ 95%]
21:ux‐lang‐zh_cn ########################################### [100%]
安装报错如下
path /var/opt/ruei in package ux‐bi‐publisher‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐collector‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐core‐12.1.0.1.1‐20120702.x86_64 is not relocatable
path /opt/ruei in package ux‐generic‐12.1.0.1.1‐20120702.x86_64 is not relocatable
path /var/opt/ruei in package ux‐gui‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐de_de‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐en‐12.1.0.1.1‐20120629.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐es_es‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐fr_fr‐12.1.0.1.1‐20120628.x86_64 is not relocatable
path /var/opt/ruei in package ux‐lang‐ja_jp‐12.1.0.1.1‐20120628.x86_64 is not relocatable
解决办法：
编辑ruei‐install.sh脚本
找到如下内容
install_rpms()
{
local rpms="$@"
rpm ‐Uvh ${args} ‐‐replacepkgs ‐‐oldpackage \
‐‐relocate /opt/ruei=$RUEI_HOME \
‐‐relocate /var/opt/ruei=$RUEI_DATA \
${rpms} || die "installation failed"
}
将其中的两个”‐‐relocate”去掉，也就是修改为如下
install_rpms()
{
local rpms="$@"
rpm ‐Uvh ${args} ‐‐replacepkgs ‐‐oldpackage \
${rpms} || die "installation failed"
}
安装后需要执行的
重启apache
/sbin/service httpd restart
vi ~moniforce/.bash_profile ,添加两行
source /etc/ruei.conf
source $RUEI_HOME/bin/env.sh
moniforce用户登录，设置ruei控制台admin用户的密码
su ‐ moniforce
set‐admin‐password
如果出现如下错误，PHP Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 1920 bytes) in /opt/ruei/gui/include/data/cube.inc.php on line 0
可以通过修改/etc/php.ini来解决，打开php.ini文件，找到一行memory_limit = 16M，将值改大即可，比如memory_limit = 96M
将ruei安装的字体，拷贝到java字体下
cp /opt/ruei/bi‐publisher/fonts/* /usr/java/jre/lib/fonts/
访问首页
https://ip_address/ruei
用户名是admin，密码是使用set‐admin‐password命令设置的密码
二十三：
访问export.php控制
默认配置情况下，禁止任何对export.php发起的http请求，控制文件配置是
/etc/httpd/conf.d/uxinsight.conf，文件中如下内容
Deny from all
我们可以修改为根据用户名和密码认证的方式来访问export.php，
第一步需要修改上述的uxinsight.conf文件， 找到
Deny from all
替换为如下内容
Order deny,allow
AuthUserFile /opt/ruei/.credentials
AuthName "Exports"
AuthType Digest
# Uncomment line below in case of IE6
# BrowserMatch "MSIE" AuthDigestEnableQueryStringHack=On
Require valid‐user
Allow from all
第二步，需要创建用户名和密码，使用htdigest工具
htdigest -c /opt/ruei/.credentials "Exports" username
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29500582/viewspace-1472663/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/29500582/viewspace-1472663/
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
