Monday, October 13, 2014

Migration IBM initiate V9 to IBM MDM v11 - Application and Algo

Steps:
1.Import from v9 HUB to MDM v11 workspace(RAD v8.5).
2.Using RAD upgrade the Project(under Master Data Management menu bar option available) the all application.
3.Most of error related to Algo.( all filed name are madatary for v11  i.e error in v9 , put the proper name it will working fine )
4.clean & Build
5.Start WAS server in u r workspace.
6.Deploy the project including weight & all other configuration.It will take some time to complete.

IF error come like Unable to JMX connection.
Check the IVT pass/fail ? If Pass then  the stop WAS server and change Envernoment JRE.( Double click on WAS server in RAD and one page will be open , u can find the JRE )
Check DB Schema as per below.
IF u r using Oracle DB then proper DB Schema below
/**************************************************/

ALTER SYSTEM SET db_4k_cache_size=128M;
ALTER SYSTEM SET db_16k_cache_size=128M;

CREATE TABLESPACE "DATSPACE"
    DATAFILE 'D:\oraclexe\app\oracle\oradata\XE\DATSPACE.dbf'
    SIZE 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

CREATE TABLESPACE "EMESPACE1"
    DATAFILE 'D:\oraclexe\app\oracle\oradata\XEEMESPACE1.dbf'
    SIZE 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
   
CREATE TABLESPACE "IDXSPACE"
    DATAFILE 'D:\oraclexe\app\oracle\oradata\XEIDXSPACE.dbf'
    SIZE 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
   
CREATE TABLESPACE "EMESPACE2"
    DATAFILE 'D:\oraclexe\app\oracle\oradata\XEEMESPACE2.dbf'
    SIZE 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

CREATE TABLESPACE "LOBSPACE"
    DATAFILE 'D:\oraclexe\app\oracle\oradata\XELOBSPACE.dbf'
    SIZE 1024M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

CREATE TABLESPACE "TBS4K" NOLOGGING
      DATAFILE 'D:\oraclexe\app\oracle\oradata\XETBS4K.dbf'
      SIZE 512M blocksize 4k EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
     
CREATE TABLESPACE "TBS8K"
    DATAFILE 'D:\oraclexe\app\oracle\oradata\XETBS8K.dbf'
    SIZE 512M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;    



CREATE TABLESPACE "TBS16K" NOLOGGING
      DATAFILE 'D:\oraclexe\app\oracle\oradata\XETBS16K.dbf'
      SIZE 512M blocksize 16k EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE USER MDMUSER IDENTIFIED BY mdmuser DEFAULT TABLESPACE DATSPACE TEMPORARY TABLESPACE TEMP;
GRANT CREATE SESSION TO MDMUSER;

GRANT UNLIMITED TABLESPACE TO MDMUSER;
GRANT CREATE SEQUENCE TO MDMUSER;
GRANT CREATE ANY SYNONYM TO MDMUSER;
ALTER USER MDMUSER QUOTA UNLIMITED ON DATSPACE;
ALTER USER MDMUSER QUOTA UNLIMITED ON IDXSPACE;
ALTER USER MDMUSER QUOTA UNLIMITED ON EMESPACE1;
ALTER USER MDMUSER QUOTA UNLIMITED ON EMESPACE2;
ALTER USER MDMUSER QUOTA UNLIMITED ON LOBSPACE;
ALTER USER MDMUSER QUOTA UNLIMITED ON TBS4K;
ALTER USER MDMUSER QUOTA UNLIMITED ON TBS8K;
ALTER USER MDMUSER QUOTA UNLIMITED ON TBS16K;
ALTER SYSTEM SET open_cursors = 1500 SCOPE=BOTH;
ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR SCOPE=BOTH;
GRANT CREATE TABLE TO MDMUSER;
GRANT CREATE TRIGGER TO MDMUSER;
GRANT CREATE PROCEDURE TO MDMUSER;
GRANT CREATE SEQUENCE TO MDMUSER;
GRANT CREATE TYPE TO MDMUSER;
GRANT CREATE VIEW TO MDMUSER;
GRANT SELECT ANY TABLE TO MDMUSER;
GRANT IMP_FULL_DATABASE TO MDMUSER;
GRANT SELECT ANY DICTIONARY TO MDMUSER;
GRANT RESOURCE TO MDMUSER;
GRANT CONNECT TO MDMUSER;
GRANT CREATE SNAPSHOT TO MDMUSER;
/
exit

/*************************************************************/

No comments:

Post a Comment