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
- Open the ebilling_olap.properties file, located in the following directory:
- Specify the following values in the ebilling_olap.properties file for the current installation.
Parameter in the ebilling_olap.properties File |
|
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. |
- Open the ebilling_oltp.properties file, located in the following directory:
- UNIX.
EDX_HOME /db/oracle
- Windows.
EDX_HOME \db\oracle
- Specify the following values in the ebilling_oltp.properties file for the current installation.
Parameter in the ebilling_oltp.properties File |
|
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. |
- Go to the directory with the Oracle Database installation files:
- UNIX.
EDX_HOME /db/oracle
- Windows.
EDX_HOME \db\oracle
- 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
- 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.
- 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.
|