oracle交互创建,Oracle 11g使用DBCA以非交互(静默)方式创建数据库

使用DBCA以非交互(静默)方式创建数据库

通过执行dbca -h | -help来查看帮助选项

[Oracle@jyrac1 ~]$ dbca -help

dbca  [-silent | -progressOnly | -customCreate] {  }  | { [ [options] ] -responseFile  } [-continueOnNonFatalErrors ]

Please refer to the manual for details.

You can enter one of the following command:

创建数据库的参数如下:

Create a database by specifying the following parameters:

-createDatabase

-templateName  现有模板的名称

[-cloneTemplate]

-gdbName  全局数据库名

[-policyManaged | -adminManaged ]

[-createServerPool ]

[-force ]

-serverPoolName

-[cardinality ]

[-sid ] 数据库系统标识符

[-sysPassword ]

[-systemPassword ]

[-emConfiguration

-dbsnmpPassword

-sysmanPassword

[-hostUserName

-hostUserPassword

-backupSchedule ]

[-smtpServer

-emailAddress ]

[-centralAgent ]]

[-disableSecurityConfiguration

[-datafileDestination  所有数据文件的目标位置 |  -datafileNames ]

[-redoLogFileSize ]

[-recoveryAreaDestination ]

[-datafileJarLocation  ] 数据文件 jar 的位置, 只用于复制数据库的创建

[-storageType < FS | ASM >

[-asmsnmpPassword    ]

-diskGroupName

-recoveryGroupName

[-characterSet ] 数据库的字符集

[-nationalCharacterSet  ] 数据库的国家字符集

[-registerWithDirService

-dirServiceUserName    目录服务的用户名

-dirServicePassword    目录服务的口令

-walletPassword    ]

[-listeners  ] 监听程序列表, 该列表用于配置具有如下对象的数据库

[-variablesFile  ]] 用于模板中成对变量和值的文件名

[-variables  ]

[-initParams ]

[-memoryPercentage ]

[-automaticMemoryManagement ]

[-totalMemory ]

[-databaseType ]]

Configure a database by specifying the following parameters:

-configureDatabase

-sourceDB

[-sysDBAUserName

-sysDBAPassword    ]

[-registerWithDirService|-unregisterWithDirService|-regenerateDBPassword

-dirServiceUserName

-dirServicePassword

-walletPassword    ]

[-disableSecurityConfiguration

[-enableSecurityConfiguration

[-emConfiguration

-dbsnmpPassword

-symanPassword

[-hostUserName

-hostUserPassword

-backupSchedule ]

[-smtpServer

-emailAddress ]

[-centralAgent ]]

使用现有数据库创建模板的参数如下:

Create a template from an existing database by specifying the following parameters:

-createTemplateFromDB

-sourceDB    ::> < 服务采用 :: 格式

-templateName        新的模板名

-sysDBAUserName        具有SYSDBA权限的用户名

-sysDBAPassword      具有SYSDBA权限的用户名的口令

[-maintainFileLocations ]

使用现有数据库创建复制模板的参数如下:

Create a clone template from an existing database by specifying the following parameters:

-createCloneTemplate

-sourceSID      源数据库 sid

-templateName        新的模板名

[-sysDBAUserName      具有SYSDBA权限的用户名

-sysDBAPassword    ] 具有SYSDBA权限的用户名的口令

[-maintainFileLocations ]

[-datafileJarLocation      ] 存放压缩格式数据文件的目录

Generate scripts to create database by specifying the following parameters:

-generateScripts

-templateName

-gdbName

[-scriptDest      ]

通过指定以下参数来删除数据库

Delete a database by specifying the following parameters:

-deleteDatabase

-sourceDB

[-sysDBAUserName

-sysDBAPassword    ]

使用silent模式可以通过数据库创建模析和通过模板来创建数据库

通过模板来创建数据库

[oracle@jyrac1 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ora11g -sid ora11g -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL

Enter SYS user password:

Enter SYSTEM user password:

Enter DBSNMP user password:

Enter SYSMAN user password:

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

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/ora11g/ora11g.log" for further details.

[oracle@jyrac1 ~]$ cat /u01/app/oracle/cfgtoollogs/dbca/ora11g/ora11g.log

Copying database files

DBCA_PROGRESS : 1%

DBCA_PROGRESS : 3%

DBCA_PROGRESS : 11%

DBCA_PROGRESS : 18%

DBCA_PROGRESS : 26%

DBCA_PROGRESS : 37%

Creating and starting Oracle instance

DBCA_PROGRESS : 40%

DBCA_PROGRESS : 45%

DBCA_PROGRESS : 50%

DBCA_PROGRESS : 55%

DBCA_PROGRESS : 56%

DBCA_PROGRESS : 60%

DBCA_PROGRESS : 62%

Completing Database Creation

DBCA_PROGRESS : 66%

DBCA_PROGRESS : 70%

DBCA_PROGRESS : 73%

DBCA_PROGRESS : 85%

DBCA_PROGRESS : 96%

DBCA_PROGRESS : 100%

Database creation complete. For details check the logfiles at:

/u01/app/oracle/cfgtoollogs/dbca/ora11g.

Database Information:

Global Database Name:ora11g

System Identifier(SID):ora11gThe Database Control URL is https://jyrac1:5500/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/11.2.0/db/jyrac1_ora11g/sysman/config/emkey.ora.  Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.