Forgot System Password for Oracle XE

Good morning,

I forgot the system password for my Oracle XE installation to my Ubuntu Server computer.  Is there any way I can rest that password?

Thanks so much,

Who is Participating?
tangchunfengConnect With a Mentor Commented:
sqlplus / as sysdba
alter user system identified by newpassword;
Greg CloughConnect With a Mentor Senior Oracle DBACommented:
tangchunfeng is correct, but make sure that your ORACLE_SID variable is set first:

su - oracle (or just login as the "oracle" unix user)
echo $ORACLE_SID (If this is already set to the name of your database, then stop here)
cat /etc/oratab (or maybe /var/opt/oracle/oratab. This lists all databases on the server)
ps -ef | grep smon (This will list the names of all databases that are up-and-running on the server)
. oraenv
(Enter the name of your database when prompted, in UPPER case)

This will setup your environment to point to the correct database, otherwise your "sqlplus" won't know which database to connect to.
piratepatrolAuthor Commented:
Thanks so much.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.