If error like Unknown error JMX connection
Check the IVT pass/fail ? this case IVT must Fail. IBM MDM not install properly.
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
/*************************************************************/
Check the IVT pass/fail ? this case IVT must Fail. IBM MDM not install properly.
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