• ORA28000:the account is locked(Linux连接Oracle)


    1,切换用户,连接oracle数据库

    [root@dh-db-lsvwbF7y ~]# su - oracle
    [oracle@dh-db-lsvwbF7y ~]$
    [oracle@dh-db-lsvwbF7y ~]$ sqlplus /nolog
    
    SQL*Plus: Release 11.2.0.4.0 Production on 星期三 2月 16 17:32:28 2022
    
    Copyright (c) 1982, 2013, Oracle.  All rights reserved.
    
    SQL> conn /as sysdba;
    已连接。

    2,查看用户状态,并将用户状态解锁

    SQL> select username,account_status from dba_users where username = 'DSSC';
    
    USERNAME
    --------------------------------------------------------------------------------
    ACCOUNT_STATUS
    --------------------------------------------------------------------------------
    DSSC
    LOCKED
    
    
    SQL> alter user DSSC account unlock;
    
    用户已更改。
    
    SQL>
  • 相关阅读:
    Mysql_常规操作
    三剑客
    Nginx_安全2
    shell_常规小脚本
    redis数据库持久化
    redis数据库操作
    keepalived高可用lvs集群
    ansible的roles角色
    keepalived高可用
    keepalived概念
  • 原文地址:https://www.cnblogs.com/bobobjh/p/15901703.html
Copyright © 2020-2023  润新知