Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.0.4 > Process of Migrating Oracle Self-Service E-Billing 6.0.1 to 6.0.2 >
Migrating Oracle Self-Service E-Billing Version 6.0.1 OLAP to 6.0.2 on Microsoft Windows
Follow these steps to migrate Oracle Self-Service E-Billing 6.0.1 OLAP to 6.0.2 on Microsoft Windows. This task is a step in Process of Migrating Oracle Self-Service E-Billing 6.0.1 to 6.0.2. To migrate Oracle Self-Service E-Billing 6.0.1 OLAP to 6.0.2 on Microsoft Windows
- Go to the
EDX_HOME \db\ebilling\oracle\olap\migration\ebilling_6.0.1_to_6.0.2 directory, where EDX_HOME is the location where Oracle Self-Service E-Billing is installed.
- Verify that the following files exist:
- migrate_olap_6.0.1_to_6.0.2.sh
- migrate_olap_6.0.1_to_6.0.2.sql
- Create_Procedure.sql
- Version.sql
- Run the following commands from SQL*Plus:
C:\set ORACLE_SID=olap
C:\sqlplus olap/olap
SQL> @ migrate_olap_6.0.1_to_6.0.2.sql
SQL> exit;
- Check the migrate_olap_6.0.1_to_6.0.2.log file for Oracle errors.
- If migrating to Oracle Database 11
g , follow these steps:
- Run the acl.sql script, located in
EDX_HOME \db\ebilling\oracle\olap\etl\packages directory, as follows:
set ORACLE_SID=olap
Sqlplus olap/olap
SQL>acl.sql Mail_Server_Name Lower_Port_of_Mail_Server Upper_Port_of_Mail_Server
SQL>exit
where:
- Mail_Server_Name is the name of your mail server.
- Lower_Port_of_Mail_Server is the lower port number of your mail server.
- Upper_Port_of_Mail_Server is the upper port number of your mail server.
- Check acl.log for errors. Ignore ORA-31003 and ORA-06512.
|