Monday, October 13, 2014

If error like Unknown error JMX connection

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

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

No comments:

Post a Comment