首页 > 数据库 > Oracle > dbca静默删除或创建数据库
dbca -silent -deleteDatabase -sourceDB hrcore -sysDBAUserName sys -sysDBAPassword hydeesoft
指定数据文件位置单实例数据库:
[oracle@oracle11g-02 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -datafileDestination /home/oracle \
> -gdbname orcl -sid orcl -responseFile NO_VALUE -characterSet ZHS16GBK \
> -totalMemory 1536 -emConfiguration NONE -sampleSchema true \
> -sysPassword Password123 \
> -systemPassword Password123
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
57% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.
dbca -silent -createDatabase -templateName General_Purpose.dbc \
-gdbname orcl -sid orcl -responseFile NO_VALUE -characterSet ZHS16GBK \
-totalMemory 1536 -emConfiguration NONE -sampleSchema true \
-sysPassword Password123 \
-systemPassword Password123
--这个SYSASM的密码貌似无所谓
dbca -silent \
-createDatabase \
-templateName General_Purpose.dbc \
-gdbName jsdb \
-sid jsdb \
-SysPassword aB#13579 \
-SystemPassword aB#13579 \
-emConfiguration NONE \
-redoLogFileSize 500 \
-recoveryAreaDestination FRA \
-storageType ASM \
-asmSysPassword dba123 \
-diskGroupName DATA02 \
-characterSet ZHS16GBK \
-nationalCharacterSet AL16UTF16 \
-totalMemory 2400 \
-databaseType MULTIPURPOSE \
-nodelist yserppprd07,yserppprd08
静默创建监听:
netca -silent -responsefile $ORACLE_HOME/assistants/netca/netca.rsp
[grid@zbxdb1 ~]$ netca -silent -responsefile $ORACLE_HOME/assistants/netca/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /oracle/app/11.2.0/grid/assistants/netca/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Profile configuration complete.
Listener "LISTENER" already exists.
Oracle Net Services configuration successful. The exit code is 0
12cR2忽略预检查:
dbca -silent -createDatabase -responseFile ./dbca.rsp -ignorePreReqs
dbca -ignorePreReqs -silent -createDatabase -templateName General_Purpose.dbc -createAsContainerDatabase false -initparams db_create_file_dest='+data', db_create_online_log_dest_1='+data',audit_trail=NONE -nodelist ncrac3,ncrac4 -databaseConfType rac -sysPassword aB#13579 -systemPassword aB#13579 -gdbname horcl -sid horcl -responseFile NO_VALUE -characterSet ZHS16GBK -nationalCharacterSet AL16UTF16 -totalMemory 20480 -emConfiguration LOCAL -storageType ASM -diskGroupName DATA -recoveryGroupName DATA -runCVUChecks false -sampleSchema true -continueOnNonFatalErrors true
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2141587/ ,如需转载,请注明出处,否则将追究法律责任。