Locked user

This topic describes errors related to a locked user and the troubleshooting procedure.

Error: ERROR 3118

Error messages

ERROR 3118 (HY000):User locked

Example

When you log on as the ny1 user, this error is returned, indicating that this user is locked.

[admin@k08j13249.eu95sqa /home/admin]
$obclient -h10.0.0.0 -P2881 -uny@Oracle -p -A
Enter password:
ERROR 3118 (HY000): User locked

Solution

1. Log on as the SYS user.

   [admin@k08j13249.eu95sqa /home/admin]
   $obclient -h10.0.0.0 -P2881 -usys@Oracle -p -A
   Enter password:
   Welcome to the OceanBase.  Commands end with ; or \g.
   Your OceanBase connection id is 3221583828
   Server version: OceanBase 3.2.4.0 (r100000072022102819-2a28da9e758e2d232c41fa1a1b0070a08b77dd7d) (Built Oct 28 2022 19:46:38)
   
   Copyright (c) 2000, 2018, OceanBase Corporation Ab and others.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   

2. Unlock the ny user.

   obclient> ALTER USER ny ACCOUNT UNLOCK ;
   Query OK, 0 rows affected
   

3. Log on as the ny user again.

   [admin@k08j13249.eu95sqa /home/admin]
   $obclient -hxx.xx.xx.xx -P2881 -uny@Oracle -p -A
   Enter password:
   Welcome to the OceanBase.  Commands end with ; or \g.
   Your OceanBase connection id is 3221584568
   Server version: OceanBase 3.2.4.0 (r100000072022102819-2a28da9e758e2d232c41fa1a1b0070a08b77dd7d) (Built Oct 28 2022 19:46:38)
   
   Copyright (c) 2000, 2018, OceanBase Corporation Ab and others.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.