SQL Server and Database Collation

 

SELECT SERVERPROPERTY('Collation') AS 'Collation'

SELECT name, collation_name FROM sys.databases

The JDE Database Collation level should be Latin1_General_CI_AS_WS

msdb SQL_Latin1_General_CP1_CI_AS

DBA SQL_Latin1_General_CP1_CI_AS

JDE920 Latin1_General_CI_AS_WS

JDE_CRP Latin1_General_CI_AS_WS

JDE_DEVELOPMENT Latin1_General_CI_AS_WS

JDE_DV920 Latin1_General_CI_AS_WS

JDE_PRIST920 Latin1_General_CI_AS_WS

JDE_PS920 Latin1_General_CI_AS_WS

JDE_PY920 Latin1_General_CI_AS_WS

JDE_PD920 Latin1_General_CI_AS_WS

JDE_PRODUCTION Latin1_General_CI_AS_WS

JDE 64 Bit Full Package

 

In order to do first 64 Bit Full package for Fresh Install (when 32 bit Package not build), then add these specs to Base Full package. 

Add Specs to Full Package -
INSERT INTO DV920.F98710DV920FA SELECT * FROM DV920.F98710 WHERE THOBNM = 'F00942T';
INSERT INTO DV920.F98710DV920FA SELECT * FROM DV920.F98710 WHERE THOBNM = 'F98780R';
INSERT INTO DV920.F98710DV920FA SELECT * FROM DV920.F98710 WHERE THOBNM = 'F98780H';

INSERT INTO DV920.F98711DV920FA SELECT * FROM DV920.F98711 WHERE TDOBNM = 'F00942T';
INSERT INTO DV920.F98711DV920FA SELECT * FROM DV920.F98711 WHERE TDOBNM = 'F98780R';
INSERT INTO DV920.F98711DV920FA SELECT * FROM DV920.F98711 WHERE TDOBNM = 'F98780H';

INSERT INTO DV920.F98712DV920FA SELECT * FROM DV920.F98712 WHERE TPOBNM = 'F00942T';
INSERT INTO DV920.F98712DV920FA SELECT * FROM DV920.F98712 WHERE TPOBNM = 'F98780R';
INSERT INTO DV920.F98712DV920FA SELECT * FROM DV920.F98712 WHERE TPOBNM = 'F98780H';

INSERT INTO DV920.F98713DV920FA SELECT * FROM DV920.F98713 WHERE TLOBNM = 'F00942T';
INSERT INTO DV920.F98713DV920FA SELECT * FROM DV920.F98713 WHERE TLOBNM = 'F98780R';
INSERT INTO DV920.F98713DV920FA SELECT * FROM DV920.F98713 WHERE TLOBNM = 'F98780H';

Start Weblogic Admin Server, Node Manager and Server Manager Agent on Linux

 

Start Weblogic Admin Server, Node Manager and Server Manager Agent on Linux

1 Create system service files:

1.1 adminserver system service file

# vi /usr/lib/systemd/system/wls_adminserver.service

----------------------------------------------------

[Unit]

Description=WebLogic Adminserver Service

After=network.target 

[Service]

Type=simple

WorkingDirectory=/apps/oracle/middleware/user_projects/domains/E1_HTTP

ExecStart=/apps/oracle/middleware/user_projects/domains/E1_HTTP/bin/startWebLogic.sh

ExecStop=/apps/oracle/middleware/user_projects/domains/E1_HTTP/stopWebLogic.sh

User=oracle

Group=oinstall

[Install]

WantedBy=multi-user.target

1.2 nodemanager system service file

# vi /usr/lib/systemd/system/wls_nodemanager.service

------------------------------------------------------

[Unit]

Description=WebLogic NodeManager Service

After=network.target 

[Service]

Type=simple

WorkingDirectory=/apps/oracle/middleware/user_projects/domains/E1_HTTP

ExecStart=/apps/oracle/middleware/user_projects/domains/E1_HTTP/bin/startNodeManager.sh

