Oracle user unlock

Oracle user unlock

Connect first

SQL * Plus: Release 12.1.0.2.0 Production on Thursday February 12 15:40:422015

Copyright (c) 1982,201 4, Oracle. All rights reserved.

Enter the User name: system

Enter the password:

Last Successful Logon Time: Thursday, December 31, 2015 10:26:40 +

Connect:

Oracle Database 12c Enterprise EditionRelease 12.1.0.2.0-64bit Production

With the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing opt

Ions

// Wake up and format the corresponding columns for observation

SQL> column username format a20

SQL> column account_status format a20

SQL> set pagesize 400

// Enter the following select statement to query the user and status information from dba_users.

SQL> select username, account_status fromdba_users

USERNAME ACCOUNT_STATUS

----------------------------------------

C ## TEST OPEN

C ## SCOTT OPEN

ORACLE_OCM EXPIRED & LOCKED

Ojvmsys expired & LOCKED

Syskm expired & LOCKED

XS $ null expired & LOCKED

Gsmcatuser expired & LOCKED

Mddata expired & LOCKED

Sysbackup expired & LOCKED

Dip expired & LOCKED

Sysdg expired & LOCKED

APEX_PUBLIC_USER EXPIRED & LOCKED

SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED

R

 

SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED

R

 

Gsmuser expired & LOCKED

Audsys expired & LOCKED

C ## USER1 OPEN

FLOWS_FILES EXPIRED & LOCKED

Dvf expired & LOCKED

Mdsys expired & LOCKED

Ordsys expired & LOCKED

Dbsnmp expired & LOCKED

Wmsys expired & LOCKED

APEX_040200 EXPIRED & LOCKED

Appqossys expired & LOCKED

Gpressmin_internal EXPIRED & LOCKED

Orddata expired & LOCKED

Ctxsys expired & LOCKED

Anonymous expired & LOCKED

Xdb expired & LOCKED

Ordplugins expired & LOCKED

Dvsys expired & LOCKED

SI_INFORMTN_SCHEMA EXPIRED & LOCKED

Olapsys expired & LOCKED

Lbacsys expired & LOCKED

Outln expired & LOCKED

SYSTEM OPEN

SYS OPEN

38 rows have been selected.

As shown above, if account_status of username is open, it indicates that the user has been unlocked. If account_status of username is EXPIRED, it indicates that the user has EXPIRED. If account_status of username is locked, indicates that the user is locked. You cannot log on to an expired or locked account. You must first unlock the account.

// Next we will unlock the outln user

SQL> alter user outln account unlock;

The user has changed.

// Specify a password for the user

SQL> alter user outln identified byadmin;

The user has changed.

// Query the user

SQL> select username, account_status fromdba_users;

USERNAME ACCOUNT_STATUS

----------------------------------------

C ## TEST OPEN

C ## SCOTT OPEN

ORACLE_OCM EXPIRED & LOCKED

Ojvmsys expired & LOCKED

Syskm expired & LOCKED

XS $ null expired & LOCKED

Gsmcatuser expired & LOCKED

Mddata expired & LOCKED

Sysbackup expired & LOCKED

Dip expired & LOCKED

Sysdg expired & LOCKED

APEX_PUBLIC_USER EXPIRED & LOCKED

SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED

R

SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED

R

Gsmuser expired & LOCKED

Audsys expired & LOCKED

C ## USER1 OPEN

FLOWS_FILES EXPIRED & LOCKED

Dvf expired & LOCKED

Mdsys expired & LOCKED

Ordsys expired & LOCKED

Dbsnmp expired & LOCKED

Wmsys expired & LOCKED

APEX_040200 EXPIRED & LOCKED

Appqossys expired & LOCKED

Gpressmin_internal EXPIRED & LOCKED

Orddata expired & LOCKED

Ctxsys expired & LOCKED

Anonymous expired & LOCKED

Xdb expired & LOCKED

Ordplugins expired & LOCKED

Dvsys expired & LOCKED

SI_INFORMTN_SCHEMA EXPIRED & LOCKED

Olapsys expired & LOCKED

Lbacsys expired & LOCKED

OUTLN OPEN

SYSTEM OPEN

SYS OPEN

38 rows have been selected.

As shown above, outln is displayed as open.

// Test the connection

SQL> connect outln/admin

Connected.