2.11 Database Configuration Assistant Command Reference for Silent Mode

«« Previous
Next »»

This section provides details about the syntax and options for Database Configuration Assistant (DBCA) silent mode commands.

DBCA Command-Line Syntax and Options Overview

DBCA silent mode has the following command syntax:

dbca  [-silent | -progressOnly] {command options }  | { [command [options]]
-responseFile response_file_location } [-continueOnNonFatalErrors {true | false}]
[-h|-help]

Table 2-4 describes the DBCA silent mode options.

Table 2-4 DBCA Silent Mode Options

Option Description
 -silent | -progressOnly Specify -silent to run DBCA in silent mode.

In silent mode, DBCA uses values that you specify, in the response file or as command-line options, to create or modify a database.

Specify -progressOnly to run DBCA in response file mode.

In the response file mode, DBCA uses values that you specify, in the response file or as command line options, to create and configure a database. As it configures and starts the database, it displays a window that contains status messages and a progress bar. DBCA in response file mode uses a graphical display. Ensure that the DISPLAY environment variable is set correctly.

These options are mutually exclusive.
command options Specify a DBCA command and valid options for the command.
-responseFile response_file_location  
Specify the complete path to the response file. The default name for the response file is dbca.rsp.
-continueOnNonFatalErrors {true | false} Specify true, the default, for DBCA to continue running if it encounters a nonfatal error.

Specify false for DBCA to stop running if it encounters a nonfatal error.
-h | -help Displays help for DBCA.

You can display help for a specific command by entering the following:

dbca command -help

For example, to display the help for the -createDatabase command, enter the following:

dbca -createDatabase -help

Table 2-5 describes the DBCA silent mode commands.

Table 2-5 DBCA Silent Mode Commands

Command Description
createDatabase Creates a database
configureDatabase Configures a database
createTemplateFromDB Creates a database template from an existing database
createCloneTemplate Creates a clone (seed) database template from an existing database
generateScripts Generates scripts to create a database
deleteDatabase Deletes a database
createPluggableDatabase Creates a PDB in a CDB
unplugDatabase Unplugs a PDB from a CDB
deletePluggableDatabase Deletes a PDB
configurePluggableDatabase Configures a PDB

DBCA Templates

You can use DBCA to create a database from a template supplied by Oracle or from a template that you create. A DBCA template is an XML file that contains information required to create a database.

Oracle ships templates for the following two workload types:
  • General purpose OR online transaction processing
  • Data warehouse
Select the template suited to the type of workload your database will support. If you are not sure which to choose, then use the "General purpose OR online transaction processing" template. You can also create custom templates to meet your specific workload requirements.
  • createDatabase
The createDatabase command creates a database.

Syntax and Parameters

Use the dbca -createDatabase command with the following syntax:

dbca -createDatabase 
    -templateName template_name 
    [-cloneTemplate] 
    -gdbName global_database_name 
    [-sid database_system_identifier]
    [-createAsContainerDatabase {true | false}
        [-numberOfPDBs integer]
        [-pdbName pdb_name]]
    [-sysPassword sys_user_password]
    [-systemPassword system_user_password]
    [-emConfiguration {DBEXPRESS | CENTRAL | BOTH | NONE}
       -dbsnmpPassword DBSNMP_user_password
       [-omsHost EM_management_server_host_name
       -omsPort EM_management_server_port_number
       -emUser EM_admin_username
       -emPassword EM_admin_user_password]]
    [-dvConfiguration {true | false}
        -dvUserName Database_Vault_owner_username
        -dvUserPassword Database_Vault_owner_password
        -dvAccountManagerName Database_Vault_account_manager
        -dvAccountManagerPassword Database_Vault_account_manager_password]
    [-olsConfiguration {true | false}]
    [-datafileDestination directory | -datafileNames text_file_location]
    [-redoLogFileSize integer]
    [-recoveryAreaDestination destination_directory]
    [-datafileJarLocation jar_file_location]
    [-storageType {FS | ASM} 
        [-asmsnmpPassword asmsnmp_password]
        -diskGroupName disk_group_name
        -recoveryGroupName recovery_area_disk_group_name]
    [-characterSet database_character_set]
    [-nationalCharacterSet database_national_character_set]
    [-registerWithDirService {true | false} 
         -dirServiceUserName directory_service_user_name
         -dirServicePassword directory_service_password
         -walletPassword wallet_password]
    [-listeners list_of_listeners]
    [-variablesFile variable_file]
    [-variables variable_list]
    [-initParams parameter_list]
    [-sampleSchema {true | false}]
    [-memoryPercentage integer]
    [-automaticMemoryManagement {true | false}]
    [-totalMemory integer]
    [-databaseType {MULTIPURPOSE | DATA_WAREHOUSING | OLTP}]
    -serviceUserPassword Windows_Oracle_Home_service_user_password

