oracle如何查看链接用户,查看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