Oracle 10g XE
I installed Oracle 10g Express edition on my laptop for educational purpose. I lost the administrator password and unable to login through the login page.
Is there a way to reset/receover the password without uninstalling or do I have to reinstall again.
What do you mean you lost the administrator password?
Just in case try this:
set your ORACLE_HOME and ORACLE_SID, then...
conn sys as sysdba
press Enter when asked for the password
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Thanks. I was able to login as mentioned below. I am not sure how to proceed further.
Two things I want to rectify:
1. when I installed the default user created was system. How to reset the password for this user. Now when I try to login, it says the account is locked.
2. The URL http://127.0.0.1:8080/apex does not open up the database page. How to rectify it. I have tried with localhost:8080 also in the url.
Any suggestions would be appreciated.
sql>conn / as sysdba;
provide password ur password.
sql>alter user identified by
start your database.
command prompt: netstat -an | find "TCP"
check for the ip and port, status.
ping the ip address.
if not, change the port:8080
sql>exec dbms_xdb.setlistenerlocalaccess(true);<-- should be true
try doing these, may work.
If your account is locked,unlock it.
Originally Posted by raambala
connect as sys user, then
alter user system account unlock;
if you need to change the password,do it like the above poster said..
alter user system identified by ;
how can lost your password??
never forgotten a password?
Originally Posted by sandypeter111
Click Here to Expand Forum to Full Width