Table 2-6 createDatabase Parameters

Parameter Required/
Optional
Description
-templateName
template_name
Required Name of an existing template in the default location or the complete path to a template that is not in the default location
-cloneTemplate Optional Indicates that the template is a seed template

A seed template contains both the structure and the physical data files of an existing database. When the template file extension is .dbc, DBCA treats it as seed template by default.
-gdbName global_database_name Required Global database name in the form database_name.domain_name
-sid database_system_identifier Optional Database system identifier

The SID uniquely identifies the instance that runs the database. If it is not specified, then it defaults to the database name.
-createAsContainerDatabase {true | false} Optional Specify true to create a CDB.

Specify false, the default, to create a non-CDB.

When true is specified, the following additional parameters are optional:
  • -numberOfPDBs: Number of PDBs to create. The default is 0 (zero).
  • -pdbName: Base name of each PDB. A number is appended to each name if -numberOfPDBs is greater than 1. This parameter must be specified if -numberOfPDBs is greater than 0 (zero).
-sysPassword sys_user_password Optional  SYS user password for the new database
-systemPassword system_user_password Optional  SYSTEM user password for the new database
-emConfiguration {DBEXPRESS |
CENTRAL | BOTH |
NONE}
Optional  When DBEXPRESS, CENTRAL, or BOTH is specified, specify the following additional parameters:
  • -dbsnmpPassword: DBSNMP user password
  • -omsHost: Enterprise Manager management server host name
  • -omsPort: Enterprise Manager management server port number
  • -emUser: Host username for Enterprise Manager administrator
  • -emPassword: Host user password for Enterprise Manager administrator
-dvConfiguration
{true | false}
Optional  Specify false, the default, to indicate that the database will not use Oracle Database Vault.

Specify true to configure and enable Database Vault, or specify false to not configure and enable Database Vault.

When true is specified, the following additional Database Vault parameters are required:
  • -dvUserName: Specify the Database Vault owner username.
  • -dvUserPassword: Specify Database Vault owner password.
  • -dvAccountManagerName: Specify a separate Database Vault account manager.
  • -dvAccountManagerPassword: Specify the Database Vault account manager password.
-olsConfiguration
{true | false}
Optional  Specify true to configure and enable Oracle Label Security.

Specify false, the default, to indicate that the database will not use Oracle Label Security.
-datafileDestination
directory
Optional Complete path to the location of the database's data files

Note: The -datafileDestination and -datafileNames parameters are mutually exclusive.
-datafileNames text_file_location Optional  A text file containing database objects such as control files, tablespaces, redo log files, and the SPFILE matched to their corresponding file name mappings in name=value format

Note: The -datafileDestination and -datafileNames parameters are mutually exclusive.
-redoLogFileSize integer Optional Size of each online redo log in megabytes
-recoveryAreaDestination directory Optional Destination directory for the Fast Recovery Area, which is a backup and recovery area
-datafileJarLocation jar_file_location Optional Location of the database offline backup (for clone database creation only)

The data files for the seed database are stored in compressed RMAN backup format in a file with a .dfb extension.
-storageType {FS | ASM} Optional FS for file system

