oracle手工建库脚本

------non-cdb

CREATE DATABASE orcl
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1 ('/dbdata/app/oracle/oradata/orcl/redo01a.log') SIZE 500M BLOCKSIZE 512,
           GROUP 2 ('/dbdata/app/oracle/oradata/orcl/redo02a.log') SIZE 500M BLOCKSIZE 512,
           GROUP 3 ('/dbdata/app/oracle/oradata/orcl/redo03a.log') SIZE 500M BLOCKSIZE 512
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   CHARACTER SET ZHS16GBK
   NATIONAL CHARACTER SET AL16UTF16
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/dbdata/app/oracle/oradata/orcl/system01.dbf' SIZE 325M REUSE
   SYSAUX DATAFILE '/dbdata/app/oracle/oradata/orcl/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE users
      DATAFILE '/dbdata/app/oracle/oradata/orcl/users01.dbf'
      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/dbdata/app/oracle/oradata/orcl/temp01.dbf'
      SIZE 20M REUSE
   UNDO TABLESPACE undotbs
      DATAFILE '/dbdata/app/oracle/oradata/orcl/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

In SQL*Plus, connect to your Oracle Database instance with the SYSDBA administrative privilege:

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

 

-------pdb

CREATE DATABASE cdb
  USER SYS IDENTIFIED BY oracle
  USER SYSTEM IDENTIFIED BY oracle
  LOGFILE GROUP 1 ('/u01/app/oracle/oradata/cdb/redo01a.log','/u01/app/oracle/oradata/cdb/redo01b.log') 
             SIZE 100M BLOCKSIZE 512,
          GROUP 2 ('/u01/app/oracle/oradata/cdb/redo02a.log','/u01/app/oracle/oradata/cdb/redo02b.log') 
             SIZE 100M BLOCKSIZE 512
  MAXLOGHISTORY 1
  MAXLOGFILES 16
  MAXLOGMEMBERS 3
  MAXDATAFILES 1024
  CHARACTER SET AL32UTF8
  NATIONAL CHARACTER SET AL16UTF16
  EXTENT MANAGEMENT LOCAL
  DATAFILE '/u01/app/oracle/oradata/cdb/system01.dbf' SIZE 700M
  SYSAUX DATAFILE '/u01/app/oracle/oradata/cdb/sysaux01.dbf' SIZE 550M
  DEFAULT TABLESPACE deftbs
     DATAFILE '/u01/app/oracle/oradata/cdb/deftbs01.dbf' SIZE 500M
  DEFAULT TEMPORARY TABLESPACE tempts1
     TEMPFILE '/u01/app/oracle/oradata/cdb/temp01.dbf' SIZE 20M 
  UNDO TABLESPACE undotbs1
     DATAFILE '/u01/app/oracle/oradata/cdb/undotbs01.dbf' SIZE 200M 
  ENABLE PLUGGABLE DATABASE   
    SEED
    FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/cdb/', 
'/u01/app/oracle/oradata/cdb/pdbseed/')
    SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
    SYSAUX DATAFILES SIZE 100M
  USER_DATA TABLESPACE usertbs
    DATAFILE '/u01/app/oracle/oradata/cdb/pdbseed/usertbs01.dbf' SIZE 200M;

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

@?/rdbms/admin/utlrp.sql