«

»

Jul 02 2012

Recover Lost or Corrupt Password in E1 Local (OEE) Database

VN:F [1.9.22_1171]
Rating: 4.8/5 (5 votes cast)

One of the standard errors while running JD Edwards EnterpriseOne Standalone Demo is – “Unable to Locate Security Server”.

But what when  you get that error after 6 or odd months when your standalone was working perfectly fine?

Our JD Edwards EnterpriseOne Standalone Demo 9.0.2 or 9.0 or prior running on Oracle Database will cease to work after 6 months. This is due to the Oracle Database Password Expiration policies, which just expires the passwords. You can verify this in your JDE.LOG files, which would say Unable to logon – Password Expired.

The issue above can also occur in one of the following situations:

  • If the Deployment Server or FAT client is replaced with a new hardware or hard drive after a crash or as part of an upgrade.
  • If the SYSTEM/SYS password of the Local Oracle database is not getting encrypted for some reason and there are errors in C:\ReconfigureMSDE.log

Thankfully, Oracle has a solution to fix this. This applies to JD Edwards EnterpriseOne Tools – Version: 8.98 (Oracle Support ID: 1064181.1). Here are the steps to connect to the Local Oracle (OEE) database with NT administrator credentials. Once connected as an admin, then simply reset the SYSTEM/SYS password.

  1. Navigate to the OEE directory and locate the sqlnet.ora file. It should be located in the path
    E1Local\network\admin.
  2. Change this file (sqlnet.ora) and set SQLNET.AUTHENTICATION_SERVICES=(NTS).
  3. Restart the OEE E1Local instance.
  4. Login to the machine with an administrator account.
  5. Connect to the local database using “sqlplus / as sysdba”.
  6. Run the SQL command:  Alter user system identified by admin;
  7. Now exit sqlplus and run ReconfigureMSDE.exe (at system\bin32). You will now be able to encrypt the password for SYSTEM/SYS.
  8. Go back and disable the NT authentication in OEE by setting the SQLNET.AUTHENTICATION_SERVICES=(NONE) in the same sqlnet.ora.
  9. Restarting the E1Local instance is required.

Once this is done, you will be able to access / login to your JD Edwards EnterpriseOne Standalone.

Published under the license.

VN:F [1.9.22_1171]
Rating: 4.8/5 (5 votes cast)
Recover Lost or Corrupt Password in E1 Local (OEE) Database, 4.8 out of 5 based on 5 ratings
(Visited 2,088 times, 1 visits today)

About the author

Krishna Nambiar

Krishna Nambiar is a very experienced CNC Consultant and has worked on quite implementations, and other support projects. Very keen to share and help for the goodwill of others, he is one of the Administrators of JDESource.com.
Also being a budding Photographer, and an Avid Reader, you can get to know more about him via following profiles.

7 comments

Skip to comment form

  1. Tim

    I followed these steps, but on step 7 the “change from password” cell appears blank. I continued, and got an error message saying it can’t accept blanks, changed it to “admin” but then it said it couldn’t change the password. I tried again with “admin”, “demo” but still not working.

    The error in ReconfigureMSDE.log is:
    Oracle does not allow blank passwords. The blank Oracle password that you entered was changed to “admin”.
    Generating encrypted password…
    Starting service OracleE1LocalTNSListener for the database…
    Starting service OracleServiceE1Local for the database…
    ERROR: Could not change the SYSTEM user’s password. Look in the c:\ReconfigureMSDE.log and jde.log for more details. Will not attempt to change the SYS user’s password.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  2. Francisco B

    By the way, the asterisks shown in the red square means “admin” without the quotation marks

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  3. Gokhan M

    Hi Francisco,

    I get following error. Any idea?

    Generating encrypted password…
    Starting service OracleE1LocalTNSListener for the database…
    Starting service OracleServiceE1Local for the database…
    ERROR: Could not change the SYSTEM user’s password. Look in the c:\ReconfigureMSDE.log and jde.log for more details. Will not attempt to change the SYS user’s password.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  4. Dian SMP Siji

    Thanks a lot .. It works.

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  5. Brian Gilbert

    Can you please provide more detailed instructions for someone who is a functional consultant. I find the steps above very hard to understand.

    Thank you,

    Brian

    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  6. amolchandane

    Hi after step 5, it connected to oracle database but while changing password using alter command, it throws error as: ORA-01109: database not open

    Kindly suggest.

    Thanks,
    Amol Chandane
    Tech Lead, Sears Holdings India

    VN:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
    1. JDEE1Tips

      Hey,

      are you still facing the issue ? Seems your database is not started properly.

      In case if you need a help , please let us know.

      VN:F [1.9.22_1171]
      Rating: 0 (from 0 votes)

Leave a Reply