查看oracle数据库版本信息和当前连接用户

使用show命令显示数据库版本信息和当前连接用户

SQL> show release;
release 1202000100
SQL> show user;
USER is "SYS"
SQL> select name,cdb,open_mode from v$database;

NAME      CDB OPEN_MODE
--------- --- --------------------
ORCL      NO  READ WRITE

设置当前列的字段个数为20，就不会分行显示了

SQL> col username for a20;

查看oracle账户的锁定状态，解锁账户和设置账户口令

SQL> select username,account_status from dba_users;

USERNAME             ACCOUNT_STATUS
-------------------- --------------------------------
SYS                  OPEN
SYSTEM               OPEN
XS$NULL              EXPIRED & LOCKED
OJVMSYS              EXPIRED & LOCKED
LBACSYS              EXPIRED & LOCKED
OUTLN                EXPIRED & LOCKED
SYS$UMF              EXPIRED & LOCKED
DBSNMP               EXPIRED & LOCKED
APPQOSSYS            EXPIRED & LOCKED
DBSFWUSER            EXPIRED & LOCKED
GGSYS                EXPIRED & LOCKED

USERNAME             ACCOUNT_STATUS

解锁用户

SQL> alter user Oracle_Ocm Account Unlock;

查询解锁的用户

SQL> select username,account_status from dba_users where username='ORACLE_OCM';

USERNAME             ACCOUNT_STATUS
-------------------- --------------------------------
ORACLE_OCM           EXPIRED

更新sys口令

SQL> alter user sys identified by oracle;

User altered.

查看没有锁定的账户

SQL> select username,account_status from dba_users where account_status='OPEN';

USERNAME             ACCOUNT_STATUS
-------------------- --------------------------------
SYS                  OPEN
SYSTEM               OPEN
FGEDU                OPEN
WXJDB                OPEN

Mr丶点心

打赏 海报 链接