Saturday, October 8, 2016


Step-by-Step Guide to Setting Up and Upgrading Oracle CCB Database with Patching and Schema Enhancements

Oracle’s Customer Care and Billing (CCB) platform is a robust utility solution. This post details a comprehensive process for validating, installing, configuring, and upgrading an Oracle CCB database instance—from validating components to applying patches and running schema upgrades. Whether provisioning a new instance or upgrading to a newer release, this guide will walk you through a tested, real-world workflow.


Step 1  : Check that the Spatial and Oracle Text have been installed with the Database.


SQL> column COMP_NAME format a60
SQL> column STATUS format a60
SQL> SELECT COMP_NAME,STATUS FROM DBA_REGISTRY WHERE COMP_NAME IN ('Spatial','Oracle Text');

COMP_NAME                                                    STATUS
------------------------------------------------------------ ------------------------------------------------------------
Spatial                                                      VALID
Oracle Text                                                  VALID

SQL>

==================================================================

Step 2 Create Tablespace for CCB Schema

==================================================================

We need to create the tablespace and Schema that will be used to store the CCB tables 

SQL> CREATE TABLESPACE CISTS_DATA LOGGING DATAFILE
'/u03/app/oracle/oradata/OMCCB/cists01.dbf' SIZE 10240M REUSE
AUTOEXTEND ON
NEXT 8192K
MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 1M;
  2    3    4    5    6    7


Tablespace created.
============================================================

Step 3 Create the User 's for CCB

=============================================================

CIS_USER – Limited Privilege User

This user is granted restricted access suitable for day-to-day CCB operations that don’t require elevated privileges. Ideal for application-level data modifications.


SQL> CREATE ROLE CIS_USER;

Role created.

CIS_READ – Read-Only Access

This role is used for reporting or monitoring purposes, where users only need to query data without making any changes.

SQL> CREATE ROLE CIS_READ;

Role created.
===
CISADM – Super User / Admin Schema Owner

This is the primary schema owner for the CCB application. It has full administrative rights, including table creation, schema modifications, and patching capabilities

SQL> CREATE USER CISADM IDENTIFIED BY CISADM DEFAULT TABLESPACE CISTS_DATA
TEMPORARY TABLESPACE TEMP PROFILE DEFAULT;  2

User created.

SQL>

SQL> GRANT UNLIMITED TABLESPACE TO CISADM WITH ADMIN OPTION;

Grant succeeded.

SQL> GRANT SELECT ANY TABLE TO CISADM;

Grant succeeded.

SQL> GRANT CREATE DATABASE LINK TO CISADM;

Grant succeeded.

SQL> GRANT CONNECT TO CISADM;

Grant succeeded.

SQL> GRANT RESOURCE TO CISADM;

Grant succeeded.

SQL> GRANT DBA TO CISADM WITH ADMIN OPTION;

Grant succeeded.

SQL> GRANT CREATE ANY SYNONYM TO CISADM;

Grant succeeded.

SQL> GRANT SELECT ANY DICTIONARY TO CISADM;

Grant succeeded.

SQL>
================================================================

 Step 4: Apply  CCB related Database Patches

=================================================================

Provide Patch Parameters:

  • Schema: CISADM

  • DB Connection: <Hostname of the database>:<DB port>:<CCB DB Name>

  • Environment: Production


C:\CCB\FW43010-HFix>SET TOOLSBIN=C:\CCB\database_standalone\bin

C:\CCB\FW43010-HFix>ouafDatabasePatch.cmd
"CMDLINE::: C:\Java\jdk1.7.0_79\bin\java.exe -cp C:\CCB\database_standalone\lib\*;C:\CCB\database_standalone\config com.oracle.ouaf.database.patch.OUAFPatch  "


Enter the target database type (O/M/D) [O]:


Enter the username that owns the schema: CISADM

Enter the password for the CISADM user:


Enter the name of the Oracle Database Connection String: omccb.Domain.com:1533:CCDDB

Target Schema is a Production Schema



Ready to process patches, Do you want to continue? (Y/N): Y

Working Directory: OMCCB001

***********************************

Setting up language file: OMCCB001\CDXPatch.lang
exit value: 0

Applying 21647369 ...

Writing to log file: OMCCB001\log21647369.log



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

--Applying patch 21647369 at 06-09-2016 15:06:02

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


--Copying language information



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

--Patch 21647369 applied successfully at 06-09-2016 15:06:02

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


Applying 21196697 ...

Writing to log file: OMCCB001\log21196697.log



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

--Applying patch 21196697 at 06-09-2016 15:06:02

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


--Copying language information



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

--Patch 21196697 applied successfully at 06-09-2016 15:06:03

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


Applying 21792146 ...

Writing to log file: OMCCB001\log21792146.log



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

--Applying patch 21792146 at 06-09-2016 15:06:03

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


--Copying language information



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

--Patch 21792146 applied successfully at 06-09-2016 15:06:05

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


Patch applied successfully..


C:\CCB\FW43010-HFix>

====================================================================


Step 5 CCB Schema Install and Upgrade in the database 


=====================================================================
execute the OraDBI.exe 

C:\Users\Palane\Downloads\Compressed\New folder\CCB\V78183-01\CCB-V2.5.0.1.0-Oracle-Database-MultiplatForm\CCB\Upgrade\Install-Upgrade>OraDBI.exe


Enter the name of the target database: OMCCB


Enter your database username: CISADM


Enter your password username:

Enter the location for Java Home(e.g. C:\Java\jdk1.6.0_18): C:\Java\jdk1.7.0_79


Enter the TUGBU jarfiles location (e.g.C:\Database-Install\Jarfiles): C:\CCB\jarfiles


Enter the Oracle user with read-write privileges to Database Schema: CISUSER

Enter the Oracle user with read-only privileges to Database Schema: CISREAD


Enter the database role with read-write privileges to Database Schema: CIS_USER

Enter the database role with read-only privileges to Database Schema: CIS_READ

Enter the name of the target Schema where you want to install or upgrade: CISADM
Enter the password for CISADM schema (or hit ENTER to quit):
Re-enter the value:


Connecting to the Target Database as user CISADM
User Name      : CISADM
Database Name  : OMCCB

Ready to upgrade the target database from V2.5.0.1.0 to V2.5.0.1.0, do you want to continue (Y/N)? Y


Executing Database Setup Scripts...


Processing file cdx_bp_crtlog.sql ...


Connecting to the Target Database as user CISADM
User Name      : CISADM
Database Name  : OMCCB


Executing Initialization Scripts...


Processing file CCB230_BPSCHEMA1.SQL ...

Processing file CCB_240_INI_SCH1.SQL ...

Processing file CCB231_BPSCHEMA1.SQL ...

Processing file CCB240_bpschema3.sql ...

Processing file CCB2401_BpSchema1.sql ...

Processing file 24020_C1_BP_BpSchema1.sql ...

Processing file 24020_C1_BP_BpSchema2.SQL ...

Processing file 25010_C1_BP_BpSchema1.SQL ...


Performing Schema Upgrade for CCB...


Running the Schema Upgrade process in the Modification Mode

Connecting to the Target Database
User Name      : CISADM
Database Name  : OMCCB
Schema Name    : CISADM

Setting Current Schema to CISADM
Loading Blueprint
Loading the schema information from the target database
Creating the missing tables
Upgrading the columns
Upgrading indexes
Upgrading Primary Keys
Upgrading the sequences
Upgrading the views
Upgrading the triggers
Schema Upgraded Successfully, Now Exiting


Executing Intermediate Scripts...


Processing file 6683177_RS1.SQL ...

Processing file CCB220_APDATA1.SQL ...

Processing file CCB220_APDATA2.SQL ...

Processing file CCB220_APDATA3.SQL ...

Processing file CDX_AP_INIDATA.SQL ...

Processing file CCB230_APDATA1.SQL ...

Processing file CCB230_APDATA2.SQL ...

Processing file CCB231_APDATA1.SQL ...

Processing file CCB240_APDATA1.SQL ...

Processing file CCB240_APDATA2.SQL ...

Processing file CCB240_APDATA3.SQL ...

Processing file CCB240_APDATA4.SQL ...

Processing file CCB240_appdata_Bld22.sql ...

Processing file 14510546_RS1.sql ...

Processing file CCB240_BP_SCH2.SQL ...

Processing file 24030_BUG_20878127.SQL ...

Processing file 24030_BUG_21165656.SQL ...


Setting Environment ID...