When FS is specified, your database files are managed by the file system of your operating system. You specify the directory path where the database files are to be stored using a database template, the -datafileDestination parameter, or the -datafileNames parameter. Oracle Database can create and manage the actual files.

ASM for Oracle Automatic Storage Management (Oracle ASM)

When ASM is specified, your database files are placed in Oracle ASM disk groups. Oracle Database automatically manages database file placement and naming.

When ASM is specified, specify the following additional parameters:
  • -asmsnmpPassword: ASMSNMP password for ASM monitoring. This parameter is optional.
  • -diskGroupName: Database area disk group name. This parameter is required.
  • -recoveryGroupName: Recovery area disk group name. This parameter is required.
-characterSet database_character_set Optional Character set of the database
-nationalCharacterSet database_national_
character_set
Optional National character set of the database
-registerWithDirService
{true | false}
Optional Specify true to register with a Lightweight Directory Access Protocol (LDAP) service.

Specify false, the default, to not register with an LDAP service.

When true is specified, the following additional parameters are required:
  • -dirServiceUserName: Username for the LDAP service
  • -dirServicePassword: Password for the LDAP service
  • -walletPassword: Password for the database wallet
-listeners list_of_listeners Optional  A comma-separated list of listeners for the database
-variablesFile variable_file Optional Complete path to the file that contains the variable-value pairs for variables in the database template
-variables variable_list Optional A comma-separated list of name=value pairs for the variables in the database template
-initParams parameter_list Optional A comma-separated list of name=value pairs of initialization parameter values for the database
-sampleSchema {true | false} Optional Specify true to include sample schemas (EXAMPLE tablespace) in your database. Oracle guides and educational materials contain examples based on the sample schemas. Oracle recommends that you include them in your database.

Specify false to create the database without the sample schemas.
-memoryPercentage integer Optional The percentage of physical memory that can be used by Oracle Database
-automaticMemory
Management {true | false}
Optional Forces the use of the MEMORY_TARGET initialization parameter
-totalMemory integer Optional Total amount of physical memory, in megabytes, that can be used by the new database
-databaseType {MULTIPURPOSE | DATA_WAREHOUSING | OLTP} Optional Specify MULTIPURPOSE if the database is for both OLTP and data warehouse purposes.

Specify DATA_WAREHOUSING if the primary purpose of the database is a data warehouse.

Specify OLTP if the primary purpose of the database is online transaction processing.
-serviceUserPassword Windows_Oracle_
Home_service_
user_password
Required For the Windows platform only, specify the Oracle Home User password if the Oracle Home was installed using an Oracle Home User.

  • configureDatabase
The configureDatabase command configures a database.

Syntax and Parameters

Use the dbca -configureDatabase command with the following syntax:

dbca -configureDatabase 
   -sourceDB source_database_sid
   [-sysDBAUserName user_name
    -sysDBAPassword password]
   [-registerWithDirService | -unregisterWithDirService | -regenerateDBPassword {true | false}
      -dirServiceUserName directory_service_user_name
      -dirServicePassword directory_service_password
      -walletPassword wallet_password]
   [-addDBOption options_list]
   [-dvConfiguration {true | false}
      -dvUserName Database_Vault_owner_username
      -dvUserPassword Database_Vault_owner_password
      -dvAccountManagerName Database_Vault_account_manager
      -dvAccountManagerPassword Database_Vault_account_manager_password]

Table 2-7 configureDatabase Parameters

ParameterRequired/
Optional
Description
-sourceDB source_database_sidRequiredThe database system identifier of the database being configured
-sysDBAUserName user_nameOptionalUsername of a user that has SYSDBA administrative privilege
-sysDBAPassword passwordOptionalPassword of the user granted SYSDBA administrative privilege
-registerWithDirService | -unregisterWithDirService | -regenerateDBPassword {true | false}OptionalSet one of the following parameters to either true or false:
  • -registerWithDirService: true registers with a Lightweight Directory Access Protocol (LDAP) service; false, the default, does not register with an LDAP service.
  • -unregisterWithDirService: true unregisters from an LDAP service; false, the default, does not unregister from an LDAP service.
  • -regenerateDBPassword: true regenerates the database password for an LDAP service; false, the default, does not regenerate the database password for an LDAP service.
