-
Oracle 10g XE
Hi,
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.
Thanks
Ram
-
What do you mean you lost the administrator password?
Just in case try this:
set your ORACLE_HOME and ORACLE_SID, then...
sqlplus /nolog
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.
Thanks
Ram
-
1.
sql>conn / as sysdba;
provide password ur password.
sql>alter user identified by
2.
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.sethttpport(8090);
sql>exec dbms_xdb.setlistenerlocalaccess(true);<-- should be true
now: 127.0.0.1:8090
try doing these, may work.
cheers!
-
Originally Posted by raambala
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.
If your account is locked,unlock it.
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??
-
Originally Posted by sandypeter111
how can lost your password??
never forgotten a password?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|