Resetting Oracle User Password

Resetting an Oracle user password is as simple as logging in and changing in as the admin user.

If you are using the Fedora image provided with the course, you can follow the instructions exactly:

1. Open a terminal window
2. Switch to the root user:

   1. sudo su

3. Switch to the oracle user:

   1. su oracle

4. Login to SQLPlus as the SYSDBA

   1. sqlplus / as sysdba

5. Change the password for the student user:

   1. SQL> ALTER USER student IDENTIFIED BY student;

6. Exit from SQLPlus:

   1. SQL> EXIT

7. Exit from oracle, then from root user:

   1. exit

   2. exit

8. Login to SQLPlus:

   1. sqlplus student/student

9. You should now be logged into SQLPlus!

 

It is that simple.