Oracle 11g uses DBCA to create a database in non-interactive (silent) Mode

Use DBCA to create a database in non-interactive (silent) Mode
Run dbca-h |-help to view help options.
[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:
Parameters for creating a database are as follows:
Create a database by specifying the following parameters:
-CreateDatabase
-TemplateName: name of an existing Template
[-CloneTemplate]
-GdbName: Global Database Name
[-PolicyManaged |-adminManaged]
[-CreateServerPool]
[-Force]
-ServerPoolName
-[Cardinality]
[-Sid] database system identifier
[-SysPassword]
[-SystemPassword]
[-EmConfiguration
-DbsnmpPassword
-SysmanPassword
[-HostUserName
-HostUserPassword
-BackupSchedule]
[-SmtpServer
-EmailAddress]
[-CentralAgent]
[-DisableSecurityConfiguration
[-DatafileDestination: Target Location of all data files |-datafileNames]
[-RedoLogFileSize]
[-RecoveryAreaDestination]
[-DatafileJarLocation] the location of the data file jar, used only to copy the creation of the database
[-StorageType <FS | ASM>
[-AsmsnmpPassword]
-DiskGroupName
-RecoveryGroupName
[-CharacterSet] Character Set of the database
[-NationalCharacterSet] National Character Set of the database
[-RegisterWithDirService
-DirServiceUserName: User Name of the Directory Service
-Password of the dirServicePassword Directory Service
-WalletPassword]
[-Listeners] listener list, which is used to configure databases with the following objects
[-VariablesFile] Name of the file used for the variable and value in the template
[-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
-Login Password
[-HostUserName
-HostUserPassword
-BackupSchedule]
[-SmtpServer
-EmailAddress]
[-CentralAgent]

Parameters for creating a template using an existing database are as follows:
Create a template from an existing database by specifying the following parameters:
-CreateTemplateFromDB
-SourceDB:> <service format: Format
-TemplateName: New Template Name
-SysDBAUserName: username with SYSDBA Permissions
-SysDBAPassword: password of the username with SYSDBA Permissions
[-MaintainFileLocations]

Parameters for creating a replication template using an existing database are as follows:
Create a clone template from an existing database by specifying the following parameters:
-CreateCloneTemplate
-SourceSID: source database sid
-TemplateName: New Template Name
[-SysDBAUserName: username with SYSDBA Permissions
-SysDBAPassword] password of the username with SYSDBA Permissions
[-MaintainFileLocations]
[-DatafileJarLocation] Directory for storing compressed data files

Generate scripts to create database by specifying the following parameters:
-GenerateScripts
-TemplateName
-GdbName
[-ScriptDest]
Delete a database by specifying the following parameters:
Delete a database by specifying the following parameters:
-DeleteDatabase
-SourceDB
[-SysDBAUserName
-SysDBAPassword]
 
You can use the silent mode to create a database analysis and a template to create a database.

Create a database using a template
[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/export toollogs/dbca/ora11g/ora11g. log" for further details.
[Oracle @ jyrac1 ~] $ Cat/u01/app/oracle/export toollogs/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:
/U01/app/oracle/export toollogs/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.

1 2 3 Next Page