Class: MintPress::OracleUtils::DBCASessionImpl

Inherits:

Object

• Object
• MintPress::OracleUtils::DBCASessionImpl

Includes:

MintLogger, Utils

Defined in:

src/oracle-utils/lib/oracle-utils/dbca-session.rb

Properties (Read/Write)

Properties (Read Only)

Constant Summary

Constants included from MintLogger

MintLogger::DEBUG, MintLogger::ERROR, MintLogger::FATAL, MintLogger::INFO, MintLogger::UNKNOWN, MintLogger::VERBOSE, MintLogger::WARN

Constants included from Utils

Utils::VERSION

Instance Method Summary

• #add_instance(options = {}) ⇒ Object
  ./dbca -addInstance -help -addInstance - Command to Add an instance to an admin managed cluster database.
• #camelify_keys(options = {}) ⇒ Object
• #check_result(result) ⇒ Object
• #configure_database(options = {}) ⇒ Object
  ./dbca -configureDatabase -help -configureDatabase - Command to Configure a database.
• #configure_pluggable_database(options = {}) ⇒ Object
  ./dbca -configurePluggableDatabase -help -configurePluggableDatabase - Command to Configure a pluggable database.
• #create_database(options = {}) ⇒ Object
  ./dbca -createDatabase -help -createDatabase - Command to Create a database.
• #create_duplicate_db(options = {}) ⇒ Object
  ./dbca -createDuplicateDB -help -createDuplicateDB - Command to Duplicate a database.
• #create_pluggable_database(options = {}) ⇒ Object
  ./dbca -createPluggableDatabase -help -createPluggableDatabase - Command to Create a pluggable database.
• #database_exists?(gdbName:, options: {}) ⇒ Boolean
• #dbca_runner(command:, options:) ⇒ Object
  Generic DBCA Runner method to execute DBCA commands.
• #delete_database(options = {}) ⇒ Object
  ./dbca -deleteDatabase -help -deleteDatabase - Command to Delete a database.
• #delete_instance(options = {}) ⇒ Object
  ./dbca -deleteInstance -help -deleteInstance - Command to Delete an instance from an admin managed cluster database.
• #delete_pluggable_database(options = {}) ⇒ Object
  ./dbca -deletePluggableDatabase -help -deletePluggableDatabase - Command to Delete a pluggable database.
• #execute_prereqs(options = {}) ⇒ Object
  ./dbca -executePrereqs -help -executePrereqs - Command to execute prerequisite checks.
• #find_binary(oracle_home) ⇒ Object
• #generate_scripts(options = {}) ⇒ Object
  ./dbca -generateScripts -help -generateScripts - Command to Generate scripts which can be used to create database.
• #initialize(transport:, oracle_home:, options: {}) ⇒ DBCASessionImpl constructor
  Refer to the SQL*Plus User's Guide and Reference for more information.
• #unplug_database(options = {}) ⇒ Object
  ./dbca -unplugDatabase -help -unplugDatabase - Command to Unplug a pluggable database.

Methods included from MintLogger::Utils::Common

#boolean_val, #has_value?, #no_value?, #nvl, #path_as_symbol, #ruby_level_to_send

Methods included from Utils

#shellout

Constructor Details

#initialize(transport:, oracle_home:, options: {}) ⇒ DBCASessionImpl

Refer to the SQL*Plus User's Guide and Reference for more information.

Raises:

• (ArgumentError)

Instance Method Details

#add_instance(options = {}) ⇒ Object

./dbca -addInstance -help -addInstance - Command to Add an instance to an admin managed cluster database. -gdbName -nodeName [-instanceName ] [-sysDBAPassword ] [-sysDBAUserName ] [-updateDirService ] -dirServicePassword -dirServiceUserName

#camelify_keys(options = {}) ⇒ Object

#check_result(result) ⇒ Object

#configure_database(options = {}) ⇒ Object

./dbca -configureDatabase -help -configureDatabase - Command to Configure a database. -sourceDB [-addDBOption ] [-dvConfiguration Specify true to configure and enable database vault.] -dvUserName -dvUserPassword [-dvAccountManagerName ] [-dvAccountManagerPassword ] [-olsConfiguration Specify true to configure and enable Oracle Label Security.] [-configureWithOID This flag configures Oracle Label Security with OID.] [-registerWithDirService | -unregisterWithDirService | -regenerateDBPassword] [-registerWithDirService ] -dirServiceUserName [-databaseCN ] [-dirServicePassword ] [-walletPassword ] [-unregisterWithDirService ] -dirServiceUserName [-dirServicePassword ] [-walletPassword ] [-regenerateDBPassword ] [-sysDBAPassword ] [-sysDBAUserName ]

