How to change forgot password of Oracle user

In this blog we’ll learn how to reset your password in Oracle XE whether

·         you still have access to your account

·         you’ve forgotten the password

·         the password is expired

So what’s the issue? here you’re trying to log on to Oracle XE or Express Edition and you’ve forgotten your password. I’ve done this many times usually because I’ve gone some time since last using Oracle or the password has expired, the expiry for a password in Oracle XE is180 days about six months, so if you don’t reset it in this period it will expire, so how can you reset it?

I’ll guide you, how to reset your password as well as reset it from another account, if it has expired in this blog. Let’s have a look at how to reset your password


Here we will try to find out the solution of the problem, how to change forgot password of Oracle database user by following simple steps:


1.  Login windows with administrative account

2.  Go to Start –> Programs –> Oracle

3.   Now click on “Start Database”

4.   After started,  click “Run Sql Command Line”

5.   Now on Sql command line please write following      

How to change forgot password of Oracle user

SQL> connect as sysdba       Username:  system       Password:   manager    

 Note:  Please note that system user is created by oracle with password manager at the time of installation

6.   Now you can change any database user password using following command       SQL> Alter user user_name identified by new_password

Note:   Kindly replace user_name with the user whose password you want to change and change new_password  with your new password for that user.

7. Done


Find Wifi Password Android

Recent Articles

online earning for students and developers

In this modern life, Everyone is running after money. There is no doubt that no work can be done without money and it is...

2 ways to earn online money

Because of covid19 the situation you are going through, you need to be able to Earn money online.If you want to see how people...

BrowseDomains Tool Review

So you're thinking about starting a business. The most common question people have after that is, "How do I choose the name of my...

How to Create a Website with Elementor Pro Part 2

How to Create a Website with Elementor Pro Homepage Create a page (page -> add new) and edit with elements. Give this page the words "home",...

How to Create a Website using Elementor Pro

How to Create a Website using Elementor Pro Elementor is one of the most famous WordPress page builder. You can use Elementor to create a...

Related Stories

Leave A Reply

Please enter your comment!
Please enter your name here

Stay on op - Ge the daily news in your inbox