Oracle Database Retrieval DBA account password

Source: Internet
Author: User
This is an article written in the QQ space in the sophomore year. I still remember that it took me a whole day to solve this problem, so I had a deep understanding at that time, so at that time, I recorded the process of solving the problem. Today, I am eager to find some articles written in the space at the university to share with you, to prevent me from happening in the past, it costs a lot.

This is an article written in the QQ space in the sophomore year. I still remember that it took me a whole day to solve this problem, so I had a deep understanding at that time, so at that time, I recorded the process of solving the problem. Today, I am eager to find some articles written in the space at the university to share with you, to prevent me from happening in the past, it costs a lot.

This is an article written in the QQ space in the sophomore year. I still remember that it took me a whole day to solve this problem, so I had a deep understanding at that time, so at that time, I recorded the process of solving the problem. Today, I am eager to find some articles written in the space at the university and share them with you to prevent me from happening in the past, it takes a lot of time. The following are all recorded at that time:

Today, I logged on to Oracle with SCOTT. When I edited the table, I found that I didn't have the corresponding permissions. So I wanted to log on to sys and grant the DBA role SCOTT as a DBA, however, I couldn't remember the password. The Oracle database was very secure and thought I couldn't find it. After several hours, I finally recovered it. The method was as follows:
Close all services related to the Oracle database.
Open CMD and enter orapwd file = file name password = User password entried = entries.
The file name must contain the complete full path name. If not specified, Oracle places it under $ ORACLE_HOME/dbs (Unix) or $ ORACLE_HOME/DATABASE (NT) by default.
The password must start with an English letter. do not include Chinese characters.
Ntries indicates the maximum number of Super Users Allowed. This is optional. The first two must be specified. It is usually set to be larger than the actual needs, so as not to be insufficient.
After successful logon, restart Oracle and log on to sys and password. Remember that the password must be followed by the as sysdba. I opened the PL/SQL command window and logged on with the conn sys/password as sysdba!
Then I successfully logged on and granted the maximum DBA permission to the SCOTT user, in this way, I can have the edit permission on the table (in fact, I can grant SCOTT the corresponding permissions for this table operation. DBA permissions are too large and generally not safe ).





Http://blog.csdn.net/chenleixing/article/details/43318911

Zookeeper

Zookeeper

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.