CDB、PDB相关管理命令（持续补充中）

DBA一二记

已于 2022-10-18 15:51:49 修改

阅读量285

点赞数

文章标签：数据库 oracle sql linux dba

于 2022-10-18 14:00:04 首次发布

本文链接：https://blog.csdn.net/qq_41474349/article/details/127387253

版权

正常监听状态

lsnrctl status

在这里插入图片描述

看CDB名字

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT

查看所有PDB

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO

查看PDB具体状态

SQL> SELECT con_id,NAME,OPEN_MODE,restricted from v$PDBS;

    CON_ID NAME       OPEN_MODE  RES
---------- ---------- ---------- ---
         2 PDB$SEED   READ ONLY  NO
         3 PDB1       READ WRITE NO

查看dbf位置

SQL> col NAME for a100;
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/CDB1/system01.dbf
/u01/app/oracle/oradata/CDB1/sysaux01.dbf
/u01/app/oracle/oradata/CDB1/undotbs01.dbf
/u01/app/oracle/oradata/CDB1/pdbseed/system01.dbf
/u01/app/oracle/oradata/CDB1/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/CDB1/users01.dbf
/u01/app/oracle/oradata/CDB1/pdb1/system01.dbf
/u01/app/oracle/oradata/CDB1/pdb1/sysaux01.dbf
/u01/app/oracle/oradata/CDB1/pdb1/users01.dbf

数据库启停

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  838858904 bytes
Fixed Size                  9140376 bytes
Variable Size             222298112 bytes
Database Buffers          599785472 bytes
Redo Buffers                7634944 bytes
Database mounted.
Database opened.

开启PDB

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           MOUNTED
SQL> alter pluggable database pdb1 open;

Pluggable database altered.

CDB、PDB切换

SQL> alter session set container=CDB$ROOT;

Session altered.

EMCC连接PDB

su - oracle
sqlplus / as sysdba
alter session set container=pdb1;
select dbms_xdb_config.gethttpport() from dual;
exec dbms_xdb_config.setHTTPPort(8091);

访问网站http://192.168.142.138:8091/em