페이지 이력

버전 비교

키

이 줄이 추가되었습니다.
이 줄이 삭제되었습니다.
서식이 변경되었습니다.

준비 작업

리스너 생성

리스너 갯수와 이름 그리고 사용할 포트에 맞게 response 파일 내의 변수를 설정하기 바랍니다.

코드 블럭

language	bash
title	Listener response 파일 생성
linenumbers	true

[GENERAL]
RESPONSEFILE_VERSION="19.0"
CREATE_TYPE="CUSTOM"
SHOW_GUI=false

[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}

코드 블럭

language	bash
title	리스너 생성
linenumbers	true

netca -silent -responsefile ~/netca.rsp

펼치기

서식 미적용

[racdb1:/home/oracle]$ $ORACLE_HOME/bin/netca -silent -responsefile ~/netca.rsp

명령행 인수 분석:
    매개변수 "silent" = true
    매개변수 "responsefile" = /home/oracle/netca.rsp
명령행 인수 분석을 완료했습니다.
Oracle Net Service 구성:
프로파일 구성이 완료되었습니다.
Oracle Net 리스너 시작:
    실행 중인 리스너 제어:
      /u01/app/oracle/product/19c/db_1/bin/lsnrctl start LISTENER
    리스너 제어가 완료되었습니다.
    리스너가 성공적으로 시작되었습니다.
리스너 구성이 완료되었습니다.
Oracle Net Service 구성을 성공했습니다. 종료 코드는 다음과 같습니다. 0

DB 생성 스크립트 생성

코드 블럭

language	bash
title	DB 생성 스크립트 추출
linenumbers	true

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 <정기적인 클러스터 검증 수행 여부>listeners <리스너명>

펼치기

서식 미적용

[racdb1:/home/oracle]> dbca -silent -generateScripts -gdbName ora19corcl19c -templateName New_Database.dbt -scriptDest ~/dbca_scripts -createAsContainerDatabase false -databaseConfigType RACSINGLE -nodelist rac1,rac2 -memoryMgmtType AUTO_SGA -totalMemory 40002000 -characterSet AL32UTF8  -nationalCharacterSet AL16UTF16 -storageType ASM -useOMF true FS -redoLogFileSize 200 -databaseType MULTIPURPOSE -datafileDestination +DATA/oradata -recoveryAreaDestination +/FRA -recoveryAreaSize 20000 -emConfiguration none -runCVUCheckslisteners falseLISTENER
DB 작업 준비
4%5% 완료
Oracle 인스턴스 생성 및 시작 중
5% 완료
6% 완료
8%9% 완료
데이터베이스 파일 생성 중
9%10% 완료
13%14% 완료
데이터 딕셔너리 뷰 생성 중
14%15% 완료
16%18% 완료
19%20% 완료
20%22% 완료
21%23% 완료
25%27% 완료
Oracle JVM
31%34% 완료
38%41% 완료
44%48% 완료
46%50% 완료
Oracle Text
48%53% 완료
50%55% 완료
Oracle Multimedia
63%68% 완료
Oracle OLAP
67%73% 완료
Oracle Spatial
68%74% 완료
75%82% 완료
클러스터 데이터베이스 뷰 생성 중
76% 완료
83% 완료중
데이터베이스 생성84% 완료 중
85% 완료
86% 완료
88% 완료
사후 구성 작업 실행 중
100% 완료
스크립트 "/home/oracle/dbca_scripts" 생성을 성공했습니다.
자세한 내용은 로그 파일 "/u01/app/oracle/cfgtoollogs/dbca/racdborcl19c/racdborcl19c0.log"을(를) 참조하십시오.

스크립트 수정

코드 블럭

language	bash
title	파라미터(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

코드 블럭

language	bash
title	<인스턴스 명>.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

펼치기

서식 미적용

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

DB 생성

스크립트 실행

코드 블럭

language	bash
title	DB 생성 스크립트 수행 : 설치 노드 최종 수행

./<인스턴스 명>.sh

펼치기

2번 노드 먼저 수행 : dump 파일 경로와 파라미터 파일 생성

서식 미적용
[racdb2:/home/oracle]> cd dbca_scripts/ [racdb2:/home/oracle/dbca_scripts]> ./racdb2.sh

1번 노드 마지막 수행 : dump 파일 경로와 파라미터 파일 생성 후 database 생성

서식 미적용

[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

결과 확인

코드 블럭
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
--------------------------------------------------------------------------------

Content

공간 도구

버전 비교

이전 버전 4

새 버전 5

키

준비 작업

리스너 생성

DB 생성 스크립트 생성

스크립트 수정

DB 생성

스크립트 실행

결과 확인