正常监听状态
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