******************************************
Executing the Environment ID Setup Process
******************************************


Connecting to the Target Database ...
User Name      : CISADM
Database Name  : OMCCB
Schema Name    : CISADM

Setting Current Schema to CISADM
The Environment ID of the target database is already set to 200164.

Environment ID Setup Process completed successfully, Now Exiting ...


Auto Delete Upgrade for CCB...


Running Auto System Data Deletion process in Modification Mode

Connecting to the Target Database
User Name      : CISADM
Database Name  : OMCCB
Schema Name    : CISADM

Setting Current Schema to CISADM
Reading Blueprint
Loading CI_ALG_TYPE from the blueprint
Loading CI_ALG_TYPE from the target database
Comparing CI_ALG_TYPE
Loading CI_ALG_TYPE_L from the blueprint
Loading CI_ALG_TYPE_L from the target database
Comparing CI_ALG_TYPE_L
Loading CI_ALG_TYPE_PRM from the blueprint
Loading CI_ALG_TYPE_PRM from the target database
Comparing CI_ALG_TYPE_PRM
Loading CI_ALG_TYPE_PRM_L from the blueprint
Loading CI_ALG_TYPE_PRM_L from the target database
Comparing CI_ALG_TYPE_PRM_L
Loading CI_APP_SVC_ACC from the blueprint
Loading CI_APP_SVC_ACC from the target database
Comparing CI_APP_SVC_ACC
Loading CI_BATCH_CTRL from the blueprint
Loading CI_BATCH_CTRL from the target database
Comparing CI_BATCH_CTRL
Loading CI_BATCH_CTRL_L from the blueprint
Loading CI_BATCH_CTRL_L from the target database
Comparing CI_BATCH_CTRL_L
Loading CI_BATCH_CTRL_ALG from the blueprint
Loading CI_BATCH_CTRL_ALG from the target database
Comparing CI_BATCH_CTRL_ALG
Loading CI_BATCH_CTRL_P from the blueprint
Loading CI_BATCH_CTRL_P from the target database
Comparing CI_BATCH_CTRL_P
Loading CI_BATCH_CTRL_P_L from the blueprint
Loading CI_BATCH_CTRL_P_L from the target database
Comparing CI_BATCH_CTRL_P_L
Loading CI_DISP_ICON from the blueprint
Loading CI_DISP_ICON from the target database
Comparing CI_DISP_ICON
Loading CI_DISP_ICON_L from the blueprint
Loading CI_DISP_ICON_L from the target database
Comparing CI_DISP_ICON_L
Loading CI_FK_REF from the blueprint
Loading CI_FK_REF from the target database
Comparing CI_FK_REF
Loading CI_FK_REF_L from the blueprint
Loading CI_FK_REF_L from the target database
Comparing CI_FK_REF_L
Loading CI_LANGUAGE from the blueprint
Loading CI_LANGUAGE from the target database
Comparing CI_LANGUAGE
Loading CI_LOOKUP_FIELD from the blueprint
Loading CI_LOOKUP_FIELD from the target database
Comparing CI_LOOKUP_FIELD
Loading CI_LOOKUP_VAL from the blueprint
Loading CI_LOOKUP_VAL from the target database
Comparing CI_LOOKUP_VAL
Loading CI_LOOKUP_VAL_L from the blueprint
Loading CI_LOOKUP_VAL_L from the target database
Comparing CI_LOOKUP_VAL_L
Loading CI_MD_CONST from the blueprint
Loading CI_MD_CONST from the target database
Comparing CI_MD_CONST
Loading CI_MD_CONST_FLD from the blueprint
Loading CI_MD_CONST_FLD from the target database
Comparing CI_MD_CONST_FLD
Loading CI_MD_FLD from the blueprint
Loading CI_MD_FLD from the target database
Comparing CI_MD_FLD
Loading CI_MD_FLD_L from the blueprint
Loading CI_MD_FLD_L from the target database
Comparing CI_MD_FLD_L
Loading CI_MD_MENU from the blueprint
Loading CI_MD_MENU from the target database
Comparing CI_MD_MENU
Loading CI_MD_MENU_L from the blueprint
Loading CI_MD_MENU_L from the target database
Comparing CI_MD_MENU_L
Loading CI_MD_MENU_LINE from the blueprint
Loading CI_MD_MENU_LINE from the target database
Comparing CI_MD_MENU_LINE
Loading CI_MD_MENU_LINE_L from the blueprint
Loading CI_MD_MENU_LINE_L from the target database
Comparing CI_MD_MENU_LINE_L
Loading CI_MD_MENU_ITEM from the blueprint
Loading CI_MD_MENU_ITEM from the target database
Comparing CI_MD_MENU_ITEM
Loading CI_MD_MENU_ITEM_L from the blueprint
Loading CI_MD_MENU_ITEM_L from the target database
Comparing CI_MD_MENU_ITEM_L
Loading CI_MD_MENU_IMOD from the blueprint
Loading CI_MD_MENU_IMOD from the target database
Comparing CI_MD_MENU_IMOD
Loading CI_MD_MO from the blueprint
Loading CI_MD_MO from the target database
Comparing CI_MD_MO
Loading CI_MD_MO_L from the blueprint
Loading CI_MD_MO_L from the target database
Comparing CI_MD_MO_L
Loading CI_MD_MO_TBL from the blueprint
Loading CI_MD_MO_TBL from the target database
Comparing CI_MD_MO_TBL
Loading CI_MD_MO_WRK from the blueprint
Loading CI_MD_MO_WRK from the target database
Comparing CI_MD_MO_WRK
Loading CI_MD_MO_OPT from the blueprint
Loading CI_MD_MO_OPT from the target database
Comparing CI_MD_MO_OPT
Loading CI_MD_NAV from the blueprint
Loading CI_MD_NAV from the target database
Comparing CI_MD_NAV
Loading CI_MD_PRG_COM from the blueprint
Loading CI_MD_PRG_COM from the target database
Comparing CI_MD_PRG_COM
Loading CI_MD_PRG_ELEM from the blueprint
Loading CI_MD_PRG_ELEM from the target database
Comparing CI_MD_PRG_ELEM
Loading CI_MD_PRG_EL_AT from the blueprint
Loading CI_MD_PRG_EL_AT from the target database
Comparing CI_MD_PRG_EL_AT
Loading CI_MD_PRG_LOC from the blueprint
Loading CI_MD_PRG_LOC from the target database
Comparing CI_MD_PRG_LOC
Loading CI_MD_PRG_MOD from the blueprint
Loading CI_MD_PRG_MOD from the target database
Comparing CI_MD_PRG_MOD
Loading CI_MD_PRG_SEC from the blueprint
Loading CI_MD_PRG_SEC from the target database
Comparing CI_MD_PRG_SEC
Loading CI_MD_PRG_SQL from the blueprint
Loading CI_MD_PRG_SQL from the target database
Comparing CI_MD_PRG_SQL
Loading CI_MD_PRG_TAB from the blueprint
Loading CI_MD_PRG_TAB from the target database
Comparing CI_MD_PRG_TAB
Loading CI_MD_PRG_VAR from the blueprint
Loading CI_MD_PRG_VAR from the target database
Comparing CI_MD_PRG_VAR
Loading CI_MD_SO from the blueprint
Loading CI_MD_SO from the target database
Comparing CI_MD_SO
Loading CI_MD_SO_L from the blueprint
Loading CI_MD_SO_L from the target database
Comparing CI_MD_SO_L
Loading CI_MD_SO_RSFLD from the blueprint
Loading CI_MD_SO_RSFLD from the target database
Comparing CI_MD_SO_RSFLD
Loading CI_MD_SO_RSFLDAT from the blueprint
Loading CI_MD_SO_RSFLDAT from the target database
Comparing CI_MD_SO_RSFLDAT
Loading CI_MD_SOCG from the blueprint
Loading CI_MD_SOCG from the target database
Comparing CI_MD_SOCG
Loading CI_MD_SOCG_FLD from the blueprint
Loading CI_MD_SOCG_FLD from the target database
Comparing CI_MD_SOCG_FLD
Loading CI_MD_SOCG_FLDAT from the blueprint
Loading CI_MD_SOCG_FLDAT from the target database
Comparing CI_MD_SOCG_FLDAT
Loading CI_MD_SOCG_L from the blueprint
Loading CI_MD_SOCG_L from the target database
Comparing CI_MD_SOCG_L
Loading CI_MD_SOCG_SORT from the blueprint
Loading CI_MD_SOCG_SORT from the target database
Comparing CI_MD_SOCG_SORT
Loading CI_MD_SVC from the blueprint
Loading CI_MD_SVC from the target database
Comparing CI_MD_SVC
Loading CI_MD_SVC_L from the blueprint
Loading CI_MD_SVC_L from the target database
Comparing CI_MD_SVC_L
Loading CI_MD_SVC_PRG from the blueprint
Loading CI_MD_SVC_PRG from the target database
Comparing CI_MD_SVC_PRG
Loading CI_MD_TAB_MOD from the blueprint
Loading CI_MD_TAB_MOD from the target database
Comparing CI_MD_TAB_MOD
Loading CI_MD_TBL from the blueprint
Loading CI_MD_TBL from the target database
Comparing CI_MD_TBL
Loading CI_MD_TBL_FLD from the blueprint
Loading CI_MD_TBL_FLD from the target database
Comparing CI_MD_TBL_FLD
Loading CI_MD_TBL_FLD_L from the blueprint
Loading CI_MD_TBL_FLD_L from the target database
Comparing CI_MD_TBL_FLD_L
Loading CI_MD_TBL_L from the blueprint
Loading CI_MD_TBL_L from the target database
Comparing CI_MD_TBL_L
Loading CI_MD_WRK_TBL from the blueprint
Loading CI_MD_WRK_TBL from the target database
Comparing CI_MD_WRK_TBL
Loading CI_MD_WRK_TBLFLD from the blueprint
Loading CI_MD_WRK_TBLFLD from the target database
Comparing CI_MD_WRK_TBLFLD
Loading CI_MD_WRK_TBL_L from the blueprint
Loading CI_MD_WRK_TBL_L from the target database
Comparing CI_MD_WRK_TBL_L
Loading CI_MSG from the blueprint
Loading CI_MSG from the target database
Comparing CI_MSG
Loading CI_MSG_CATEGORY from the blueprint
Loading CI_MSG_CATEGORY from the target database
Comparing CI_MSG_CATEGORY
Loading CI_MSG_CATEGORY_L from the blueprint
Loading CI_MSG_CATEGORY_L from the target database
Comparing CI_MSG_CATEGORY_L
Loading CI_MSG_L from the blueprint
Loading CI_MSG_L from the target database
Comparing CI_MSG_L
Loading CI_NAV_OPT from the blueprint
Loading CI_NAV_OPT from the target database
Comparing CI_NAV_OPT
Loading CI_NAV_OPT_CTXT from the blueprint
Loading CI_NAV_OPT_CTXT from the target database
Comparing CI_NAV_OPT_CTXT
Loading CI_NAV_OPT_L from the blueprint
Loading CI_NAV_OPT_L from the target database
Comparing CI_NAV_OPT_L
Loading CI_NAV_OPT_USG from the blueprint
Loading CI_NAV_OPT_USG from the target database
Comparing CI_NAV_OPT_USG
Loading CI_PORTAL from the blueprint
Loading CI_PORTAL from the target database
Comparing CI_PORTAL
Loading CI_PORTAL_L from the blueprint
Loading CI_PORTAL_L from the target database
Comparing CI_PORTAL_L
Loading CI_PORTAL_ZONE from the blueprint
Loading CI_PORTAL_ZONE from the target database
Comparing CI_PORTAL_ZONE
Loading CI_TD_DRLKEY_TY from the blueprint
Loading CI_TD_DRLKEY_TY from the target database
Comparing CI_TD_DRLKEY_TY
Loading CI_TD_SRTKEY_TY from the blueprint
Loading CI_TD_SRTKEY_TY from the target database
Comparing CI_TD_SRTKEY_TY
Loading CI_TD_SRTKEY_TY_L from the blueprint
Loading CI_TD_SRTKEY_TY_L from the target database
Comparing CI_TD_SRTKEY_TY_L
Loading CI_TD_TYPE from the blueprint
Loading CI_TD_TYPE from the target database
Comparing CI_TD_TYPE
Loading CI_TD_TYPE_L from the blueprint
Loading CI_TD_TYPE_L from the target database
Comparing CI_TD_TYPE_L
Loading CI_XAI_ADAPTER from the blueprint
Loading CI_XAI_ADAPTER from the target database
Comparing CI_XAI_ADAPTER
Loading CI_XAI_ADAPTER_L from the blueprint
Loading CI_XAI_ADAPTER_L from the target database
Comparing CI_XAI_ADAPTER_L
Loading CI_XAI_CLASS from the blueprint
Loading CI_XAI_CLASS from the target database
Comparing CI_XAI_CLASS
Loading CI_XAI_CLASS_L from the blueprint
Loading CI_XAI_CLASS_L from the target database
Comparing CI_XAI_CLASS_L
Loading CI_XAI_ENV_HNDL from the blueprint
Loading CI_XAI_ENV_HNDL from the target database
Comparing CI_XAI_ENV_HNDL
Loading CI_XAI_ENV_HNDL_L from the blueprint
Loading CI_XAI_ENV_HNDL_L from the target database
Comparing CI_XAI_ENV_HNDL_L
Loading CI_XAI_FORMAT from the blueprint
Loading CI_XAI_FORMAT from the target database
Comparing CI_XAI_FORMAT
Loading CI_XAI_FORMAT_L from the blueprint
Loading CI_XAI_FORMAT_L from the target database
Comparing CI_XAI_FORMAT_L
Loading CI_XAI_IN_SVC from the blueprint
Loading CI_XAI_IN_SVC from the target database
Comparing CI_XAI_IN_SVC
Loading CI_XAI_IN_SVC_L from the blueprint
Loading CI_XAI_IN_SVC_L from the target database
Comparing CI_XAI_IN_SVC_L
Loading CI_XAI_SVC_PARM from the blueprint
Loading CI_XAI_SVC_PARM from the target database
Comparing CI_XAI_SVC_PARM
Loading CI_ZONE from the blueprint
Loading CI_ZONE from the target database
Comparing CI_ZONE
Loading CI_ZONE_L from the blueprint
Loading CI_ZONE_L from the target database
Comparing CI_ZONE_L
Loading CI_ZONE_HDL from the blueprint
Loading CI_ZONE_HDL from the target database
Comparing CI_ZONE_HDL
Loading CI_ZONE_HDL_L from the blueprint
Loading CI_ZONE_HDL_L from the target database
Comparing CI_ZONE_HDL_L
Loading CI_ZONE_HDL_PRM from the blueprint
Loading CI_ZONE_HDL_PRM from the target database
Comparing CI_ZONE_HDL_PRM
Loading CI_ZONE_HDL_PRM_L from the blueprint
Loading CI_ZONE_HDL_PRM_L from the target database
Comparing CI_ZONE_HDL_PRM_L
Loading CI_ZONE_PRM from the blueprint
Loading CI_ZONE_PRM from the target database
Comparing CI_ZONE_PRM
Loading SC_ACCESS_CNTL from the blueprint
Loading SC_ACCESS_CNTL from the target database
Comparing SC_ACCESS_CNTL
Loading SC_APP_SERVICE from the blueprint
Loading SC_APP_SERVICE from the target database
Comparing SC_APP_SERVICE
Loading SC_APP_SERVICE_L from the blueprint
Loading SC_APP_SERVICE_L from the target database
Comparing SC_APP_SERVICE_L
Loading SC_USR_GRP_PROF from the blueprint
Loading SC_USR_GRP_PROF from the target database
Comparing SC_USR_GRP_PROF
Loading F1_MD_DB_OBJ from the blueprint
Loading F1_MD_DB_OBJ from the target database
Comparing F1_MD_DB_OBJ
Loading CI_ALG from the blueprint
Loading CI_ALG from the target database
Comparing CI_ALG
Loading CI_ALG_L from the blueprint
Loading CI_ALG_L from the target database
Comparing CI_ALG_L
Loading CI_ALG_PARM from the blueprint
Loading CI_ALG_PARM from the target database
Comparing CI_ALG_PARM
Loading CI_ALG_VER from the blueprint
Loading CI_ALG_VER from the target database
Comparing CI_ALG_VER
Loading CI_CHAR_ENTITY from the blueprint
Loading CI_CHAR_ENTITY from the target database
Comparing CI_CHAR_ENTITY
Loading CI_CHAR_TYPE from the blueprint
Loading CI_CHAR_TYPE from the target database
Comparing CI_CHAR_TYPE
Loading CI_CHAR_TYPE_L from the blueprint
Loading CI_CHAR_TYPE_L from the target database
Comparing CI_CHAR_TYPE_L
Loading CI_CHAR_VAL from the blueprint
Loading CI_CHAR_VAL from the target database
Comparing CI_CHAR_VAL
Loading CI_CHAR_VAL_L from the blueprint
Loading CI_CHAR_VAL_L from the target database
Comparing CI_CHAR_VAL_L
Loading CI_MD_MO_ALG from the blueprint
Loading CI_MD_MO_ALG from the target database
Comparing CI_MD_MO_ALG
Loading CI_SCR from the blueprint
Loading CI_SCR from the target database
Comparing CI_SCR
Loading CI_SCR_CRT from the blueprint
Loading CI_SCR_CRT from the target database
Comparing CI_SCR_CRT
Loading CI_SCR_CRT_GRP from the blueprint
Loading CI_SCR_CRT_GRP from the target database
Comparing CI_SCR_CRT_GRP
Loading CI_SCR_CRT_GRP_L from the blueprint
Loading CI_SCR_CRT_GRP_L from the target database
Comparing CI_SCR_CRT_GRP_L
Loading CI_SCR_DA from the blueprint
Loading CI_SCR_DA from the target database
Comparing CI_SCR_DA
Loading CI_SCR_FLD_MAP from the blueprint
Loading CI_SCR_FLD_MAP from the target database
Comparing CI_SCR_FLD_MAP
Loading CI_SCR_L from the blueprint
Loading CI_SCR_L from the target database
Comparing CI_SCR_L
Loading CI_SCR_PRMPT from the blueprint
Loading CI_SCR_PRMPT from the target database
Comparing CI_SCR_PRMPT
Loading CI_SCR_PRMPT_L from the blueprint
Loading CI_SCR_PRMPT_L from the target database
Comparing CI_SCR_PRMPT_L
Loading CI_SCR_STEP from the blueprint
Loading CI_SCR_STEP from the target database
Comparing CI_SCR_STEP
Loading CI_SCR_STEP_L from the blueprint
Loading CI_SCR_STEP_L from the target database
Comparing CI_SCR_STEP_L
Loading CI_UI_ZONE from the blueprint
Loading CI_UI_ZONE from the target database
Comparing CI_UI_ZONE
Loading F1_BUS_OBJ from the blueprint
Loading F1_BUS_OBJ from the target database
Comparing F1_BUS_OBJ
Loading F1_BUS_OBJ_ALG from the blueprint
Loading F1_BUS_OBJ_ALG from the target database
Comparing F1_BUS_OBJ_ALG
Loading F1_BUS_OBJ_L from the blueprint
Loading F1_BUS_OBJ_L from the target database
Comparing F1_BUS_OBJ_L
Loading F1_BUS_OBJ_OPT from the blueprint
Loading F1_BUS_OBJ_OPT from the target database
Comparing F1_BUS_OBJ_OPT
Loading F1_BUS_OBJ_STATUS from the blueprint
Loading F1_BUS_OBJ_STATUS from the target database
Comparing F1_BUS_OBJ_STATUS
Loading F1_BUS_OBJ_STATUS_ALG from the blueprint
Loading F1_BUS_OBJ_STATUS_ALG from the target database
Comparing F1_BUS_OBJ_STATUS_ALG
Loading F1_BUS_OBJ_STATUS_L from the blueprint
Loading F1_BUS_OBJ_STATUS_L from the target database
Comparing F1_BUS_OBJ_STATUS_L
Loading F1_BUS_OBJ_STATUS_OPT from the blueprint
Loading F1_BUS_OBJ_STATUS_OPT from the target database
Comparing F1_BUS_OBJ_STATUS_OPT
Loading F1_BUS_OBJ_TR_RULE from the blueprint
Loading F1_BUS_OBJ_TR_RULE from the target database
Comparing F1_BUS_OBJ_TR_RULE
Loading F1_BUS_OBJ_TR_RULE_L from the blueprint
Loading F1_BUS_OBJ_TR_RULE_L from the target database
Comparing F1_BUS_OBJ_TR_RULE_L
Loading F1_BUS_SVC from the blueprint
Loading F1_BUS_SVC from the target database
Comparing F1_BUS_SVC
Loading F1_BUS_SVC_L from the blueprint
Loading F1_BUS_SVC_L from the target database
Comparing F1_BUS_SVC_L
Loading F1_DATA_AREA from the blueprint
Loading F1_DATA_AREA from the target database
Comparing F1_DATA_AREA
Loading F1_DATA_AREA_L from the blueprint
Loading F1_DATA_AREA_L from the target database
Comparing F1_DATA_AREA_L
Loading F1_MAP from the blueprint
Loading F1_MAP from the target database
Comparing F1_MAP
Loading F1_MAP_L from the blueprint
Loading F1_MAP_L from the target database
Comparing F1_MAP_L
Loading F1_SCHEMA from the blueprint
Loading F1_SCHEMA from the target database
Comparing F1_SCHEMA
Loading F1_MANAG_CONTENT from the blueprint
Loading F1_MANAG_CONTENT from the target database
Comparing F1_MANAG_CONTENT
Loading F1_MANAG_CONTENT_L from the blueprint
Loading F1_MANAG_CONTENT_L from the target database
Comparing F1_MANAG_CONTENT_L
Loading F1_BUS_OBJ_STATUS_RSN from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN from the target database
Comparing F1_BUS_OBJ_STATUS_RSN
Loading F1_BUS_OBJ_STATUS_RSN_L from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN_L from the target database
Comparing F1_BUS_OBJ_STATUS_RSN_L
Loading F1_BUS_OBJ_STATUS_RSN_CHAR from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN_CHAR from the target database
Comparing F1_BUS_OBJ_STATUS_RSN_CHAR
Loading F1_EXT_LOOKUP_VAL from the blueprint
Loading F1_EXT_LOOKUP_VAL from the target database
Comparing F1_EXT_LOOKUP_VAL
Loading F1_EXT_LOOKUP_VAL_L from the blueprint
Loading F1_EXT_LOOKUP_VAL_L from the target database
Comparing F1_EXT_LOOKUP_VAL_L
Loading F1_DB_OBJECTS_REPO from the blueprint
Loading F1_DB_OBJECTS_REPO from the target database
Comparing F1_DB_OBJECTS_REPO
Loading F1_MIGR_PLAN from the blueprint
Loading F1_MIGR_PLAN from the target database
Comparing F1_MIGR_PLAN
Loading F1_MIGR_PLAN_L from the blueprint
Loading F1_MIGR_PLAN_L from the target database
Comparing F1_MIGR_PLAN_L
Loading F1_MIGR_PLAN_INSTR from the blueprint
Loading F1_MIGR_PLAN_INSTR from the target database
Comparing F1_MIGR_PLAN_INSTR
Loading F1_MIGR_PLAN_INSTR_L from the blueprint
Loading F1_MIGR_PLAN_INSTR_L from the target database
Comparing F1_MIGR_PLAN_INSTR_L
Loading F1_MIGR_PLAN_INSTR_ALG from the blueprint
Loading F1_MIGR_PLAN_INSTR_ALG from the target database
Comparing F1_MIGR_PLAN_INSTR_ALG
Loading F1_MIGR_REQ from the blueprint
Loading F1_MIGR_REQ from the target database
Comparing F1_MIGR_REQ
Loading F1_MIGR_REQ_L from the blueprint
Loading F1_MIGR_REQ_L from the target database
Comparing F1_MIGR_REQ_L
Loading F1_MIGR_REQ_INSTR from the blueprint
Loading F1_MIGR_REQ_INSTR from the target database
Comparing F1_MIGR_REQ_INSTR
Loading F1_MIGR_REQ_INSTR_L from the blueprint
Loading F1_MIGR_REQ_INSTR_L from the target database
Comparing F1_MIGR_REQ_INSTR_L
Loading F1_MIGR_REQ_INSTR_ENTITY from the blueprint
Loading F1_MIGR_REQ_INSTR_ENTITY from the target database
Comparing F1_MIGR_REQ_INSTR_ENTITY
Loading F1_IWS_SVC_L from the blueprint
Loading F1_IWS_SVC_L from the target database
Comparing F1_IWS_SVC_L
Loading F1_IWS_SVC from the blueprint
Loading F1_IWS_SVC from the target database
Comparing F1_IWS_SVC
Loading F1_IWS_SVC_OPER_L from the blueprint
Loading F1_IWS_SVC_OPER_L from the target database
Comparing F1_IWS_SVC_OPER_L
Loading F1_IWS_SVC_OPER from the blueprint
Loading F1_IWS_SVC_OPER from the target database
Comparing F1_IWS_SVC_OPER
Loading F1_IWS_ANN_L from the blueprint
Loading F1_IWS_ANN_L from the target database
Comparing F1_IWS_ANN_L
Loading F1_IWS_ANN_PARM from the blueprint
Loading F1_IWS_ANN_PARM from the target database
Comparing F1_IWS_ANN_PARM
Loading F1_IWS_ANN from the blueprint
Loading F1_IWS_ANN from the target database
Comparing F1_IWS_ANN
Loading F1_IWS_ANN_TYPE_PARM_L from the blueprint
Loading F1_IWS_ANN_TYPE_PARM_L from the target database
Comparing F1_IWS_ANN_TYPE_PARM_L
Loading F1_IWS_ANN_TYPE_L from the blueprint
Loading F1_IWS_ANN_TYPE_L from the target database
Comparing F1_IWS_ANN_TYPE_L
Loading F1_IWS_ANN_TYPE from the blueprint
Loading F1_IWS_ANN_TYPE from the target database
Comparing F1_IWS_ANN_TYPE
Loading F1_IWS_ANN_TYPE_PARM from the blueprint
Loading F1_IWS_ANN_TYPE_PARM from the target database
Comparing F1_IWS_ANN_TYPE_PARM
Loading CI_PORTAL_OPT from the blueprint
Loading CI_PORTAL_OPT from the target database
Comparing CI_PORTAL_OPT
Loading F1_EXT_LOOKUP_VAL_CHAR from the blueprint
Loading F1_EXT_LOOKUP_VAL_CHAR from the target database
Comparing F1_EXT_LOOKUP_VAL_CHAR
Upgrading Database
Pass:1
Auto System Data Deletion Process Executed Successfully, Now Exiting


