User:Administrator
Last Update:2020-7-14 14:28
### Code Reference
-
URL:https://docs.oracle.com/en/database/oracle/oracle-database/index.html
-
DESC:oracle12c查看版本|oracle12c查看组件|oracle12c查看模式|基本使用|慎用CREATE [PLUGGABLE|NULL] DATABASE 创建数据库
-
Last Update:2020-7-14 14:35
-
Time:2020-7-16 19:45 Tittle:oracle12c查看版本|oracle12c查看组件|oracle12c查看模式|基本使用|慎用CREATE [PLUGGABLE|NULL] DATABASE 创建数据库
-
Version:003
-
oracle12c查看组件
select * from dba_registry; -
oracle12c查看版本
select * from v$version; -
oracle12c查看模式
方法1 alter session set container=CDB$ROOT
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-8wMGfvRn-1594901169428)(http://redevm/uploads/big/f03974bab12b2bb1dd4ffa99f9cd9289.png)]- Snippet:
Jupyter Code
方法2 show parameter ENABLE_PLUGGABLE_DATABASE
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-3Ll7rAGr-1594901169435)(http://redevm/uploads/big/673b78994701b647904a72df3626b190.png)]方法3 select cdb from v$database;
- Snippet:
-
oracle12c创建插件库
(检查数据库参数ENABLE_PLUGGABLE_DATABASE为TRUE)我的系统路径设为/u01/app/oracle/oradata/db_rede/注意路径(最好不要这样建pdb,dbca静默模式安装更好,ORA-01917 12cR1版本目前没有方案处理,官方文档有出入!) CREATE PLUGGABLE DATABASE db_rede ADMIN USER rede IDENTIFIED BY 1 STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M) DEFAULT TABLESPACE usertbs DATAFILE '/u01/app/oracle/oradata/db_rede/rede01.dbf' SIZE 25M AUTOEXTEND ON PATH_PREFIX = '/u01/app/oracle/oradata/db_rede' FILE_NAME_CONVERT =('/u01/app/oracle/oradata/pdbseed/','/u01/app/oracle/oradata/db_rede/');
-
ORA-01917: user or role ‘PDB_DBA’ does not exist
-
Snippet:
Jupyter Code
Jupyter Code -
ORA-65104: operation not allowed on an inactive pluggable database
-
Snippet:
Jupyter Code
-
-
oracle12c常用命令
-
Snippet:
Jupyter Code--查看PDB信息(在CDB模式下) show pdbs --查看所有pdb select name,open_mode from v$pdbs; --v$pdbs为PDB信息视图 select con_id, dbid, guid, name , open_mode from v$pdbs; --切换容器 alter session set container=orcl1 --切换到PDBorcl1容器 alter session set container=CDB$ROOT --切换到CDB容器 --查看当前属于哪个容器 select sys_context('USERENV','CON_NAME') from dual; --使用sys_context查看属于哪个容器 show con_name --用show查看当前属于哪个容器 --启动PDB alter pluggable database orcl1 open; --开启指定PDB alter pluggable database all open; --开启所有PDB alter session set container=orcl1; --切换到PDB进去开启数据库 startup --关闭PDB alter pluggable database orcl1 close; --关闭指定的PDB alter pluggable database all close; --关闭所有PDB alter session set container=orcl1; --切换到PDB进去关闭数据库 shutdown immediate --创建或克隆前要指定文件映射的位置(需要CBD下sysdba权限,先创建路径,不然那会报错ORA-02097,ORA-01261) alter system set db_create_file_dest='/u01/app/oracle/oradata/orcdb/pdbseed'; --创建一个新的PDB:(需要CBD下sysdba权限) create pluggable database pdb3 admin user admin identified by admin; --ORA-65005,db_create_file_dest 为pdbseed alter pluggable database pdb3 open; --克隆PDB(需要CBD下sysdba权限) create pluggable database pdb3 from pdb2; --pdb2必须是打开的,才可以被打开 alter pluggable database orcl2 open; --然后打开这个pdb --删除PDB(需要CBD下sysdba权限) alter pluggable database orcl2 close; --关闭之后才能删除 drop pluggable database orcl2 including datafiles; --删除PDB orcl2 --设置CDB启动PDB自动启动(在这里使用的是触发器) CREATE OR REPLACE TRIGGER open_pdbs AFTER STARTUP ON DATABASE BEGIN EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN'; END open_pdbs; /
-
-
-
参考
- Time:2020-7-14 19:30 Tittle:csdn博客目录
- Time:2020-7-14 19:30 Tittle:step by step oracle 12c 手工创建CDB数据库(插件数据库)
- Time:2020-7-16 18:06 Tittle:DBCA静默方式安装数据库(docker容器oracle 12c没有图形界面,需要部署一个cdb模式的数据库来测试tde)