Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 from Other Products > Process of Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database to Oracle Self-Service E-Billing Version 6.0 >

Migrating the Oracle Communications Billing Analytics version 5.1.1 OLTP Database to Oracle Self-Service E-Billing Version 6.0 OLTP on UNIX

This topic describes how to migrate the Oracle Communications Billing Analytics version 5.1.1 OLTP database to Oracle Self-Service E-Billing 6.0 OLTP on UNIX.

This task is a step in Process of Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database to Oracle Self-Service E-Billing Version 6.0.

To migrate the Oracle Communications Billing Analytics version 5.1.1 OLTP database to Oracle Self-Service E-Billing version 6.0 on UNIX

1. On UNIX, log in as the ORACLE user for migration activity.
2. Go to the EDX_HOME/db/ebilling/oracle/oltp/migration/511_to_6.0 directory. In the path, EDX_HOME is the Oracle Self-Service E-Billing installation directory.
3. Verify that the following files exist:
   • migrate_oltp_511_to_6.0.sh
   • migrate_oltp_511_to_6.0.sql
4. Run the following commands at the shell prompt:

   chmod 777 migrate_oltp_511_to_6.0.sh

   ./migrate_oltp_511_to_6.0.sh

5. Provide the correct values for your environment.

   Field	What to Enter
   Database ID	Instance name, such as OLTP
   Database Username	Schema name, such as OLTP
   Database Password	Schema password.
   SYS Password	Password of the SYSDBA.

6. Check for errors in the following log files:
   • db_oltp_migrate_511_6.0.log
   • migrate_oltp_511_to_6.0.log

     Note that after running the OLTP migration script, migrate_oltp_511_to_6.0.sh, the following error messages appears in the log file. Ignore these errors. After compiling the schema, these errors will disappear:

     Warning: Package Body created with compilation errors.

     Errors for PACKAGE BODY OLTP_PROD_LOADER_PKG:

     LINE/COL ERROR

     -------- -----------------------------------------------------------------

     400/6 PL/SQL: SQL Statement ignored

     437/5 PL/SQL: ORA-00904: "SERVICE_FACT"."ETL_KEY": invalid identifier

     Warning: Package Body created with compilation errors.

     Errors for PACKAGE BODY PKG_COPY_HIERARCHY:

     LINE/COL ERROR

     -------- -----------------------------------------------------------------

     316/2 PL/SQL: Statement ignored

     316/2 PLS-00905: object OLTP6.PR_COPY_ACCOUNT_WSPACE is invalid