pat98's always & forever

- dbca 이용 DB 생성 테스트

silent 모드에서 Template 값이 우선인지, 명시적으로 지정한 값이 우선이지 테스트함.

현재 Template 인 /u01/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/OLTP_X2_2_190000.dbt 

의 값은 기본 <characterSet>AL32UTF8</characterSet> 임

명시적으로 -characterset KO16MSWIN949 값으로 지정하고 생성해 봄.

어떤 것으로 생성될까?

[EXA1]oracle@db01:/home/oracle# ORACLE_SID=ORCL;export ORACLE_SID;ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1;export ORACLE_HOME;export SKIP_CVU_CHECK=true;PATH=$PATH:/u01/app/oracle/product/19.0.0.0/dbhome_1/bin:/u01/app/oracle/product/19.0.0.0/dbhome_1;export PATH;/u01/app/oracle/product/19.0.0.0/dbhome_1/bin/dbca -createDatabase -silent  -gdbName ORCL -sid ORCL -sysPassword XXXXX -systemPassword XXXXX -databaseType MULTIPURPOSE  -responseFile NO_VALUE  -dvConfiguration false  -olsConfiguration false  -registerWithDirService false  -asmSysPassword XXXXX -asmsnmpPassword XXXXX -storageType ASM  -diskGroupName +DATAC1 -recoveryGroupName +RECOC1 -nodelist db01,db02 -ignorePreReqs  -characterset KO16MSWIN949 -templateName /u01/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/OLTP_X2_2_190000.dbt -runCVUChecks false -emConfiguration NONE

[WARNING] [DBT-06801] Specified Fast Recovery Area size (140,000 MB) is less than the recommended value.
   CAUSE: Fast Recovery Area size should at least be three times the database size (91,698 MB).
   ACTION: Specify Fast Recovery Area Size to be at least three times the database size.
[WARNING] [DBT-11153] Character set specified (KO16MSWIN949) is different from that of the character set (AL32UTF8) in the template. Character set mismatch may cause data truncation.
   ACTION: Make sure the character sets uses the same encoding scheme.
[WARNING] [DBT-06801] Specified Fast Recovery Area size (140,000 MB) is less than the recommended value.
   CAUSE: Fast Recovery Area size should at least be three times the database size (99,890 MB).
   ACTION: Specify Fast Recovery Area Size to be at least three times the database size.
Prepare for db operation
8% complete
Creating and starting Oracle instance
10% complete
11% complete
15% complete
Creating database files
16% complete
17% complete
23% complete
Creating data dictionary views
25% complete
30% complete
31% complete
32% complete
37% complete
39% complete
42% complete
46% complete
Creating cluster database views
48% complete
62% complete
Completing Database Creation
65% complete
68% complete
69% complete
Executing Post Configuration Actions
92% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/ORCL.
Database Information:
Global Database Name:ORCL
System Identifier(SID) Prefix:ORCL
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ORCL1.log" for further details.

[EXA1]oracle@db01:/home/oracle# export ORACLE_SID=ORCL1
[ORCL1]oracle@db01:/home/oracle# sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 9 20:10:35 2024
Version 19.25.0.0.0

Copyright (c) 1982, 2024, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.25.0.0.0

SQL> set linesize 120 
SQL> col parameter for A30
SQL> col value     for A20
SQL> select parameter,value from  NLS_DATABASE_PARAMETERS where parameter like '%CHARACTERSET';

PARAMETER                      VALUE
------------------------------ --------------------
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_CHARACTERSET               KO16MSWIN949

결과 : 명시적으로 지정한 값으로 생성됨.

- 테스트 후 삭제

[ORCL]oracle@db01:/home/oracle# dbca -silent -deleteDatabase -sourceDB ORCL -sysDBAUserName sys -sysDBAPassword XXXXX
[WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed.
Prepare for db operation
32% complete
Connecting to database
39% complete
42% complete
45% complete
48% complete
52% complete
55% complete
58% complete
65% complete
Updating network configuration files
68% complete
Deleting instances and datafiles
77% complete
87% complete
97% complete
100% complete
Database deletion completed.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ORCL/ORCL2.log" for further details.