Oracle12c创建非公有用户方法

1.  登陆数据库 

sqlplus /nolog

2. 连接数据库

conn / as sysdba; 

3.select con_id,dbid,NAME,OPEN_MODE from v$pdbs;//查看数据库

4.alter session set container=ORCLPDB;//设置容器为pbd,3步骤查询出来的第二列con_id;

5.打开

alter session set container=PDBORCL;

alter pluggable database PDBORCL open;

或者使用SYS用户创建创建触发器:

CREATE TRIGGER open_all_pdbs

  AFTER STARTUP ON DATABASE

BEGIN

   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';

END ;

/

这样数据库启动就打开PDB;

6.创建普通用户;

create user name identified by password;

grant connect,resource,dba to name;

7.查看实例

8.在tns配置实例:

9.登陆实例为 orclpdb;

10.oracle12c的em谁会用麻烦告知下,谢谢