一、静默建库
1、利用模板文件来创建单实例库:
[oracle@racdb oracle]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ora11g -sid ora11g -sysPassword PASSWORD -systemPassword PASSWORD -responseFile NO_VALUE -datafileDestination /u01/app/oracle/oradata/ -redoLogFileSize 50 -recoveryAreaDestination /u01/app/oracle/flash_recovery_area -storageType FS -characterSet ZHS16GBK -nationalCharacterSet AL16UTF16 -sampleSchema true -memoryPercentage 30 -totalMemory 200 -databaseType OLTP -emConfiguration NONE
2、利用模板文件来创建rac库:
[oracle@rac01 dbca]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname jmrac -sid jmrac -sysPassword PASSWORD -systemPassword PASSWORD -datafileDestination ‘DATA/’ -redoLogFileSize 50 -recoveryAreaDestination ‘ARCH/’ -storageType ASM -asmsnmpPassword PASSWORD -diskGroupName ‘DATA’ -responseFile NO_VALUE -characterset ZHS16GBK -nationalCharacterSet AL16UTF16 -sampleSchema true -automaticMemoryManagement true -totalMemory 500 -nodeinfo rac01,rac02
3、利用响应文件来创建rac库:
[oracle@rac01 dbca]$ more
O
R
A
C
L
E
H
O
M
E
/
a
s
s
i
s
t
a
n
t
s
/
d
b
c
a
/
d
b
c
a
r
a
c
.
r
s
p
[
G
E
N
E
R
A
L
]
R
E
S
P
O
N
S
E
F
I
L
E
V
E
R
S
I
O
N
=
"
11.2.0
"
O
P
E
R
A
T
I
O
N
T
Y
P
E
=
"
c
r
e
a
t
e
D
a
t
a
b
a
s
e
"
[
C
R
E
A
T
E
D
A
T
A
B
A
S
E
]
G
D
B
N
A
M
E
=
"
r
a
c
d
b
"
S
I
D
=
"
r
a
c
d
b
"
N
O
D
E
L
I
S
T
=
r
a
c
01
,
r
a
c
02
T
E
M
P
L
A
T
E
N
A
M
E
=
"
G
e
n
e
r
a
l
P
u
r
p
o
s
e
.
d
b
c
"
S
Y
S
P
A
S
S
W
O
R
D
=
"
P
A
S
S
W
O
R
D
"
S
Y
S
T
E
M
P
A
S
S
W
O
R
D
=
"
P
A
S
S
W
O
R
D
"
S
Y
S
M
A
N
P
A
S
S
W
O
R
D
=
"
P
A
S
S
W
O
R
D
"
D
B
S
N
M
P
P
A
S
S
W
O
R
D
=
"
P
A
S
S
W
O
R
D
"
S
T
O
R
A
G
E
T
Y
P
E
=
A
S
M
D
I
S
K
G
R
O
U
P
N
A
M
E
=
D
A
T
A
A
S
M
S
N
M
P
P
A
S
S
W
O
R
D
=
"
P
A
S
S
W
O
R
D
"
R
E
C
O
V
E
R
Y
G
R
O
U
P
N
A
M
E
=
A
R
C
H
C
H
A
R
A
C
T
E
R
S
E
T
=
"
Z
H
S
16
G
B
K
"
N
A
T
I
O
N
A
L
C
H
A
R
A
C
T
E
R
S
E
T
=
"
U
T
F
8
"
[
o
r
a
c
l
e
@
r
a
c
01
d
b
c
a
]
ORACLE_HOME/assistants/dbca/dbca_rac.rsp [GENERAL] RESPONSEFILE_VERSION = "11.2.0" OPERATION_TYPE = "createDatabase" [CREATEDATABASE] GDBNAME = "racdb" SID = "racdb" NODELIST=rac01,rac02 TEMPLATENAME = "General_Purpose.dbc" SYSPASSWORD = "PASSWORD" SYSTEMPASSWORD = "PASSWORD" SYSMANPASSWORD = "PASSWORD" DBSNMPPASSWORD = "PASSWORD" STORAGETYPE=ASM DISKGROUPNAME=DATA ASMSNMP_PASSWORD="PASSWORD" RECOVERYGROUPNAME=ARCH CHARACTERSET = "ZHS16GBK" NATIONALCHARACTERSET= "UTF8" [oracle@rac01 dbca]
ORACLEHOME/assistants/dbca/dbcarac.rsp[GENERAL]RESPONSEFILEVERSION="11.2.0"OPERATIONTYPE="createDatabase"[CREATEDATABASE]GDBNAME="racdb"SID="racdb"NODELIST=rac01,rac02TEMPLATENAME="GeneralPurpose.dbc"SYSPASSWORD="PASSWORD"SYSTEMPASSWORD="PASSWORD"SYSMANPASSWORD="PASSWORD"DBSNMPPASSWORD="PASSWORD"STORAGETYPE=ASMDISKGROUPNAME=DATAASMSNMPPASSWORD="PASSWORD"RECOVERYGROUPNAME=ARCHCHARACTERSET="ZHS16GBK"NATIONALCHARACTERSET="UTF8"[oracle@rac01dbca] dbca -silent -responseFile $ORACLE_HOME/assistants/dbca/dbca_rac.rsp
二、静默删库
dbca -silent -deleteDatabase -sourceDB cdb02 -sysDBAUserName sys -sysDBAPassword PASSWORD