61 lines
1.5 KiB
Markdown
Executable File
61 lines
1.5 KiB
Markdown
Executable File
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
|
|
|