Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Linux \ Linux user status query, and to unlock locked user     - Zend Studio PHP syntax color scheme to export (Linux)

- Oracle delete table space prompted ORA-00604 and ORA-38301 (Database)

- Do not find ifconfig eth0 and IP address under CentOS6.5 (Linux)

- TOAD connect DB2 error SQL1460N solve (Database)

- C ++ inheritance and derived (induction principle) (Programming)

- How do I upgrade to Ubuntu 15.04 (Beta) (Linux)

- Linux protobuf-c (Linux)

- Shuffle Process Arrangement in MapReduce (Server)

- CentOS7 boot systemd introduction and use of management (Linux)

- Hands to teach you to solve Ubuntu error message (Linux)

- Usage sed some of the parameters (Linux)

- 20+ Best Practices article MySQL Performance Optimization (Database)

- Oracle to start to solve the error ORA-27102 (Database)

- configuration ssh without password under Linux (Linux)

- How to Install Winusb in Ubuntu 14.04 (Linux)

- CentOS installation Docker series (Linux)

- 7 extremely dangerous Linux commands (Linux)

- Open Ubuntu system updates (Linux)

- To batch create users under Linux (Linux)

- Arduino UNO simulation development environment set up and run simulation (Linux)

 
         
  Linux user status query, and to unlock locked user
     
  Add Date : 2018-11-21      
         
         
         
  The first if the current user is root, then the first switch to the Oracle user, and then open sqlplus, and give dba role.

[Oracle @ oa2RedHat ~] $ sqlplus / nolog

SQL * Plus: Release 11.2.0.1.0 Production on Fri Oct 10 16:41:26 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL> conn / as sysdba;
Connected.
SQL> select username, account_status from dba_users;

Get the following menu list, and then find you need a user to see his status, if locked, then execute the following command to unlock

SQL> alter user test account unlock;

Of course, you can also use plsql client tools, remote connection you need to unlock the database, using dba role, and then do the unlocking operation in the graphical interface. So it is relatively simple.
     
         
         
         
  More:      
 
- Linux FTP setting file description (Server)
- Install the Red Hat Container Development Kit on OSX (Server)
- Unix system security configuration (Linux)
- To remove those IP is prohibited Fail2ban on CentOS 6/7 (Server)
- iOS in Singleton (Programming)
- Python common data type summary (Programming)
- MySQL management partition table (Database)
- How to make GRub instead of the default Ubuntu software center (Linux)
- Sshuttle A VPN-based transparent proxy that uses ssh (Server)
- MySQL migration tool used in the production environment (Database)
- Linux install deploy Ansible (Linux)
- Setting up Linux machine through a proxy firewall (Linux)
- The difference between free command displays the buffers and cache (Linux)
- Parameters of the extra port MySQL 5.6 (Database)
- Linux iptables port mapping settings (Server)
- How to configure AWStats in Ubuntu Server (Server)
- Linux dynamic libraries and Guide (Programming)
- Analysis of Java keyword final (Programming)
- C # function (Programming)
- Python: Finding meet the conditions specified in the file directory (Programming)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.