Bookshelf Home | Contents | Index | PDF     

Installation Guide for Oracle Self-Service E-Billing > Configuring the Oracle Database >

Creating the Oracle Self-Service E-Billing Database Using Ant (Single Node)

Oracle Self-Service E-Billing provides an ant script for creating the Oracle Self-Service E-Billing database. This topic describes how to create a single-node installation of the Oracle Self-Service E-Billing database. The single-node database is also referred to as a standalone database.

You must configure the ebilling_olap.properties and ebilling_oltp.properties files with the same EBILL database SID and tnsnames, and OLTP and OLAP user names and passwords. The ebilling_olap.properties, ebilling_oltp.properties, and ebilling_etl.properties files contain configuration parameters specific to each installation and are used by the Ant script that installs the Oracle Self-Service E-Billing database. You update these files before running the Oracle Self-Service E-Billing Ant script.

This task is a step in Roadmap for Configuring the Oracle Self-Service E-Billing Database.

To create the Oracle Self-Service E-Billing database using Ant (single node)

  1. Open the ebilling_olap.properties file, located in the following directory:
    • UNIX. EDX_HOME/db/oracle
    • Windows. EDX_HOME\db\oracle

      In the directory, EDX_HOME is the location where you installed Oracle Self-Service E-Billing.

  2. Specify the following values in the ebilling_olap.properties file for the current installation.
    Parameter in the ebilling_olap.properties File
    Description

    ORACLE_HOME

    The root installation path for any Oracle product installed through an installer that is based on Oracle Universal Installer.

    ORACLE_ADMIN

    Location of the Oracle admin folder.

    OLAP_USER

    The OLAP schema user name.

    OLAP_PASSWD

    The password for the OLAP schema.

    OLTP_USER

    The OLTP schema user name.

    OLTP_PASSWD

    The password for the OLTP schema.

    EBILL_SID

    The Oracle SID of the Oracle Self-Service E-Billing database.

    EBILL_TNS_NAME

    The Oracle Self-Service E-Billing database TNS (Transparent Network Substrate) name.

    SYS_PASSWD

    The password of the SYS user.

    META_USER

    Not used.

    META_PASSWD

    Not used.

    L_DB_EDX_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_EDX_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_APP_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_APP_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_EDX_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_EDX_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_APP_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_APP_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_LOAD_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_LOAD_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_LOAD_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_LOAD_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_FS_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_FS_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_FS_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_FS_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_STG_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_STG_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_STG_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_STG_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    DB_CONTROL_FILE_LOCN1

    An instance control file folder location. The installation script automatically adds the Oracle SID to the path, as in: /home/oracle/oradata/ORACLE_SID.

    DB_CONTROL_FILE_LOCN2

    An instance control file folder location. The installation script automatically adds the Oracle SID to the path, as in: /home/oracle/oradata/ORACLE_SID.

    DB_CONTROL_FILE_LOCN3

    An instance control file folder location. The installation script automatically adds the Oracle SID to the path, as in: /home/oracle/oradata/ORACLE_SID.

    REDO_LOG_FILE_LOCN1

    An instance redo file folder location. The installation script automatically adds the Oracle SID and /redo to the path, as in: /home/oracle/oradata/ORACLE_SID/redo.

    REDO_LOG_FILE_LOCN2

    An instance redo file folder location. The installation script automatically adds the Oracle SID and /redo to the path, as in: /home/oracle/oradata/ORACLE_SID/redo.

    SYSTEM_FILE_LOCN

    The instance system file folder location. The installation script automatically adds the Oracle SID and /data to the path, as in: /home/oracle/oradata/ORACLE_SID/data.

    TRACE_FILE_LOCN

    The folder location of the instance trace file, such as
    /home/oracle/oradata.

    L_BACKUP_FILE

    Not used.

    L_LOG_FILE

    Not used.

    L_OLAP_BACKUP_FILE

    Not used.

    L_OLAP_LOG_FILE

    Not used.

    ENCRYPTION_WALLET_LOCN

    (Optional) If you are implementing database encryption, then specify the location of the Oracle wallet folder location. Use the same location that you set in the sqlnet.ora file.

    WALLET_AUTO_OPEN

    (Optional) If you are implementing database encryption, then specify whether the Oracle Wallet opens automatically when the database instance is restarted, or whether you must open it manually using the Ant Encryption menu. The value can be Y or N. It is recommended to set the value to Y.

    TDE_ENCRYPT_OLAPCOLUMN

    (Optional) When you are using encryption, specify whether to use column-level encryption in the OLAP schema. The value can be Y or N.

    TDE_ENCRYPT_OLAPTSPACE

    (Optional) When you are using encryption, specify whether to use tablespace-level encryption in the OLAP schema. The value can be TRUE or FALSE.
  3. Open the ebilling_oltp.properties file, located in the following directory:
    • UNIX. EDX_HOME/db/oracle
    • Windows. EDX_HOME\db\oracle
  4. Specify the following values in the ebilling_oltp.properties file for the current installation.
    Parameter in the ebilling_oltp.properties File
    Description

    ORACLE_HOME

    The root installation path for any Oracle product installed through an installer that is based on Oracle Universal Installer.

    ORACLE_BASE

    Location of the Oracle base folder.

    EBILL_LISTEN_PORT

    The Oracle Self-Service E-Billing database listening port for creating the bootstrap user.

    EBILL_HOSTNAME

    The Oracle Self-Service E-Billing database host name for creating the bootstrap user.

    OLTP_USER

    The OLTP schema user name.

    OLTP_PASSWD

    The password for the OLTP schema.

    OLAP_USER

    The OLAP schema user name.

    OLAP_PASSWD

    The password for the OLAP schema.

    EBILL_SID

    The ORACLE SID for the Oracle Self-Service E-Billing database.

    EBILL_TNS_NAME

    The TNS (Transparent Network Substrate) name for the Oracle Self-Service E-Billing database.

    SYS_PASSWD

    The OLTP SYS user password.

    L_DB_EDX_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_EDX_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_EDX_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_EDX_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_APP_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_APP_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_APP_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_APP_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_LOAD_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_LOAD_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_LOAD_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_LOAD_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_FS_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_FS_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_FS_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_FS_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_STG_DATA_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_STG_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    L_DB_STG_INDX_TB_FILE_LOC

    The folder location where the installation script creates the L_DB_STG_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    LARGE_DB_EDX_DATA_TB_FILE_LOC

    The folder location where the installation script creates the LARGE_DB_EDX_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    LARGE_DB_EDX_INDX_TB_FILE_LOC

    The folder location where the installation script creates the LARGE_DB_EDX_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    MEDIUM_DB_EDX_DATA_TB_
    FILE_LOC

    The folder location where the installation script creates the MEDIUM_DB_EDX_DATA_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    MEDIUM_DB_EDX_INDX_TB_FILE_
    LOC

    The folder location where the installation script creates the MEDIUM_DB_EDX_INDX_TB_FILE_LOC schema tablespace. The installation script automatically adds the Oracle SID, schema name, and /data to the path, as in:
    /home/oracle/oradata/ORACLE_SID/SCHEMA_NAME/data.

    TDE_ENCRYPT_OLTPCOLUMN

    (Optional) When you are using encryption, specify whether to use column-level encryption in the OLTP schema. The value can be Y or N.

    TDE_ENCRYPT_OLTPTSPACE

    (Optional) When you are using encryption, specify whether to use tablespace-level encryption in the OLTP schema. The value can be TRUE or FALSE.
  5. Go to the directory with the Oracle Database installation files:
    • UNIX. EDX_HOME/db/oracle
    • Windows. EDX_HOME\db\oracle
  6. If you have not configured the Apache Ant environment, then do so now:
    • UNIX. Run the following commands, where JDK160_24 is your JDK version:

    export ANT_HOME=/opt/apache-ant-1.6.5

    export JAVA_HOME= $WEBLOGIC_HOME/JDK160_24

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

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

    set ANT_HOME=C:\apache-ant-1.6.5

    set JAVA_HOME= %WEBLOGIC_HOME%\JDK160_24

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

  7. Enter Ant to run the build script.

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

  8. From the Main Menu, select Option 2, Standalone Install. This option is for a self-sustaining or single-node instance.
  9. You have the option to create the database instance, tablespaces, and schemas, including the users and objects, in one step or in separate steps:
    • To create the instance, tablespaces, and schemas in one step, select Option 6, Run Steps 1, 2, and 3, from the single-node Installation Main Menu.

      This step can take anywhere from 20 minutes to 2 hours to complete, depending on the speed of your platform. The script creates a new database instance for Oracle Self-Service E-Billing, defines the data dictionaries and all system database objects, and creates the tablespace and schemas. If you have set properties for TDE encryption, then the Ant script prompts you to create an Oracle Wallet password when it is ready to create the Master Encryption Key. Specify a password for the Oracle Wallet, then enter it again. Ant exits when finished. Review all log files for possible errors. You do not have to follow any more steps.

    • To create the instance, tablespaces, and schemas separately, continue with Step 10.
  10. Select Option 1, Create Database Instance.

    This step can take anywhere from 20 minutes to 2 hours to complete, depending on the speed of your platform. The script creates a new instance for the Oracle Self-Service E-Billing database, defines the data dictionaries and all system database objects.

    Ant returns to the current menu when finished. Review all log files for possible errors.

  11. Select Option 2, Create eBilling Tablespaces.

    This step creates a tablespace for the Oracle Self-Service E-Billing database.

  12. Select Option 3, Create eBilling Schemas.

    If you have set properties for TDE encryption, then the Ant script prompts you to create an Oracle Wallet password when it is ready to create the Master Encryption Key. Specify a password for the Oracle Wallet, then enter it again.

  13. You have the option to create database users and objects in one step or separately:
    • To create both users and objects in one step, select Option 4, Run Steps 1 and 2. Review all log files for possible errors.
    • To create users and objects separately, select Option 1, Create Database Users. Select Option 2, Create Database Objects. Review all log files for possible errors.

      The script creates new database users, grants the necessary permission and privileges, and creates all the database objects for the Oracle Self-Service E-Billing OLTP and OLAP schemas. Ant returns to the current menu when finished.

  14. Select Option 6, Return to the Main Menu.
    
Installation Guide for Oracle Self-Service E-Billing Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.