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

Configuring the Oracle Self-Service E-Billing Database on Oracle Exadata

Configuring Oracle Self-Service E-Billing on Oracle Exadata using Oracle Real Application Clusters (RAC) requires that you manually create database instances using Database Configuration Assistant (DBCA). You must also modify the Ant script before creating the schemas.

You do not need to configure Oracle Services.

NOTE:  If you are using Oracle RAC One Node and creating a single instance of a database on Oracle Exadata, you do not need to follow these steps. Use the procedures for UNIX described in this chapter without any changes.

To configure the Oracle Self-Service E-Billing database on Oracle Exadata with Oracle RAC

1. Use the NETCA command to create the listener, using the default value for all options.
2. Create the database instances manually using DBCA. Create one OLAP and one OLTP instance on each node. The following table shows sample data.

   SID	Host 1	Host 2
   OLTPSID	oltp1	oltp2
   OLAPSID	olap1	olap2

   NOTE:  DBCA automatically creates a TNS name for a new instance, so you do not need to manually configure the tnsnames.ora file.

3. Use SQL*Plus to log on the OLAP instance as sysdba. Run the following scripts individually as the OLAP sysdba user:

   $ORACLE_HOME/owb/UnifiedRepos/clean_owbsys.sql

   $ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql SYSTEM

   $ORACLE_HOME/owb/UnifiedRepos/unlock_owbsys.sql

   $ORACLE_HOME/rdbms/admin/userlock.sql

   $ORACLE_HOME/rdbms/admin/dbmslock.sql

4. Modify the Ant script for OLAP and OLTP. Edit the following items in both the buildedxolapadmin.xml OLAP file, found in the db/ebilling/oracle directory, and the buildedxadmin.xml OLTP file, found in the db/eStatement/oracle directory:
   • Remove the following code from the Checkdir target:

   <available file="${filepath}" type="dir" property="direxists"/>

   <fail unless="direxists" message="${line.separator}${line.separator}Directory '${filepath}' does not exists. Create the folder and install again; or try a different path for the Tablespace"/>

   • In the target "SetupDatabase"->replace->replacefilter, remove "${OLAP_SID}/data" from the following code, and remove the same code for all tokens with _LOC at the end of the name:

   token="$L_DB_EDX_DATA_TB_FILE_LOC"

   value="${L_DB_EDX_DATA_TB_FILE_LOC}/${OLAP_SID}/data"/>

5. Create the Oracle Self-Service E-Billing database on an existing instance using the ant script with the following additions and modifications. See either Creating the Oracle Self-Service E-Billing Database Using Ant or Creating the Oracle Self-Service E-Billing Database Using the Automated Ant Target.
   • Additional Modifications to OLAP Properties. In the ebilling_olap.properties file, for the OLAP_SID and OLTP_SID properties set the SID on your software database server, such as OLAP_SID=olap1 and OLTP_SID=oltp1. Set all TB_FILE_LOC properties to this format: DISK_GROUP/OLAP_TNS/datafile. For example: L_DB_EDX_DATA_TB_FILE_LOC=+DATA/olap/datafile. Specify a local directory value for the property TRACE_FILE_LOCN, for example: TRACE_FILE_LOCN=/export/oracle/olap. Skip the following properties:
     • DB_CONTROL_FILE_LOCN1
     • DB_CONTROL_FILE_LOCN2
     • DB_CONTROL_FILE_LOCN3
     • REDO_LOG_FILE_LOCN1
     • REDO_LOG_FILE_LOCN2
     • SYSTEM_FILE_LOCN
   • Additional Modifications to OLTP Properties. In the ebilling_oltp.properties file, for the OLAP_SID and OLTP_SID properties, set the SID on your software database server, such as OLAP_SID=olap1, OLTP_SID=oltp1. Set all TB_FILE_LOC properties to this format: DISK_GROUP/OLTP_TNS/datafile, for example: L_DB_EDX_DATA_TB_FILE_LOC=+DATA/oltp/datafile. Specify a local directory value for the property TRACE_FILE_LOCN, for example: TRACE_FILE_LOCN=/export/oracle/oltp. Skip the following properties:
     • DB_CONTROL_FILE_LOCN1
     • DB_CONTROL_FILE_LOCN2
     • DB_CONTROL_FILE_LOCN3
     • REDO_LOG_FILE_LOCN1
     • REDO_LOG_FILE_LOCN2
     • SYSTEM_FILE_LOCN
     • UNDO_FILE_LOCN
   • Modifications When Running the Ant Script. When you run the modified Ant script, use the install-existing option.
6. Follow the procedures in Installing the ETL Module for Oracle Self-Service E-Billing.