Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Forgot System Password for Oracle XE

Posted on 2009-06-26
3
Medium Priority
?
3,178 Views
Last Modified: 2012-05-07
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,


Jazon
0
Comment
Question by:piratepatrol
3 Comments
 
LVL 6

Accepted Solution

by:
tangchunfeng earned 1000 total points
ID: 24727668
sqlplus / as sysdba
alter user system identified by newpassword;
0
 
LVL 6

Assisted Solution

by:Greg Clough
Greg Clough earned 1000 total points
ID: 24728987
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.
0
 
LVL 3

Author Comment

by:piratepatrol
ID: 24761671
Thanks so much.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question