商云方的技术博客 (沪ICP备14046774号-1)

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>