Integratd Cloud Applications and Platform

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

AWS Computing Web Services

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

drive your new generation business

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

This is default featured post 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

Oracle Extends JD Edwards Roadmap to 2024

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

JD Edwards Purge-it Introduction

Oracle JD Edwards EnterpriseOne 是一套以企業資源管理(ERP)為基礎的全方位解決方案,在傳統企業核心流程使用外,更能延伸的以重新檢視各項作業流程,並能整合供應鏈管理與商業智慧,以調整未來公司營運的需求,幫助企業成長並增加競爭力。

然而在公司成長之際,EnterpriseOne 的資料庫也同時的在成長,導致執行的速度及效能變慢,如果您想要改善 JD Edwards 的效能及速度,勢必要有一種容易安全的方式來調整您的系統,把過去的歷史資料從正式環境搬移到歷史資料區以供查詢,但又不能單單只以資料庫資料表的層級來檢視,必須兼顧各模組的相關性,又能保持資料的完整性,那麼 Klik-IT Data Purging and Archiving for JD Edwards 就是您的最佳選擇


每個JDE的使用者都會問,我們要如何做 Purging and Archiving, 在 Oracle 官方的文件裡 Doc ID 1082128.1 有寫者這麼一段建議的解決方案:

In reference to archiving, there are no specific tools available within EnterpriseOne. You can use any third party tools and features available within you Database (RDBMS native tools)


因此 Purge-it!提供了 JDE Purging and Archiving 的解決方案,Purge-it!以JD Edwards的系統開發工具,開發出能完全整合到JDE現有的環境,並提供最早期的Xe版本到目前最新的9.1版,完全和JDE一致的操作方式及介面,IT人員能夠以最少的導入時間及成本,完成上線使用。










EM無法登入,提示ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)

--查看DB目前密碼的期限sys@TESTDB11>select * from dba_profiles where profile = 'DEFAULT' and resource_name = 'PASSWORD_LIFE_TIME';

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180

--查看帳戶的狀態, 發現DBSNMP及 SYSMAN 帳戶都己經過期了
sys@TESTDB11>select username, account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SCOTT OPEN
PLSQL OPEN
IX OPEN
SH OPEN
OE OPEN
HR OPEN
STORE OPEN
OPS$USERA OPEN
USERA OPEN
DBSNMP EXPIRED
SYSMAN EXPIRED
SYSTEM EXPIRED(GRACE)
OUTLN EXPIRED & LOCKED
FLOWS_FILES EXPIRED & LOCKED
MDSYS EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
APPQOSSYS EXPIRED & LOCKED
APEX_030200 EXPIRED & LOCKED
OWBSYS_AUDIT EXPIRED & LOCKED
ORDDATA EXPIRED & LOCKED
CTXSYS EXPIRED & LOCKED
ANONYMOUS EXPIRED & LOCKED
XDB EXPIRED & LOCKED
ORDPLUGINS EXPIRED & LOCKED
OWBSYS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
ORACLE_OCM EXPIRED & LOCKED
XS$NULL EXPIRED & LOCKED
BI EXPIRED & LOCKED
PM EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
DIP EXPIRED & LOCKED
APEX_PUBLIC_USER EXPIRED & LOCKED
SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED
SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED

40 rows selected.

--修改帳戶的密碼期限為無限制
sys@TESTDB11>alter profile default limit password_life_time unlimited;

Profile altered.

--修改DBSNMP和SYSMAN 的密碼
sys@TESTDB11>alter user dbsnmp identified by dbsnmp;

User altered.

sys@TESTDB11>alter user sysman identified by sysman;

User altered.

--重新登入EM,問題己經解決

-------->>如果問題還是沒有解決, 請往下看:

再查詢sysman和dbsnmp的狀態,這次是LOCKED(TIMED)
SQL> select username,account_status from dba_users where username='SYSMAN';
USERNAME ACCOUNT_STATUS
SYSMAN LOCKED(TIMED)
原因:
dbsnmp和sysman這2個帳戶和oem緊密相關,dbsnmp啟動Oracle智能代理,用於收集oracle系統運行狀況的相關數據,sysman是oem的超級管理員。如果配置了oem後,又使用alter user <帳戶名> identified by <新密碼>;修改了這2個帳戶的密碼,就會出現dbsnmp 和sysman "LOCKED(TIMED)". 的情況。
解決方法:
還必須同步修改oem中記錄的dbsnmp和sysman帳戶的密碼。
$emca -config dbcontrol db
根據提示修改sysman和dbsnmp的密碼即可

JDE-Fat-Client-Installation

JDE Fat Client Installation


JDE E1 LocalDB Installation




Related Posts Plugin for WordPress, Blogger...