Performing English System Data Upgrade for CCB...


Running System Data Upgrade process in Modification Mode

Connecting to the Target Database
User Name      : CISADM
Database Name  : OMCCB
Schema  Name   : CISADM

Setting Current Schema to CISADM
Reading Blueprint
Loading CI_CURRENCY_CD from the blueprint
Loading CI_CURRENCY_CD from the target database
Comparing CI_CURRENCY_CD
Loading CI_CURRENCY_CD_L from the blueprint
Loading CI_CURRENCY_CD_L from the target database
Comparing CI_CURRENCY_CD_L
Loading CI_DISP_PROF from the blueprint
Loading CI_DISP_PROF from the target database
Comparing CI_DISP_PROF
Loading CI_DISP_PROF_L from the blueprint
Loading CI_DISP_PROF_L from the target database
Comparing CI_DISP_PROF_L
Loading CI_USR_PORTAL from the blueprint
Loading CI_USR_PORTAL from the target database
Comparing CI_USR_PORTAL
Loading CI_XAI_RCVR from the blueprint
Loading CI_XAI_RCVR from the target database
Comparing CI_XAI_RCVR
Loading CI_XAI_RCVR_CTX from the blueprint
Loading CI_XAI_RCVR_CTX from the target database
Comparing CI_XAI_RCVR_CTX
Loading CI_XAI_RCVR_L from the blueprint
Loading CI_XAI_RCVR_L from the target database
Comparing CI_XAI_RCVR_L
Loading CI_XAI_RCVR_RGRP from the blueprint
Loading CI_XAI_RCVR_RGRP from the target database
Comparing CI_XAI_RCVR_RGRP
Loading CI_XAI_RCVR_RSP from the blueprint
Loading CI_XAI_RCVR_RSP from the target database
Comparing CI_XAI_RCVR_RSP
Loading CI_XAI_SENDER from the blueprint
Loading CI_XAI_SENDER from the target database
Comparing CI_XAI_SENDER
Loading CI_XAI_SENDER_L from the blueprint
Loading CI_XAI_SENDER_L from the target database
Comparing CI_XAI_SENDER_L
Loading CI_XAI_SNDR_CTX from the blueprint
Loading CI_XAI_SNDR_CTX from the target database
Comparing CI_XAI_SNDR_CTX
Loading CI_XAI_OPTION from the blueprint
Loading CI_XAI_OPTION from the target database
Comparing CI_XAI_OPTION
Loading SC_USER_GROUP from the blueprint
Loading SC_USER_GROUP from the target database
Comparing SC_USER_GROUP
Loading SC_USER_GROUP_L from the blueprint
Loading SC_USER_GROUP_L from the target database
Comparing SC_USER_GROUP_L
Loading SC_USR_GRP_USR from the blueprint
Loading SC_USR_GRP_USR from the target database
Comparing SC_USR_GRP_USR
Loading CI_ALG_TYPE from the blueprint
Loading CI_ALG_TYPE from the target database
Comparing CI_ALG_TYPE
Loading CI_ALG_TYPE_L from the blueprint
Loading CI_ALG_TYPE_L from the target database
Comparing CI_ALG_TYPE_L
Loading CI_ALG_TYPE_PRM from the blueprint
Loading CI_ALG_TYPE_PRM from the target database
Comparing CI_ALG_TYPE_PRM
Loading CI_ALG_TYPE_PRM_L from the blueprint
Loading CI_ALG_TYPE_PRM_L from the target database
Comparing CI_ALG_TYPE_PRM_L
Loading CI_APP_SVC_ACC from the blueprint
Loading CI_APP_SVC_ACC from the target database
Comparing CI_APP_SVC_ACC
Loading CI_BATCH_CTRL from the blueprint
Loading CI_BATCH_CTRL from the target database
Comparing CI_BATCH_CTRL
Loading CI_BATCH_CTRL_L from the blueprint
Loading CI_BATCH_CTRL_L from the target database
Comparing CI_BATCH_CTRL_L
Loading CI_BATCH_CTRL_ALG from the blueprint
Loading CI_BATCH_CTRL_ALG from the target database
Comparing CI_BATCH_CTRL_ALG
Loading CI_BATCH_CTRL_P from the blueprint
Loading CI_BATCH_CTRL_P from the target database
Comparing CI_BATCH_CTRL_P
Loading CI_BATCH_CTRL_P_L from the blueprint
Loading CI_BATCH_CTRL_P_L from the target database
Comparing CI_BATCH_CTRL_P_L
Loading CI_DISP_ICON from the blueprint
Loading CI_DISP_ICON from the target database
Comparing CI_DISP_ICON
Loading CI_DISP_ICON_L from the blueprint
Loading CI_DISP_ICON_L from the target database
Comparing CI_DISP_ICON_L
Loading CI_FK_REF from the blueprint
Loading CI_FK_REF from the target database
Comparing CI_FK_REF
Loading CI_FK_REF_L from the blueprint
Loading CI_FK_REF_L from the target database
Comparing CI_FK_REF_L
Loading CI_LANGUAGE from the blueprint
Loading CI_LANGUAGE from the target database
Comparing CI_LANGUAGE
Loading CI_LOOKUP_FIELD from the blueprint
Loading CI_LOOKUP_FIELD from the target database
Comparing CI_LOOKUP_FIELD
Loading CI_LOOKUP_VAL from the blueprint
Loading CI_LOOKUP_VAL from the target database
Comparing CI_LOOKUP_VAL
Loading CI_LOOKUP_VAL_L from the blueprint
Loading CI_LOOKUP_VAL_L from the target database
Comparing CI_LOOKUP_VAL_L
Loading CI_MD_CONST from the blueprint
Loading CI_MD_CONST from the target database
Comparing CI_MD_CONST
Loading CI_MD_CONST_FLD from the blueprint
Loading CI_MD_CONST_FLD from the target database
Comparing CI_MD_CONST_FLD
Loading CI_MD_FLD from the blueprint
Loading CI_MD_FLD from the target database
Comparing CI_MD_FLD
Loading CI_MD_FLD_L from the blueprint
Loading CI_MD_FLD_L from the target database
Comparing CI_MD_FLD_L
Loading CI_MD_MENU from the blueprint
Loading CI_MD_MENU from the target database
Comparing CI_MD_MENU
Loading CI_MD_MENU_L from the blueprint
Loading CI_MD_MENU_L from the target database
Comparing CI_MD_MENU_L
Loading CI_MD_MENU_LINE from the blueprint
Loading CI_MD_MENU_LINE from the target database
Comparing CI_MD_MENU_LINE
Loading CI_MD_MENU_LINE_L from the blueprint
Loading CI_MD_MENU_LINE_L from the target database
Comparing CI_MD_MENU_LINE_L
Loading CI_MD_MENU_ITEM from the blueprint
Loading CI_MD_MENU_ITEM from the target database
Comparing CI_MD_MENU_ITEM
Loading CI_MD_MENU_ITEM_L from the blueprint
Loading CI_MD_MENU_ITEM_L from the target database
Comparing CI_MD_MENU_ITEM_L
Loading CI_MD_MENU_IMOD from the blueprint
Loading CI_MD_MENU_IMOD from the target database
Comparing CI_MD_MENU_IMOD
Loading CI_MD_MO from the blueprint
Loading CI_MD_MO from the target database
Comparing CI_MD_MO
Loading CI_MD_MO_L from the blueprint
Loading CI_MD_MO_L from the target database
Comparing CI_MD_MO_L
Loading CI_MD_MO_TBL from the blueprint
Loading CI_MD_MO_TBL from the target database
Comparing CI_MD_MO_TBL
Loading CI_MD_MO_WRK from the blueprint
Loading CI_MD_MO_WRK from the target database
Comparing CI_MD_MO_WRK
Loading CI_MD_MO_OPT from the blueprint
Loading CI_MD_MO_OPT from the target database
Comparing CI_MD_MO_OPT
Loading CI_MD_NAV from the blueprint
Loading CI_MD_NAV from the target database
Comparing CI_MD_NAV
Loading CI_MD_PRG_COM from the blueprint
Loading CI_MD_PRG_COM from the target database
Comparing CI_MD_PRG_COM
Loading CI_MD_PRG_ELEM from the blueprint
Loading CI_MD_PRG_ELEM from the target database
Comparing CI_MD_PRG_ELEM
Loading CI_MD_PRG_EL_AT from the blueprint
Loading CI_MD_PRG_EL_AT from the target database
Comparing CI_MD_PRG_EL_AT
Loading CI_MD_PRG_LOC from the blueprint
Loading CI_MD_PRG_LOC from the target database
Comparing CI_MD_PRG_LOC
Loading CI_MD_PRG_MOD from the blueprint
Loading CI_MD_PRG_MOD from the target database
Comparing CI_MD_PRG_MOD
Loading CI_MD_PRG_SEC from the blueprint
Loading CI_MD_PRG_SEC from the target database
Comparing CI_MD_PRG_SEC
Loading CI_MD_PRG_SQL from the blueprint
Loading CI_MD_PRG_SQL from the target database
Comparing CI_MD_PRG_SQL
Loading CI_MD_PRG_TAB from the blueprint
Loading CI_MD_PRG_TAB from the target database
Comparing CI_MD_PRG_TAB
Loading CI_MD_PRG_VAR from the blueprint
Loading CI_MD_PRG_VAR from the target database
Comparing CI_MD_PRG_VAR
Loading CI_MD_SO from the blueprint
Loading CI_MD_SO from the target database
Comparing CI_MD_SO
Loading CI_MD_SO_L from the blueprint
Loading CI_MD_SO_L from the target database
Comparing CI_MD_SO_L
Loading CI_MD_SO_RSFLD from the blueprint
Loading CI_MD_SO_RSFLD from the target database
Comparing CI_MD_SO_RSFLD
Loading CI_MD_SO_RSFLDAT from the blueprint
Loading CI_MD_SO_RSFLDAT from the target database
Comparing CI_MD_SO_RSFLDAT
Loading CI_MD_SOCG from the blueprint
Loading CI_MD_SOCG from the target database
Comparing CI_MD_SOCG
Loading CI_MD_SOCG_FLD from the blueprint
Loading CI_MD_SOCG_FLD from the target database
Comparing CI_MD_SOCG_FLD
Loading CI_MD_SOCG_FLDAT from the blueprint
Loading CI_MD_SOCG_FLDAT from the target database
Comparing CI_MD_SOCG_FLDAT
Loading CI_MD_SOCG_L from the blueprint
Loading CI_MD_SOCG_L from the target database
Comparing CI_MD_SOCG_L
Loading CI_MD_SOCG_SORT from the blueprint
Loading CI_MD_SOCG_SORT from the target database
Comparing CI_MD_SOCG_SORT
Loading CI_MD_SVC from the blueprint
Loading CI_MD_SVC from the target database
Comparing CI_MD_SVC
Loading CI_MD_SVC_L from the blueprint
Loading CI_MD_SVC_L from the target database
Comparing CI_MD_SVC_L
Loading CI_MD_SVC_PRG from the blueprint
Loading CI_MD_SVC_PRG from the target database
Comparing CI_MD_SVC_PRG
Loading CI_MD_TAB_MOD from the blueprint
Loading CI_MD_TAB_MOD from the target database
Comparing CI_MD_TAB_MOD
Loading CI_MD_TBL from the blueprint
Loading CI_MD_TBL from the target database
Comparing CI_MD_TBL
Loading CI_MD_TBL_FLD from the blueprint
Loading CI_MD_TBL_FLD from the target database
Comparing CI_MD_TBL_FLD
Loading CI_MD_TBL_FLD_L from the blueprint
Loading CI_MD_TBL_FLD_L from the target database
Comparing CI_MD_TBL_FLD_L
Loading CI_MD_TBL_L from the blueprint
Loading CI_MD_TBL_L from the target database
Comparing CI_MD_TBL_L
Loading CI_MD_WRK_TBL from the blueprint
Loading CI_MD_WRK_TBL from the target database
Comparing CI_MD_WRK_TBL
Loading CI_MD_WRK_TBLFLD from the blueprint
Loading CI_MD_WRK_TBLFLD from the target database
Comparing CI_MD_WRK_TBLFLD
Loading CI_MD_WRK_TBL_L from the blueprint
Loading CI_MD_WRK_TBL_L from the target database
Comparing CI_MD_WRK_TBL_L
Loading CI_MSG from the blueprint
Loading CI_MSG from the target database
Comparing CI_MSG
Loading CI_MSG_CATEGORY from the blueprint
Loading CI_MSG_CATEGORY from the target database
Comparing CI_MSG_CATEGORY
Loading CI_MSG_CATEGORY_L from the blueprint
Loading CI_MSG_CATEGORY_L from the target database
Comparing CI_MSG_CATEGORY_L
Loading CI_MSG_L from the blueprint
Loading CI_MSG_L from the target database
Comparing CI_MSG_L
Loading CI_NAV_OPT from the blueprint
Loading CI_NAV_OPT from the target database
Comparing CI_NAV_OPT
Loading CI_NAV_OPT_CTXT from the blueprint
Loading CI_NAV_OPT_CTXT from the target database
Comparing CI_NAV_OPT_CTXT
Loading CI_NAV_OPT_L from the blueprint
Loading CI_NAV_OPT_L from the target database
Comparing CI_NAV_OPT_L
Loading CI_NAV_OPT_USG from the blueprint
Loading CI_NAV_OPT_USG from the target database
Comparing CI_NAV_OPT_USG
Loading CI_PORTAL from the blueprint
Loading CI_PORTAL from the target database
Comparing CI_PORTAL
Loading CI_PORTAL_L from the blueprint
Loading CI_PORTAL_L from the target database
Comparing CI_PORTAL_L
Loading CI_PORTAL_ZONE from the blueprint
Loading CI_PORTAL_ZONE from the target database
Comparing CI_PORTAL_ZONE
Loading CI_TD_DRLKEY_TY from the blueprint
Loading CI_TD_DRLKEY_TY from the target database
Comparing CI_TD_DRLKEY_TY
Loading CI_TD_SRTKEY_TY from the blueprint
Loading CI_TD_SRTKEY_TY from the target database
Comparing CI_TD_SRTKEY_TY
Loading CI_TD_SRTKEY_TY_L from the blueprint
Loading CI_TD_SRTKEY_TY_L from the target database
Comparing CI_TD_SRTKEY_TY_L
Loading CI_TD_TYPE from the blueprint
Loading CI_TD_TYPE from the target database
Comparing CI_TD_TYPE
Loading CI_TD_TYPE_L from the blueprint
Loading CI_TD_TYPE_L from the target database
Comparing CI_TD_TYPE_L
Loading CI_XAI_ADAPTER from the blueprint
Loading CI_XAI_ADAPTER from the target database
Comparing CI_XAI_ADAPTER
Loading CI_XAI_ADAPTER_L from the blueprint
Loading CI_XAI_ADAPTER_L from the target database
Comparing CI_XAI_ADAPTER_L
Loading CI_XAI_CLASS from the blueprint
Loading CI_XAI_CLASS from the target database
Comparing CI_XAI_CLASS
Loading CI_XAI_CLASS_L from the blueprint
Loading CI_XAI_CLASS_L from the target database
Comparing CI_XAI_CLASS_L
Loading CI_XAI_ENV_HNDL from the blueprint
Loading CI_XAI_ENV_HNDL from the target database
Comparing CI_XAI_ENV_HNDL
Loading CI_XAI_ENV_HNDL_L from the blueprint
Loading CI_XAI_ENV_HNDL_L from the target database
Comparing CI_XAI_ENV_HNDL_L
Loading CI_XAI_FORMAT from the blueprint
Loading CI_XAI_FORMAT from the target database
Comparing CI_XAI_FORMAT
Loading CI_XAI_FORMAT_L from the blueprint
Loading CI_XAI_FORMAT_L from the target database
Comparing CI_XAI_FORMAT_L
Loading CI_XAI_IN_SVC from the blueprint
Loading CI_XAI_IN_SVC from the target database
Comparing CI_XAI_IN_SVC
Loading CI_XAI_IN_SVC_L from the blueprint
Loading CI_XAI_IN_SVC_L from the target database
Comparing CI_XAI_IN_SVC_L
Loading CI_XAI_SVC_PARM from the blueprint
Loading CI_XAI_SVC_PARM from the target database
Comparing CI_XAI_SVC_PARM
Loading CI_ZONE from the blueprint
Loading CI_ZONE from the target database
Comparing CI_ZONE
Loading CI_ZONE_L from the blueprint
Loading CI_ZONE_L from the target database
Comparing CI_ZONE_L
Loading CI_ZONE_HDL from the blueprint
Loading CI_ZONE_HDL from the target database
Comparing CI_ZONE_HDL
Loading CI_ZONE_HDL_L from the blueprint
Loading CI_ZONE_HDL_L from the target database
Comparing CI_ZONE_HDL_L
Loading CI_ZONE_HDL_PRM from the blueprint
Loading CI_ZONE_HDL_PRM from the target database
Comparing CI_ZONE_HDL_PRM
Loading CI_ZONE_HDL_PRM_L from the blueprint
Loading CI_ZONE_HDL_PRM_L from the target database
Comparing CI_ZONE_HDL_PRM_L
Loading CI_ZONE_PRM from the blueprint
Loading CI_ZONE_PRM from the target database
Comparing CI_ZONE_PRM
Loading SC_ACCESS_CNTL from the blueprint
Loading SC_ACCESS_CNTL from the target database
Comparing SC_ACCESS_CNTL
Loading SC_APP_SERVICE from the blueprint
Loading SC_APP_SERVICE from the target database
Comparing SC_APP_SERVICE
Loading SC_APP_SERVICE_L from the blueprint
Loading SC_APP_SERVICE_L from the target database
Comparing SC_APP_SERVICE_L
Loading SC_USR_GRP_PROF from the blueprint
Loading SC_USR_GRP_PROF from the target database
Comparing SC_USR_GRP_PROF
Loading F1_MD_DB_OBJ from the blueprint
Loading F1_MD_DB_OBJ from the target database
Comparing F1_MD_DB_OBJ
Loading CI_ALG from the blueprint
Loading CI_ALG from the target database
Comparing CI_ALG
Loading CI_ALG_L from the blueprint
Loading CI_ALG_L from the target database
Comparing CI_ALG_L
Loading CI_ALG_PARM from the blueprint
Loading CI_ALG_PARM from the target database
Comparing CI_ALG_PARM
Loading CI_ALG_VER from the blueprint
Loading CI_ALG_VER from the target database
Comparing CI_ALG_VER
Loading CI_CHAR_ENTITY from the blueprint
Loading CI_CHAR_ENTITY from the target database
Comparing CI_CHAR_ENTITY
Loading CI_CHAR_TYPE from the blueprint
Loading CI_CHAR_TYPE from the target database
Comparing CI_CHAR_TYPE
Loading CI_CHAR_TYPE_L from the blueprint
Loading CI_CHAR_TYPE_L from the target database
Comparing CI_CHAR_TYPE_L
Loading CI_CHAR_VAL from the blueprint
Loading CI_CHAR_VAL from the target database
Comparing CI_CHAR_VAL
Loading CI_CHAR_VAL_L from the blueprint
Loading CI_CHAR_VAL_L from the target database
Comparing CI_CHAR_VAL_L
Loading CI_MD_MO_ALG from the blueprint
Loading CI_MD_MO_ALG from the target database
Comparing CI_MD_MO_ALG
Loading CI_SCR from the blueprint
Loading CI_SCR from the target database
Comparing CI_SCR
Loading CI_SCR_CRT from the blueprint
Loading CI_SCR_CRT from the target database
Comparing CI_SCR_CRT
Loading CI_SCR_CRT_GRP from the blueprint
Loading CI_SCR_CRT_GRP from the target database
Comparing CI_SCR_CRT_GRP
Loading CI_SCR_CRT_GRP_L from the blueprint
Loading CI_SCR_CRT_GRP_L from the target database
Comparing CI_SCR_CRT_GRP_L
Loading CI_SCR_DA from the blueprint
Loading CI_SCR_DA from the target database
Comparing CI_SCR_DA
Loading CI_SCR_FLD_MAP from the blueprint
Loading CI_SCR_FLD_MAP from the target database
Comparing CI_SCR_FLD_MAP
Loading CI_SCR_L from the blueprint
Loading CI_SCR_L from the target database
Comparing CI_SCR_L
Loading CI_SCR_PRMPT from the blueprint
Loading CI_SCR_PRMPT from the target database
Comparing CI_SCR_PRMPT
Loading CI_SCR_PRMPT_L from the blueprint
Loading CI_SCR_PRMPT_L from the target database
Comparing CI_SCR_PRMPT_L
Loading CI_SCR_STEP from the blueprint
Loading CI_SCR_STEP from the target database
Comparing CI_SCR_STEP
Loading CI_SCR_STEP_L from the blueprint
Loading CI_SCR_STEP_L from the target database
Comparing CI_SCR_STEP_L
Loading CI_UI_ZONE from the blueprint
Loading CI_UI_ZONE from the target database
Comparing CI_UI_ZONE
Loading F1_BUS_OBJ from the blueprint
Loading F1_BUS_OBJ from the target database
Comparing F1_BUS_OBJ
Loading F1_BUS_OBJ_ALG from the blueprint
Loading F1_BUS_OBJ_ALG from the target database
Comparing F1_BUS_OBJ_ALG
Loading F1_BUS_OBJ_L from the blueprint
Loading F1_BUS_OBJ_L from the target database
Comparing F1_BUS_OBJ_L
Loading F1_BUS_OBJ_OPT from the blueprint
Loading F1_BUS_OBJ_OPT from the target database
Comparing F1_BUS_OBJ_OPT
Loading F1_BUS_OBJ_STATUS from the blueprint
Loading F1_BUS_OBJ_STATUS from the target database
Comparing F1_BUS_OBJ_STATUS
Loading F1_BUS_OBJ_STATUS_ALG from the blueprint
Loading F1_BUS_OBJ_STATUS_ALG from the target database
Comparing F1_BUS_OBJ_STATUS_ALG
Loading F1_BUS_OBJ_STATUS_L from the blueprint
Loading F1_BUS_OBJ_STATUS_L from the target database
Comparing F1_BUS_OBJ_STATUS_L
Loading F1_BUS_OBJ_STATUS_OPT from the blueprint
Loading F1_BUS_OBJ_STATUS_OPT from the target database
Comparing F1_BUS_OBJ_STATUS_OPT
Loading F1_BUS_OBJ_TR_RULE from the blueprint
Loading F1_BUS_OBJ_TR_RULE from the target database
Comparing F1_BUS_OBJ_TR_RULE
Loading F1_BUS_OBJ_TR_RULE_L from the blueprint
Loading F1_BUS_OBJ_TR_RULE_L from the target database
Comparing F1_BUS_OBJ_TR_RULE_L
Loading F1_BUS_SVC from the blueprint
Loading F1_BUS_SVC from the target database
Comparing F1_BUS_SVC
Loading F1_BUS_SVC_L from the blueprint
Loading F1_BUS_SVC_L from the target database
Comparing F1_BUS_SVC_L
Loading F1_DATA_AREA from the blueprint
Loading F1_DATA_AREA from the target database
Comparing F1_DATA_AREA
Loading F1_DATA_AREA_L from the blueprint
Loading F1_DATA_AREA_L from the target database
Comparing F1_DATA_AREA_L
Loading F1_MAP from the blueprint
Loading F1_MAP from the target database
Comparing F1_MAP
Loading F1_MAP_L from the blueprint
Loading F1_MAP_L from the target database
Comparing F1_MAP_L
Loading F1_SCHEMA from the blueprint
Loading F1_SCHEMA from the target database
Comparing F1_SCHEMA
Loading F1_MANAG_CONTENT from the blueprint
Loading F1_MANAG_CONTENT from the target database
Comparing F1_MANAG_CONTENT
Loading F1_MANAG_CONTENT_L from the blueprint
Loading F1_MANAG_CONTENT_L from the target database
Comparing F1_MANAG_CONTENT_L
Loading F1_BUS_OBJ_STATUS_RSN from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN from the target database
Comparing F1_BUS_OBJ_STATUS_RSN
Loading F1_BUS_OBJ_STATUS_RSN_L from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN_L from the target database
Comparing F1_BUS_OBJ_STATUS_RSN_L
Loading F1_BUS_OBJ_STATUS_RSN_CHAR from the blueprint
Loading F1_BUS_OBJ_STATUS_RSN_CHAR from the target database
Comparing F1_BUS_OBJ_STATUS_RSN_CHAR
Loading F1_EXT_LOOKUP_VAL from the blueprint
Loading F1_EXT_LOOKUP_VAL from the target database
Comparing F1_EXT_LOOKUP_VAL
Loading F1_EXT_LOOKUP_VAL_L from the blueprint
Loading F1_EXT_LOOKUP_VAL_L from the target database
Comparing F1_EXT_LOOKUP_VAL_L
Loading F1_DB_OBJECTS_REPO from the blueprint
Loading F1_DB_OBJECTS_REPO from the target database
Comparing F1_DB_OBJECTS_REPO
Loading F1_MIGR_PLAN from the blueprint
Loading F1_MIGR_PLAN from the target database
Comparing F1_MIGR_PLAN
Loading F1_MIGR_PLAN_L from the blueprint
Loading F1_MIGR_PLAN_L from the target database
Comparing F1_MIGR_PLAN_L
Loading F1_MIGR_PLAN_INSTR from the blueprint
Loading F1_MIGR_PLAN_INSTR from the target database
Comparing F1_MIGR_PLAN_INSTR
Loading F1_MIGR_PLAN_INSTR_L from the blueprint
Loading F1_MIGR_PLAN_INSTR_L from the target database
Comparing F1_MIGR_PLAN_INSTR_L
Loading F1_MIGR_PLAN_INSTR_ALG from the blueprint
Loading F1_MIGR_PLAN_INSTR_ALG from the target database
Comparing F1_MIGR_PLAN_INSTR_ALG
Loading F1_MIGR_REQ from the blueprint
Loading F1_MIGR_REQ from the target database
Comparing F1_MIGR_REQ
Loading F1_MIGR_REQ_L from the blueprint
Loading F1_MIGR_REQ_L from the target database
Comparing F1_MIGR_REQ_L
Loading F1_MIGR_REQ_INSTR from the blueprint
Loading F1_MIGR_REQ_INSTR from the target database
Comparing F1_MIGR_REQ_INSTR
Loading F1_MIGR_REQ_INSTR_L from the blueprint
Loading F1_MIGR_REQ_INSTR_L from the target database
Comparing F1_MIGR_REQ_INSTR_L
Loading F1_MIGR_REQ_INSTR_ENTITY from the blueprint
Loading F1_MIGR_REQ_INSTR_ENTITY from the target database
Comparing F1_MIGR_REQ_INSTR_ENTITY
Loading F1_IWS_SVC_L from the blueprint
Loading F1_IWS_SVC_L from the target database
Comparing F1_IWS_SVC_L
Loading F1_IWS_SVC from the blueprint
Loading F1_IWS_SVC from the target database
Comparing F1_IWS_SVC
Loading F1_IWS_SVC_OPER_L from the blueprint
Loading F1_IWS_SVC_OPER_L from the target database
Comparing F1_IWS_SVC_OPER_L
Loading F1_IWS_SVC_OPER from the blueprint
Loading F1_IWS_SVC_OPER from the target database
Comparing F1_IWS_SVC_OPER
Loading F1_IWS_ANN_L from the blueprint
Loading F1_IWS_ANN_L from the target database
Comparing F1_IWS_ANN_L
Loading F1_IWS_ANN_PARM from the blueprint
Loading F1_IWS_ANN_PARM from the target database
Comparing F1_IWS_ANN_PARM
Loading F1_IWS_ANN from the blueprint
Loading F1_IWS_ANN from the target database
Comparing F1_IWS_ANN
Loading F1_IWS_ANN_TYPE_L from the blueprint
Loading F1_IWS_ANN_TYPE_L from the target database
Comparing F1_IWS_ANN_TYPE_L
Loading F1_IWS_ANN_TYPE from the blueprint
Loading F1_IWS_ANN_TYPE from the target database
Comparing F1_IWS_ANN_TYPE
Loading F1_IWS_ANN_TYPE_PARM from the blueprint
Loading F1_IWS_ANN_TYPE_PARM from the target database
Comparing F1_IWS_ANN_TYPE_PARM
Loading F1_IWS_ANN_TYPE_PARM_L from the blueprint
Loading F1_IWS_ANN_TYPE_PARM_L from the target database
Comparing F1_IWS_ANN_TYPE_PARM_L
Loading CI_PORTAL_OPT from the blueprint
Loading CI_PORTAL_OPT from the target database
Comparing CI_PORTAL_OPT
Loading F1_EXT_LOOKUP_VAL_CHAR from the blueprint
Loading F1_EXT_LOOKUP_VAL_CHAR from the target database
Comparing F1_EXT_LOOKUP_VAL_CHAR
Upgrading Database
Pass:1
System Data Upgraded Successfully, Now Exiting


