Lost Sysadmin Password for Oracle Fusion ECM (Stellent)

April 21, 2009

Did you forget your sysadmin password for your Oracle Fusion ECM (Stellent) Content Server?!

There are those rare occasions where you might not know the sysadmin password for your Content Server. The reasons for this are many and varied and certainly not limited to forgetting the password or the departure of your administrator who was the "keeper of the key".

What can you do now?

  1. Stop all Content Server services/processes including main, admin and inbound refinery services/processes
  2. Stop the Web Server (Apache, IIS, etc.)
  3. Find this file: -content server install directory-/data/users/SecurityInfo.hda
  4. Rename that file to something else so you can keep it, like SecurityInfo.hda.bak
  5. Open your Content Server database (perhaps with SQL Management Studio for SQL Server or SQL Developer for Oracle)
  6. Find the record in the Users table where dName equals sysadmin
  7. Remove the value for dPasswordEncoding for that record
  8. For that same record set the value for the dPassword column to a temporary password
  9. Commit your database changes
  10. Start the Content Server services
  11. Start the User Admin standalone application, not from the admin applets page
  12. Use your new password to login when prompted
  13. Find the sysadmin user and update the password to your new long term password
  14. Close the User Admin application
  15. Start the Content Server Web Server
  16. Enjoy!
© 2020 Jason Stortz (version 20200607-210013)