Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1427189
  • 博文数量: 316
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 3503
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(316)

文章存档

2021年(48)

2020年(115)

2019年(11)

2018年(9)

2017年(9)

2016年(17)

2015年(7)

2014年(4)

2013年(1)

2012年(11)

2011年(27)

2010年(35)

2009年(11)

2008年(11)

分类: Oracle

2018-10-17 09:28:17

在虚拟机上做安装练习,重点参考官方文档,但官方文档中也有些错误
操作系统版本 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
https://192.168.146.132/ruei


设置邮箱
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
阅读(946) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~