Planner Backup

CREATE USER "JDEBACKUP" IDENTIFIED BY JD3BACKUP DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK ;
GRANT EXP_FULL_DATABASE TO JDEBACKUP;
GRANT IMP_FULL_DATABASE TO JDEBACKUP;
ALTER USER "JDEBACKUP" QUOTA UNLIMITED ON USERS;
CREATE OR REPLACE DIRECTORY BACKUP AS 'E:\Planner_DATABASE_BACKUP';
GRANT READ, WRITE ON DIRECTORY BACKUP TO JDEBACKUP;

cd\
E:
cd E1lOCAL_DATABASE_BACKUP
del *.* /q

cd\
E:
cd Oracle\E1Local\BIN

expdp JDEBACKUP/JD3BACKUP@E1Local DIRECTORY=BACKUP dumpfile=JDECTL920.dmp logfile=Exp_JDECTL920.log compression=none schemas=JDECTL920

expdp JDEBACKUP/JD3BACKUP@E1Local DIRECTORY=BACKUP dumpfile=JDEDATA920.dmp logfile=Exp_JDEDATA920.log compression=none schemas=JDEDATA920

expdp JDEBACKUP/JD3BACKUP@E1Local DIRECTORY=BACKUP dumpfile=JDEDD920.dmp logfile=Exp_JDEDD920.log compression=none schemas=JDEDD920

expdp JDEBACKUP/JD3BACKUP@E1Local DIRECTORY=BACKUP dumpfile=JDEOL920.dmp logfile=Exp_JDEOL920.log compression=none schemas=JDEOL920

expdp JDEBACKUP/JD3BACKUP@E1Local DIRECTORY=BACKUP dumpfile=JDEPLAN920.dmp logfile=Exp_JDEPLAN920.log compression=none schemas=JDEPLAN920

expdp JDEBACKUP/JD3BACKUP@E1Local DIRECTORY=BACKUP dumpfile=JDESY920.dmp logfile=Exp_JDESY920.log compression=none schemas=JDESY920

expdp JDEBACKUP/JD3BACKUP@E1Local DIRECTORY=BACKUP dumpfile=JDEVL920.dmp logfile=Exp_JDEVL920.log compression=none schemas=JDEVL920

expdp JDEBACKUP/JD3BACKUP@E1Local DIRECTORY=BACKUP dumpfile=SPEC_E920.dmp logfile=Exp_SPEC_E920.log compression=none schemas=SPEC_E920


Exit

Database Role JDEADMIN and JDEUSER

Starting with Application JDE 9.2 there comes 2 roles for Database JDEADMIN  and JDEUSER.

During upgrade these roles are not added to database which are migrated from older release.

Run these command


User JDE_DEVELOPMENT

Create role JDEADMIN
Create role JDEUSER
ALTER ROLE JDEADMIN ADD MEMBER JDE

exec sp_MSForEachTable 'GRANT ALTER,REFERENCES, SELECT, INSERT, DELETE, UPDATE ON ? TO [JDEADMIN]'
go

exec sp_MSForEachTable 'GRANT REFERENCES, SELECT, INSERT, DELETE, UPDATE ON ? TO [JDEUSER]'
go