Solutions for Oracle 10 Gb user unlocking and restricted execution Permissions

This article is intended to solve the problem of Oracle 10g user unlocking and restricted execution permissions. It is hoped that this article will help you understand Oracle 10g user unlocking.

Recently, we found that some of the company's on-site database systems have the following problems:

1) The user is locked, but the Oracle 10g user cannot be unlocked.

Note: a user is often locked on a site. He just used [alter user <user_name> account unlock; commit;] and still cannot log on. He still reports an error: the user is locked.

Solution: Check the DBA_USERS table to view the user's status. Whether the lock is changed to the LOCKED (TIMED) status indicates that the user is LOCKED ).

 
 

  
  
Select*FromUSER_HISTORY $-- Check whether the user password has expired 
  
  
Select*FromDba_profiles-- View User profile Settings 
 
 

Solution:

 
 

  
  
Sqlplus/nolog
  
  
Conn/AsSysdba
  
  
Alter User<User_name> account unlock;-- Unlock 
  
  
Alter User<User_name>PasswordExpire;-- Password expired 
  
  
Alter User<User_name> identifiedBy<Password>;-- Reset Password 
 
 

Or alter profile default limit failed_login_Attempts unlimited;

Then you can log on.

Note: To view the password limit for any account, you can query the Expire_Date column in The DBA_USERS data dictionary view. If you want to view the data, you can query the Expiry_Date column in The USER_USERS data dictionary view (using SQL * Plus or a client-based query tool ).

2) ORA-01031: insufficient privileges Problems

ORA-01031: insufficient privileges error reported while logging on with sysdba

Cause: the operating system uses the Oracle user to log on, and then uses

 
 

  
  
sqlplus /nolog   
  
  
conn /as sysdba 
 
 

This requires that the operating system user before connect is a DBA group. Therefore, you must first determine whether the Oracle user belongs to the DBA group and find that the user belongs to the staff group.

Solution: After modifying the group attributes of Oracle users, the problem is solved.

1. How to unlock users in Oracle
2. Oracle username re-indexing method
3. Explain how to query user tablespaces in Oracle
4. An analysis of the management method of the Oracle user permission table
5. Introduction to Oracle database backup and recovery features