#configure_pluggable_database(options = {}) ⇒ Object

./dbca -configurePluggableDatabase -help -configurePluggableDatabase - Command to Configure a pluggable database. -pdbName -sourceDB [-dvConfiguration Specify true to configure and enable database vault.] -dvUserName -dvUserPassword [-dvAccountManagerName ] [-dvAccountManagerPassword ] [-lbacsysPassword ] [-olsConfiguration Specify true to configure and enable Oracle Label Security.] [-configureWithOID This flag configures Oracle Label Security with OID.] [-registerWithDirService | -unregisterWithDirService] [-registerWithDirService ] -dirServiceUserName [-databaseCN ] [-dirServicePassword ] [-walletPassword ] [-unregisterWithDirService ] -dirServiceUserName [-dirServicePassword ] [-walletPassword ]

#create_database(options = {}) ⇒ Object

./dbca -createDatabase -help -createDatabase - Command to Create a database. -responseFile | (-gdbName,-templateName) -responseFile - -gdbName -templateName [-characterSet ] [-createAsContainerDatabase ] [-numberOfPDBs ] [-pdbAdminPassword ] [-pdbName ] [-pdbOptions ] [-pdbStorageMAXSizeInMB ] [-pdbStorageMAXTempSizeInMB ] [-useLocalUndoForPDBs Specify false to disable local undo tablespace for PDBs.] [-createListener ] [-customScripts ] [-databaseConfigType ] [-RACOneNodeServiceName ] [-databaseType ] [-datafileDestination ] [-datafileJarLocation ] [-dbOptions ] [-dvConfiguration Specify true to configure and enable database vault.] -dvUserName -dvUserPassword [-dvAccountManagerName ] [-dvAccountManagerPassword ] [-emConfiguration ] [-dbsnmpPassword ] [-emExpressPort ] [-emPassword ] [-emUser ] [-omsHost ] [-omsPort ] [-enableArchive Specify true to enable archive>] [-archiveLogDest ] [-archiveLogMode ] [-initParams ] [-initParamsEscapeChar ] [-listeners ] [-memoryMgmtType ] [-memoryPercentage | -totalMemory] [-memoryPercentage ] [-totalMemory ] [-nationalCharacterSet ] [-nodelist ] [-olsConfiguration Specify true to configure and enable Oracle Label Security.] [-configureWithOID This flag configures Oracle Label Security with OID.] [-oracleHomeUserName ] [-oracleHomeUserPassword ] [-policyManaged | -adminManaged] [-policyManaged ] -serverPoolName [-createServerPool ] [-cardinality ] [-force ] [-pqCardinality ] [-pqPoolName ] [-pqPoolName ] [-adminManaged ] [-recoveryAreaDestination ] [-recoveryAreaSize ] [-redoLogFileSize ] [-registerWithDirService ] -dirServiceUserName [-databaseCN ] [-dirServicePassword ] [-walletPassword ] [-runCVUChecks ] [-sampleSchema ] [-sid ] [-storageType < FS | ASM >] -datafileDestination [-asmsnmpPassword ] [-sysPassword ] [-systemPassword ] [-useOMF Specify true to use Oracle-Managed Files.] [-useWalletForDBCredentials Specify true to load database credentials from wallet] -dbCredentialsWalletLocation [-dbCredentialsWalletPassword ] [-variables ] [-variablesFile ]

#create_duplicate_db(options = {}) ⇒ Object

./dbca -createDuplicateDB -help -createDuplicateDB - Command to Duplicate a database. -gdbName -primaryDBConnectionString -sid [-createAsStandby ] [-dbUniqueName ] [-customScripts ] [-datafileDestination ] [-initParams ] [-initParamsEscapeChar ]

#create_pluggable_database(options = {}) ⇒ Object

./dbca -createPluggableDatabase -help -createPluggableDatabase - Command to Create a pluggable database. -pdbName -sourceDB [-createAsClone Create PDB as clone. When "true" is passed a new PDB GUID is generated for the plugged PDB] [-createPDBFrom ] [-copyPDBFiles Specify true if PDB datafiles need to be copied] [-createNewPDBAdminUser ] [-fileNameConvert ] [-pdbAdminPassword ] [-pdbAdminUserName ] [-pdbArchiveFile ] [-pdbBackUpfile ] [-pdbMetadataFile ] [-pdbStorageMAXSizeInMB ] [-pdbStorageMAXTempSizeInMB ] [-sourceFileNameConvert ] [-workArea ] [-createUserTableSpace Specify true if a default user tablespace need to be created in new PDB.] [-customScripts ] [-dvConfiguration Specify true to configure and enable database vault.] -dvUserName -dvUserPassword [-dvAccountManagerName ] [-dvAccountManagerPassword ] [-lbacsysPassword ] [-pdbDatafileDestination ] [-pdbStorageMAXSizeInMB ] [-pdbStorageMAXTempSizeInMB ] [-pdbUseMultipleBackup ] [-registerWithDirService ] -dirServiceUserName [-databaseCN ] [-dirServicePassword ] [-walletPassword ] [-useMetaDataFileLocation Specify true if datafile path defined in metadata file within PDB archive file is to be used while extracting datafiles.]