Executing Finalization Scripts...


Processing file CCB_cleanup.sql ...

Processing file cdx_security.sql ...

Processing file CCB230_APDATA3.SQL ...

Processing file CCB231_POST_DATA1.SQL ...

Processing file CCB240_cleanup.sql ...

Processing file CCB240_cleanup2.sql ...

Processing file 24020_C1_AP_apData1.sql ...

Processing file 24020_C1_AP_APDATA2.SQL ...

Processing file 24030_BUG_18906800.SQL ...

Processing file 24030_BUG_19162075.SQL ...

Processing file 24030_BUG_20023780.SQL ...

Processing file 24030_BUG_20426547.SQL ...

Processing file 24030_BUG_21078919.SQL ...

Processing file 24030_BUG_19707998.SQL ...

Processing file 25010_BUG_21482753.SQL ...


Configuring Security...



Connecting to the Target Database ...
User Name      : CISADM
Database Name  : OMCCB

Generating security ...

Security privileges and Synonyms generated successfully, Now Exiting ...

Storing Database Credential with ecncrypted password...

Install/Upgrade of Database Rel.V2.5.0.1.0 Completed Sucessfully, Now Exiting ...

Press Enter to Continue ...


C:\Users\Palane\Downloads\Compressed\New folder\CCB\V78183-01\CCB-V2.5.0.1.0-Oracle-Database-MultiplatForm\CCB\Upgrade\Install-Upgrade>


===
Error handling 

ERROR: ORA-03113: end-of-file on communication channel
Process ID: 27462
Session ID: 1138 Serial number: 20663 (DBD ERROR: error possibly near <*> indicator at char 19 in 'update CISADM.CI_UT<*>_INSTL_DTL set end_dttm=to_date('06-10-2016 10:56:44','MM-DD-YYYY HH24:MI:SS'), run_status_flg='02'
             where instl_log_id=20 and seq_num = 31 - 1') occured while executing update CISADM.CI_UT_INSTL_DTL set end_dttm=to_date('06-10-2016 10:56:44','MM-DD-YYYY HH24:MI:SS'), run_status_flg='02'
             where instl_log_id=20 and seq_num = 31 - 1
Error Occured, Process being aborted ...
Posted by at No comments:
Subscribe to: Posts (Atom)