105 lines
3.5 KiB
Plaintext
Executable File
105 lines
3.5 KiB
Plaintext
Executable File
~~ Context: DBNAME=JABBA, db_unique_name=JABBAPRD, instances JABBA1/JABBA2
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
|
mkdir -p /app/base/admin/JABBA
|
|
cd /app/base/admin/JABBA
|
|
mkdir scripts divers adump init diag
|
|
|
|
~~ initJABBA.ora
|
|
~~~~~~~~~~~~~~~~
|
|
|
|
*.db_name=JABBA
|
|
*.db_unique_name=JABBAPRD
|
|
*.compatible=12.1.0.2.0
|
|
*.control_files=(+DATA/JABBAPRD/control01.ctl,+DATA/JABBAPRD/control02.ctl)
|
|
*.db_create_file_dest=+DATA
|
|
*.db_create_online_log_dest_1=+DATA
|
|
*.db_recovery_file_dest_size=4G
|
|
*.db_recovery_file_dest=+RECO
|
|
*.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/base/admin/JABBA
|
|
*.sga_max_size=3G
|
|
*.sga_target=3G
|
|
*.pga_aggregate_target=512M
|
|
*.pga_aggregate_limit=1G
|
|
*.processes=350
|
|
*.audit_file_dest=/app/base/admin/JABBA/adump
|
|
*.audit_trail=db
|
|
*.remote_login_passwordfile=exclusive
|
|
JABBAPRD1.instance_number=1
|
|
JABBAPRD2.instance_number=2
|
|
JABBAPRD1.thread=1
|
|
JABBAPRD2.thread=2
|
|
JABBAPRD1.undo_tablespace=UNDOTBS1
|
|
JABBAPRD2.undo_tablespace=UNDOTBS2
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
|
startup nomount pfile='/mnt/yavin4/tmp/_oracle_/ad-hoc/initJABBA.ora'
|
|
|
|
create database JABBA
|
|
datafile size 700M autoextend on next 64M
|
|
extent management local
|
|
SYSAUX datafile size 512M autoextend on next 64M
|
|
default temporary tablespace TEMP tempfile size 256M autoextend off
|
|
undo tablespace UNDOTBS1 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;
|
|
|
|
create undo tablespace UNDOTBS2 datafile size 256M autoextend off;
|
|
create tablespace USERS datafile size 32M autoextend ON next 32M;
|
|
alter database default tablespace USERS;
|
|
|
|
@?/rdbms/admin/catalog.sql
|
|
@?/rdbms/admin/catproc.sql
|
|
@?/rdbms/admin/catclust.sql
|
|
@?/rdbms/admin/utlrp.sql
|
|
|
|
|
|
alter database add logfile thread 2
|
|
group 3 size 64M,
|
|
group 4 size 64M;
|
|
|
|
alter database enable public thread 2;
|
|
|
|
|
|
~~ add cluster_database=true in init.ora and restart instance on 2 nodes
|
|
startup pfile='/mnt/yavin4/tmp/_oracle_/ad-hoc/initJABBA.ora'
|
|
|
|
~~ create spfile on ASM
|
|
create spfile='+DATA/JABBAPRD/spfileJABBA.ora' from pfile='/mnt/yavin4/tmp/_oracle_/ad-hoc/initJABBA.ora';
|
|
|
|
~~ on both nodes, create init.ora under $ORACLE_HOME/dbs
|
|
echo "spfile='+DATA/JABBAPRD/spfileJABBA.ora'" > $ORACLE_HOME/dbs/initJABBAPRD1.ora
|
|
echo "spfile='+DATA/JABBAPRD/spfileJABBA.ora'" > $ORACLE_HOME/dbs/initJABBAPRD2.ora
|
|
|
|
~~ register DB in CRS
|
|
srvctl add database -d JABBAPRD -pwfile '+DATA/JABBAPRD/orapwJABBA' -o /app/oracle/product/12.1 -p '+DATA/JABBAPRD/spfileJABBA.ora'
|
|
|
|
~~ create passwordfile on ASM; if the DB is not yet registered on CRS, you will get a WARNING
|
|
orapwd FILE='+DATA/JABBAPRD/orapwJABBA' ENTRIES=10 DBUNIQUENAME='JABBAPRD' password=secret
|
|
|
|
srvctl add instance -d JABBAPRD -i JABBAPRD1 -n vortex-db01
|
|
srvctl add instance -d JABBAPRD -i JABBAPRD2 -n vortex-db02
|
|
|
|
~~ shutdown both instances with SQL*Plus, therfore start DB with srvctl
|
|
srvctl start database -db JABBAPRD
|
|
srvctl status database -db JABBAPRD -v
|
|
|
|
~~ enable ARCHIVELOG mode
|
|
alter system set cluster_database=false scope=spfile sid='*';
|
|
srvctl stop database -db JABBAPRD
|
|
|
|
startup mount exclusive
|
|
alter database archivelog;
|
|
alter database open;
|
|
alter system set cluster_database=true scope=spfile sid='*';
|
|
|
|
~~ shutdown database within SQL*Plus, therefore start with srvctl
|
|
srvctl start database -db JABBAPRD
|