快速在oracle19c的pdb库里创建一个数据库用户

vi chk_pdb.sh

sqlplus / as sysdba <<!
col name format a20;
select sys_context ('USERENV', 'CON_NAME') from dual;
select con_id,dbid,NAME,OPEN_MODE from v\$pdbs;
!
echo "
oracle库假设用的是pdb库，名为pdborcl
sqlplus / as sysdba <<!
-- 1 、启动oracle19c的pdb库
alter pluggable database pdborcl open;
-- 2、查看启动情况
col name format a20;
select con_id,dbid,NAME,OPEN_MODE from v\$pdbs;
-- 3、切换到启动的pdb库
alter session set container=PDBORCL;
-- 4、确定切换到启动的pdb库
select sys_context ('USERENV', 'CON_NAME') from dual;
-- 5、在启动的pdb库里创建一个oracle用户
create user test01 identified by test01;
grant dba to test01;
!
"

sh chk_pdb.sh

[oracle@stdserv ~]$ sh chk_pdb.sh 

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 5 09:46:28 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> SQL> 
SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------
CDB$ROOT

SQL> 
    CON_ID       DBID NAME                 OPEN_MODE
---------- ---------- -------------------- ----------
         2 2793565277 PDB$SEED             READ ONLY
         3 3407629896 PDB1                 READ WRITE
         4 2857899685 PDB2                 MOUNTED
         5  979416812 PDB3                 MOUNTED

SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

oracle库假设用的是pdb库，名为pdborcl
sqlplus / as sysdba <<!
-- 1 、启动oracle19c的pdb库
alter pluggable database pdborcl open;
-- 2、查看启动情况
col name format a20;
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
-- 3、切换到启动的pdb库
alter session set container=PDBORCL;
-- 4、确定切换到启动的pdb库
select sys_context ('USERENV', 'CON_NAME') from dual;
-- 5、在启动的pdb库里创建一个oracle用户
create user test01 identified by test01;
grant dba to test01;
!