E1: DB: How to Recover Lost or Corrupt SYSTEM/SYS Password in Local Oracle (OEE) Database?
(Doc ID 1064181.1)
Last updated on AUGUST 22, 2023
Applies to:
JD Edwards EnterpriseOne Tools - Version 8.98 to 9.2 [Release 8.98 to 9.2]Information in this document applies to any platform.
Goal
How to recover a lost or corrupt SYSTEM/SYS password for a Local (Oracle) OEE database
Oracle Enterprise Edition (OEE) database became available starting with EnterpriseOne 9.0 with Tools Release 8.98. The OEE database is supported on the following machines:
- Deployment Server
- Web Development Client
- Standalone Client
Check the MTRS and or Certification page (for Tools Release 9.1 and above) for the supported version of OEE.
This condition can happen in one of the following situations:
- If the Deployment Server or FAT client is replaced with new hardware or hard drive after a crash or as part of an upgrade.
- If the SYSTEM/SYS password for OEE is not getting encrypted for some reason and there are errors in C:\ReconfigureMSDE.log.
Note: These instructions require knowledge of Oracle database and are better followed with assistance from your DBA. If additional assistance is required with these steps contact Oracle Products team.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |