Bookshelf Home | Contents | Index | PDF     

Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 > Process of Migrating Oracle Self-Service E-Billing Version 6.0 to Version 6.0.1 >

Migrating Oracle Self-Service E-Billing to Oracle Database 11g

If you are migrating Oracle Self-Service E-Billing from Oracle Database 10g to Oracle Database 11g, then you must follow these procedures. These steps are for both UNIX and Windows environments.

This task is a step in Process of Migrating Oracle Self-Service E-Billing Version 6.0 to Version 6.0.1.

To migrate Oracle Self-Service E-Billing from Oracle Database 10g to Oracle Database 11g

  1. On UNIX, log in as the ORACLE user for migration activity. Export your existing version 6.0 OLAP and OLTP databases from Oracle Database 10g, using the following commands:

    exp system/manager@olap_tnsname file=olap_export.dmp FULL=Y log=olap_export.log

    exp system/manager@oltp_tnsname file=oltp_export.dmp FULL=Y log=oltp_export.log

  2. Install Oracle Database 11g.
  3. Create a new Oracle Database 11g database instance, tablespace, and schema for OLAP.
  4. Edit the edxadmin_unix.properties file, located in the following directory:
    • UNIX. EDX_HOME/db/ebilling/oracle
    • Windows. EDX_HOME\db\ebilling\oracle
  5. Verify that the following values are correct for the current installation:
    • ORACLE_BASE and ORACLE_HOME locations
    • OLTP and OLAP database SID, user name, and password
    • SYSDBA password and tnsnames for OLTP and OLAP
    • Database file locations
    • Redo file locations
    • Trace file location
  6. Create the Oracle Self-Service E-Billing database:
    1. Go to the location of the Oracle Database installation files in your software installation:
      • UNIX. EDX_HOME/db/ebilling/oracle
      • Windows. EDX_HOME\db\ebilling\oracle
    2. If you have not configured the Apache Ant environment, then do so now:
      • UNIX. Run the following commands, where JDK150_11 is your JDK version:

    export ANT_HOME=/opt/apache-ant-1.6.5

    export PATH=$ANT_HOME/bin:$PATH

    export JAVA_HOME= $WEBLOGIC_HOME/JDK150_11

    export PATH=$JAVA_HOME/bin:$ANT_HOME/bin:$PATH

    • Windows. Run the following commands, where JDK150_11 is your JDK version:

    set ANT_HOME=C:\apache-ant-1.6.5

    set PATH=%PATH%;%ANT_HOME%\bin

    set JAVA_HOME= %WEBLOGIC_HOME%\JDK150_11

    1. Enter Ant to run the build script.

      By default, the Ant command runs the build.xml file in the current directory.

    2. Select Option 1, Install the OLAP database. Complete Options 1-5 on the OLAP menu to create the OLAP database instance, tablespaces, and schema. Review all log files for possible errors even if a Build Successful message appears. When done, choose Q (Quit).
  7. Create a new Oracle Database 11g database instance, tablespace, and user for OLTP (eStatement):
    1. Edit the edxadmin.properties file, located in the following directory:
      • UNIX. EDX_HOME/db/eStatement/oracle
      • Windows. EDX_HOME\db\eStatement\oracle
    2. Verify that the following values are correct for the current installation:
      • ORACLE_BASE and ORACLE_HOME
      • OLTP database SID, user name, and password
      • SYSTEM password for OLTP
      • Database file locations
      • Redo file locations
      • Trace file location
    3. Go to the directory location of the eStatement Oracle Database installation files in your software installation:
      • UNIX. EDX_HOME/db/eStatement/oracle
      • Windows. EDX_HOME\db\eStatement\oracle
    4. Run the commands to configure the Apache Ant environment.
      • UNIX. Run the following commands, where JDK150_11 is your JDK version:

    export ANT_HOME=/opt/apache-ant-1.6.5

    export JAVA_HOME=$WEBLOGIC_HOME/JDK150_11

    export PATH=$JAVA_HOME/bin:$ANT_HOME/bin:$PATH

    • Windows. Run the following commands, where JDK150_11 is your JDK version:

    set ANT_HOME=C:\apache-ant-1.6.5

    set JAVA_HOME=%WEBLOGIC_HOME%\JDK150_11

    set PATH=%PATH%;%JAVA_HOME%\bin;%ANT_HOME%\bin

    In the set JAVA_HOME command, JDK150_11 is your JDK version.

    1. Enter Ant to run the build script.

      By default, the Ant command runs the build.xml file in the current directory.

    2. From the top level Main Menu, select Option 1, Install eStatement Database to start.

      The Install eStatement Database menu appears.

    3. Complete Options 1-4 on the Install eStatement Database Menu to create the OLTP instance, tablespace, and user. Review all log files for possible errors even if a Build Successful message appears. When done, choose Q (Quit).
  8. Create the database link, TAM_LINK, in the OLTP schema.
  9. Log on to the OLTP instance as SYSDBA, and execute the following command. In the command, OLTP_Schema is the name of the OLTP schema.

    SQL> GRANT CREATE DATABASE LINK TO OLTP_Schema;

  10. Go to the following directory:
    • UNIX. EDX_HOME/db/ebilling/oracle
    • Windows. EDX_HOME\db\ebilling\oracle
  11. Log on to the OLTP schema, using SQL*Plus, not as SYSDBA.
  12. Execute the following SQL script, providing the three input parameters:

    SQL> DROP DATABASE LINK TAM_LINK;

    SQL>@ crt_db_link.sql OLAP_User OLAP_Password OLAP_TNS_Name

    SQL>exit

    where:

    • OLAP_User is the name of the OLAP schema user.
    • OLAP_Password is the OLAP schema user's password.
    • OLAP_TNS_Name is the name of the OLAP instance.
  13. Import Oracle Database 10g database into the new database:

    imp system/manager@oltp_sid fromuser=oltp touser=oltp file=oltp_export.dmp log=oltp_import.log

    imp system/manager@olap_sid fromuser=olap touser=olap file=olap_export.dmp log=oltp_import.log

    NOTE:  If the importing and exporting schema names are different, then you might receive a message indicating that the user does not exist for snapshot logs after the importing some objects. You can ignore this message.

    
Installation Guide for Oracle Self-Service E-Billing Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.