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

How to rank website on Google first page

There are many factors that can affect a website's ranking on Google's search engine results page (SERP). Here are some general tips that can help...

Hostinger Vs Dreamhost: Which one is best for you

Hostinger and Dreamhost are two of the most popular web hosting providers in the world. They both offer a wide range of features and...

Rank Math SEO Plugin Review: Pros and Cons

Rank Math SEO plugin is a very user-friendly and efficient plugin that can help you optimize your website for search engines. It has few features...

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...

Related Stories

Leave A Reply

Please enter your comment!
Please enter your name here

Stay on op - Ge the daily news in your inbox