Master:CreateMax

From ExxtremeWiki
Jump to: navigation, search

Master:CreateMax [edit] Example Scripting for Creating an Oracle database for 4.x and 5.x Maximo Systems

NOTE: This code includes sections for the "Demo Database" as well

CREATE TABLESPACE MAX_DATA DATAFILE 'd:\oracle\oradata\akics411\akics_max_data1.ora'

 SIZE 1024M AUTOEXTEND ON MAXSIZE 10000M DEFAULT STORAGE (INITIAL 40960 NEXT 40960 PCTINCREASE 20);

alter tablespace MAX_DATA add datafile 'd:\oracle\oradata\akics411\akics_max_data2.ora'

 size 1024M AUTOEXTEND ON MAXSIZE 10000M ;

alter tablespace MAX_DATA add datafile 'd:\oracle\oradata\akics411\akics_max_data3.ora'

 size 1024M AUTOEXTEND ON MAXSIZE 10000M ;

CREATE TABLESPACE MAX_INDEX DATAFILE 'd:\oracle\oradata\akics411\akics_max_index1.ora'

 SIZE 1024M AUTOEXTEND ON MAXSIZE 10000M DEFAULT STORAGE (INITIAL 40960 NEXT 40960 PCTINCREASE 20);

alter tablespace MAX_INDEX add datafile 'd:\oracle\oradata\akics411\akics_max_index2.ora'

 size 1024M AUTOEXTEND ON MAXSIZE 10000M ;

alter tablespace MAX_INDEX add datafile 'd:\oracle\oradata\akics411\akics_max_index3.ora'

 size 1024M AUTOEXTEND ON MAXSIZE 10000M ;


--CREATE STANDARD MAXIMO USERS FOR ORACLE --ADDITIONAL INFORMATION IS AVAILABLE IN THE ORACLE INSTALLATION GUIDE

grant connect, resource, DBA to SYSADM identified by SYSADM; grant connect to SYSSQL identified by SYSSQL; grant connect to DEFLT identified by DEFLT; grant connect to DEFLTREG identified by DEFLTREG;

alter user SYSADM default tablespace MAX_DATA; alter user SYSSQL default tablespace MAX_DATA; alter user DEFLT default tablespace MAX_DATA; alter user DEFLTREG default tablespace MAX_DATA;

grant connect,resource to maximo identified by maximo; grant DBA to maximo; revoke unlimited tablespace from maximo;

alter user maximo default tablespace MAX_DATA quota unlimited on MAX_DATA;

-- If you create a separate index tablespace use the following:

alter user maximo quota unlimited on MAX_INDEX;

alter user maximo temporary tablespace temp;

-- For ORACLE on NT use the following instead of the above: -- alter user maximo temporary tablespace temporary_data;

grant create public synonym to maximo; grant drop public synonym to maximo; grant create user to maximo; grant drop user to maximo;


--CREATE MAXIMO DEMO USERS FOR ORACLE --RUN AFTER INSTALLING STANDARD MAXIMO USERS

create user smith identified by smith1; create user liberi identified by liberi; create user winston identified by winston; create user granger identified by granger; create user hunter identified by hunter; create user jones identified by jones1; create user kazmier identified by kazmier; create user lou identified by loulou; create user miller identified by miller; create user rogers identified by rogers; create user schafer identified by schafer; create user wilson identified by wilson; create user workflow identified by workflow; create user stanley identified by stanley; create user ball identified by ballball; create user nachshen identified by nachshen;

grant create session to smith; grant create session to liberi; grant create session to winston; grant create session to granger; grant create session to hunter; grant create session to jones; grant create session to kazmier; grant create session to lou; grant create session to miller; grant create session to rogers; grant create session to schafer; grant create session to wilson; grant create session to workflow; grant create session to stanley; grant create session to ball; grant create session to nachshen;

--CREATE MAXIMO USER DEFLTREG FOR ORACLE

create user defltreg identified by defltreg; grant create session to defltreg;

--CREATE MAXIMO USER PSDIPUB FOR ORACLE --RUN THIS SCRIPT IF INSTALLING DATABASE NOT USING MAXINST.EXE --RUN AFTER INSTALLING STANDARD MAXIMO USERS --DO NOT MODIFY THE NAME OR PASSWORD

create user psdipub identified by psdipub; grant create session to psdipub;


-- And finally if necessary --SELECT * FROM MAXENCRYPT; -- -- Restore readable encrypted MAXIMO password maximo to maxencrypt -- for version 4.0.1.2+ --

--delete from maxencrypt;


-- There WAS a bug here, when the column order was unexpected!

--INSERT INTO MAXENCRYPT(ENCRYPT,ROWSTAMP) VALUES('@GKFABGCJDFEP','1'); --commit;

--grant select on maximo.maxencrypt to PSDIPUB; --commit;

Catagory: Maximo 4.x Catagory: Maximo 5.x Catagory: Oracle