{}
1. 준비 작업
A) DB 생성 스크립트 생성
dbca -silent -generateScripts -gdbName <글로벌DB명> -templateName New_Database.dbt -scriptDest <스크립트 저장 경로> -createAsContainerDatabase <CDB 여부> -databaseConfigType <DB 타입> -nodelist <쉼표로 구분한 구성할 노드 목록> -memoryMgmtType <메모리 관리 타입> -totalMemory <DB에 할당할 메모리 크기(MB)> -characterSet <문자셋> -nationalCharacterSet <National 문자셋> -storageType <스토리지 타입> -useOMF true <OMF 사용여부> -redoLogFileSize <Redo Log 크기(MB)> -databaseType <DB 용도> -datafileDestination <db_create_file_dest> -recoveryAreaDestination <db_recovery_file_dest> -recoveryAreaSize <FRA 영역 크기(MB)> -emConfiguration <EM 설정> -runCVUChecks <정기적인 클러스터 검증 수행 여부>
[racdb1:/home/oracle]> dbca -silent -generateScripts -gdbName racdb -templateName New_Database.dbt -scriptDest ~/dbca_scripts -createAsContainerDatabase false -databaseConfigType RAC -nodelist rac1,rac2 -memoryMgmtType AUTO_SGA -totalMemory 4000 -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -storageType ASM -useOMF true -redoLogFileSize 200 -databaseType MULTIPURPOSE -datafileDestination +DATA -recoveryAreaDestination +FRA -recoveryAreaSize 20000 -emConfiguration none -runCVUChecks false DB 작업 준비 4% 완료 Oracle 인스턴스 생성 및 시작 중 5% 완료 6% 완료 8% 완료 데이터베이스 파일 생성 중 9% 완료 13% 완료 데이터 딕셔너리 뷰 생성 중 14% 완료 16% 완료 19% 완료 20% 완료 21% 완료 25% 완료 Oracle JVM 31% 완료 38% 완료 44% 완료 46% 완료 Oracle Text 48% 완료 50% 완료 Oracle Multimedia 63% 완료 Oracle OLAP 67% 완료 Oracle Spatial 68% 완료 75% 완료 클러스터 데이터베이스 뷰 생성 중 76% 완료 83% 완료 데이터베이스 생성 완료 중 85% 완료 86% 완료 88% 완료 사후 구성 작업 실행 중 100% 완료 스크립트 "/home/oracle/dbca_scripts" 생성을 성공했습니다. 자세한 내용은 로그 파일 "/u01/app/oracle/cfgtoollogs/dbca/racdb/racdb.log"을(를) 참조하십시오.
B) 스크립트 수정
파라미터(init.ora) 수정
nls_language="AMERICAN" # 변경 audit_trail=none # 변경 db_create_online_log_dest_1="+DATA" # 추가 db_create_online_log_dest_2="+FRA" #추가
############################################################################## # Copyright (c) 1991, 2013 by Oracle Corporation ############################################################################## ########################################### # NLS ########################################### nls_language="AMERICAN" nls_territory="KOREA" ########################################### # SGA Memory ########################################### sga_target=3000m ########################################### # Shared Server ########################################### dispatchers="(PROTOCOL=TCP) (SERVICE=racdbXDB)" ########################################### # Miscellaneous ########################################### compatible=19.0.0 diagnostic_dest=/u01/app/oracle ########################################### # Network Registration ########################################### local_listener=-oraagent-dummy- ########################################### # Database Identification ########################################### db_name="racdb" ########################################### # Security and Auditing ########################################### audit_file_dest="/u01/app/oracle/admin/racdb/adump" audit_trail=none remote_login_passwordfile=exclusive ########################################### # System Managed Undo and Rollback Segments ########################################### undo_tablespace=UNDOTBS1 ########################################### # Sort, Hash Joins, Bitmap Indexes ########################################### pga_aggregate_target=1000m ########################################### # Cache and I/O ########################################### db_block_size=8192 ########################################### # Cursors and Library Cache ########################################### open_cursors=300 ########################################### # Cluster Database ########################################### #cluster_database=true ########################################### # File Configuration ########################################### db_create_file_dest="+DATA" db_recovery_file_dest="+FRA" db_recovery_file_dest_size=20000m db_create_online_log_dest_1="+DATA" db_create_online_log_dest_2="+FRA" ########################################### # Processes and Sessions ########################################### processes=300 family:dw_helper.instance_mode=read-only racdb2.instance_number=2 racdb1.instance_number=1 racdb1.thread=1 racdb2.thread=2 racdb2.undo_tablespace=UNDOTBS2 racdb1.undo_tablespace=UNDOTBS1
<인스턴스 명>.sql 에서 미설치 컴포넌트 주석 처리
#@/home/oracle/dbca_scripts/context.sql #@/home/oracle/dbca_scripts/ordinst.sql #@/home/oracle/dbca_scripts/interMedia.sql #@/home/oracle/dbca_scripts/cwmlite.sql #@/home/oracle/dbca_scripts/spatial.sql
set verify off ACCEPT sysPassword CHAR PROMPT 'Enter new password for SYS: ' HIDE ACCEPT systemPassword CHAR PROMPT 'Enter new password for SYSTEM: ' HIDE host /u01/app/oracle/product/19c/db_1/bin/srvctl add database -d racdb -pwfile +DATA/RACDB/orapwracdb -o /u01/app/oracle/product/19c/db_1 -n racdb -a "DATA,FRA" host /u01/app/oracle/product/19c/db_1/bin/srvctl add instance -d racdb -i racdb1 -n rac1 host /u01/app/oracle/product/19c/db_1/bin/srvctl add instance -d racdb -i racdb2 -n rac2 host /u01/app/oracle/product/19c/db_1/bin/srvctl disable database -d racdb host /u01/app/oracle/product/19c/db_1/bin/orapwd file=+DATA/RACDB/orapwracdb force=y format=12 dbuniquename=racdb host /u01/app/19c/grid/bin/setasmgidwrap o=/u01/app/oracle/product/19c/db_1/bin/oracle @/home/oracle/dbca_scripts/CreateDB.sql @/home/oracle/dbca_scripts/CreateDBFiles.sql @/home/oracle/dbca_scripts/CreateDBCatalog.sql @/home/oracle/dbca_scripts/JServer.sql #@/home/oracle/dbca_scripts/context.sql #@/home/oracle/dbca_scripts/ordinst.sql #@/home/oracle/dbca_scripts/interMedia.sql #@/home/oracle/dbca_scripts/cwmlite.sql #@/home/oracle/dbca_scripts/spatial.sql @/home/oracle/dbca_scripts/CreateClustDBViews.sql @/home/oracle/dbca_scripts/lockAccount.sql @/home/oracle/dbca_scripts/postDBCreation.sql
<인스턴스 명>.sh에 원격 노드 디렉토리 생성 구문 추가하기
ssh rac2 "mkdir -p /u01/app/oracle/admin/racdb/adump" ssh rac2 "mkdir -p /u01/app/oracle/admin/racdb/dpdump" ssh rac2 "mkdir -p /u01/app/oracle/admin/racdb/hdump" ssh rac2 "mkdir -p /u01/app/oracle/admin/racdb/pfile" ssh rac2 "mkdir -p /u01/app/oracle/audit" ssh rac2 "mkdir -p /u01/app/oracle/cfgtoollogs/dbca/racdb"
#!/bin/sh
# Prompt if script is run on remote nodes
echo "Is the script run on all the remote nodes? [y/n] (n)"
read ans
if [ $ans = 'y' -o $ans = "Y" ]; then
echo ""
else
echo "Please run the script on all the remote nodes first."
exit 0
fi
# Finish prompt
DB_HOME=$ORACLE_HOME
ASM_HOME=/u01/app/19c/grid
ORACLE_HOME=$ASM_HOME; export ORACLE_HOME
ORACLE_SID=+ASM1; export ORACLE_SID
PERL5LIB=$ORACLE_HOME/rdbms/admin:$PERL5LIB; export PERL5LIB
/u01/app/19c/grid/bin/sqlplus /nolog @/home/oracle/dbca_scripts/mkDir.sql
ORACLE_HOME=$DB_HOME; export ORACLE_HOME
OLD_UMASK=`umask`
umask 0027
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/admin/racdb/adump
mkdir -p /u01/app/oracle/admin/racdb/dpdump
mkdir -p /u01/app/oracle/admin/racdb/hdump
mkdir -p /u01/app/oracle/admin/racdb/pfile
mkdir -p /u01/app/oracle/audit
mkdir -p /u01/app/oracle/cfgtoollogs/dbca/racdb
ssh rac2 "mkdir -p /u01/app/oracle/admin/racdb/adump"
ssh rac2 "mkdir -p /u01/app/oracle/admin/racdb/dpdump"
ssh rac2 "mkdir -p /u01/app/oracle/admin/racdb/hdump"
ssh rac2 "mkdir -p /u01/app/oracle/admin/racdb/pfile"
ssh rac2 "mkdir -p /u01/app/oracle/audit"
ssh rac2 "mkdir -p /u01/app/oracle/cfgtoollogs/dbca/racdb"
umask ${OLD_UMASK}
PERL5LIB=$ORACLE_HOME/rdbms/admin:$PERL5LIB; export PERL5LIB
ORACLE_SID=racdb1; export ORACLE_SID
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH; export PATH
/u01/app/oracle/product/19c/db_1/bin/sqlplus /nolog @/home/oracle/dbca_scripts/racdb1.sql
2. DB 생성
A) 스크립트 실행
DB 생성 스크립트 수행
./<인스턴스 명>.sh
[racdb1:/home/oracle]> cd dbca_scripts/ [racdb1:/home/oracle/dbca_scripts]> ./racdb1.sh Is the script run on all the remote nodes? [y/n] (n) y SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 14 14:44:15 2020 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected. Diskgroup altered. Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0 SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 14 14:44:18 2020 Version 19.5.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Enter new password for SYS: Enter new password for SYSTEM: Enter password for SYS: Connected to an idle instance. SQL> spool /home/oracle/dbca_scripts/CreateDB.log append SQL> startup nomount pfile="/home/oracle/dbca_scripts/init.ora"; ORACLE instance started. Total System Global Area 3154113400 bytes Fixed Size 8901496 bytes Variable Size 637534208 bytes Database Buffers 2499805184 bytes Redo Buffers 7872512 bytes SQL> CREATE DATABASE "racdb" 2 MAXINSTANCES 32 3 MAXLOGHISTORY 1 4 MAXLOGFILES 192 5 MAXLOGMEMBERS 3 6 MAXDATAFILES 1024 7 DATAFILE SIZE 700M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED 8 EXTENT MANAGEMENT LOCAL 9 SYSAUX DATAFILE SIZE 550M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED 10 SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 20M AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED 11 SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 200M AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED 12 CHARACTER SET AL32UTF8 13 NATIONAL CHARACTER SET AL16UTF16 14 LOGFILE GROUP 1 SIZE 200M, 15 GROUP 2 SIZE 200M 16 USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword"; Database created. << 중략 >> SQL> select comp_id, status from dba_registry; COMP_ID STATUS ------------------------------ -------------------------------------------- CATALOG VALID CATPROC VALID RAC VALID JAVAVM VALID XML VALID CATJAVA VALID XDB VALID OWM VALID 8 rows selected. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> host /u01/app/oracle/product/19c/db_1/bin/srvctl enable database -d racdb; SQL> host /u01/app/oracle/product/19c/db_1/bin/srvctl start database -d racdb; SQL> connect "SYS"/"&&sysPassword" as SYSDBA Connected. SQL> spool off SQL> exit; Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.5.0.0.0
B) 결과 확인
crsctl stat res -t
[racdb1:/home/oracle]> crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.qosmserver
1 ONLINE ONLINE rac1 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE ONLINE rac1 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
2 ONLINE ONLINE rac2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
