JDE Oracle ASM Tablespace

For ASM Database to create a Tablespace under Diskgroup use following command -

create tablespace dv920t datafile '+DATA' size 3072M autoextend on next 300M maxsize 5120M logging extent management local segment space management auto;
create tablespace dv920i datafile '+DATA' size 1536M autoextend on next 150M maxsize 3072M logging extent management local segment space management auto;
create tablespace testctli datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create tablespace testctlt datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create BIGFILE tablespace testdtai datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create BIGFILE tablespace testdtat datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;


create tablespace pd920t datafile '+DATA' size 3072M autoextend on next 300M maxsize 5120M logging extent management local segment space management auto;
create tablespace pd920i datafile '+DATA' size 1536M autoextend on next 150M maxsize 3072M logging extent management local segment space management auto;
create tablespace prodctli datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create tablespace prodctlt datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create BIGFILE tablespace proddtai datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create BIGFILE tablespace proddtat datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;

create tablespace py920t datafile '+DATA' size 3072M autoextend on next 300M maxsize 5120M logging extent management local segment space management auto;
create tablespace py920i datafile '+DATA' size 1536M autoextend on next 150M maxsize 3072M logging extent management local segment space management auto;
create tablespace crpctli datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create tablespace crpctlt datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create BIGFILE tablespace crpdtai datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create BIGFILE tablespace crpdtat datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;

create tablespace ps920t datafile '+DATA' size 3072M autoextend on next 300M maxsize 5120M logging extent management local segment space management auto;
create tablespace ps920i datafile '+DATA' size 1536M autoextend on next 150M maxsize 3072M logging extent management local segment space management auto;
create tablespace ps920ctli datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create tablespace ps920ctlt datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create BIGFILE tablespace ps920dtai datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;
create BIGFILE tablespace ps920dtat datafile '+DATA' size 1000M autoextend on next 100M maxsize 2000M logging extent management local segment space management auto;


create tablespace sy920t datafile '+DATA' size 250M autoextend on next 25M maxsize 1000M logging extent management local segment space management auto;
create tablespace sy920i datafile '+DATA' size 100M autoextend on next 10M maxsize 1000M logging extent management local segment space management auto;
create tablespace svm920t datafile '+DATA' size 10M autoextend on next 1M maxsize 1000M logging extent management local segment space management auto;
create tablespace svm920i datafile '+DATA' size 10M autoextend on next 1M maxsize 1000M logging extent management local segment space management auto;
create tablespace ol920t datafile '+DATA' size 250M autoextend on next 5M maxsize 1000M logging extent management local  segment space management auto;
create tablespace ol920i datafile '+DATA' size 100M autoextend on next 5M maxsize 1000M logging extent management local  segment space management auto;
create tablespace dd920t datafile '+DATA' size 350M autoextend on next 10M maxsize 1000M logging extent management local  segment space management auto;
create tablespace dd920i datafile '+DATA' size 125M autoextend on next 5M maxsize 1000M logging extent management local segment space management auto;

When Installing JDE Set ORCL_set.sh as following value

Please set only ASM Disk Group to INDEX_PATH and TABLE_PATH.

export INDEX_PATH=DATA
export TABLE_PATH=DATA

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

Oracle Weblogic 12.2.1.3 Critical Patch Update (January 2019 OCPU)

Due to the increase in attack on Weblogic, Oracle is releasing Critical Patch Update every Quarter.

Below are the steps to Install Weblogic  Weblogic 12.2.1.3 January CPU patch set.  Remember if you already have the previous patch there are conflict sometimes, so you might have to uninstall the previous patchset before applying the latest one.

The Oracle Product Patch info is located at  https://www.oracle.com/technetwork/topics/security/alerts-086861.html

Download following Patch from  support.oracle.com

6880880 - Optach 13.9.4 Patch

29137924 - OUI Interim Patch

28710939 - Weblogic 12.2.1.3 Jan 2019 OCPU

1. Stop Weblogic Admin Server and All Managed Instance
2. Stop NodeManager Service
3. Stop Server Manager Agent
4. Make sure Task Manager no java process running
5. Unzip in a folder D:\Software\92\HTML\PatchSet using 7-zip (if it’s a linux system use command unzip )
6. Backup D:\Oracle\Middleware using 7-zip
7. open CMD  - Run As an administrator
8. set PATH=D:\OracleWLS\Middleware\Oracle_Home\OPatch;%PATH%
9. set PATH=D:\OracleWLS\Java\bin;%PATHH%
10. D:
11. cd D:\Software\92\HTML\PatchSet\6880880  (This is a directory in Step 5 to unzip folder)
12. java -jar opatch_generic.jar -J-Doracle.installer.oh_admin_acl=true -silent oracle_home=D:\OracleWLS\Middleware\Oracle_Home
13. cd ..
14. cd 29137924
15. opatch apply -oop
16. cd ..
17. cd 28710939
18. opatch apply -oop