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.:confused:

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

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!

Quote:

---

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??

Quote:

---

Originally Posted by sandypeter111

how can lost your password??

---

never forgotten a password?