• 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.
  • 相关阅读:
    Jenkins的多个任务并串联参数传递
    jenkins任务构建失败重试插件Naginator Plugin
    通过hive向写elasticsearch的写如数据
    Elasticsearch中的索引管理和搜索常用命令总结
    Elasticsearch安装
    运行 Spark on YARN
    Jenkins console输出乱码???
    spark的standlone模式安装和application 提交
    多种排序算法整理
    结构型模式(二)
  • 原文地址:https://www.cnblogs.com/kramer/p/3894991.html
Copyright © 2020-2023  润新知