oracle登录sys用户代码,oracle sys 用户登录

登录名：sys as sysdba

密码 ：******

## select name,pdb from v$services order by 1; 查看pdb cdb

## alter session set container=ORCLPDB     修改container到pdb

alter pluggable database ORCLPDB open;  修改ORCLPDB状态

select * from dba_users;    查看所有用户

select * from dba_role_privs where granted_role='DBA'; ##查看拥有DBA权限的用户

oracle pdb状态 如果为read only想要变为读写状态。 则要先变为close immediate；

alter pluggable database PDB$SEED  close immediate;

再改为读写

alter pluggable database PDB$SEED  open read write;