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 the Automated Ant Target

Instead of manually performing each of the Oracle Self-Service E-Billing database setup steps, you can use the automated Ant target to install the Oracle Self-Service E-Billing 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 target that installs the Oracle Self-Service E-Billing database.

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 the automated Ant target

  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. Run the install-new target to create the new instance, tablespaces, schemas, and schema objects (tables, indexes, packages, procedures, and so on) for OLAP and OLTP, using the SID specified in the properties file:

    ant install-new

    Or, if the EBILL instance and tablespaces are already created and you want to create schemas on them, then use the install-existing target to create schemas and schema objects (tables, indexes, packages, procedures, and so on) with the user names and passwords specified in the properties file. Run:

    ant install-existing

    These commands create the Oracle Self-Service E-Billing seed data for OLTP and OLAP.

    If you want to install sample data for both OLAP and OLTP, then use the following commands:

    • Telco Sample Data. ant install-existing -DloadSampleDataTelco=true
    • Utility Sample Data. ant install-existing -DloadSampleDataUtility=true
  7. 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.
  8. Install the ETL module and the Oracle Warehouse Builder Repository.

    For instructions on installing the ETL module, see Installing the ETL Module.

    For instructions on installing and setting up the Oracle Warehouse Builder Repository, see Process of Installing the Oracle Warehouse Builder Repository.

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