RUEI for rhel6.4 64bit oracle11g 安裝手冊

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
下載地址：
百度網盤地址:

oracle地址：
RUEI介質獲取

參考文件的獲取
http://www.oracle.com/technetwork/documentation/realuserei-091455.html
RUEI相關的Data sheets, White papers, Trainings and Tutorials



一：
系統安裝： 略
資料庫安裝： 略

資料庫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 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/
 訪問首頁

   
使用者名稱是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