database's docs

3.10.0 RAC-create database via Database Configuration  Assistant (DBCA)


0. 什么是DBCA?

全称: Database Configuration  Assistant (DBCA)


1. 使用DBCA来创建database

sudo su oracle
cd /u01/app/oracle/oracle-software/database/response
******************************************
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]
GDBNAME = "racdb"
POLICYMANAGED = "false"
SID = "racdb"
NODELIST=db-oracle-node1,db-oracle-node2
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "oracle_SYS66"
SYSTEMPASSWORD = "oracle_SYSTEM66"
EMCONFIGURATION = "LOCAL"
SYSMANPASSWORD = "oracle_SYSMAN66"
DBSNMPPASSWORD = "oracle_DBSNMP66"
STORAGETYPE=ASM
DISKGROUPNAME=DATADG
ASMSNMP_PASSWORD="oracle_ASMSNMP66"
RECOVERYGROUPNAME=FRADG
******************************************

/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca -silent -responseFile /u01/app/oracle/oracle-software/database/response/dbca.rsp
Copying database files
1% complete
3% complete
9% complete
15% complete
21% complete
27% complete
30% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
44% complete
45% complete
48% complete
50% complete
Creating cluster database views
52% complete
70% complete
Completing Database Creation
73% complete
76% complete
85% complete
94% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/racdb/racdb.log" for further details.

vim /u01/app/oracle/cfgtoollogs/dbca/racdb/racdb.log
******************************************
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 15%
DBCA_PROGRESS : 21%
DBCA_PROGRESS : 27%
DBCA_PROGRESS : 30%
Creating and starting Oracle instance
DBCA_PROGRESS : 32%
DBCA_PROGRESS : 36%
DBCA_PROGRESS : 40%
DBCA_PROGRESS : 44%
DBCA_PROGRESS : 45%
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 50%
Creating cluster database views
DBCA_PROGRESS : 52%
DBCA_PROGRESS : 70%
Completing Database Creation
DBCA_PROGRESS : 73%
DBCA_PROGRESS : 76%
DBCA_PROGRESS : 85%
DBCA_PROGRESS : 94%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/racdb.
Database Information:
Global Database Name:racdb
System Identifier(SID) Prefix:racdbThe Database Control URL is https://db-oracle-node1:1158/em

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/dbhome_1/db-oracle-node1_racdb/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.
******************************************