oracle 12c 初步操作
2024-09-27 00:39:03
查看是否为cdb
SQL> select name,cdb,open_mode,con_id from v$database; NAME CDB OPEN_MODE CON_ID
--------------------------- --------- ------------------------------------------------------------ ----------
ORCL12C YES READ WRITE 0
查看当前容器
SQL> show con_name CON_NAME
------------------------------
CDB$ROOT
查看有多少个PDB
SQL> select con_id, dbid, guid, name , open_mode from v$pdbs;
CON_ID DBID GUID NAME OPEN_MODE
---------- ---------- ------------------------------------------------ ---------------------------- ------------------------------
2 4096928455 FF675156E40B2F3DE043B303A8C00283 PDB$SEED READ ONLY
3 2301438674 FF6761430B3E311EE043B303A8C00BA6 PDBORCL READ WRITE
关闭PDB
SQL> alter session set container=PDBORCL; Session altered. SQL> shutdown immediate
Pluggable Database closed.
SQL> show con_name CON_NAME
------------------------------
PDBORCL
SQL> alter session set container=CDB$ROOT; Session altered. SQL> select con_id, dbid, guid, name , open_mode from v$pdbs; CON_ID DBID GUID NAME OPEN_MODE
---------- ---------- ------------------------------------------------ ---------------------------- ------------------------------
2 4096928455 FF675156E40B2F3DE043B303A8C00283 PDB$SEED READ ONLY
3 2301438674 FF6761430B3E311EE043B303A8C00BA6 PDBORCL MOUNTED
启动PDB
SQL> alter session set container=PDBORCL; Session altered. SQL> STARTUP
Pluggable Database opened.
进入PDB做一些日常操作
SQL> select FILE_NAME,TABLESPACE_NAME ,file_id from dba_data_files; FILE_NAME TABLESPACE_NAME FILE_ID
------------------------------------------------------------------------------------ ---------------------------- ----------
/u01/app/oracle/oradata/orcl12c/pdborcl/example01.dbf EXAMPLE 11
/u01/app/oracle/oradata/orcl12c/pdborcl/SAMPLE_SCHEMA_users01.dbf USERS 10
/u01/app/oracle/oradata/orcl12c/pdborcl/sysaux01.dbf SYSAUX 9
/u01/app/oracle/oradata/orcl12c/pdborcl/system01.dbf SYSTEM 8
创建PDB
SQL> CREATE PLUGGABLE DATABASE pdbtest1 ADMIN USER pdbtest1admin IDENTIFIED BY pdbtest1admin
2 STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)
3 DEFAULT TABLESPACE test1tb1
4 DATAFILE '/u01/app/oracle/oradata/orcl12c/pdbtest1/test1tb101.dbf' size 50m autoextend off
5 FILE_NAME_CONVERT =('/u01/app/oracle/oradata/orcl12c/pdbseed','/u01/app/oracle/oradata/orcl12c/pdbtest1'); Pluggable database created.
最新文章
- MVC5+EF6+AutoMapper+Bootstrap打造在线博客（1.0）
- SQL注入POC
- HyperLink控件
- JAVA学习提高之－－－－安装多个JDK版本的问题
- Log4j乱码
- IOS中的UINavigationController（导航控制器）
- Windows Kernel Way 扉言
- tomcat+nginx+redis实现均衡负载、session共享(二)
- dpkg卸载和安装deb
- GoldentGate Oracle to Oracle 初始化具体解释
- 201521123112《Java程序设计》第6周学习总结
- PuTsangTo-单撸游戏开发02 测试场景与单轴移动
- MT 【331】两元非齐次不等式
- webbrowser 里的js函数和C#的函数互相调用方式
- Notes ： <Hands-on ML with Sklearn & TF> Chapter 4
- objdump和backtrace的配合使用
- 性能测试三十五：jvm垃圾回收-GC
- LOJ#2427. 「POI2010」珍珠项链 Beads
- [转][C#]HttpClient 代码示例
- 主角场景Shader效果：光影