Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I Forgot Oracle XE Password for Database administrator user "system"

665342Oct 15 2008 — edited Oct 16 2008
Hello,

is there a chance to get my password back for the database administraor account with the username "system" or to reset it otherwise? Unfortunately I have no change to remember it. Is there help for that problem?

Comments

Surachart Opun
If you would like to change password:

you login to sys and then change password of some users if you need

linux:

export ORACLE_SID=XE
export ORACLE_HOME=<ORACLE_PATH>
sqlplus / as sysdba

SQL> alter user system identified by <new_pass>;


window:
set ORACLE_SID=XE
set ORACLE_HOME=<ORACLE_PATH>
sqlplus / as sysdba

SQL> alter user system identified by <new_pass>;

2813381
Dietmar Aust
Hi,

I guess I would also do a

alter user SYS identified by <new pass>;

During installation, I believe both passwords (SYS and SYSTEM) are set the same.

Regards,
~Dietmar.
665342
How can I login as sys? Is there a chance, I cannot remember any password? Thanks for help.
Paul M.
How can I login as sys?
You already got the answer...

set ORACLE_SID=XE
sqlplus / as sysdba

That's OS authentication, you can connect as SYS user without providing any password. Then you can change any passwords you want.
665342
Thanks, that worked! :)
Dietmar Aust
That is good!

Could you please give some rewards points for correct and/or helpful answers? HunterX should deserve some ;).

Thanks,
~Dietmar.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 13 2008
Added on Oct 15 2008
6 comments
95,390 views