When true is specified, the following additional parameters are required:
  • -dirServiceUserName: Username for the LDAP service
  • -dirServicePassword: Password for the LDAP service
  • -walletPassword: Password for the database wallet
-addDBOptionOptionalSpecify any of the following Oracle Database options in a comma separated list:
  • JSERVER
  • ORACLE_TEXT
  • IMEDIA
  • CWMLITE
  • SPATIAL
  • OMS
  • APEX
  • DV
-dvConfiguration {true | false}OptionalSpecify false, the default, to indicate that the database will not use Oracle Database Vault.

Specify true to configure and enable Database Vault, or specify false to not configure and enable Database Vault.

When true is specified, the following additional Database Vault parameters are required:
  • -dvUserName: Specify the Database Vault owner username.
  • -dvUserPassword: Specify Database Vault owner password.
  • -dvAccountManagerName: Specify a separate Database Vault account manager.
  • -dvAccountManagerPassword: Specify the Database Vault account manager password.
  • createTemplateFromDB
The createTemplateFromDB command creates a database template from an existing database.

Syntax and Parameters

Use the dbca -createTemplateFromDB command with the following syntax:

dbca -createTemplateFromDB 
   -sourceDB source_database_sid
   -templateName new_template_name
   -sysDBAUserName user_name
   -sysDBAPassword password
   [-maintainFileLocations {true | false}]
   [-connectionString easy_connect_string].

Table 2-8 createTemplateFromDB Parameters

ParameterRequired/
Optional
Description
-sourceDB source_database_sidRequiredThe database system identifier of the database being configured
-templateName new_template_nameRequiredName of the new database template
-sysDBAUserName user_nameRequiredUsername of a user that has SYSDBA administrative privilege
-sysDBAPassword passwordRequiredPassword of the user granted SYSDBA administrative privilege
-maintainFileLocations {true | false}OptionalSpecify true to use the file locations of the database in the template.

Specify false, the default, to use different file locations in the template. The file locations are determined by Oracle Flexible Architecture (OFA).
-connectionString easy_connect_stringOptionalEasy connect string for connecting to a remote database in the following form:

"host[:port][/service_name][:server][/instance_name]"
  • createCloneTemplate
The createCloneTemplate command creates a clone (seed) database template from an existing database.

Syntax and Parameters

Use the dbca -createCloneTemplate command with the following syntax:

dbca -createCloneTemplate 
   -sourceSID source_database_sid
   -templateName new_template_name
   [-sysDBAUserName user_name
    -sysDBAPassword password]
   [-maxBackupSetSizeInMB integer]
   [-rmanParallelism integer
   [-datafileJarLocation jar_location]

Table 2-9 createCloneTemplate Parameters

ParameterRequired/
Optional
Description
-sourceSID source_database_sidRequiredThe database system identifier
-templateName new_template_nameRequiredName of the new database template
-sysDBAUserName user_nameOptionalUsername of a user granted SYSDBA administrative privilege
-sysDBAPassword passwordOptionalPassword of the user granted SYSDBA administrative privilege
-maxBackupSetSizeInMB integerOptionalMaximum backup set size in megabytes
-rmanParallelism integerOptionalParallelism for Recovery Manager (RMAN) operations
-datafileJarLocation jar_locationOptionalComplete path that specifies where to place data files in a compressed format
  • generateScripts
The generateScripts command generates scripts to create a database.

Syntax and Parameters

Use the dbca -generateScripts command with the following syntax:

dbca -generateScripts 
   -templateName template_name
   -gdbName global_database_name
   [-scriptDest script_destination]

Table 2-10 generateScripts Parameters

ParameterRequired/
Optional
Description
-templateName template_nameRequiredName of an existing database template in the default location or the complete path of a template that is not in the default location
-gdbName global_database_nameRequiredGlobal database name in the form database_name.domain_name
-scriptDest script_destinationOptionalComplete path that specifies where to place the scripts
  • deleteDatabase
The deleteDatabase command deletes a database.

Syntax and Parameters

Use the dbca -deleteDatabase command with the following syntax:

dbca -deleteDatabase 
   -sourceDB source_database_sid
   [-sysDBAUserName user_name
    -sysDBAPassword password]
   [-emConfiguration {DBEXPRESS | CENTRAL | BOTH | NONE}
     [-omsHost central_agent_home
      -omsPort central_agent_port
      -emUser host_username
      -emPassword host_user_password]]

Table 2-11 deleteDatabase Parameters

ParameterRequired/
Optional
Description
 -sourceDB source_database_sidRequiredThe database system identifier
 -sysDBAUserName user_nameOptionalUsername of a user that has SYSDBA administrative privilege
 -sysDBAPassword passwordOptionalPassword of the user granted SYSDBA administrative privilege
-emConfiguration {DBEXPRESS | CENTRAL | BOTH | NONE}OptionalWhen DBEXPRESS, CENTRAL, or BOTH is specified, specify the following additional parameters:
  • -omsHost: Enterprise Manager central agent home
  • -omsPort: Enterprise Manager central agent port
  • -emUser: Host username for Enterprise Manager backup jobs
  • -emPassword: Host user password for Enterprise Manager backup jobs
  • createPluggableDatabase
The createPluggableDatabase command creates a PDB in a CDB.

Syntax and Parameters

Use the dbca -createPluggableDatabase command with the following syntax:

dbca -createPluggableDatabase 
   -sourceeDB source_database_sid
   -pdbName new_pdb_name
   [-createAsClone {true | false}]
   [-createPDBFrom {DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML}
      [-pdbArchiveFile pdb_archive_file_location]
      [-PDBBackUpfile pdb_backup_file_location]
      [-PDBMetadataFile pdb_metadata_file_location]
      [-pdbAdminUserName pdb_admin_user_name]
      [-pdbAdminPassword pdb_admin_password]
      [-createNewPDBAdminUser {true | false}]
      [-sourceFileNameConvert source_file_name_convert_clause]
      [-fileNameConvert file_name_convert_clause]
      [-copyPDBFiles  {true | false}]]
   [-pdbDatafileDestination pdb_datafile_destination]
   [-useMetaDataFileLocation {true | false}]
   [-registerWithDirService {true | false} 
      -dirServiceUserName directory_service_user_name
      -dirServicePassword directory_service_password
      -walletPassword wallet_password]
   [-lbacsysPassword LBACSYS_user_password]
   [-createUserTableSpace {true | false)]
   [-dvConfiguration {true | false}
      -dvUserName Database_Vault_owner_username
      -dvUserPassword Database_Vault_owner_password
      -dvAccountManagerName Database_Vault_account_manager
      -dvAccountManagerPassword Database_Vault_account_manager_password]

Table 2-12 createPluggableDatabase Parameters

ParameterRequired/
Optional
 Description
-sourceDB source_database_sidRequiredThe database system identifier of the CDB
-pdbName new_pdb_nameRequiredName of the new PDB
-createAsClone {true | false}Optional
Specify TRUE if the files you plan to use to create the new PDB are the same files that were used to create an existing PDB. Specifying TRUE ensures that Oracle Database generates unique PDB DBID, GUID, and other identifiers expected for the new PDB.

Specify FALSE, the default, if the files you plan to use to create the new PDB are not the same files that were used to create an existing PDB.
-createPDBFrom {DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML}OptionalSpecify DEFAULT to create the PDB from the CDB's seed. When you specify DEFAULT, the following additional parameters are required:
  • -pdbAdminUserName: The username of the PDB's local administrator
  • -pdbAdminPassword: The password for the PDB's local administrator
Specify FILEARCHIVE to create the PDB from an unplugged PDB's files. When you specify FILEARCHIVE, the following additional parameter is required:

-pdbArchiveFile: Complete path and name for unplugged PDB's archive file
  • The archive file contains all of the files for the PDB, including its XML metadata file and its data files. Typically, the archive file has a .gz extension.
  • -createNewPDBAdminUser: Specify true to create a new PDB administrator or false to avoid creating a new PDB administrator.
Specify RMANBACKUP to create the PDB from a Recovery Manager (RMAN) backup. When you specify RMANBACKUP, the following additional parameters are required:
  • -PDBBackUpfile: Complete path and name for the PDB backup file
  • -PDBMetadataFile: Complete path and name for the PDB's XML metadata file
Specify USINGXML to create the PDB from an unplugged PDB's XML metadata file. When you specify USINGXML, the following additional parameter is required:
  • -PDBMetadataFile: Complete path and name for the PDB's XML metadata file
Specify these other clauses if they are required:
  • -sourceFileNameConvert: The SOURCE_FILE_NAME_CONVERT clause.
  • -fileNameConvert: The FILE_NAME_CONVERT clause.
  • -copyPDBFiles: Specify true for the FILE_NAME_CONVERT clause to copy the files, or specify false if the files do not need to be copied.
 -pdbDatafileDestination pdb_datafile_destinationOptionalCompete path for the location of the new PDB's data files

When this parameter is not specified, either Oracle Managed Files or the PDB_FILE_NAME_CONVERT initialization parameter specifies how to generate the names and locations of the files. If you use both Oracle Managed Files and the PDB_FILE_NAME_CONVERT initialization parameter, then Oracle Managed Files takes precedence.

When this parameter is not specified, Oracle Managed Files is not enabled, and the PDB_FILE_NAME_CONVERT initialization parameter is not set, by default a path to a subdirectory with the name of the PDB in the directory for the root's files is used.
-useMetaDataFileLocation {true | false}OptionalSpecify true to use the data file path defined in XML metadata file within a PDB archive when extracting datafiles

Specify false, the default, to not use the data file path defined in XML metadata file within a PDB archive when extracting data files
-registerWithDirService {true | false}OptionalSpecify true to register with a Lightweight Directory Access Protocol (LDAP) service.

Specify false, the default, to not register with an LDAP service.

When true is specified, the following additional parameters are required:
  • -dirServiceUserName: Username for the LDAP service
  • -dirServicePassword: Password for the LDAP service
  • -walletPassword: Password for the database wallet
-lbacsysPasswordOptionalSpecify the LBACSYS user password when configuring Oracle Label Security. This parameter is required when configuring Oracle Label Security.
-dvConfiguration {true | false}OptionalSpecify false, the default, to indicate that the PDB will not use Oracle Database Vault.

Specify true to configure and enable Database Vault.

When true is specified, the following additional Database Vault parameters are required:
  • -dvUserName: Specify the Database Vault owner username.
  • -dvUserPassword: Specify Database Vault owner password.
  • -dvAccountManagerName: Specify a separate Database Vault account manager.
  • -dvAccountManagerPassword: Specify the Database Vault account manager password.
  • unplugDatabase
The unplugDatabase command unplugs a PDB from a CDB.

Syntax and Parameters

Use the dbca -unplugDatabase command with the following syntax:

dbca -unplugDatabase 
   -sourceeDB source_database_sid
   -pdbName pdb_name
      [-pdbArchiveFile pdb_archive_file_location]
      [-PDBBackUpfile pdb_backup_file_location]
      [-PDBMetadataFile pdb_metadata_file_location]
      [-archiveType {TAR | RMAN | NONE}]
   [-unregisterWithDirService {true | false}
      -dirServiceUserName directory_service_user_name
      -dirServicePassword directory_service_password
      -walletPassword wallet_password]

Table 2-13 unplugDatabase Parameters

ParameterRequired/
Optional
Description
-sourceDB source_database_sidRequiredThe database system identifier of the CDB
-pdbName pdb_nameRequiredName of the new PDB
-pdbArchiveFile pdb_archive_file_locationOptionalComplete path and file name for the unplugged PDB's archive file
-PDBBackUpFile pdb_archive_file_locationOptionalComplete path and file name for the unplugged PDB's backup file, required when archive type is RMAN
-PDBMetadataFile pdb_archive_file_locationOptionalComplete path and file name for the unplugged PDB's metadata file, required when archive type is RMAN or NONE
-archiveType {TAR | RMAN | NONE}OptionalSpecify TAR to store the unplugged PDB's files in a tar file.

Specify RMAN to store the unplugged PDB's files in an RMAN backup.

Specify NONE to store the unplugged PDB's files without using a tar file or an RMAN backup
-unregisterWithDirService {true | false}OptionalWhen true is specified, unregisters from an LDAP service. When false, the default, is specified, does not unregister from an LDAP service.

When true is specified, the following additional parameters are required:
  • -dirServiceUserName: Username for the LDAP service
  • -dirServicePassword: Password for the LDAP service
  • -walletPassword: Password for the database wallet
  • deletePluggableDatabase
The deletePluggableDatabase command deletes a PDB.

Syntax and Parameters

Use the dbca -deletePluggableDatabase command with the following syntax:

dbca -deletePluggableDatabase 
   -sourceeDB source_database_sid
   -pdbName pdb_name

Table 2-14 deletePluggableDatabase Parameters

ParameterRequired/
Optional
Description
-sourceDB source_database_sidRequiredThe database system identifier of the CDB
-pdbName pdb_nameRequiredName of the PDB
  • configurePluggableDatabase
The configurePluggableDatabase command configures a PDB.

Syntax and Parameters

Use the dbca -configurePluggableDatabase command with the following syntax:

dbca -configurePluggableDatabase 
   -sourceeDB source_database_sid
   -pdbName new_pdb_name
   [-dvConfiguration {true | false}
      -dvUserName Database_Vault_owner_username
      -dvUserPassword Database_Vault_owner_password
      -dvAccountManagerName Database_Vault_account_manager
      -dvAccountManagerPassword Database_Vault_account_manager_password]
   [-olsConfiguration {true | false}]
   [-registerWithDirService {true | false} | -unregisterWithDirService {true | false}
      -dirServiceUserName directory_service_user_name
      -dirServicePassword directory_service_password
      -walletPassword wallet_password]
   [-lbacsysPassword LBACSYS_user_password]

Table 2-15 configurePluggableDatabase Parameters

ParameterRequired/
Optional
Description
-sourceDB source_database_sidRequiredThe database system identifier of the CDB
-pdbName new_pdb_nameRequiredName of the new PDB
-dvConfiguration {true | false}OptionalSpecify false, the default, to indicate that the PDB will not use Oracle Database Vault.

Specify true to configure and enable Database Vault.

When true is specified, the following additional Database Vault parameters are required:
  • -dvUserName: Specify the Database Vault owner username.
  • -dvUserPassword: Specify Database Vault owner password.
  • -dvAccountManagerName: Specify a separate Database Vault account manager.
  • -dvAccountManagerPassword: Specify the Database Vault account manager password.
-olsConfiguration {true | false}OptionalSpecify true to configure and enable Oracle Label Security.

Specify false, the default, to indicate that the PDB will not use Oracle Label Security.
-registerWithDirService {true | false} | -unregisterWithDirService {true | false}OptionalSpecify true to register with a Lightweight Directory Access Protocol (LDAP) service.

Specify false, the default, to unregister from an LDAP service.

When true is specified, the following additional parameters are required:
  • -dirServiceUserName: Username for the LDAP service
  • -dirServicePassword: Password for the LDAP service
  • -walletPassword: Password for the database wallet
-lbacsysPasswordOptionalSpecify the LBACSYS user password when configuring Oracle Label Security. This parameter is required when configuring Oracle Label Security.

«« Previous
Next »»