• oracle 12c 初步操作


    查看是否为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.
  • 相关阅读:
    【转】内网yum源搭建
    IO-同步,异步,阻塞,非阻塞,阅读摘要
    java如何获取当前时间,精确到毫秒
    java编写创建数据库和表的程序
    Java得到当前系统时间,精确到毫秒的几种方法
    linux学习 XShell上传、下载本地文件到linux服务器
    java的InputStream和OutputStream的理解
    SpringMVC使用session实现简单登录
    spring MVC 的MultipartFile转File读取
    SpringMvc文件上传和下载
  • 原文地址:https://www.cnblogs.com/kramer/p/3894991.html
Copyright © 2020-2023  润新知