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