ExecStop=/apps/oracle/middleware/user_projects/domains/E1_HTTP/bin/stopNodeManager.sh

User=oracle

Group=oinstall

[Install]

WantedBy=multi-user.target

1.3 JDE SM Agent system service file

# vi /usr/lib/systemd/system/wls_smagent.service

------------------------------------------------------

[Unit]

Description=Server Manager Agent Service

After=network.target

[Service]

Type=oneshot

WorkingDirectory=/apps/jde_home_agent/SCFHA

ExecStart=/apps/jde_home_agent/SCFHA/bin/startAgent

ExecStop=/apps/jde_home_agent/SCFHA/bin/stopAgent

RemainAfterExit=yes

User=oracle

Group=oinstall

[Install]

WantedBy=multi-user.target

3) Test the system service :

3.1 start system service

# systemctl start wls_adminserver.service

# systemctl start wls_nodemanager.service

# systemctl start wls_smagent.service

3.2 stop system service

# systemctl stop wls_adminserver.service

# systemctl stop wls_nodemanager.service

# systemctl stop wls_smagent.service

4) Set the service to start automatically at systm reboot :

# systemctl enable wls_adminserver.service

# systemctl enable wls_nodemanager.service

# systemctl enable wls_smagent.service

# systemctl list-unit-files|grep wls

JDE Julian and Calendar Date

JDE Excel Date Conversion

Julain to Gregorian Date

=DATE(YEAR("01/01/"&TEXT(1900+INT(A1/1000),0)),MONTH("01/01/"&TEXT(1900+INT(A1/1000),0)),DAY("01/01/"&TEXT(1900+INT(A1/1000),0)))+MOD(A1,1000)-1

Gregorian to Julian

=(YEAR(A1)-2000+100)*1000+A1-DATE(YEAR(A1),"01","01")+1

Linux Change Time Zone

 

1. View Time Zone 

Timedatectl

2. List Time Zone

timedatectl list-timezones

timedatectl list-timezones |grep Denver

timedatectl list-timezones | grep York

3. Set Time Zone

Based on timezone value need to set here is eg to set Denver or New York Time Zone

timedatectl set-timezone America/Denver

timedatectl set-timezone America/New_York

4.View Time Zone to verify timezone is set as required

Timedatectl

Reference - https://linuxize.com/post/how-to-set-or-change-timezone-in-linux/

JD Edwards OMW: How to List Objects and Manage Token Status Using SQL

Object Management Workbench (OMW) in JD Edwards EnterpriseOne controls object development, check-in/check-out status, and token locking. Understanding how objects and tokens are tracked in the database is critical for CNC administrators and developers troubleshooting locked objects or development issues.

This blog explains how to:

• List objects based on check-out status
• Identify token usage
• Find checked-in / checked-out objects
• Release OMW tokens using SQL

1. List of Objects Not Checked Out and No Token

This query returns objects that are:

• NOT checked out
• NOT holding any token

SELECT * FROM SY920.F98222 
WHERE POOMWCHS = '0' 
AND POOMWOST = '02' 
AND POOMWPOS1 = '0' 
AND POOMWPON1 = 0 
AND POOMWPRJID = 'Project_Name'; 

2. List of Objects Not Checked Out but Have Token

This query identifies objects that:

• Are NOT checked out
• STILL hold a token

SELECT *
FROM SY920.F98222
WHERE POOMWCHS = '0'
AND POOMWOST = '02'
AND POOMWPOS1 = '1'
AND POOMWPRJID = 'Project_Name';

3. List of Objects Checked Out and Have Token

This query returns objects that are:

• Currently checked out
• Holding a token

SELECT *
FROM SY920.F98222
WHERE POOMWCHS = '1'
AND POOMWOST = '03'
AND POOMWPOS1 = '1'
AND POOMWPRJID = 'Project_Name';

4. Release OMW Token Using SQL

