[INSTALL][OL7.9 / Oracle 19.15.0.0] Oracle Slient 설치_생성 스크립트 추출 버전 (수정중)

테스트 시나리오

• .rsp가 아닌 .dbt 파일을 이용하여 수동으로 설치
• 단, 위 과정을 진행하기 전 -slient로 engine 설치 후에 진행 필요
  (engine slient 설치는 https://study-storage93.tistory.com/9 slient mode 내용 참고)

script 추출

dbca \
-silent \
-generateScripts \
-templateName /u01/app2/oracle/19.0.0.0/db_1/assistants/dbca/templates/New_Database.dbt \
-gdbName TEST \
-sid TEST \
-characterSet UTF8 \
-scriptDest /home/ora19c/script

----------------------------------------------------------------------------------------
-templateName : engine 설치했다는 가정하에 $ORACLE_HOME/assistants/dbca/templates에 .dbt 파일 존재
-gdbName : dbca 설치 시 global database name이 해당 옵션 부분
-sid : dba 설치 시 sid 부분
-characterSet : dbca 설치 시 charaterset 설정 부분
-scriptDest : 스크립트 추출할 경로
----------------------------------------------------------------------------------------

Prepare for db operation
5% complete
Creating and starting Oracle instance
6% complete
9% complete
Creating database files
10% complete
14% complete
Creating data dictionary views
15% complete
18% complete
20% complete
22% complete
23% complete
27% complete
Oracle JVM
34% complete
41% complete
48% complete
50% complete
Oracle Text
53% complete
55% complete
Oracle Multimedia
68% complete
Oracle OLAP
73% complete
Oracle Spatial
74% complete
82% complete
Completing Database Creation
84% complete
85% complete
86% complete
Executing Post Configuration Actions
100% complete
The generation of the script "/home/ora19c/script" is successful.
Look at the log file "/u01/app2/oracle/cfgtoollogs/dbca/TEST/TEST0.log" for further details.

[ora19c@oraclevm ~]$ cd /home/ora19c/script

[ora19c@oraclevm script]$ ls -al
total 64
drwxr-xr-x.  2 ora19c dba 4096 Nov 30 17:05 .
drwx------. 12 ora19c dba 4096 Nov 30 17:05 ..
-rw-r-----.  1 ora19c dba  516 Nov 30 17:05 context.sql
-rw-r-----.  1 ora19c dba  731 Nov 30 17:05 CreateDBCatalog.sql
-rw-r-----.  1 ora19c dba  386 Nov 30 17:05 CreateDBFiles.sql
-rw-r-----.  1 ora19c dba 1183 Nov 30 17:05 CreateDB.sql
-rw-r-----.  1 ora19c dba  187 Nov 30 17:05 cwmlite.sql
-rw-r-----.  1 ora19c dba 1800 Nov 30 17:05 init.ora
-rw-r-----.  1 ora19c dba  182 Nov 30 17:05 interMedia.sql
-rw-r-----.  1 ora19c dba  444 Nov 30 17:05 JServer.sql
-rw-r-----.  1 ora19c dba  816 Nov 30 17:05 lockAccount.sql
-rw-r-----.  1 ora19c dba  191 Nov 30 17:05 ordinst.sql
-rw-r-----.  1 ora19c dba  664 Nov 30 17:05 postDBCreation.sql
-rw-r-----.  1 ora19c dba  279 Nov 30 17:05 spatial.sql
-rwxr-xr-x.  1 ora19c dba  706 Nov 30 17:05 TEST.sh
-rwxr-xr-x.  1 ora19c dba  662 Nov 30 17:05 TEST.sql

(+) log file 내용 

    - successful이므로 확인할 필요 없으나 예의상 과정 확인

[ora19c@oraclevm ~]$ vi /u01/app2/oracle/cfgtoollogs/dbca/TEST/TEST0.log

[ 2022-11-30 17:05:43.164 KST ] Prepare for db operation
DBCA_PROGRESS : 5%
[ 2022-11-30 17:05:43.230 KST ] Creating and starting Oracle instance
DBCA_PROGRESS : 6%
DBCA_PROGRESS : 9%
[ 2022-11-30 17:05:43.271 KST ] Creating database files
DBCA_PROGRESS : 10%
DBCA_PROGRESS : 14%
[ 2022-11-30 17:05:43.275 KST ] Creating data dictionary views
DBCA_PROGRESS : 15%
DBCA_PROGRESS : 18%
DBCA_PROGRESS : 20%
DBCA_PROGRESS : 22%
DBCA_PROGRESS : 23%
DBCA_PROGRESS : 27%
[ 2022-11-30 17:05:43.284 KST ] Oracle JVM
DBCA_PROGRESS : 34%
DBCA_PROGRESS : 41%
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 50%
[ 2022-11-30 17:05:43.289 KST ] Oracle Text
DBCA_PROGRESS : 53%
DBCA_PROGRESS : 55%
[ 2022-11-30 17:05:43.294 KST ] Oracle Multimedia
DBCA_PROGRESS : 68%
[ 2022-11-30 17:05:43.301 KST ] Oracle OLAP
DBCA_PROGRESS : 73%
[ 2022-11-30 17:05:43.304 KST ] Oracle Spatial
DBCA_PROGRESS : 74%
DBCA_PROGRESS : 82%
[ 2022-11-30 17:05:43.307 KST ] Completing Database Creation
DBCA_PROGRESS : 84%
DBCA_PROGRESS : 85%
DBCA_PROGRESS : 86%
[ 2022-11-30 17:05:43.343 KST ] Executing Post Configuration Actions
DBCA_PROGRESS : 100%
[ 2022-11-30 17:05:43.346 KST ] The generation of the script "/home/ora19c/script" is successful.