OMFを使用しない orcl
OMFを使用する PROD1
非CDB(bigfile) PROD2
https://docs.oracle.com/cd/F19136_01/admin/creating-and-configuring-an-oracle-database.html#GUID-CE58B606-4534-4149-878F-C0DFEF32AA49
https://docs.oracle.com/cd/F19136_01/multi/creating-and-configuring-a-cdb.html#GUID-F20BEFA4-3F40-421E-B5BB-EE6D9808E3F0
mkdir -p /oradata/orcl
chown -R oracle: /oradata
vim /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=7000M 0 0
df -h
umount /dev/shm
mount /dev/shm
df -h
su - oracle
vim ~/.bashrc
alias orcl='export ORACLE_SID=orcl'
alias PROD1='export ORACLE_SID=PROD1'
alias PROD2='export ORACLE_SID=PROD2'
alias PROD3='export ORACLE_SID=PROD3'
alias cdh='cd $ORACLE_HOME'
alias cdb='cd $ORACLE_BASE'
alias sql='sqlplus / as sysdba'
. ~/.bashrc
cdh
cd dbs
export ORACLE_SID=orcl
vim initorcl.ora
DB_NAME=orcl
DB_DOMAIN=example.com
CONTROL_FILES=('/oradata/orcl/control01.ctl','/oradata/orcl/control02.ctl')
ENABLE_PLUGGABLE_DATABASE=true
MEMORY_TARGET=1G
mkdir -p /oradata/orcl/pdbseed
sqlplus / as sysdba
startup nomount;
CREATE DATABASE orcl
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/oradata/orcl/redo01a.log','/oradata/orcl/redo01b.log')
SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/oradata/orcl/redo02a.log','/oradata/orcl/redo02b.log')
SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/oradata/orcl/redo03a.log','/oradata/orcl/redo03b.log')
SIZE 100M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/oradata/orcl/system01.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/oradata/orcl/sysaux01.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE users
DATAFILE '/oradata/orcl/users01.dbf'
SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/oradata/orcl/temp01.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE undo
DATAFILE '/oradata/orcl/undo01.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
ENABLE PLUGGABLE DATABASE
SEED
FILE_NAME_CONVERT = ('/oradata/orcl/',
'/oradata/orcl/pdbseed/')
SYSTEM DATAFILES SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOCAL UNDO ON
USER_DATA TABLESPACE usertbs
DATAFILE '/oradata/orcl/pdbseed/usertbs01.dbf'
SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
-- 対話的
@?/rdbms/admin/catcdb.sql
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql
conn system/oracle
@?/sqlplus/admin/pupbld.sql
conn / as sysdba
create spfile from pfile;
shutdown immediate
startup
----
mkdir /oradata/PROD1
export ORACLE_SID=PROD1
cdh
cd dbs
vim initPROD1.ora
DB_NAME=PROD1
DB_DOMAIN=example.com
CONTROL_FILES=('/oradata/PROD1/control01.ctl','/oradata/PROD1/control02.ctl')
ENABLE_PLUGGABLE_DATABASE=true
MEMORY_TARGET=1G
DB_CREATE_FILE_DEST='/oradata/PROD1'
sqlplus / as sysdba
startup nomount;
CREATE DATABASE PROD1
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undo
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOCAL UNDO ON;
-- 対話的
@?/rdbms/admin/catcdb.sql
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql
conn system/oracle
@?/sqlplus/admin/pupbld.sql
conn / as sysdba
create spfile from pfile;
shutdown immediate
startup
----
mkdir -p /oradata/PROD2
export ORACLE_SID=PROD2
cdh
cd dbs
vim initPROD2.ora
DB_NAME=PROD2
DB_DOMAIN=example.com
CONTROL_FILES=('/oradata/PROD2/control01.ctl','/oradata/PROD2/control02.ctl')
MEMORY_TARGET=1G
sqlplus / as sysdba
startup nomount;
CREATE DATABASE PROD2
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/oradata/PROD2/redo01a.log','/oradata/PROD2/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/oradata/PROD2/redo02a.log','/oradata/PROD2/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/oradata/PROD2/redo03a.log','/oradata/PROD2/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
set default bigfile tablespace
EXTENT MANAGEMENT LOCAL
DATAFILE '/oradata/PROD2/system01.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/oradata/PROD2/sysaux01.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE users
DATAFILE '/oradata/PROD2/users01.dbf'
SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/oradata/PROD2/temp01.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE undo
DATAFILE '/oradata/PROD2/undo01.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
USER_DATA TABLESPACE usertbs
DATAFILE '/oradata/PROD2/usertbs01.dbf'
SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql
conn system/oracle
@?/sqlplus/admin/pupbld.sql
conn / as sysdba
create spfile from pfile;
shutdown immediate
startup
----
