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 OLAP and OLTP database SID, user name, password, and tnsnames to provide a link between the databases. 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.

CAUTION:  The automated ant target will not perform Transparent Data Encryption on your database. For information about choosing an encryption method, see Choosing a Database Encryption Method.

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. Specify the following values in the ebilling_olap.properties file for the current installation. This file can be found in the EDX_HOME/db/ebilling/oracle directory or the EDX_HOME\db\ebilling\oracle directory on Windows, where EDX_HOME is the directory where you installed Oracle Self-Service E-Billing:
   • ORACLE_HOME and ORACLE_ADMIN locations
   • OLAP and OLTP database SID, user name, and password
   • SYSDBA password for OLAP
   • Database file locations for OLAP
   • Redo file locations for OLAP
   • Trace file location for OLAP
2. Specify the following values in the ebilling_oltp.properties file, found in the $EDX_HOME/db/ebilling/oracle directory (or the %EDX_HOME%\db\ebilling\oracle directory on Windows) for the current installation:
   • ORACLE_HOME and ORACLE_BASE locations
   • OLTP and OLAP database SID, user name, and password
   • SYSDBA password for OLTP
   • Database file locations for OLTP
   • Redo file locations for OLTP
   • Trace file location for OLTP
3. Change directory to the location of the Oracle Self-Service E-Billing Database installation files in your software installation: $EDX_HOME/db/ebilling/oracle (%EDX_HOME%\db\ebilling\oracle on Windows).
4. Run the install-new target to create the new instances, schemas, and schema objects (tables, indexes, packages, procedures, and so on) for OLAP and OLTP, using the SIDs specified in the properties file:

   ant install-new

   Note that this command creates seed data for OLTP and OLAP.

   Or, if the OLAP and OLTP instances are already created and you want to create schemas on them, 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

   This command creates the E-billing seed data for OLTP and OLAP.

   If you want to install sample data for both OLAP and OLTP, add the -DloadSampleData=true argument to the Ant call, for example:

   ant install-existing -DloadSampleData=true

   You can optionally run the OLAP-and OLTP-specific Ant build files, buildedxadmin.xml and buildedxolapadmin.xml. You can run any of the targets and flags using these instance-specific files with the -f <filename> flag.

   For example, to install a new OLAP instance with sample data only, you would use the following command:

   ant install-new -f buildedxolapadmin.xml -DloadSampleData=true

5. 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.