#database_exists?(gdbName:, options: {}) ⇒ Boolean

Returns:

• (Boolean)

#dbca_runner(command:, options:) ⇒ Object

Generic DBCA Runner method to execute DBCA commands

#delete_database(options = {}) ⇒ Object

./dbca -deleteDatabase -help -deleteDatabase - Command to Delete a database. -sourceDB [-deRegisterEMCloudControl ] -emUser -omsHost -omsPort [-emPassword ] [-forceArchiveLogDeletion ] [-sid ] [-sysDBAPassword ] [-sysDBAUserName ]

#delete_instance(options = {}) ⇒ Object

./dbca -deleteInstance -help -deleteInstance - Command to Delete an instance from an admin managed cluster database. -gdbName -instanceName [-nodeName ] [-sysDBAPassword ] [-sysDBAUserName ] [-updateDirService ] -dirServicePassword -dirServiceUserName

#delete_pluggable_database(options = {}) ⇒ Object

./dbca -deletePluggableDatabase -help -deletePluggableDatabase - Command to Delete a pluggable database. -pdbName -sourceDB

#execute_prereqs(options = {}) ⇒ Object

./dbca -executePrereqs -help -executePrereqs - Command to execute prerequisite checks. -databaseConfigType [-RACOneNodeServiceName ] [-nodelist ]

#find_binary(oracle_home) ⇒ Object

#generate_scripts(options = {}) ⇒ Object

./dbca -generateScripts -help -generateScripts - Command to Generate scripts which can be used to create database. -gdbName -templateName [-characterSet ] [-createAsContainerDatabase ] [-numberOfPDBs ] [-pdbAdminPassword ] [-pdbName ] [-pdbOptions ] [-pdbStorageMAXSizeInMB ] [-pdbStorageMAXTempSizeInMB ] [-useLocalUndoForPDBs Specify false to disable local undo tablespace for PDBs.] [-createListener ] [-customScripts ] [-databaseConfigType ] [-RACOneNodeServiceName ] [-databaseType ] [-datafileDestination ] [-datafileJarLocation ] [-dvConfiguration Specify true to configure and enable database vault.] -dvUserName -dvUserPassword [-dvAccountManagerName ] [-dvAccountManagerPassword ] [-emConfiguration ] [-dbsnmpPassword ] [-emExpressPort ] [-emPassword ] [-emUser ] [-omsHost ] [-omsPort ] [-enableArchive Specify true to enable archive>] [-archiveLogDest ] [-archiveLogMode ] [-initParams ] [-initParamsEscapeChar ] [-listeners ] [-memoryMgmtType ] [-memoryPercentage | -totalMemory] [-memoryPercentage ] [-totalMemory ] [-nationalCharacterSet ] [-nodelist ] [-olsConfiguration Specify true to configure and enable Oracle Label Security.] [-configureWithOID This flag configures Oracle Label Security with OID.] [-policyManaged | -adminManaged] [-policyManaged ] -serverPoolName [-createServerPool ] [-cardinality ] [-force ] [-pqCardinality ] [-pqPoolName ] [-pqPoolName ] [-adminManaged ] [-recoveryAreaDestination ] [-recoveryAreaSize ] [-redoLogFileSize ] [-registerWithDirService ] -dirServiceUserName [-databaseCN ] [-dirServicePassword ] [-walletPassword ] [-responseFile - ] [-runCVUChecks ] [-sampleSchema ] [-scriptDest ] [-sid ] [-storageType < FS | ASM >] -datafileDestination [-asmsnmpPassword ] [-sysPassword ] [-systemPassword ] [-useOMF Specify true to use Oracle-Managed Files.] [-variables ] [-variablesFile ]

#unplug_database(options = {}) ⇒ Object

./dbca -unplugDatabase -help -unplugDatabase - Command to Unplug a pluggable database. -archiveType Optional field during UnplugDatabase. [-pdbArchiveFile ] [-pdbBackUpfile ] [-pdbMetadataFile ] -pdbName -sourceDB [-unregisterWithDirService ] -dirServiceUserName [-dirServicePassword ] [-walletPassword ]