Installation Guide for Oracle Billing Insight > Configuring the Oracle Database >

Creating the Oracle Billing Insight Database Using the Automated Ant Target

Instead of manually performing each of the Oracle Billing Insight database setup steps, you can use the automated Ant target to install the Oracle Billing Insight database.

Before running the Ant script you must configure the BillingInsight.properties file with the same EBILL database SID and tnsnames, and OLTP and OLAP user names and passwords. This properties file contain configuration parameters specific to each installation and are used by the Ant script that installs the Oracle Billing Insight database.

This task is a step in Roadmap for Configuring the Oracle Billing Insight Database.

To create the Oracle Billing Insight database using the automated Ant target

1. Open the BillingInsight.properties configuration file in a text editor. This file is 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 Billing Insight.

2. In the BillingInsight.properties file, specify the property values for the current installation. For details, see Table 3.
3. Go to the directory with the Oracle Database installation files:
   • UNIX. EDX_HOME/db/oracle
   • Windows. EDX_HOME\db\oracle
4. If the EBILL instance is already created and you want to create tablespaces and schemas on them, then use the install-existing target to create tablespaces, 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 Billing Insight 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
5. 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.
6. Install the Oracle Data Integrator (ODI).

   For instructions on installing and setting up the Oracle Data Integrator, see Creating a Standalone Agent.

7. Configure ODI for your production environment.

   For instructions on configuring ODI, see Configuring Oracle Billing Insight for Your ODI Configuration.