ITPub博客

首页 > 数据库 > Oracle > dbca静默删除或创建数据库

dbca静默删除或创建数据库

原创 Oracle 作者:abstractcyj 时间:2017-07-04 16:56:00 1 删除 编辑

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/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091583