Hence thought to put some of the learnings here so that some of us may get benefitted too.
we have Oracle Application Express 2.2 configured for some Database Administration and monitoring activities. This works as some sort of respository as well.
it was configured way back in 2006 and the person/team who created/installed is no longer serving the organization.
Hence I was completely unaware of the login credential (admin). I struggled and then found a metalink Note(304815.1) to fix this issue.
This is what I did.
- Logged in as sys
- Unlocked the account flows_020200 (it varies with the version of Apex installed)
- since I was not knowing the password for this account, I changed it. (searched some forum and it says - it doesnot affect Apex installation)
- Logged in back with flows_020200 user and ran a pl/sql block
- commited the transaction
- Logged in using the admin URL (http://yourserver:7777/pls/htmldb/htmldb_admin)
- Workspace to be entered - INTERNAL
- I was able to login successfully and changed the passsword for the original 'ADMIN' user account
Hope to put some more learnings in the comning blogs around Oracle AS, Portal, core Oracle database, Oracle Ebiz
