Shulou(Shulou.com)06/01 Report--

There are two ways to install a database instance, one is to install using dbca, and the other is to install it manually using the create database command. There are two ways to install dbca, one is graphical interface installation (interactive), the other is silent installation (non-interactive). This article focuses on dbca silent installation.

Syntax:

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

# create a database by

-createDatabase

-location of the templateName # template: $ORACLE_HOME/assistants/dbca/templates

[- cloneTemplate]

-gdbName

[- policyManaged |-adminManaged]

[- createServerPool]

[- force]

-serverPoolName

-[cardinality]

[- sid]

[- sysPassword]

[- systemPassword]

[- emConfiguration # OEM related

-dbsnmpPassword

-sysmanPassword

[- hostUserName

-hostUserPassword

-backupSchedule]

[- smtpServer

-emailAddress]

[- centralAgent]]

[- disableSecurityConfiguration # disable security

[- datafileDestination |-datafileNames] # location of the data file

[- redoLogFileSize]

[- recoveryAreaDestination]

[- datafileJarLocation]

[- storageType

[- asmsnmpPassword]

-diskGroupName

-recoveryGroupName

[- characterSet]

[- nationalCharacterSet]

[- registerWithDirService

-dirServiceUserName

-dirServicePassword

-walletPassword]

[- listeners]

[- variablesFile]]

[- variables]

[- initParams]

[- memoryPercentage]

[- automaticMemoryManagement] # whether to use AMM or not

[- totalMemory]

[- databaseType]] # Database type

# configure the database by specifying the following parameters

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 using an existing database

-createTemplateFromDB

-sourceDB

-templateName

-sysDBAUserName

-sysDBAPassword

[- maintainFileLocations]

# create a replication template using an existing database

-createCloneTemplate

-sourceSID

-templateName

[- sysDBAUserName

-sysDBAPassword]

[- maintainFileLocations]

[- datafileJarLocation]

# generate a script to create a database by specifying the following parameters

-generateScripts

-templateName

-gdbName

[- scriptDest]

# Delete database

-deleteDatabase

-sourceDB

[- sysDBAUserName

-sysDBAPassword]

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

-

Case study:

1. Create a database instance

Dbca-silent-createDatabase-templateName General_Purpose.dbc-gdbname ora11g-sid ora11g-responseFile NO_VALUE-characterSet AL32UTF8-nationalCharacterSet AL16UTF16-memoryPercentage 30-emConfiguration NONE-sysPassword asd-systemPassword asd

Execute in # Xshell environment. If you don't specify a password, the screen will be cleared.

2. Create a template

Dbca-silent-createTemplateFromDB-sourceDB ora11g-templateName temp_ora11g-sysDBAUserName sys-sysDBAPassword asd

# the template created is in $ORACLE_HOME/assistants/dbca/templates

3. Delete an instance

Dbca-silent-deleteDatabase-sourceDB orcl

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.