notes/tiddlywiki/Oracle 19c manual CDB creation.md

initASTYPRD.ora:

db_name=ASTY
instance_name=ASTYPRD
db_unique_name=ASTYPRD
compatible=19.0.0.0.0
control_files=(/data/ASTYPRD/control01.ctl)
db_create_file_dest=/data
db_create_online_log_dest_1=/data
db_recovery_file_dest_size=4G
db_recovery_file_dest=/fra
log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'
log_archive_format=%t_%s_%r.arc
db_block_size=8192
open_cursors=300
diagnostic_dest=/app/oracle/base/admin/ASTYPRD
sga_max_size=3G
sga_target=3G
pga_aggregate_target=512M
pga_aggregate_limit=2G
processes=350
audit_file_dest=/app/oracle/base/admin/ASTYPRD/adump
audit_trail=db
remote_login_passwordfile=exclusive
undo_tablespace=TS_UNDO
enable_pluggable_database=TRUE

Create database:

spool createdb.log

create database ASTY
datafile  size 700M  autoextend on next  64M
extent management local
SYSAUX datafile  size 512M autoextend on next  64M
default temporary tablespace TS_TEMP tempfile size 256M autoextend off
undo tablespace TS_UNDO datafile  size 256M autoextend off
character set AL32UTF8
national character set AL16UTF16
logfile group 1 size 64M,
group 2 size 64M
user SYS identified by secret user SYSTEM identified by secret
enable pluggable database;

create tablespace USERS datafile size 32M autoextend ON next 32M;
alter database default tablespace USERS;

spool off

Ensure using Oracle provided perl:

export PATH=$ORACLE_HOME/perl/bin:$PATH

Run catcdb.sql providing the required informations:

@?/rdbms/admin/catcdb.sql