In some cases, tokens remain locked due to:

• Unexpected session termination
• Network disconnection
• Abnormal OMW exit

You can release the token using SQL update.

UPDATE SY920.F98222
SET POOMWPOS1 = '0',
POOMWPON1 = 0
WHERE POOMWOST = '02'
AND POOMWPOS1 = '1'
AND POOMWPRJID LIKE 'Project_Name'; 

Print Weblogic Java GC Detail

 

Print GC Detail for Java  in Weblogic. Add this parameter in  server start section of Managed Server and restart service

Create Folder D:\Temp\GCLOG

 -Xloggc:D:\Temp\GCLOG\Prod_3278.log -verbose:gc -XX:+PrintGCDateStamps -XX:-PrintGCDetails

Restart Service and see GC logs in D:\Temp\GCLOG

To View Log you can see in Power Shell also using 

cd  D:\Temp\GCLOG

Get-Content -Path Prod_3278.log -Tail 50

Oracle Support page to Compare Apps & Tools release Net Changes

 

Oracle Support page to Compare Apps & Tools release Net Changes

 https://apexapps.oracle.com/pls/apex/f?p=103254:18:109497585364962::NO:RP,18:P_ID_18:208136276869697198410960926144257

How To Find OS Version On IBM i

 

To find the OS version of an IBM i (iSeries, AS/400), use the steps below:

1. Type the following on the command line: 
   DSPSFWRSC
2. Press 
   [F11]

The above commands will result in a screen similar to the one below:

Registering Fat Client DLL for 9.2.4.x

Registering Fat Client DLL for 9.2.4.x

--D:\E920\system\bin32\ Bitness is 32Registering files in
 D:\E920\system\bin32 ...
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\ActivBPMInterface.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\ActivBPMXMLContent.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\activDocumentation.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\ActivDOM.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\activExplorer.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\ActivFindIt.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\activHeader.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\ActivMyActivEra.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\activProperties.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\activWebView.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\BPMLogger.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\CoMailMerge.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\dataitem.ocx
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\DebuggerService.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\design.ocx
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\E1Soap.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\EnvServer.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\EventClass.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\FDAAxHostMod.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\Jdboledb.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\JDEBPMSoap.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\JDEBPMSockets.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\jdectocx.ocx
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\JDEMMC.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\Jdeocx.ocx
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\Jdeowoda.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\jdesplash.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\JDETLBrowseMod.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\jdeuser.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\OneWorldInterfaceTx.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\RdaReportView.ocx
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\TextCtrlMod.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\TLBrowseCtrlMod.dll
 D:\E920\system\bin32>C:\Windows\SysWOW64\regsvr32.exe /s .\WinUbeDbgService.dll

Fat Client JDE Folder permission missing

JDE Folder permission missing
In this example e1dbuser is a database user

"C:\Windows\SysWOW64\icacls.exe" "D:\E920" /grant "e1dbuser":F /t /c
"C:\Windows\SysWOW64\icacls.exe" "D:\Oracle" /grant "e1dbuser":F /t /c
"C:\Windows\SysWOW64\icacls.exe" "D:\Oracle32" /grant "e1dbuser":F /t /c

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

Customizing the WebLogic JVM heap size

You can change the default JVM heap size to fit the needs of your deployment.

The default JVM heap size for WebLogic is 3GB. The size is set in the setDomainEnv.sh file for Linux or setDomainEnv.cmd for Windows, which is in the $DOMAIN_HOME/bin directory. The heap size is set with the -Xmx option.

To change the WebLogic JVM heap size:

1. Open the setDomainEnv file in a text editor.
2. Search for this comment line:
   For Linux:
   

   # IF USER_MEM_ARGS the environment variable is set, use it to override ALL MEM_ARGS values

   For Windows:
   

   @REM IF USER_MEM_ARGS the environment variable is set, use it to override ALL MEM_ARGS values

