User gets a pop-up window prompting for E1Local DB user and password and Jde.log shows OCI0000141 - Error - ORA-01017: invalid username/password; logon denied
Verify that the E1Local database system account password is valid. If the following command executes successfully, it means that the password is not encrypted. If so, you must encrypt the password in order to enable database access.
SQLPlus.exe system/admin@E1Local
where "admin" is the password. This password may have been set to "admin" by one of the
EnterpriseOne database scripts, or it may be a plain-text word that someone set by
running ReconfigureDB.exe
.
If the password was decrypted with ReconfigureDB
, you should re-encrypt
it using ReconfigureDB.exe
. Refer to the sections of this guide
entitled: Understanding the ReconfigureDB.exe Program and Encrypting and Decrypting the Password of the Local
Database.