首页 > 数据仓库 > RDW-RETL 安装指南

RDW-RETL 安装指南

2008年10月23日 zhiru.sun 发表评论 阅读评论

1. 安装准备
  1.1 通过Oracle Edelivery(http://edelivery.oracle.com) 下载RETL12.0安装介质(B30292-01.zip);
  1.2 通过Metalink(https://metalink.oracle.com/CSP/ui/index.html) 下载 RETL 12 的两个Patchs:RETL 12.0.1(p6008912_1200_GENERIC.zip) 和 RETL 12.0.1.1(p6418724_1200_GENERIC.zip);
  1.3 解压缩下载的RETL安装介质和Patch,参考 RETL 12.0.1.1版本下的安装指南(retl-12011-pg.pdf)进行安装

2. 安装 RETL 12
  2.1 首先 安装 RETL 12.0
    2.1.1 创建目录:/d01/app/retail/retl/12.0/rfx
    2.1.2 上传 retl_12.0_install.zip 到 /d01/app/retail/retl/12.0 目录下
    2.1.3 创建安装用户:useradd -g oinstall rfx
                                  passwd rfx
    2.1.4 su rfx

             ORACLE_HOME=/d01/app/oracle/product/10.2.0/db_1
             export ORACLE_HOME
             ORACLE_SID=RDW
             export ORACLE_SID
             INSTALL_DIR=/d01/app/retail/retl/12.0/rfx
             export INSTALL_DIR

    2.1.5 cd /d01/app/retail/retl/12.0
             unzip retl_12.0_install.zip
             ./install.sh
             ps.输入安装 RETL 12.0 的目录:/d01/app/retail/retl/12.0/rfx
    2.1.6 安装后查看 RETL 的版本:# retl -v
            显示:retl 12.0 build 870

  2.2 其次 安装覆盖型Patch,即安装 RETL 12.0.1 (参考:Upgrading from Earlier Releases of RETL章节)
    2.2.1 创建目录:/d01/app/retail/retl/12.0.1/rfx 和 /d01/app/retail/retl/12.0.1/rfx/tmp
    2.2.2 上传 retl_12.0.1_install.zip 到 /d01/app/retail/retl/12.0.1 目录下
    2.2.3 INSTALL_DIR=/d01/app/retail/retl/12.0.1/rfx
             export INSTALL_DIR

    2.2.4 执行安装前先修改/d01/app/retail/retl/12.0.1/etc 目录下的 rfx.conf/logger.conf:
             cd /d01/app/retail/retl/12.0.1/etc
             vi rfx.conf  //见附录1
             vi logger.conf //见附录2
    2.2.5 cd /d01/app/retail/retl/12.0.1
             unzip retl_12.0.1_install.zip
             ./install.sh
             ps.输入安装 RETL 12.0.1 的目录:/d01/app/retail/retl/12.0.1/rfx
    2.2.6 查看安装产生的日志:cat $INSTALL_DIR/install/install.log
    2.2.7 根据安装产生的提示,创建环境变量并执行RETL测试脚本(verify_retl):
             export RFX_HOME=/d01/app/retail/retl/12.0.1/rfx
             export PATH=/d01/app/retail/retl/12.0.1/rfx/bin:$PATH   

             执行测试脚本:
             $RFX_HOME/bin/verify_retl
             $RFX_HOME/bin/verify_retl -do
             ps. 执行以上脚本,在目录/d01/app/retail/retl/12.0.1/rfx/tmp 下会产生运行脚本的日志文档;若RETL正常安装后,会在SecureCRT tools上显示如下内容:

          Checking RETL Environment...found ORACLE environment...passed!
          Checking RETL binary...passed!
          Running samples.../d01/app/retail/retl/12.0.1/rfx/samples
        passed!
        =========================================================================
        Congratulations! Your RETL environment and installation passed all tests
        See the programmer's guide for more information about how to further test
        your database installation (if applicable).
        =========================================================================
        Exiting...saving output in /tmp/verifyretl-21524.log   

    2.2.8 安装后查看RETL版本:$ retl -v 或 $ rfx -v 或 $RFX_HOME/bin/retl -version
             显示:retl 12.0.1 build 1142
    2.2.9 执行脚本 $INSTALL_DIR/bin/setup.sh 检查RETL的安装和环境变量设置:
      2.2.9.1 需要安装Java Runtime Environment 1.4.2 (JRE) 以上版本并设置 $JAVA_HOME 环境变量:
                  JAVA_HOME=/d01/app/appworx/MGMLDRMS/jre
                  export JAVA_HOME
      2.2.9.2 . /$INSTALL_DIR/bin/setup.sh
                  ps.运行后,正常会在SecureCRT tools显示:
        ===========================================
        ****Welcome to RETL 12.0.1 Installation****
        ===========================================
        Please Enter RFX_HOME where RFX_HOME=<BASE RETL INSTALL DIR>
        Enter RFX_HOME:
        /d01/app/retail/retl/12.0.1/rfx
        /d01/app/retail/retl/12.0.1/rfx
        Please Enter JAVA_HOME where JAVA_HOME=<BASE JAVA INSTALL DIR>
        JAVA_HOME:
        /d01/app/appworx/MGMLDRMS/jre
        /d01/app/appworx/MGMLDRMS/jre
        Please Enter ORACLE_HOME where ORACLE_HOME=<BASE ORACLE INSTALL DIR>
        ORACLE_HOME:
        /d01/app/oracle/product/10.2.0/db_1
        /d01/app/oracle/product/10.2.0/db_1
        ===========================================
        Environment variables set successfully
        ===========================================
        =================================================
        Starting the testing of RETL 12.0.1 Installation
        =================================================
        Invalid argument : d01/app/retail/retl/12.0.1/rfx/bin
        grep: verify_usage: No such file or directory
        =================================================
        Starting the testing of RETL 12.0.1 Installation
        =================================================
          Checking RETL Environment...found ORACLE environment...passed!
          Checking RETL binary...passed!
          Running samples.../d01/app/retail/retl/12.0.1/rfx/samples
        passed!
        =========================================================================
        Congratulations! Your RETL environment and installation passed all tests
        See the programmer's guide for more information about how to further test
        your database installation (if applicable).
        =========================================================================
        Exiting...saving output in /d01/app/retail/retl/12.0.1/rfx/tmp/verifyretl-23125.log
    2.2.10 ./$RFX_HOME/bin/gsort
            ps.12.0.1 Programmer's Guide For Liunx:You need to create a symbolic link for gsort, pointing to $RFX_HOME/bin/gsort.
    2.2.11 RETL提供的环境变量、向后兼容说明及配置说明,可以参考书中:RETL Environment Variables、Backward Compatibility Notes、Configuration Field Descriptions、Temporary Space Configuration、Logger Configuration、Multibyte Character Support 章节

3. 修改RDW中profile文件中RETL_HOME环境变量:
    cd /d01/app/retail/rdw/dbserverunix/sample_profiles
    vi rdw_profile_ora

    # RETL SETUP REQUIRED HERE
    # CHANGE REQUIRED HERE
    # variable for the location of the RETL software.  This should be modified when RETL is installed.
    RETL_HOME=/d01/app/retail/retl/12.0.1/rfx ; export RETL_HOME
    RFX_HOME=$RETL_HOME ; export RFX_HOME

4. 安装完成RETL后,在/home/rfx/目录下建立环境文件 retl.env,内容如下:
   ORACLE_HOME=/d01/app/oracle/product/10.2.0/db_1
   export ORACLE_HOME
   ORACLE_SID=RDW
   export ORACLE_SID
   INSTALL_DIR=/d01/app/retail/retl/12.0.1/rfx
   export INSTALL_DIR
   RFX_HOME=/d01/app/retail/retl/12.0.1/rfx
   export RFX_HOME
   PATH=/d01/app/retail/retl/12.0.1/rfx/bin:$PATH
   export PATH
   JAVA_HOME=/d01/app/appworx/MGMLDRMS/jre
   export JAVA_HOME

   执行启用RETL前,先运行上述环境变量:
   source /home/rfx/retl.env
   运行后,检查一下是否已经生效:
   env | grep RFX_HOME
   如果有显示上面对应设置的结果,则表明已经生效。

附录1:rfx.conf
<CONFIG>
   <NODE hostname="syfr12" numpartitions="1" bufsize="2000">
      <!--
      If you change the TEMPDIR settings, you may also want to change
      the performance log file location specified in logger.conf.
      -->
      <TEMPDIR path="/d01/app/retail/retl/12.0.1/rfx/tmp" />
   </NODE>
   <GLOBAL bytes_per_character="1"  PRINT_HELP="ALL">
    <!-- Logger configuration has been moved to logger.conf. -->
   </GLOBAL>

   <DEFAULTS operator="oraread">
      <PROPERTY name="maxdescriptors" value="100"/>
      <PROPERTY name="hostname" value="syfr12"/>
      <PROPERTY name="port" value="1521"/>
   </DEFAULTS>
   <DEFAULTS operator="orawrite">
      <PROPERTY name="hostname" value="syfr12"/>
      <PROPERTY name="port" value="1521"/>
   </DEFAULTS>
</CONFIG>

ps.在原来的rfx.conf中必须增加:<PROPERTY name="hostname" value="syfr12"/>

附录2:logger.conf
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

<!--   
Logger configuration file.  See http://logging.apache.org/log4j/docs/documentation.html
-->

<log4j:configuration xmlns:log4j='http://jakarta.apache.org/log4j/'>

    <!--
    NONERRORS console appender.  Only messages with level less than WARN are logged
    to standard output.  Only the message is logged, not the level.
    -->
    <appender name="NONERRORS" class="org.apache.log4j.ConsoleAppender">
        <param name="target" value="System.out"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%m%n"/>
        </layout>
        <filter class="org.apache.log4j.varia.LevelRangeFilter">
            <param name="acceptOnMatch" value="true"/>
            <param name="levelMin" value="DEBUG"/>
            <param name="levelMax" value="INFO"/>
        </filter>
    </appender>

    <!--
    ERRORS console appender.  Only messages with level greater than or equal to
    WARN are logged to standard error.
    -->
    <appender name="ERRORS" class="org.apache.log4j.ConsoleAppender">
        <param name="target" value="System.err"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%-5p - %m%n"/>
        </layout>
        <filter class="org.apache.log4j.varia.LevelRangeFilter">
            <param name="acceptOnMatch" value="true"/>
            <param name="levelMin" value="WARN"/>
            <param name="levelMax" value="FATAL"/>
        </filter>
    </appender>
    <!--
    Performance appender.  Output goes to a file.
    -->
    <appender name="PERFORMANCE-APPENDER" class="org.apache.log4j.FileAppender">
        <!--
        To change the location of the performance log, change the value in the
        "file" parameter below.
        -->
        <param name="file" value="/d01/app/retail/retl/12.0.1/rfx/tmp/rfx.log"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="[%d]%m%n"/>
        </layout>
    </appender>

    <!--
    RETL logger.  Output goes to both NONERRORS and ERRORS.  The level is set to
    INFO, but if RFX_DEBUG is set, the level is changed to DEBUG.
    -->
    <logger name="retek.retl">
        <level value="INFO"/>
        <appender-ref ref="NONERRORS"/>
        <appender-ref ref="ERRORS"/>
    </logger>

    <!--
    Performance logger.  Turn off additivity so that performance information
    is not logged to retek.retl.
    -->
    <logger name="retek.retl.performance" additivity="false">
        <level value="WARN"/>
        <appender-ref ref="PERFORMANCE-APPENDER"/>
    </logger>

</log4j:configuration>

 

 

关于作者:

昵称:zhiru.sun
档案信息:
联系方式:你可以通过zhiru.sun@hand-china.com联系作者
点击查看zhiru.sun发表过的所有文章...
本文永久链接: http://blog.retailsolution.cn/archives/594

 

 

对本文的评价:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

 

 

分类: 数据仓库 标签:
  1. 本文目前尚无任何评论.
  1. 本文目前尚无任何 trackbacks 和 pingbacks.
您必须在 登录 后才能发布评论.