3. Immediately after the comment line, add one of these lines:
   For Linux:
   

   export USER_MEM_ARGS="-Xms2048m -Xmx2048m ${MEM_DEV_ARGS} ${MEM_MAX_PERM_SIZE}"

   For Windows:
   

   set USER_MEM_ARGS=-Xms2048m -Xmx2048m %MEM_DEV_ARGS% %MEM_MAX_PERM_SIZE%

4. Save the file.
5. Re-start WebLogic Server.

SQL Command

CREATE TABLE #TEMP(TBLNAME VARCHAR(200))

SELECT 'IF (SELECT COUNT(*) FROM '+TABLE_SCHEMA+'.'+TABLE_NAME +')=0 INSERT INTO #TEMP  SELECT '''+TABLE_SCHEMA+'.'+TABLE_NAME +''' '
from INFORMATION_SCHEMA.TABLES order by TABLE_SCHEMA,TABLE_NAME

SELECT 'DROP TABLE '+TABLENAME FROM #TEMP

Oracle 12c Expired User

-- How to reset the Expired user to Open with same password

select 'alter user ' || su.name || ' identified by values'    || ' ''' || spare4 || ';'    || su.password || ''';'
from sys.user$ su
join dba_users du on ACCOUNT_STATUS like 'EXPIRED%' and su.name = du.username;


-- Set Oracle Profile as Password Unlimited and Failed Login Unlimited

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED;

Manually Import E1Local Database on Fat Client

Manually Import E1Local Database on Fat Client

Step 1 - Decrypt the password
C:\e920\system\bin32
ReconfigureDB.exe to set decrypt password

Step 2 - Import JDELOCAL_PY920

CREATE USER JDELOCAL_PY920 IDENTIFIED BY JDELOCAL_PY920;

GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE VIEW TO JDELOCAL_PY920;

CREATE OR REPLACE DIRECTORY PKGDIR AS 'C:\E920_1\PY920\data\' ;

impdp TRANSPORT_DATAFILES='C:\E920_1\PY920\data\jdelocal_py920.dbf' DIRECTORY=PKGDIR DUMPFILE='jdelocal_py920.dmp' REMAP_TABLESPACE=JDELOCAL:JDELOCAL_PY920 REMAP_SCHEMA=JDELOCAL:JDELOCAL_PY920 LOGFILE='impjdelocal_py920.log'

ALTER TABLESPACE JDELOCAL_PY920 READ WRITE ;

ALTER USER JDELOCAL_PY920 DEFAULT TABLESPACE JDELOCAL_PY920 QUOTA UNLIMITED ON JDELOCAL_PY920;

Step 3- Import SPEC_PY920


CREATE USER SPEC_PY920FB IDENTIFIED BY SPEC_PY920FB;

GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE VIEW TO SPEC_PY920FB ;

CREATE OR REPLACE DIRECTORY PKGDIR AS 'C:\E920_1\PY920\spec\' ;

impdp TRANSPORT_DATAFILES='C:\E920_1\PY920\spec\spec_py920fb.dbf' DIRECTORY=PKGDIR DUMPFILE='spec_py920fb.dmp' REMAP_TABLESPACE=SPEC__PY920FB:SPEC_PY920FB REMAP_SCHEMA=SPEC__PY920FB:SPEC_PY920FB LOGFILE='impspec_py920fb.log'

ALTER TABLESPACE SPEC_PY920FB READ WRITE ;

ALTER USER SPEC_PY920FB DEFAULT TABLESPACE SPEC_PY920FB QUOTA UNLIMITED ON SPEC_PY920FB ;

Step 4 - Encrypt the password
C:\e920\system\bin32
ReconfigureDB.exe to set encrypt password

Security -> Processing Option Type '5'

Field Mapping with F00950

Change –  FSCHNG

Prompt for Values -  FSVWYN

Prompt for Version – FSATN2

Prompt for Data Selection – FSIOK AND FSIUPT

Modify Data Selection - FSATN1

Full Access Data Selection - FSICPY