databaseの作成 12c

oracle

必要な環境変数の設定

  • シェルがbashの場合
# ~/.bash_profile
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
ORACLE_SID=O12C
PATH=$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin

export PATH

パスワードファイルの作成

$ cd $ORACLE_HOME/dbs
$ orapwd file=orapwO12C.ora

初期化パラメータファイルの作成

$ vi $ORACLE_HOME/dbs

db_name='O12C'
memory_target=1G
processes=150
db_block_size=8192
db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle/'
dispatchers='(PROTOCOL=TCP)(SERVICE=O12CXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files=('/u01/ctlfile/O12C/control01.ctl', '/u02/ctlfile/O12C/control02.ctl')

データベースに接続 & サーバパラメータファイルの作成

$ sqlplus /nolog
SQL> conn / as sysdba
SQL> create spfile from pfile;

データベースをnomountで起動

SQL> startup nomount

CREATE DATABASE文を実行

SQL> CREATE DATABASE O12C
  MAXLOGFILES 16
  MAXLOGMEMBERS 4
  MAXDATAFILES 1024
  MAXLOGHISTORY 680
  CHARACTER SET AL32UTF8
DATAFILE
  '/u01/dbfile/O12C/system01.dbf'
    SIZE 500M REUSE
    EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE undotbs1 DATAFILE
  '/u02/dbfile/O12C/undobs01.dbf'
    SIZE 800M
SYSAUX DATAFILE
  '/u01/dbfile/O12C/sysaux01.dbf'
    SIZE 500M
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
  '/u02/dbfile/O12C/temp01.dbf'
    SIZE 500M
DEFAULT TABLESPACE USERS DATAFILE
  '/u01/dbfile/O12C/users01.dbf'
  SIZE 50M
LOGFILE GROUP 1
  ('/u01/oraredo/O12C/redo01a.rdo',
   '/u02/oraredo/O12C/redo02a.rdo') SIZE 200M,
  GROUP 2
  ('/u01/oraredo/O12C/redo01b.rdo',
   '/u02/oraredo/O12C/redo02b.rdo') SIZE 200M,
  GROUP 3
  ('/u01/oraredo/O12C/redo01c.rdo',
   '/u02/oraredo/O12C/redo02c.rdo') SIZE 200M
USER SYS IDENTIFIED BY Welcome#1
USER SYSTEM IDENTIFIED BY Welcome#1;

必要なスクリプトを実行

SQL> conn / as sysdba
SQL> @?/rdbms/admin/catalog
SQL> @?/rdbms/admin/catproc
SQL> @?/rdbms/admin/utlrp
SQL> conn system/Welcome#1
SQL> @?/sqlplus/admin/pupbtl