DBCA创建Oracle数据库实例

cat <<EOF>>/data/mydbs.rsp

[GENERAL]

RESPONSEFILE_VERSION = "11.2.0"

OPERATION_TYPE =  "createDatabase"

[CREATEDATABASE]

GDBNAME = "hpprdzb"

SID = "hpprdzb"

TEMPLATENAME =  "General_Purpose.dbc"

SYSPASSWORD = "123456"

SYSPASSWORD = "123456"

SYSTEMPASSWORD = "123456"

DATAFILEDESTINATION  =/data/oracle/app/oracle/oradata

AUTOMATICMEMORYMANAGEMENT =  "TRUE"

TOTALMEMORY = "480"

STORAGETYPE="FS"

CHARACTERSET="AL32UTF8"

NATIONALCHARACTERSET="UTF8"

dbca   [-silent | -progressOnly | -customCreate] {<command>  <options> }  | { [<command>  [options] ] -responseFile  <response  file > } [-continueOnNonFatalErrors <true | false>]

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  <name of an existing  template>

                   [-cloneTemplate]

                   -gdbName  <global database name>

                   [-policyManaged  | -adminManaged <Policy managed or Admin managed Database, default is  Admin managed database>]

                            [-createServerPool  <To create ServerPool which will be used by the database to be  created>]

                            [-force  <To create serverpool by force when adequate free servers are not  available. This may affect already running database>]

                            -serverPoolName  <One serverPool Name in case of create server pool and comma separated  list of serverPool name in case of use serverpool>

                            -[cardinality  <Specify cardinality for new serverPool to be created, default is the  number of qualified nodes>]

                   [-sid  <database system identifier>]

                   [-sysPassword  <SYS user password>]

                   [-systemPassword  <SYSTEM user password>]

                   [-emConfiguration  <CENTRAL|LOCAL|ALL|NOBACKUP|NOEMAIL|NONE>

                            -dbsnmpPassword  <DBSNMP user password>

                            -sysmanPassword  <SYSMAN user password>

                            [-hostUserName  <Host user name for EM backup job>

                             -hostUserPassword <Host user password for  EM backup job>

                             -backupSchedule <Daily backup schedule in  the form of hh:mm>]

                            [-smtpServer  <Outgoing mail (SMTP) server for email notifications>

                             -emailAddress <Email address for email  notifications>]

                            [-centralAgent  <Enterprise Manager central agent home>]]

                   [-disableSecurityConfiguration  <ALL|AUDIT|PASSWORD_PROFILE|NONE>

                   [-datafileDestination  <destination directory for all database files> |  -datafileNames <a text file containing  database objects such as controlfiles, tablespaces, redo log files and spfile  to their corresponding raw device file names mappings in name=value  format.>]

                   [-redoLogFileSize  <size of each redo log file in megabytes>]

                   [-recoveryAreaDestination  <destination directory for all recovery files>]

                   [-datafileJarLocation  <location of the data file jar, used  only for clone database creation>]

                   [-storageType  < FS | ASM >

                            [-asmsnmpPassword     <ASMSNMP password for ASM  monitoring>]

                             -diskGroupName   <database area disk group name>

                             -recoveryGroupName       <recovery area disk group name>

                   [-characterSet  <character set for the database>]

                   [-nationalCharacterSet  <national character set for the  database>]

                   [-registerWithDirService  <true | false>

                            -dirServiceUserName    <user name for directory service>

                            -dirServicePassword    <password for directory service >

                            -walletPassword    <password for database wallet >]

                   [-listeners  <list of listeners to configure the  database with>]

                   [-variablesFile   <file name for the variable-value pair  for variables in the template>]]

                   [-variables  <comma seperated list of name=value  pairs>]

                   [-initParams  <comma seperated list of name=value pairs>]

                   [-memoryPercentage  <percentage of physical memory for Oracle>]

                   [-automaticMemoryManagement  ]

                   [-totalMemory  <memory allocated for Oracle in MB>]

                   [-databaseType  <MULTIPURPOSE|DATA_WAREHOUSING|OLTP>]]

Configure a database by specifying the  following parameters:

         -configureDatabase

                   -sourceDB    <source database sid>

                   [-sysDBAUserName     <user name  with SYSDBA privileges>

                    -sysDBAPassword     <password for sysDBAUserName user  name>]

                   [-registerWithDirService|-unregisterWithDirService|-regenerateDBPassword  <true | false>

                            -dirServiceUserName    <user name for directory service>

                            -dirServicePassword    <password for directory service >

                            -walletPassword    <password for database wallet >]

                   [-disableSecurityConfiguration  <ALL|AUDIT|PASSWORD_PROFILE|NONE>

                   [-enableSecurityConfiguration  <true|false>

                   [-emConfiguration  <CENTRAL|LOCAL|ALL|NOBACKUP|NOEMAIL|NONE>

                            -dbsnmpPassword  <DBSNMP user password>

                            -symanPassword  <SYSMAN user password>

                            [-hostUserName  <Host user name for EM backup job>

                             -hostUserPassword <Host user password for  EM backup job>

                             -backupSchedule <Daily backup schedule in  the form of hh:mm>]

                            [-smtpServer  <Outgoing mail (SMTP) server for email notifications>

                             -emailAddress <Email address for email  notifications>]

                            [-centralAgent  <Enterprise Manager central agent home>]]

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

         -createTemplateFromDB

                   -sourceDB    <service in the form of  <host>:<port>:<sid>>

                   -templateName      <new template name>

                   -sysDBAUserName     <user name  with SYSDBA privileges>

                   -sysDBAPassword     <password for sysDBAUserName user  name>

                   [-maintainFileLocations  <true | false>]

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

         -createCloneTemplate

                   -sourceSID    <source database sid>

                   -templateName      <new template name>

                   [-sysDBAUserName     <user name  with SYSDBA privileges>

                    -sysDBAPassword     <password for sysDBAUserName user name>]

                   [-maintainFileLocations  <true | false>]

                   [-datafileJarLocation       <directory to place the datafiles  in a compressed format>]

Generate scripts to create database by  specifying the following parameters:

         -generateScripts

                   -templateName  <name of an existing  template>

                   -gdbName  <global database name>

                   [-scriptDest       <destination for all the  scriptfiles>]

Delete a database by specifying the  following parameters:

         -deleteDatabase

                   -sourceDB    <source database sid>

                   [-sysDBAUserName     <user name  with SYSDBA privileges>

                    -sysDBAPassword     <password for sysDBAUserName user  name>]

Query for help by specifying the  following options: -h | -help