With Oracle XE 11g database you cannot retrieve the password if you have not configured the notification mails. As Oracle XE 11g sends mail for the forgotten password and to find the workspace for an email id.
But there is another way to reset the password in case you have forgot the INTERNAL workspace ADMIN password. Here are the steps to reset the ADMIN password from command line.
Thats' it! the password has been changed now. Login on http://localhost:8080/apex with new password.
But there is another way to reset the password in case you have forgot the INTERNAL workspace ADMIN password. Here are the steps to reset the ADMIN password from command line.
- Goto folder <XE_HOME>\app\oracle\product\11.2.0\server\apex on your windows machine.
- Open sql plus > sqlplus sys@XE as sysdba
- Run the script > @apxchpwd.sql and enter new password when prompt comes.
Thats' it! the password has been changed now. Login on http://localhost:8080/apex with new password.
No comments:
Post a Comment