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 Windows

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

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 OLTP database on Windows

1. Go to the migration directory. In the path, EDX_HOME is the Oracle Self-Service E-Billing installation directory.

   EDX_HOME\db\ebilling\oracle\oltp\migration\511_to_6.0

2. Make sure the migrate_oltp_511_to_6.0.sql file exists.
3. Run the userlock.sql command from SQL*Plus, providing the exact path of ORACLE_HOME:

   C:\set ORACLE_SID=oltp

   C:\sqlplus sys/sys_password as sysdba

   SQL> @ ORACLE_HOME\rdbms\admin\userlock.sql

   SQL> exit;

   where:

   • sys_password is the password of the sys user.
   • ORACLE_HOME is the directory where the Oracle database software is installed.
4. Run the migration script migrate_oltp_511_to_6.0.sql:

   C:\set ORACLE_SID=oltp

   C:\sqlplus oltp/oltp

   SQL> @ migrate_oltp_511_to_6.0.sql

   SQL> exit;

5. Verify that there were no errors in the migrate_oltp_511_to_6.0.log file.

   Note that after running the OLTP migration script, migrate_oltp_511_to_6.0.sql, the following error messages appear 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