ExaDB-D dbaascli dbaascli 24.1.1.0.0 (231219) 2024/04/24 (version 23.4.1.0.0) dbaascli dbaascli --help [root@wasa-ycfpo1 ~]# dbaascli --help DBAAS CLI version 24.1.1.0.0 Executing command --help Usage: dbaascli [] [] Following are the possible flags: --help - display help. The following are the supported objects and associated commands. To view the available for a command, use the --help flag on the respective command. admin updateStack - install/update a dbaastools RPM admin showLatestStackVersion - shows the version of latest available dbaastools stack to update admin updateAHF - install/update AHF diag collect - diagnostic log collection diag healthcheck cswLib download - CSWLIB download/update dbnid bits. cswLib showImages - CSWLIB list available DB/GI images. cswLib listLocal - CSWLIB list locally available DB/GI images. cswLib deleteLocal - CSWLIB deletes local image. database bounce - bounce a specific database. database changePassword - change the password for a given user in the database. database addInstance - allows user to add the database instance on the specified node. database deleteInstance - allows user to delete the database instance on the specified node. database convertToPDB - to convert given non-CDB database to PDB. database getDetails - display details about a specific database. database modifyParameters - modifies or resets initialization parameters for a given Oracle database. database move - move DB from one home to another home. database start - start a specific database. database status - checks status of a database. database stop - stop a specific database. database upgrade - performs the upgrade of an Oracle database. database upgradeTimeZone - to upgrade the database time zone version dbaascli dbaascli --help database create - create a new database. database duplicate - create a new database from active database. database delete - delete the given database. database runDatapatch - patches the database. database backup - performs database backup operations. database recover - performs database recovery. database getPDBs - display information of PDBs in specified database. database createTemplate - create a new template from the specified database. dataguard failover - failover to Standby when all db nodes are up. This command is expected to fail if primary is down. Failover can be performed using ''force'' operation at your own risk. dataguard reinstate - reinstate failed Primary as new Standby dataguard status - show dataguard status. dataguard switchover - switchover to Standby. dataguard verify - checks cluster readiness for hosting a standby database. dataguard configureAWR - enables generation of AWR reports for standby database from primary database. dataguard convertStandby - facilitates type conversion for Standby Database. dataguard configureRedoApply - manage and monitor the redo apply setting for a given Oracle database configured for Data Guard. dataguard prepareStandbyBlob - generate a TAR file containing the primary database wallet to export for standby PDB creation. dataguard updateDGConfigAttributes - update Dataguard Automation Attributes across all nodes of a cluster. dataguard showDGConfigAttributes - show Dataguard Automation Attributes on a cluster. dataguard createDrConfig - configure the various clusterware resources on the disaster recovery network. dbHome patch - patches the dbhome from one patch level to another. dbHome create - create database Oracle Home. dbHome delete - delete the given Oracle Database Home. dbHome getDetails - display details of specified Oracle home. dbHome getDatabases - display details of databases in specified Oracle home. gridHome create - setup of Grid Infrastructure home. gridHome delete - delete the given Grid Infrastructure home. 3 varchar2 dbaascli dbaascli --help grid changePassword - change the sys and asmsnmp passwords for grid. grid upgrade - upgrade the Grid Infrastructure from one major version to another. grid patch - patch the Grid Infrastructure to the specified minor version. grid configureTCPS - configure TCPS for existing cluster. grid rotateTCPSCert - rotate TCPS certificates. grid removeTCPSCert - remove existing TCPS certs from Grid Infrastructure wallet. grid showTCPSCerts - to list TCPS certs from Grid Infrastructure wallet. grid getDetails - display the details of configured Grid Infrastructure home. job getStatus - display the status info of specified job. pdb localClone - clone a PDB from another PDB in the same database. pdb getConnectString - get connectString of the specified PDB. pdb remoteClone - clone the specified PDB from an another database. pdb close - close a PDB. pdb create - create a new PDB. pdb open - open a PDB. pdb relocate - relocate the specified PDB from remote DB into local DB. pdb delete - delete a PDB. pdb bounce - bounce the PDB. pdb getDetails - get the details of provided PDB in the database. pdb backup - performs PDB backup operations. pdb recover - performs PDB recovery. pdb refresh - refresh a specified PDB. system getDatabases - list details of all the databases. system getDBHomes - list the details of all the Oracle homes. system getGridHomes - list the details of all the Grid homes. く 4 varchar2 dbaascli dbaascli --help tde setPrimaryHSMKey - change primary HSM(KMS) key for existing HSM(KMS) configuration. tde setKeyVersion - sets the version of the primary key to be used in DB/CDB or PDB. tde removeSecondaryHSMKey - remove second HSM(KMS) key from existing HSM(KMS) configuration. tde hsmToFile - convert HSM(KMS/OKV) based TDE to FILE based TDE. tde getPrimaryHSMKey - get Primary HSM(KMS) key from existing HSM(KMS) configuration. tde fileToHSM - convert FILE based TDE to HSM(KMS/OKV) based TDE. tde addSecondaryHSMKey - add second HSM(KMS) key to existing HSM(KMS) configuration. tde backup - backup TDE wallets to local disk. tde changePassword - changes TDE keystore password as well as DB wallet password for the alias tde_ks_passwd. tde listKeys - list TDE master keys. tde status - show TDE configuration status. tde getMKIDForKeyVersionOCID - get Masterkey ID associated to KMS key version OCID. tde getHSMKeys - get TDE active key details. tde encryptTablespacesInPDB - encrypt all the tablespaces present in the given PDB. tde enableWalletRoot - enable wallet_root spfile parameter for existing database. tde exportTDEKey - export TDE master encryption key into a file. tde rotateMasterKey - rotate TDE master key. [root@wasa-ycfpo1 ~]# dbaascli dbaascli -v [oracle@vmem-6gl0h1 ~]$ dbaascli -v DBAAS CLI version 23.4.1.0.0 Executing command -v DBAAS CLI version 23.4.1.0.0 [oracle@vmem-6gl0h1 ~]$ rpm -qa | grep dbaas dbaastools_exa-1.0-23.4.1.0.0_231031.1153.x86_64 ssh host_access_control idle-timeout --help [root@vmem-6gl0h1 ~]# host_access_control idle-timeout --help Usage: host_access_control idle-timeout [options] [arguments] [arguments] --client {integer} --clientaliveinterval {integer} --clientalivecountmax {integer} --shell {integer} --defaults --status Idle Timeout Settings Control Options: -h, --help show this help message and exit -c CLIENT, --client=CLIENT SSH client idle timeout. Option retained for backwards compatibility. Number of seconds of inactivity on an ssh connection before the connection is terminated. Sets ClientAliveCountMax to 0 and ClientAliveInterval to the given --client value. Input is limited from 0 to 31557600 (one year) (*Exadata factory default is 600 (10m)) -i CLIENTALIVEINTERVAL, --clientaliveinterval=CLIENTALIVEINTERVAL ClientAliveInterval, SSH client idle timeout. Number of seconds of inactivity before a message is sent to request a response from the client. Input is limited from 0 (disabled) to 31557600 (one year) (*Exadata factory default is 600 (10m)) -m CLIENTALIVECOUNTMAX, --clientalivecountmax=CLIENTALIVECOUNTMAX ClientAliveCountMax, SSH client idle timeout. The number of client alive messages which may be sent without sshd receiving any messages back from the client. Input is limited from 0 to 100000 (*Exadata factory default is 0) -l SHELL, --shell=SHELL Shell idle timeout. Number of seconds of no input before the shell will terminate. Input is limited to 0 or from 300 to 31557600 (one year) (*Exadata factory default is 14400 (4h)) --defaults Set all idle-timeout values to *Exadata factory defaults -s, --status Display current idle timeout settings 17 varchar2 host_access_control idle-timeout [root@vmem-6gl0h1 ~]# host_access_control idle-timeout -l 14400 [2023-11-20 13:22:45 +0900] [INFO] [IMG-SEC-0404] Shell timeout set to 14400 [root@vmem-6gl0h1 ~]# cat /etc/ssh/sshd_config | grep -i inter ClientAliveInterval 600 [root@vmem-6gl0h1 ~]# host_access_control idle-timeout -c 14400 [2023-11-20 13:23:04 +0900] [INFO] [IMG-SEC-0403] SSH client idle timeout is set to 14400 [2023-11-20 13:23:05 +0900] [INFO] [IMG-SEC-0A02] SSHD Service restarted. Changes in effect for new connections. [root@vmem-6gl0h1 ~]# cat /etc/ssh/sshd_config | grep -i inter ClientAliveInterval 14400 [root@vmem-6gl0h1 ~]# host_access_control idle-timeout -s [2023-11-20 13:23:17 +0900] [INFO] [IMG-SEC-0402] Shell timeout is set to TMOUT=14400 [2023-11-20 13:23:17 +0900] [INFO] [IMG-SEC-0403] SSH client idle timeout is set to ClientAliveInterval 14400 [2023-11-20 13:23:17 +0900] [INFO] [IMG-SEC-0403] SSH client idle timeout is set to ClientAliveCountMax 0 dbaascli 2. Oracle Database Home 3. Oracle Database Home でのOracle Databaseの作成 Cloud Software Library --help [root@taro-3nusm1 ~]# dbaascli cswlib --help DBAAS CLI version 24.1.1.0.0 Executing command cswlib --help cswLib download - CSWLIB download/update dbnid bits. cswLib showImages - CSWLIB list available DB/GI images. cswLib listLocal - CSWLIB list locally available DB/GI images. cswLib deleteLocal - CSWLIB deletes local image. [root@taro-3nusm1 ~]# dbaascli cswlib showImages --help [root@vmem-6gl0h1 ~]# dbaascli cswlib showimages --help DBAAS CLI version 23.4.1.0.0 Executing command cswlib showimages --help cswLib showImages - CSWLIB list available DB/GI images. Usage: dbaascli cswLib showImages [--product ] [--jsonFormat [--jsonFilePath ]] Where: [--product - product type. The valid values are: DATABASE | GRID .] [--jsonFormat - displays output in JSON format.] [--jsonFilePath - path of the JSON file.] dbaascli cswlib showImages [root@vmem-6gl0h1 ~]# dbaascli cswlib showimages DBAAS CLI version 23.4.1.0.0 Executing command cswlib showimages Job id: c45ccffd-a8b9-4de5-8d36-92c3c929b84c Session log: /var/opt/oracle/log/cswLib/showImages/dbaastools_2023- 11-20_01-24-57-PM_173707.log Log file location: /var/opt/oracle/log/cswLib/showImages/dbaastools_2023-11-20_01-24-57- PM_173707.log ############ List of Available database Artifacts ############# 1.IMAGE_TAG=11.2.0.4.230418 VERSION=11.2.0.4.230418 DESCRIPTION=11.2 APR 2023 DB Image 2.IMAGE_TAG=12.2.0.1.230117 VERSION=12.2.0.1.230117 DESCRIPTION=12.2 JAN 2023 DB Image 3.IMAGE_TAG=12.2.0.1.230718 VERSION=12.2.0.1.230718 DESCRIPTION=12.2 JUL 2023 DB Image 4.IMAGE_TAG=18.23.0.0.0 VERSION=18.23.0.0.0 DESCRIPTION=18c JUL 2023 DB Image 5.IMAGE_TAG=12.1.0.2.231017 VERSION=12.1.0.2.231017 DESCRIPTION=12.1 OCT 2023 DB Image 6.IMAGE_TAG=18.22.0.0.0 VERSION=18.22.0.0.0 DESCRIPTION=18c APR 2023 DB Image 7.IMAGE_TAG=11.2.0.4.231017 VERSION=11.2.0.4.231017 DESCRIPTION=11.2 OCT 2023 DB Image 8.IMAGE_TAG=12.1.0.2.230418 VERSION=12.1.0.2.230418 DESCRIPTION=12.1 APR 2023 DB Image 9.IMAGE_TAG=19.18.0.0.0 VERSION=19.18.0.0.0 DESCRIPTION=19c JAN 2023 DB Image 10.IMAGE_TAG=19.20.0.0.0 VERSION=19.20.0.0.0 DESCRIPTION=19c JUL 2023 DB Image 11.IMAGE_TAG=11.2.0.4.230117 VERSION=11.2.0.4.230117 DESCRIPTION=11.2 JAN 2023 DB Image 12.IMAGE_TAG=18.21.0.0.0 VERSION=18.21.0.0.0 DESCRIPTION=18c JAN 2023 DB Image 13.IMAGE_TAG=12.2.0.1.230418 VERSION=12.2.0.1.230418 DESCRIPTION=12.2 APR 2023 DB Image 14.IMAGE_TAG=11.2.0.4.230718 VERSION=11.2.0.4.230718 DESCRIPTION=11.2 JUL 2023 DB Image 15.IMAGE_TAG=12.1.0.2.230718 VERSION=12.1.0.2.230718 DESCRIPTION=12.1 JUL 2023 DB Image dbaascli cswlib showImages 16.IMAGE_TAG=18.20.0.0.0 VERSION=18.20.0.0.0 DESCRIPTION=18c OCT 2022 DB Image 17.IMAGE_TAG=12.2.0.1.231017 VERSION=12.2.0.1.231017 DESCRIPTION=12.2 OCT 2023 DB Image 18.IMAGE_TAG=18.24.0.0.0 VERSION=18.24.0.0.0 DESCRIPTION=18c OCT 2023 DB Image 19.IMAGE_TAG=19.19.0.0.0 VERSION=19.19.0.0.0 DESCRIPTION=19c APR 2023 DB Image 20.IMAGE_TAG=19.21.0.0.0 VERSION=19.21.0.0.0 DESCRIPTION=19c OCT 2023 DB Image 21.IMAGE_TAG=12.1.0.2.230117 VERSION=12.1.0.2.230117 DESCRIPTION=12.1 JAN 2023 DB Image Images can be downloaded using their image tags. For details, see help using 'dbaascli cswlib download --help'. dbaascli execution completed dbaascli cswLib listLocal [root@vmem-6gl0h1 ~]# dbaascli cswlib listLocal --help DBAAS CLI version 23.4.1.0.0 Executing command cswlib listLocal --help cswLib listLocal - CSWLIB list locally available DB/GI images. Usage: dbaascli cswLib listLocal [--product ] Where: [--product - product type. The valid values are: DATABASE | GRID .] [root@vmem-6gl0h1 ~]# dbaascli cswlib listLocal DBAAS CLI version 23.4.1.0.0 Executing command cswlib listLocal Job id: dc4a03a3-c63f-4600-b09e-dad1c5092d3f Session log: /var/opt/oracle/log/cswLib/listLocal/dbaastools_2023-11-20_07-43-42-PM_301284.log Log file location: /var/opt/oracle/log/cswLib/listLocal/dbaastools_2023-11-20_07-43-42-PM_301284.log ############ List of Available Database Images ############# 1.IMAGE_TAG=19.20.0.0.0 IMAGE_SIZE=5GB VERSION=19.20.0.0.0 DESCRIPTION=19c JUL 2023 DB Image 2.IMAGE_TAG=19.21.0.0.0 IMAGE_SIZE=5GB VERSION=19.21.0.0.0 DESCRIPTION=19c OCT 2023 DB Image dbaascli execution completed [root@vmem-6gl0h1 ~]# baascli cswlib download --help [root@vmem-6gl0h1 ~]# dbaascli cswlib download --help DBAAS CLI version 23.4.1.0.0 Executing command cswlib download --help cswLib download - CSWLIB download/update dbnid bits. Usage: dbaascli cswLib download { --version | --imageTag } [--product ] Where: --version | --imageTag --version - Oracle home image version. --imageTag - Oracle home image tag. [--product - product type. The valid values are: DATABASE | GRID .] dbaascli cswlib download [root@vmem-6gl0h1 ~]# dbaascli cswlib download --version 19.21.0.0.0 DBAAS CLI version 23.4.1.0.0 Executing command cswlib download --version 19.21.0.0.0 Job id: f0e6e39c-250d-4fe2-b484-478798089491 Session log: /var/opt/oracle/log/cswLib/download/dbaastools_2023-11-20_01-29-57-PM_204515.log Image location=/var/opt/oracle/dbaas_acfs/dbnid/19.21.0.0.0 Download succeeded Log file location: /var/opt/oracle/log/cswLib/download/dbaastools_2023-11-20_01-29-57-PM_204515.log dbaascli execution completed You have new mail in /var/spool/mail/root [root@vmem-6gl0h1 ~]# dbaascli cswlib listLocal DBAAS CLI version 23.4.1.0.0 Executing command cswlib listLocal Job id: c162764a-49e8-47e0-aacc-a95e12376162 Session log: /var/opt/oracle/log/cswLib/listLocal/dbaastools_2023-11-20_01-31-38-PM_214945.log Log file location: /var/opt/oracle/log/cswLib/listLocal/dbaastools_2023-11-20_01-31-38-PM_214945.log ############ List of Available Database Images ############# 1.IMAGE_TAG=19.20.0.0.0 IMAGE_SIZE=5GB VERSION=19.20.0.0.0 DESCRIPTION=19c JUL 2023 DB Image 2.IMAGE_TAG=19.21.0.0.0 IMAGE_SIZE=5GB VERSION=19.21.0.0.0 DESCRIPTION=19c OCT 2023 DB Image dbaascli execution completed 19.21 dbaascli cswlib download [root@vmem-6gl0h1 ~]# ls -al /var/opt/oracle/dbaas_acfs/dbnid/19.21.0.0.0 total 5267560 drwx------ 2 oracle oinstall 20480 Nov 16 16:45 . drwxr-xr-x 6 oracle oinstall 20480 Nov 16 16:42 .. -rwx------ 1 oracle oinstall 5389406916 Nov 16 16:43 db19000_bits_EXA.zip [root@vmem-6gl0h1 ~]# [root@vmem-6gl0h1 ~]# ls -al /var/opt/oracle/dbaas_acfs/dbnid/ total 316 drwxr-xr-x 6 oracle oinstall 20480 Nov 16 16:42 . drwxr-xr-x 22 oracle oinstall 20480 Nov 20 13:23 .. drwx------ 2 oracle oinstall 20480 Oct 20 10:09 19.20.0.0.0 drwx------ 2 oracle oinstall 20480 Nov 16 16:45 19.21.0.0.0 lrwxrwxrwx 1 oracle oinstall 65 Oct 20 10:09 db19000_bits_EXA.zip -> /var/opt/oracle/dbaas_acfs/dbnid/19.20.0.0.0/db19000_bits_EXA.zip drwxr-xr-x 3 oracle oinstall 20480 Oct 20 13:36 NONCDB drwxr-xr-x 2 oracle oinstall 20480 Oct 20 13:36 OCT2021 dbaascli cswlib deleteLocal --help [root@taro-3nusm1 ~]# dbaascli cswlib deleteLocal --help DBAAS CLI version 24.1.1.0.0 Executing command cswlib deleteLocal --help cswLib deleteLocal - CSWLIB deletes local image. Usage: dbaascli cswLib deleteLocal --imageTag Where: --imageTag - Oracle home image tag. [root@taro-3nusm1 ~]# DBHOME dbaascli dbhome --help [root@taro-3nusm1 ~]# dbaascli dbhome --help DBAAS CLI version 24.1.1.0.0 Executing command dbhome --help dbHome patch - patches the dbhome from one patch level to another. dbHome create - create database Oracle Home. dbHome delete - delete the given Oracle Database Home. dbHome getDetails - display details of specified Oracle home. dbHome getDatabases - display details of databases in specified Oracle home. [root@taro-3nusm1 ~]# Oracle Database Home dbaascli dbhome create --help [root@vmem-6gl0h1 ~]# dbaascli dbhome create --help DBAAS CLI version 23.4.1.0.0 Executing command dbhome create --help dbHome create - create database Oracle Home. Usage: dbaascli dbHome create --version [--oracleHomeName ] [--oracleHome ] [--imageTag ] [-- enableUnifiedAuditing ] [--executePrereqs] [--imageFilePath ] [--waitForCompletion ] Where: --version - Oracle home version, specified as five numeric segments separated by periods (e.g. 19.12.0.0.0). [--oracleHomeName - user defined home name, if not provided default name will be used. ] [--oracleHome - specifies Oracle home location] [--imageTag - Oracle home image tag.] [--enableUnifiedAuditing - specifies true|false to enable|disable unified auditing link option in Oracle home.] [--executePrereqs - run the prerequisite checks and report the results. ] [--imageFilePath - absolute path of the image file to be used. ] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [root@vmem-6gl0h1 ~]# Oracle Database Home dbaascli dbhome create [root@vmem-6gl0h1 ~]# dbaascli dbhome create --version 19.21.0.0.0 DBAAS CLI version 23.4.1.0.0 Executing command dbhome create --version 19.21.0.0.0 Job id: f987b833-9dc3-4c39-ba53-fa863c2c92d5 Session log: /var/opt/oracle/log/dbHome/create/dbaastools_2023-11- 20_01-36-21-PM_239183.log Loading PILOT... Session ID of the current execution is: 1118 Log file location: /var/opt/oracle/log/dbHome/create/pilot_2023-11- 20_01-36-25-PM_239783 Running Plugin_initialization job Completed Plugin_initialization job Running OH_image_validate job Completed OH_image_validate job Running OH_image_download job Completed OH_image_download job Running DB_home_version_check job Completed DB_home_version_check job Running OH_image_version_check job Completed OH_image_version_check job Running Validate_backup_location job Completed Validate_backup_location job Running Disk_space_check job Completed Disk_space_check job Running Cluster_nodes_check job Completed Cluster_nodes_check job ----------------- Running Validate_users_group job Completed Validate_users_group job Acquiring write lock: _u02_app_oracle_product_19.0.0.0_dbhome_6 Acquiring write lock: provisioning ----------------- Running Pre_OH_creation_lock_manager job Completed Pre_OH_creation_lock_manager job Running OH_pre_existence_check job Completed OH_pre_existence_check job Running Local_node_oh_image_unzip job Completed Local_node_oh_image_unzip job Running OH_creation_cvu_prechecks job Completed OH_creation_cvu_prechecks job Running Local_node_oh_clone job Completed Local_node_oh_clone job Running Update_dbnid_bits job Skipping. Job is detected as not applicable. Running Local_node_oh_backup_creation job Completed Local_node_oh_backup_creation job Oracle Database Home dbaascli dbhome create Running Remote_nodes_software_copy job Completed Remote_nodes_software_copy job ----------------- Running Remote_nodes_attach_home job Completed Remote_nodes_attach_home job ----------------- Running Remote_nodes_post_install_steps job Completed Remote_nodes_post_install_steps job Running Plugin_cleanup job Completed Plugin_cleanup job ---------- START OF PLUGIN RESULT ---------- {"ORACLE_HOME_NAME":"OraHome6","ORACLE_HOME":"/u02/app/oracle/product /19.0.0.0/dbhome_6"} ---------- END OF PLUGIN RESULT ---------- dbaascli execution completed [root@vmem-6gl0h1 ~]# Running Inventory_nodes_list_update job Completed Inventory_nodes_list_update job Running Root_script_run job Completed Root_script_run job Running Post_OH_creation_lock_manager job Completed Post_OH_creation_lock_manager job Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_6 Releasing lock: provisioning Running Generate_dbhome_metadata job Completed Generate_dbhome_metadata job Running Generate_dbhome_system_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed Generate_dbhome_system_details job Oracle Database Home の削除 dbaascli dbhome delete --help [root@taro-3nusm1 ~]# dbaascli dbhome delete --help DBAAS CLI version 24.1.1.0.0 Executing command dbhome delete --help dbHome delete - delete the given Oracle Database Home. Usage: dbaascli dbHome delete { --oracleHome | --oracleHomeName } [--resume [--sessionID ]] [--waitForCompletion ] Where: --oracleHome | --oracleHomeName --oracleHome - Oracle home path. --oracleHomeName - Oracle home name. [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [root@taro-3nusm1 ~]# Database Home dbaascli system getDBHomes [root@vmem-6gl0h1 ~]# dbaascli system getDBHomes --help DBAAS CLI version 23.4.1.0.0 Executing command system getDBHomes --help system getDBHomes - list the details of all the Oracle homes. Usage: dbaascli system getDBHomes You have new mail in /var/spool/mail/root [root@vmem-6gl0h1 ~]# dbaascli system getDBHomes [root@vmem-6gl0h1 ~]# dbaascli system getDBHomes DBAAS CLI version 23.4.1.0.0 Executing command system getDBHomes Job id: 15a9c693-d217-47b4-98f9-68eadd3b2766 Session log: /var/opt/oracle/log/system/getDBHomes/dbaastools_2023- 11-20_01-51-42-PM_371920.log { "OraHome1" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "homeName" : "OraHome1", "version" : "19.20.0.0.0", "createTime" : 1697764298000, "updateTime" : 1697765609000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.20.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.20.0.0.0" "OraHome2" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_2", "homeName" : "OraHome2", "version" : "19.13.0.0.0", "createTime" : 1697776609000, "updateTime" : 1697777833000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.13.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.13.0.0.0" } }, "messages" : [ ] }, } }, "messages" : [ ] }, dbaascli system getDBHomes OraHome3" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_3", "homeName" : "OraHome3", "version" : "19.14.0.0.0", "createTime" : 1697786065000, "updateTime" : 1697786065000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.14.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.14.0.0.0" } }, "messages" : [ ] }, "OraHome4" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "homeName" : "OraHome4", "version" : "19.20.0.0.0", "createTime" : 1699923823000, "updateTime" : 1700215854000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.20.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.20.0.0.0" } }, "messages" : [ ] }, "OraHome5" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_5", "homeName" : "OraHome5", "version" : "19.21.0.0.0", "createTime" : 1700131168000, "updateTime" : 1700182340000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.21.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.21.0.0.0" } }, "messages" : [ ] }, "OraHome6" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_6", "homeName" : "OraHome6", "version" : "19.21.0.0.0", "createTime" : 1700455140000, "updateTime" : 1700455140000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.21.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.21.0.0.0" } }, "messages" : [ ] } } dbaascli execution completed 作成された Database Home dbaascli dbhome getDetails [root@vmem-6gl0h1 ~]# dbaascli dbHome getDetails --help DBAAS CLI version 23.4.1.0.0 Executing command dbHome getDetails --help dbHome getDetails - display details of specified Oracle home. Usage: dbaascli dbHome getDetails { --oracleHomeName | --oracleHome } Where: --oracleHomeName | --oracleHome --oracleHomeName - Oracle home name. --oracleHome - Oracle home path. [root@vmem-6gl0h1 ~]# Database Home dbaascli dbhome getDetails [root@vmem-6gl0h1 ~]# dbaascli dbHome getDetails --oracleHomeName oraHome6 DBAAS CLI version 23.4.1.0.0 Executing command dbHome getDetails --oracleHomeName oraHome6 Job id: 034fe3fe-3639-4ef1-a7f5-788545bef811 Session log: /var/opt/oracle/log/dbHome/getDetails/dbaastools_2023-11-20_01-56-19-PM_49162.log { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_6", "homeName" : "OraHome6", "version" : "19.21.0.0.0", "createTime" : 1700455140000, "updateTime" : 1700455140000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.21.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.21.0.0.0" } }, "messages" : [ ] } dbaascli execution completed [root@vmem-6gl0h1 ~]# Database Home dbaascli dbhome getDetails Database Home dbaascli dbhome getDatabases [root@vmem-6gl0h1 ~]# dbaascli dbhome getDatabases --help DBAAS CLI version 23.4.1.0.0 Executing command dbhome getDatabases --help dbHome getDatabases - display details of databases in specified Oracle home. Usage: dbaascli dbHome getDatabases { --oracleHomeName | --oracleHome } Where: --oracleHomeName | --oracleHome --oracleHomeName - Oracle home name. --oracleHome - Oracle home path. [root@vmem-6gl0h1 ~]# Database Home dbaascli dbhome create [root@vmem-6gl0h1 ~]# dbaascli dbhome create --version 19.12.0.0.0 DBAAS CLI version 23.4.1.0.0 Executing command dbhome create --version 19.12.0.0.0 Job id: 2bc77ced-42a6-4f35-8237-64e3f12f4966 Session log: /var/opt/oracle/log/dbHome/create/dbaastools_2023-11-20_06-30-14-PM_115485.log Loading PILOT... Session ID of the current execution is: 1124 Log file location: /var/opt/oracle/log/dbHome/create/pilot_2023-11-20_06-30-18-PM_116347 Running Plugin_initialization job Completed Plugin_initialization job Running OH_image_validate job Completed OH_image_validate job Running OH_image_download job Execution of OH_image_download failed [FATAL] [DBAAS-60143] Failed to download the image '19.12.0.0.0'. SUMMARY: - [DBAAS-60143] Failed to download the image '19.12.0.0.0'. *** Executing jobs which need to be run always... *** Running Post_OH_creation_lock_manager job Completed Post_OH_creation_lock_manager job Running Plugin_cleanup job Completed Plugin_cleanup job ******** PLUGIN EXECUTION FAILED ******** [root@vmem-6gl0h1 ~]# Database dbaascli database --help [root@taro-3nusm1 ~]# dbaascli database --help DBAAS CLI version 24.1.1.0.0 Executing command database --help database bounce - bounce a specific database. database changePassword - change the password for a given user in the database. database addInstance - allows user to add the database instance on the specified node. database deleteInstance - allows user to delete the database instance on the specified node. database convertToPDB - to convert given non-CDB database to PDB. database getDetails - display details about a specific database. database modifyParameters - modifies or resets initialization parameters for a given Oracle database. database move - move DB from one home to another home. database start - start a specific database. database status - checks status of a database. database stop - stop a specific database. database upgrade - performs the upgrade of an Oracle database. database upgradeTimeZone - to upgrade the database time zone version database create - create a new database. database duplicate - create a new database from active database. database delete - delete the given database. database runDatapatch - patches the database. database backup - performs database backup operations. database recover - performs database recovery. database getPDBs - display information of PDBs in specified database. database createTemplate - create a new template from the specified database. [root@taro-3nusm1 ~]# Database Create dbaascli database create --help [root@vmem-6gl0h1 ~]# dbaascli database create --help DBAAS CLI version 23.4.1.0.0 Executing command database create --help database create - create a new database. Usage: dbaascli database create --dbName { --oracleHome | --oracleHomeName } [--dbUniqueName ] [--dbSID ] [--createAsCDB ] [--pdbName ] [--pdbAdminUserName ] [--dbCharset ] [--dbNCharset ] [--dbLanguage ] [--dbTerritory ] [--sgaSizeInMB ] [--pgaSizeInMB ] [--datafileDestination ] [--fraDestination ] [--fraSizeInMB ] [--nodeList ] [--tdeConfigMethod { [--kmsKeyOCID [--kmsKeyVersionOCID ] [--pdbKMSKeyVersionOCID ]] | [--okvServer --okvAdminUserName [--okvServerRestPort ] [--okvWalletName ]] }] { [--resume [--sessionID ]] | [--revert [--sessionID ]] } [--executePrereqs] [--honorNodeNumberForInstance ] [--lockPDBAdminAccount ] [--dbcaTemplateFilePath ] [-- waitForCompletion ] [--templateFromObjectStorage --objectStorageLoginUser --objectStorageBucketName --templateName [--objectStorageUrl ]] Database Create dbaascli database create --help Where: --dbName - Oracle database name. --oracleHome | --oracleHomeName --oracleHome - specifies Oracle home location --oracleHomeName - specifies Oracle home name [--dbUniqueName - specifies database unique name] [--dbSID - specifies database SID] [--createAsCDB - specifies true/false to create database as CDB/Non-CDB] [--pdbName - specifies PDB name] [--pdbAdminUserName - specifies PDB admin user name] [--dbCharset - specifies database character set] [--dbNCharset - specifies database national character set] [--dbLanguage - specifies database language] [--dbTerritory - specifies database territory] [--sgaSizeInMB - specifies sga_target value in mega byte unit] [--pgaSizeInMB - specifies pga_aggregate_target value in mega byte unit] [--datafileDestination - specifies ASM disk group name to use for database datafiles] [--fraDestination - specifies ASM disk group name to use for database fast recovery area] [--fraSizeInMB - specifies fast recovery area size value in mega byte unit] [--nodeList - specifies comma separated node list for database] [--tdeConfigMethod - specifies TDE configuration method. Allowed values are FILE, KMS and OKV] [--kmsKeyOCID | --okvServer] [--kmsKeyOCID - specifies KMS key OCID to use for TDE. This is applicable only if KMS is selected for TDE] [--kmsKeyVersionOCID - OCI Vault key version OCID to be set. This is applicable only if OCI Vault is selected for TDE] [--pdbKMSKeyVersionOCID - OCI Vault key version OCID to be set for PDB. This is applicable only if OCI Vault is selected for TDE] [--okvServer - Specifies the Oracle Key Vault server. This is applicable only if OKV is selected for TDE] --okvAdminUserName - Specifies the Oracle Key Vault admin user name [--okvServerRestPort - Specifies the rest port number for Oracle Key Vault] [--okvWalletName - Specifies the Oracle Key Vault wallet name] Database Create dbaascli database create --help [--resume | --revert] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--revert - to rollback the previous operation] [--sessionID - to resume a specific session id.] [--executePrereqs - run the prerequisite checks and report the results. ] [--honorNodeNumberForInstance - specifies true or false to indicate instance name to be suffixed with cluster node numbers when database is created on subset of nodes. Default value is true] [--lockPDBAdminAccount - specifies true or false to lock the PDB admin user account. Default value is true] [--dbcaTemplateFilePath - specifies the absolute path of the dbca template name to create the database.] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [--templateFromObjectStorage - to create database from template present in object storage] --objectStorageLoginUser - object storage login user --objectStorageBucketName - object storage bucket name --templateName - specifies the template name [--objectStorageUrl - object storage URL] Oracle Database dbaascli database create --executePrereq [root@vmem-6gl0h1 ~]# dbaascli database create --dbname dbcli01 -- oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 --executePrereqs yes DBAAS CLI version 23.4.1.0.0 Executing command database create --dbname dbcli01 --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 --executePrereqs yes Job id: fc003e99-f921-4715-94b6-882534e50469 Session log: /var/opt/oracle/log/dbcli01/database/create/dbaastools_2023-11-20_06- 34-59-PM_154607.log Enter SYS_PASSWORD: Enter SYS_PASSWORD (reconfirmation): Enter TDE_PASSWORD: Enter TDE_PASSWORD (reconfirmation): Loading PILOT... Enter SYS_PASSWORD ******************** Enter SYS_PASSWORD (reconfirmation): ***************** Enter TDE_PASSWORD ********************* Enter TDE_PASSWORD (reconfirmation): ****************** Session ID of the current execution is: 1125 Log file location: /var/opt/oracle/log/dbcli01/database/create/pilot_2023-11-20_06-36- 41-PM_163619 Running Plugin_initialization job Completed Plugin_initialization job Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_6 ----------------- Running Default_value_initialization job Completed Default_value_initialization job ----------------- Running Validate_input_params job Completed Validate_input_params job ----------------- Running Validate_cpu_availability job Completed Validate_cpu_availability job ----------------- Running Validate_asm_availability job Completed Validate_asm_availability job Running Validate_disk_space_availability job Completed Validate_disk_space_availability job ----------------- Running validate_users_umask job Completed validate_users_umask job ----------------- Running Validate_huge_pages_availability job Completed Validate_huge_pages_availability job ----------------- Running Validate_hostname_domain job Completed Validate_hostname_domain job ----------------- Running Install_db_cloud_backup_module job Skipping. Job is detected as not applicable. ----------------- Oracle Database dbaascli database create --executePrereq Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job Running Register_ocids job Skipping. Job is detected as not applicable. Running Validate_backup_report job Skipping. Job is detected as not applicable. Acquiring write lock: create_db_cloud ----------------- Running Setup_acfs_volumes job Skipping. Job is detected as not applicable. ----------------- Running Setup_db_folders job Skipping. Job is detected as not applicable. ----------------- Running DB_creation job Skipping. Job is detected as not applicable. Releasing lock: create_db_cloud ----------------- Running Generate_db_metadata job Skipping. Job is detected as not applicable. ----------------- Running Create_db_from_backup job Skipping. Job is detected as not applicable. Completed Create_db_from_backup job Running Run_datapatch job Skipping. Job is detected as not applicable. ----------------- Running Create_users_tablespace job Skipping. Job is detected as not applicable. ----------------- Running Configure_pdb_service job Skipping. Job is detected as not applicable. ----------------- Running Set_pdb_admin_user_profile job Skipping. Job is detected as not applicable. ----------------- Running Lock_pdb_admin_user job Skipping. Job is detected as not applicable. ----------------- Running Configure_flashback job Skipping. Job is detected as not applicable. ----------------- Running Update_cloud_service_recommended_config_parameters job Skipping. Job is detected as not applicable. Running Load_db_details job Skipping. Job is detected as not applicable. Running Update_distributed_lock_timeout job Skipping. Job is detected as not applicable. Running Populate_creg job Skipping. Job is detected as not applicable. Running Configure_archiving job Skipping. Job is detected as not applicable. Oracle Database dbaascli database create --executePrereq Running Configure_huge_pages job Skipping. Job is detected as not applicable. Running Update_db_wallet job Skipping. Job is detected as not applicable. Running Set_credentials job Skipping. Job is detected as not applicable. Running Add_oratab_entry job Skipping. Job is detected as not applicable. Running Update_dba_directories job Skipping. Job is detected as not applicable. Running Configure_sqlnet_ora job Skipping. Job is detected as not applicable. Running Set_cluster_interconnects job Skipping. Job is detected as not applicable. Running Configure_tnsnames_ora job Skipping. Job is detected as not applicable. Running Create_db_secure_profile job Skipping. Job is detected as not applicable. Running Enable_fips job Skipping. Job is detected as not applicable. Running Set_utc_timezone job Skipping. Job is detected as not applicable. Running DTRS_DB_Configure_Job job Skipping. Job is detected as not applicable. Running Run_dst_post_installs job Skipping. Job is detected as not applicable. Running Restart_database job Skipping. Job is detected as not applicable. Running Enable_auditing job Skipping. Job is detected as not applicable. Running Create_db_login_environment_file job Skipping. Job is detected as not applicable. Running Apply_security_measures job Skipping. Job is detected as not applicable. Running Generate_dbsystem_details job Skipping. Job is detected as not applicable. Running Set_listener_init_params job Skipping. Job is detected as not applicable. ----------------- Running Cleanup job Skipping. Job is detected as not applicable. Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_6 dbaascli execution completed [root@vmem-6gl0h1 ~]# Oracle Database Oracle Database dbaascli database create [root@vmem-6gl0h1 ~]# dbaascli database create --dbname dbcli01 -- oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 DBAAS CLI version 23.4.1.0.0 Executing command database create --dbname dbcli01 --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 Job id: aa2c12d2-ac0b-4ccd-8ff9-53aba535c640 Session log: /var/opt/oracle/log/dbcli01/database/create/dbaastools_2023-11-20_06- 45-13-PM_220170.log Enter SYS_PASSWORD: Enter SYS_PASSWORD (reconfirmation): Enter TDE_PASSWORD: Enter TDE_PASSWORD (reconfirmation): Loading PILOT... Enter SYS_PASSWORD ******************** Enter SYS_PASSWORD (reconfirmation): ******************* Enter TDE_PASSWORD ****************** Enter TDE_PASSWORD (reconfirmation): ******************** Session ID of the current execution is: 1126 Log file location: /var/opt/oracle/log/dbcli01/database/create/pilot_2023-11-20_06-47- 12-PM_229558 Running Plugin_initialization job Completed Plugin_initialization job Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_6 ----------------- Running Default_value_initialization job Completed Default_value_initialization job ----------------- Running Validate_input_params job Completed Validate_input_params job ----------------- Running Validate_cpu_availability job Completed Validate_cpu_availability job Running Validate_asm_availability job Completed Validate_asm_availability job ----------------- Running Validate_disk_space_availability job Completed Validate_disk_space_availability job ----------------- Running validate_users_umask job Completed validate_users_umask job ----------------- Running Validate_huge_pages_availability job Completed Validate_huge_pages_availability job ----------------- Running Validate_hostname_domain job Completed Validate_hostname_domain job ----------------- Oracle Database dbaascli database create Running Install_db_cloud_backup_module job Skipping. Job is detected as not applicable. Running Load_db_details job Completed Load_db_details job Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job Running Populate_creg job Completed Populate_creg job Running Validate_backup_report job Skipping. Job is detected as not applicable. Acquiring write lock: create_db_cloud ----------------- Running Setup_acfs_volumes job Completed Setup_acfs_volumes job ----------------- Running Setup_db_folders job Completed Setup_db_folders job ----------------- Running DB_creation job Completed DB_creation job Releasing lock: create_db_cloud ----------------- Running Generate_db_metadata job Completed Generate_db_metadata job ----------------- Running Create_db_from_backup job Skipping. Job is detected as not applicable. Completed Create_db_from_backup job Running Register_ocids job Skipping. Job is detected as not applicable. ----------------- Running Run_datapatch job Skipping. Job is detected as not applicable. ----------------- Running Create_users_tablespace job Skipping. Job is detected as not applicable. ----------------- Running Configure_pdb_service job Skipping. Job is detected as not applicable. ----------------- Running Set_pdb_admin_user_profile job Skipping. Job is detected as not applicable. ----------------- Running Lock_pdb_admin_user job Skipping. Job is detected as not applicable. ----------------- Running Configure_flashback job Completed Configure_flashback job Running Load_db_details job Completed Load_db_details job Running Update_cloud_service_recommended_config_parameters job Completed Update_cloud_service_recommended_config_parameters job Oracle Database Oracle Database dbaascli database create Running Update_distributed_lock_timeout job Completed Update_distributed_lock_timeout job Running Configure_archiving job Completed Configure_archiving job Running Configure_huge_pages job Completed Configure_huge_pages job Running Set_credentials job Completed Set_credentials job Running Update_dba_directories job Completed Update_dba_directories job Running Set_cluster_interconnects job Completed Set_cluster_interconnects job Running Create_db_secure_profile job Completed Create_db_secure_profile job Running Set_utc_timezone job Completed Set_utc_timezone job Running Run_dst_post_installs job Completed Run_dst_post_installs job Running Enable_auditing job Completed Enable_auditing job ----------------- Running Apply_security_measures job Completed Apply_security_measures job ----------------- Running Set_listener_init_params job Completed Set_listener_init_params job Running Update_db_wallet job Completed Update_db_wallet job Running Add_oratab_entry job Completed Add_oratab_entry job Running Configure_sqlnet_ora job Completed Configure_sqlnet_ora job Running Configure_tnsnames_ora job Completed Configure_tnsnames_ora job Running Enable_fips job Completed Enable_fips job Running DTRS_DB_Configure_Job job Completed DTRS_DB_Configure_Job job Running Restart_database job Completed Restart_database job Running Create_db_login_environment_file job Completed Create_db_login_environment_file job Running Generate_dbsystem_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed Generate_dbsystem_details job ----------------- Running Cleanup job Completed Cleanup job Database Home dbaascli dbhome getDatabases [root@vmem-6gl0h1 ~]# dbaascli dbhome getDatabases --oracleHomeName oraHome1 DBAAS CLI version 23.4.1.0.0 Executing command dbhome getDatabases --oracleHomeName oraHome1 Job id: b25b9808-9a86-4eb8-b794-81dfec37870b Session log: /var/opt/oracle/log/dbHome/getDatabases/dbaastools_2023-11-20_07-35-05-PM_256165.log { "DB19" : { "dbSyncTime" : 1700475789484, "createTime" : 1697765022000, "updateTime" : 0, "dbName" : "DB19", "dbUniqueName" : "DB19_qq4_kix", "dbDomain" : "sub04210756190.exavcn.oraclevcn.com", "dbId" : 881928558, "cpuCount" : 4, "sgaTarget" : "3808MB", "pgaAggregateTarget" : "2500MB", "dbSize" : "55GB", "dbUsedSize" : "12GB", "totalFraSize" : "1024GB", "fraSizeUsed" : "24GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.20.0.0.0“, Database Home dbaascli dbhome getDatabases "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezoghgmh7a", "resourceOCID" : "ocid1.database.oc1.ap-osaka-1.anvwsljrssl65iqa5gxmj3ghhtbyetakgl6w3qke6xpiq2o22up42s4jrsmq", "resourceID" : "d2705e01-7891-4bf7-8e91-5f01988a5a64", "resourceType" : "CDB", "parentResourceID" : null }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "AZF3cdN/r08+v+h8h+xNzfoAAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "instanceName" : "DB191", "version" : "19.20.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "status" : "OPEN" }, Database Home dbaascli dbhome getDatabases "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "instanceName" : "DB192", "version" : "19.20.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "status" : "OPEN" } }, "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "3793508688", "cdbId" : "d2705e01-7891-4bf7-8e91-5f01988a5a64", "refreshablePDB" : false, "refreshMode" : null, "refreshIntervalInMinutes" : null, "cpuCount" : 4, "storageAllocated" : "UNLIMITED", "storageUsed" : "8544MB", "guid" : "081CDD8C63033C68E0639500000A7A09", "dbid" : "3793508688", "conId" : "3", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezoghgmh7a", "resourceOCID" : "ocid1.pluggabledatabase.oc1.ap-osaka-1.anvwsljrssl65iqar7ii5kmp2bxfwc3e7t2hjgnaou5u6ipgt4pre6ppgvaq", "resourceID" : "3793508688", "resourceType" : "PDB", "parentResourceID" : "d2705e01-7891-4bf7-8e91-5f01988a5a64" }, Database Home dbaascli dbhome getDatabases "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "AUWRZPDD2U/Iv3TnUlZjty8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "pdbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "openMode" : "READ_WRITE", "restricted" : false }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "openMode" : "READ_WRITE", "restricted" : false } }, "pdbConnectStrings" : [ { "serviceName" : "DB19_PDB1.paas.oracle.com", "connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/DB19_PDB1.paas.oracle.com", "tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/DB19_PDB1.paas.oracle.com" ] } ], "pdbSize" : "8GB", "pdbUsedSize" : "1GB", "pdbSnapshotDetails" : null } }, "messages" : [ ] }, Database Home dbaascli dbhome getDatabases "DBFDSI" : { "dbSyncTime" : 1700475789354, "createTime" : 1697777238000, "updateTime" : 0, "dbName" : "DBFDSI", "dbUniqueName" : "DBFDSI_phh_kix", "dbDomain" : "sub04210756190.exavcn.oraclevcn.com", "dbId" : 3353687590, "cpuCount" : 4, "sgaTarget" : "3808MB", "pgaAggregateTarget" : "2500MB", "dbSize" : "55GB", "dbUsedSize" : "12GB", "totalFraSize" : "1191GB", "fraSizeUsed" : "20GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : true, "patchVersion" : "19.20.0.0.0", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezoghgmh7a", Database Home dbaascli dbhome getDatabases "resourceOCID" : "ocid1.database.oc1.ap-osaka-1.anvwsljrssl65iqa2tavuxqsonfs432lnl5dpycn7o4y3v5uxfddwjjvlg3q", "resourceID" : "2b67088f-a84c-4b70-a2bc-9650d128fa97", "resourceType" : "CDB", "parentResourceID" : null }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "ASMotBwDek/vvwNK44p4rhoAAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "instanceName" : "DBFDSI1", "version" : "19.20.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "status" : "OPEN" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "instanceName" : "DBFDSI2", "version" : "19.20.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "status" : "OPEN" } }, Database Home dbaascli dbhome getDatabases "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "3217098636", "cdbId" : "2b67088f-a84c-4b70-a2bc-9650d128fa97", "refreshablePDB" : false, "refreshMode" : null, "refreshIntervalInMinutes" : null, "cpuCount" : 4, "storageAllocated" : "UNLIMITED", "storageUsed" : "8544MB", "guid" : "081FB65CDB86887CE0639500000ABAD4", "dbid" : "3217098636", "conId" : "3", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezoghgmh7a", "resourceOCID" : "ocid1.pluggabledatabase.oc1.ap-osaka-1.anvwsljrssl65iqay24yxzmv7szvwdkutzl2yfvv37pss4iagd5vhrebl3mq", "resourceID" : "3217098636", "resourceType" : "PDB", "parentResourceID" : "2b67088f-a84c-4b70-a2bc-9650d128fa97" }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "ARbww5QrCU8bv8x9UaBu1H0AAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, Database Home dbaascli dbhome getDatabases "pdbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "openMode" : "READ_WRITE", "restricted" : false }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "openMode" : "READ_WRITE", "restricted" : false } }, "pdbConnectStrings" : [ { "serviceName" : "DBFDSI_PDB1.paas.oracle.com", "connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/DBFDSI_PDB1.paas.oracle.com", "tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/DBFDSI_PDB1.paas.oracle.com" ] }, { "serviceName" : "PDB1_dg", "connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/PDB1_dg", "tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/PDB1_dg" ] }, { "serviceName" : "PDB1_dg_ro", "connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/PDB1_dg_ro", "tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/PDB1_dg_ro" ] } ], "pdbSize" : "8GB", "pdbUsedSize" : "1GB", "pdbSnapshotDetails" : null } }, "messages" : [ ] } } dbaascli execution completed Database Home dbaascli dbhome getDatabases nonCDB Oracle Database dbaascli database create --createAsCDB false [root@orcl0322-61tsm1 ~]# dbaascli database create --dbname dbcli02 - -oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 --createAsCDB false DBAAS CLI version 22.1.1.1.0 Executing command database create --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 --createAsCDB false Job id: 9a721027-0385-406f-bbc5-16f0fca121cf Enter SYS_PASSWORD: Enter SYS_PASSWORD (reconfirmation): Enter TDE_PASSWORD: Enter TDE_PASSWORD (reconfirmation): Loading PILOT... Enter SYS_PASSWORD *********** Enter SYS_PASSWORD (reconfirmation): ********** Enter TDE_PASSWORD ********** Enter TDE_PASSWORD (reconfirmation): *********** Session ID of the current execution is: 37 Log file location: /var/opt/oracle/log/dbcli02/database/create/pilot_2022-03-25_05-50- 00-AM ----------------- Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Default_value_initialization job Completed Default_value_initialization job ----------------- Running Validate_input_params job Completed Validate_input_params job ----------------- Running Validate_cpu_availability job Completed Validate_cpu_availability job ----------------- Running Validate_asm_availability job Completed Validate_asm_availability job Running Validate_disk_space_availability job Completed Validate_disk_space_availability job ----------------- Running validate_users_umask job Completed validate_users_umask job ----------------- Running Validate_huge_pages_availability job Completed Validate_huge_pages_availability job ----------------- Running Validate_hostname_domain job Completed Validate_hostname_domain job ----------------- Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job ----------------- Running DB_creation_acquire_lock job Completed DB_creation_acquire_lock job nonCDB の Oracle Database dbaascli database create --createAsCDB false ----------------- Running Setup_acfs_volumes job Completed Setup_acfs_volumes job ----------------- Running Setup_db_folders job Completed Setup_db_folders job ----------------- Running Check_and_configure_huge_pages job Completed Check_and_configure_huge_pages job ----------------- Running DB_creation job Completed DB_creation job ----------------- Running DB_creation_release_lock job Completed DB_creation_release_lock job ----------------- Running Load_db_details job Completed Load_db_details job ----------------- Running Populate_creg job Completed Populate_creg job ----------------- Running Register_ocids job Skipping. Job is detected as not applicable. ----------------- Running Create_users_tablespace job Skipping. Job is detected as not applicable. ----------------- Running Configure_pdb_service job Skipping. Job is detected as not applicable. ----------------- Running Set_pdb_admin_user_profile job Skipping. Job is detected as not applicable. ----------------- Running Lock_pdb_admin_user job Skipping. Job is detected as not applicable. ----------------- Running Configure_flashback job Completed Configure_flashback job ----------------- Running Configure_undo_retention job Completed Configure_undo_retention job ----------------- Running Update_cloud_service_recommended_config_parameters job Completed Update_cloud_service_recommended_config_parameters job ----------------- Running Update_distributed_lock_timeout job Completed Update_distributed_lock_timeout job ----------------- Running Configure_archiving job Completed Configure_archiving job ----------------- Running Configure_huge_pages job Completed Configure_huge_pages job ----------------- Running Set_credentials job Completed Set_credentials job <> 65 varchar2 nonCDB の Oracle Databaseを作成する dbaascli database create --createAsCDB false <続き> ----------------- Running Update_dba_directories job Completed Update_dba_directories job ----------------- Running Set_cluster_interconnects job Completed Set_cluster_interconnects job ----------------- Running Create_db_secure_profile job Completed Create_db_secure_profile job ----------------- Running Set_utc_timezone job Completed Set_utc_timezone job ----------------- Running Run_dst_post_installs job Completed Run_dst_post_installs job ----------------- Running Enable_auditing job Completed Enable_auditing job ----------------- Running Apply_security_measures job Completed Apply_security_measures job ----------------- Running Set_listener_init_params job Completed Set_listener_init_params job ----------------- Running Update_db_wallet job Completed Update_db_wallet job Running Add_oratab_entry job Completed Add_oratab_entry job ----------------- Running Configure_sqlnet_ora job Completed Configure_sqlnet_ora job ----------------- Running Configure_tnsnames_ora job Completed Configure_tnsnames_ora job ----------------- Running Enable_fips job Completed Enable_fips job ----------------- Running DB_backup_assistant job Completed DB_backup_assistant job ----------------- Running Restart_database job Completed Restart_database job ----------------- Running Create_db_login_environment_file job Completed Create_db_login_environment_file job ----------------- Running Generate_dbsystem_details job Completed Generate_dbsystem_details job ----------------- Running Cleanup job Completed Cleanup job dbaascli execution completed nonCDB の Oracle Database SQL> show con_name non CDB が作成されたことを確認 [oracle@orcl0322-61tsm1 ~]$ . dbcli02.env [oracle@orcl0322-61tsm1 ~]$ env|grep ORACLE ORACLE_UNQNAME=dbcli02 ORACLE_SID=dbcli021 ORACLE_BASE=/u02/app/oracle ORACLE_HOSTNAME=orcl0322-61tsm1.sub07160524340.testvcn.oraclevcn.com ORACLE_HOME=/u02/app/oracle/product/19.0.0.0/dbhome_6 [oracle@orcl0322-61tsm1 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 25 06:31:07 2022 Version 19.11.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Connected to: Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.11.0.0.0 SQL> show con_name CON_NAME dbcli02 SQL> nonCDB のOCI Database convertToPDB コマンド⼀覧 dbaascli database convertToPDB --help [root@orcl0322-61tsm1 ~]# dbaascli database convertToPDB --help DBAAS CLI version 22.1.1.1.0 Executing command database convertToPDB --help database convertToPDB - to convert given non-CDB database to PDB. Usage: dbaascli database convertToPDB --dbname [--resume [--sessionID ]] [--executePrereqs] { [--copyDatafiles] | [--backupPrepared] } [--cdbName ] [--targetPDBName ] [--waitForCompletion ] PDB.] Where: --dbname - Oracle database name. [--resume - To resume the previous execution] [--sessionID - to resume a specific session id.] [--executePrereqs - to execute the Pre-Conversion checks only. ] [--copyDatafiles | --backupPrepared] [--copyDatafiles - to create a new copy of the datafiles instead of using the ones from the source database.] [--backupPrepared - flag to acknowledge that a proper database backup is in place for the non CDB prior to performing the conversion to [--cdbName - to specify the name of the target CDB in which the PDB will be created. If the CDB does not exist, then it will be created in the same Oracle home as the source non CDB. ] [--targetPDBName - to specify the name of the PDB that will be created as part of the operation. ] [--waitForCompletion - Specify false to run the operation in background. Valid values : true|false.] nonCDB CDB dbaascli database convertToPDB --precheck [root@orcl0322-61tsm1 ~]# dbaascli database convertToPDB --dbname dbcli02 --precheck DBAAS CLI version 22.1.1.1.0 Executing command database convertToPDB --precheck Job id: 7f09a238-51de-47db-a960-31c8cb834e45 Loading PILOT... Session ID of the current execution is: 40 Log file location: /var/opt/oracle/log/dbcli02/database/convertToPDB/pilot_2022-03- 25_06-32-46-AM ----------------- Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Validate_source_db_open_state job Completed Validate_source_db_open_state job ----------------- Running Validate_source_db_database_type job Completed Validate_source_db_database_type job ----------------- Running Validate_source_db_version job Completed Validate_source_db_version job ----------------- Running Validate_rdbms_conversion_packages job Completed Validate_rdbms_conversion_packages job ----------------- Running Validate_source_db_database_role job Completed Validate_source_db_database_role job ----------------- Running Validate_source_db_tde_configuration job Completed Validate_source_db_tde_configuration job ----------------- Running Validate_source_db_credentials job Completed Validate_source_db_credentials job ----------------- Running Validate_target_pdb_name job Completed Validate_target_pdb_name job ----------------- Running Validate_dataguard_configuration job Completed Validate_dataguard_configuration job ----------------- Running Validate_backup_confirmation job Execution of Validate_backup_confirmation failed [FATAL] [DBAAS-70324] The following non container database cannot be converted to pluggable database without RMAN backup confirmation: dbcli02. CAUSE: The requested operation will modify the original data files. Therefore it is required to confirm that there is a RMAN database backup in place. ACTION: If the required database RMAN based backup is in place, retry the operation with the flag --backupPrepared to confirm. Or specify the --copyDatafiles flag to convert the database using a copy of the original data files. ↑RMANバ ******** PLUGIN EXECUTION FAILED ******** Executing jobs which need to be run always... Completed execution. nonCDB を CDB (--backupPrepared付) dbaascli database convertToPDB --precheck [root@orcl0322-61tsm1 ~]# dbaascli database convertToPDB --dbname dbcli02 --backupPrepared --precheck DBAAS CLI version 22.1.1.1.0 Executing command database convertToPDB --backupPrepared --precheck Job id: dea58be4-24e3-4988-8d3b-b2cbddc8d82d Loading PILOT... Session ID of the current execution is: 42 Log file location: /var/opt/oracle/log/dbcli02/database/convertToPDB/pilot_2022-03- 25_06-59-18-AM ----------------- Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Validate_source_db_open_state job Completed Validate_source_db_open_state job ----------------- Running Validate_source_db_database_type job Completed Validate_source_db_database_type job Running Validate_source_db_tde_configuration job Completed Validate_source_db_tde_configuration job ----------------- Running Validate_source_db_credentials job Completed Validate_source_db_credentials job ----------------- Running Validate_target_pdb_name job Completed Validate_target_pdb_name job ----------------- Running Validate_dataguard_configuration job Completed Validate_dataguard_configuration job ----------------- Running Validate_backup_confirmation job Completed Validate_backup_confirmation job ----------------- Running Validate_new_cdb_creation job Completed Validate_new_cdb_creation job dbaascli execution completed Running Validate_source_db_version job Completed Validate_source_db_version job Running Validate_rdbms_conversion_packages job Completed Validate_rdbms_conversion_packages job Running Validate_source_db_database_role job Completed Validate_source_db_database_role job nonCDB の Oracle Database dbaascli database convertToPDB [root@orcl0322-61tsm1 ~]# dbaascli database convertToPDB --dbname dbcli02 --backupPrepared DBAAS CLI version 22.1.1.1.0 Executing command database convertToPDB --backupPrepared Job id: 003bbec9-3f00-4db8-b593-65298fa75d0a Loading PILOT... Session ID of the current execution is: 44 Log file location: /var/opt/oracle/log/dbcli02/database/convertToPDB/pilot_2022-03- 25_07-10-35-AM ----------------- Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Validate_source_db_open_state job Completed Validate_source_db_open_state job ----------------- Running Validate_source_db_database_type job Completed Validate_source_db_database_type job ----------------- Running Validate_source_db_version job Completed Validate_source_db_version job ----------------- Running Validate_rdbms_conversion_packages job Completed Validate_rdbms_conversion_packages job ----------------- Running Validate_source_db_database_role job Completed Validate_source_db_database_role job ----------------- Running Validate_source_db_tde_configuration job Completed Validate_source_db_tde_configuration job ----------------- Running Validate_source_db_credentials job Completed Validate_source_db_credentials job ----------------- Running Validate_target_pdb_name job Completed Validate_target_pdb_name job ----------------- Running Validate_dataguard_configuration job Completed Validate_dataguard_configuration job ----------------- Running Validate_backup_confirmation job Completed Validate_backup_confirmation job ----------------- Running Validate_new_cdb_creation job Completed Validate_new_cdb_creation job ----------------- Running Acquire_source_db_lock job Completed Acquire_source_db_lock job ----------------- Running Drop_dbaas_profile job Completed Drop_dbaas_profile job ----------------- Running Create_new_cdb job Completed Create_new_cdb job ----------------- nonCDB の Oracle Database dbaascli database convertToPDB Running Export_source_db_tde_keys job Completed Export_source_db_tde_keys job ----------------- Running Import_tde_keys_into_target_cdb job Completed Import_tde_keys_into_target_cdb job ----------------- Running Acquire_target_cdb_lock job Completed Acquire_target_cdb_lock job ----------------- Running Purge_source_db_recycle_bin job Completed Purge_source_db_recycle_bin job ----------------- Running Start_source_db_in_read_only job Completed Start_source_db_in_read_only job ----------------- Running Generate_source_db_metadata_file job Completed Generate_source_db_metadata_file job ----------------- Running Verify_source_db_plug_compatibility job Completed Verify_source_db_plug_compatibility job ----------------- Running Shutdown_source_db job Completed Shutdown_source_db job ----------------- Running Create_new_pdb job Completed Create_new_pdb job ----------------- Running Execute_source_db_conversion_script job Completed Execute_source_db_conversion_script job ----------------- Running Open_pdb job Completed Open_pdb job ----------------- Running Verify_pdb_plug_in_violations job Completed Verify_pdb_plug_in_violations job ----------------- Running Import_tde_keys_into_new_pdb job Completed Import_tde_keys_into_new_pdb job ----------------- Running Bounce_pdb job Completed Bounce_pdb job ----------------- Running Activate_tde_configuration_in_pdb job Completed Activate_tde_configuration_in_pdb job ----------------- Running Verify_pdb_violations_post_tde_activation job Completed Verify_pdb_violations_post_tde_activation job ----------------- Running Bounce_pdb_post_tde_activation job Completed Bounce_pdb_post_tde_activation job ----------------- Running Release_target_cdb_lock job Completed Release_target_cdb_lock job ----------------- <> nonCDB の Oracle Database を CDB dbaascli database convertToPDB Running Release_source_db_lock job Completed Release_source_db_lock job Running Configure_pdb_open_state job Completed Configure_pdb_open_state job Running Configure_pdb_service job Completed Configure_pdb_service job Running Configure_tnsnames_for_pdb job Completed Configure_tnsnames_for_pdb job Running Update_cloud_registry_for_pdb job Completed Update_cloud_registry_for_pdb job Running Generate_dbsystem_details job Completed Generate_dbsystem_details job dbaascli execution completed CDB CDB Database dbaascli database create ----executePrereqs yes [root@orakawa-vgfvk1 ~]# dbaascli database create --dbname dbcli01 -- oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --dbSID dbclisid --dbNCharset UTF8 --dbTerritory JAPAN --dbLanguage JAPANESE -- dbUniqueName dbcli01uniq --dbCharset JA16SJISTILDE --sgaSizeInMB 2000 --pdbName dbcli01pdb01 --pgaSizeInMB 2000 --executePrereqs yes DBAAS CLI version 22.1.1.1.0 Executing command database create --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --dbSID dbclisid -- dbNCharset UTF8 --dbTerritory JAPAN --dbLanguage JAPANESE -- dbUniqueName dbcli01uniq --dbCharset JA16SJISTILDE --sgaSizeInMB 2000 --pdbName dbcli01pdb01 --pgaSizeInMB 2000 --executePrereqs yes Job id: 21ee5ded-be08-4668-87dc-8285d048f9e6 Enter SYS_PASSWORD: Enter SYS_PASSWORD (reconfirmation): Enter TDE_PASSWORD: Enter TDE_PASSWORD (reconfirmation): Loading PILOT... Enter SYS_PASSWORD ************* Enter SYS_PASSWORD (reconfirmation): ************* Enter TDE_PASSWORD ********** Enter TDE_PASSWORD (reconfirmation): *********** Session ID of the current execution is: 6 Log file location: /var/opt/oracle/log/dbcli01/database/create/pilot_2022-03-28_09-04- 11-AM ----------------- Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Default_value_initialization job Completed Default_value_initialization job ----------------- Running Validate_input_params job Completed Validate_input_params job Running Validate_cpu_availability job Completed Validate_cpu_availability job ----------------- Running Validate_asm_availability job Completed Validate_asm_availability job Running Validate_disk_space_availability job Completed Validate_disk_space_availability job ----------------- Running validate_users_umask job Completed validate_users_umask job ----------------- Running Validate_huge_pages_availability job Completed Validate_huge_pages_availability job ----------------- <> Database dbaascli database create --パラメータ --executePrereqs yes <続き> Running Validate_hostname_domain job Completed Validate_hostname_domain job ----------------- Running Register_ocids job Skipping. Job is detected as not applicable. Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job Running Create_users_tablespace job Skipping. Job is detected as not applicable. Running DB_creation_acquire_lock job Skipping. Job is detected as not applicable. Running Configure_pdb_service job Skipping. Job is detected as not applicable. Running Setup_acfs_volumes job Skipping. Job is detected as not applicable. Running Set_pdb_admin_user_profile job Skipping. Job is detected as not applicable. Running Setup_db_folders job Skipping. Job is detected as not applicable. Running Lock_pdb_admin_user job Skipping. Job is detected as not applicable. Running Check_and_configure_huge_pages job Skipping. Job is detected as not applicable. Running Configure_flashback job Skipping. Job is detected as not applicable. Running DB_creation job Skipping. Job is detected as not applicable. Running Configure_undo_retention job Skipping. Job is detected as not applicable. Running DB_creation_release_lock job Skipping. Job is detected as not applicable. Running Update_cloud_service_recommended_config_parameters job Skipping. Job is detected as not applicable. Running Load_db_details job Skipping. Job is detected as not applicable. Running Update_distributed_lock_timeout job Skipping. Job is detected as not applicable. Running Populate_creg job Skipping. Job is detected as not applicable. Running Configure_archiving job Skipping. Job is detected as not applicable. <> 78 varchar2 Database dbaascli database create -- --executePrereqs yes ----------------- Running Configure_huge_pages job Skipping. Job is detected as not applicable. ----------------- Running Set_credentials job Skipping. Job is detected as not applicable. ----------------- Running Update_dba_directories job Skipping. Job is detected as not applicable. ----------------- Running Set_cluster_interconnects job Skipping. Job is detected as not applicable. ----------------- Running Create_db_secure_profile job Skipping. Job is detected as not applicable. ----------------- Running Set_utc_timezone job Skipping. Job is detected as not applicable. ----------------- Running Run_dst_post_installs job Skipping. Job is detected as not applicable. ----------------- Running Enable_auditing job Skipping. Job is detected as not applicable. ----------------- Running Apply_security_measures job Skipping. Job is detected as not applicable. ----------------- Running Set_listener_init_params job Skipping. Job is detected as not applicable. ----------------- Running Update_db_wallet job Skipping. Job is detected as not applicable. ----------------- Running Add_oratab_entry job Skipping. Job is detected as not applicable. ----------------- Running Configure_sqlnet_ora job Skipping. Job is detected as not applicable. ----------------- Running Configure_tnsnames_ora job Skipping. Job is detected as not applicable. ----------------- Running Enable_fips job Skipping. Job is detected as not applicable. ----------------- Running DB_backup_assistant job Skipping. Job is detected as not applicable. ----------------- Running Restart_database job Skipping. Job is detected as not applicable. ----------------- Running Create_db_login_environment_file job Skipping. Job is detected as not applicable. ----------------- Running Generate_dbsystem_details job Skipping. Job is detected as not applicable. 79 varchar2 Running Cleanup job Skipping. Job is detected as not applicable. dbaascli execution completed Database の作成（パラメーター指定） dbaascli database create --パラメーター [root@orakawa-vgfvk1 ~]# dbaascli database create --dbname dbcli01 -- oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --dbSID dbclisid --dbNCharset UTF8 --dbTerritory JAPAN --dbLanguage JAPANESE -- dbUniqueName dbcli01uniq --dbCharset JA16SJISTILDE --sgaSizeInMB 2000 --pdbName dbcli01pdb01 --pgaSizeInMB 2000 DBAAS CLI version 22.1.1.1.0 Executing command database create --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --dbSID dbclisid -- dbNCharset UTF8 --dbTerritory JAPAN --dbLanguage JAPANESE -- dbUniqueName dbcli01uniq --dbCharset JA16SJISTILDE --sgaSizeInMB 2000 --pdbName dbcli01pdb01 --pgaSizeInMB 2000 Job id: dd17a9d8-5422-44a0-a963-910d30f37e93 Enter SYS_PASSWORD: Enter SYS_PASSWORD (reconfirmation): Enter TDE_PASSWORD: Enter TDE_PASSWORD (reconfirmation): Loading PILOT... Enter SYS_PASSWORD ************** Enter SYS_PASSWORD (reconfirmation): ************ Enter TDE_PASSWORD ************ Enter TDE_PASSWORD (reconfirmation): ************ Session ID of the current execution is: 7 Log file location: /var/opt/oracle/log/dbcli01/database/create/pilot_2022-03-28_09-11- 23-AM ----------------- Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Default_value_initialization job Completed Default_value_initialization job ----------------- Running Validate_input_params job Completed Validate_input_params job Running Validate_cpu_availability job Completed Validate_cpu_availability job ----------------- Running Validate_asm_availability job Completed Validate_asm_availability job Running Validate_disk_space_availability job Completed Validate_disk_space_availability job ----------------- Running validate_users_umask job Completed validate_users_umask job ----------------- Running Validate_huge_pages_availability job Completed Validate_huge_pages_availability job ----------------- Running Validate_hostname_domain job Completed Validate_hostname_domain job Database dbaascli database create --パラメーター <続き> Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job ----------------- Running DB_creation_acquire_lock job Completed DB_creation_acquire_lock job ----------------- Running Setup_acfs_volumes job Completed Setup_acfs_volumes job ----------------- Running Setup_db_folders job Completed Setup_db_folders job ----------------- Running Check_and_configure_huge_pages job Completed Check_and_configure_huge_pages job ----------------- Running DB_creation job Completed DB_creation job ----------------- Running DB_creation_release_lock job Completed DB_creation_release_lock job ----------------- Running Load_db_details job Completed Load_db_details job ----------------- Running Populate_creg job Completed Populate_creg job ----------------- Running Register_ocids job Skipping. Job is detected as not applicable. ----------------- Running Update_dba_directories job Completed Update_dba_directories job ----------------- Running Set_cluster_interconnects job Completed Set_cluster_interconnects job ----------------- Running Create_db_secure_profile job Completed Create_db_secure_profile job ----------------- Running Set_utc_timezone job Completed Set_utc_timezone job ----------------- Running Run_dst_post_installs job Completed Run_dst_post_installs job ----------------- Running Enable_auditing job Completed Enable_auditing job ----------------- Running Apply_security_measures job Completed Apply_security_measures job ----------------- Running Set_listener_init_params job Completed Set_listener_init_params job ----------------- Running Update_db_wallet job Completed Update_db_wallet job ----------------- Running Add_oratab_entry job Completed Add_oratab_entry job ----------------- <> 81 varchar2 Database の作成（パラメーター指定） dbaascli database create --パラメーター <続き> Running Configure_sqlnet_ora job Completed Configure_sqlnet_ora job Running Configure_tnsnames_ora job Completed Configure_tnsnames_ora job Running Enable_fips job Completed Enable_fips job Running DB_backup_assistant job Completed DB_backup_assistant job Running Restart_database job Completed Restart_database job Running Create_db_login_environment_file job Completed Create_db_login_environment_file job Running Generate_dbsystem_details job Completed Generate_dbsystem_details job Running Cleanup job Completed Cleanup job dbaascli execution completed Database dbca [root@ecc2c1n1 ~]# less /var/opt/oracle/log/dbcli01/database/create/pilot_2022-03-28_09-11-23-AM INFO: [2022-03-28 09:11:44.459 JST][pool-176-thread-1][DefaultCommandExecutor$2.call:284] Command constructed for node (localnode):/usr/bin/su oracle -c 'export LC_ALL=en_US.UTF-8;export TNS_ADMIN=/u02/app/oracle/product/19.0.0.0/dbhome_1/network/admin/dbcli01;export ORACLE_HOME=/u02/app/oracle/product/19.0.0.0/dbhome_1;/var/opt/oracle/dbaastools/dbaasca/bin/dbca -silent -oui_internal -createDatabase - databaseConfigType RAC -templateName /u02/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/exa_seed.dbc -datafileJarLocation /u02/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/exa_seed.dfb -pdbSeedMetadataFile /u02/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/exa_seed_pdbseed.xml -pdbSeedBackUpfile /u02/app/oracle/product/19.0.0.0/dbhome_1/assistants/dbca/templates/exa_seed_pdbseed.dfb -gdbName dbcli01.sub03230643360.orakawavcn.oraclevcn.com -sid dbclisid -createAsContainerDatabase true -numberOfPdbs 1 -pdbName dbcli01pdb01 -pdbAdminUserName admin -honorNodeNumberForInstance - storageType ASM -datafileDestination +DATAC1 -recoveryAreaDestination +RECOC1 -recoveryAreaSize 307200 -redoLogFileDestination +DATAC1 - numberOfRedoLogsPerInstance 4 -redoLogFileSize 4000 -useOMF true -enableArchive true -tempFileProperties 1024MB:16GB:512GB -pdbTempFileProperties 1024MB:16GB:UNLIMITED -pdbTablespaceProperties USERS:1024MB:16GB:UNLIMITED -useBigFileForTablespace true -adminManaged -nodelist orakawa- vgfvk1,orakawa-vgfvk2 -characterSet JA16SJISTILDE -forceInternalAlterCharacterSet -nationalCharacterSet UTF8 -configureTDE true -tdeWalletRoot /var/opt/oracle/dbaas_acfs/dbcli01/wallet_root -encryptTablespaces ALL -initParams '"'"'nls_territory=JAPAN,db_create_online_log_dest_1=+DATAC1,os_authent_prefix="",db_name=dbcli01,pga_aggregate_target=2000m,nls_language=JAPANESE ,sga_target=2000m,control_management_pack_access=DIAGNOSTIC+TUNING,db_domain=sub03230643360.orakawavcn.oraclevcn.com,enable_ddl_logging=TRUE,inmem ory_size=400m,db_unique_name=dbcli01uniq'"'"' -skipPasswordComplexityCheck false -checkOnly -J-Dapplication.exceptions.severity=DBT- 06012:WARNING,DBT-06604:WARNING -J-Doracle.assistants.dbca.useStandardLogLocation=true -jreLoc /usr/java/jdk1.8.0_311-amd64/jre' Database uniquname, SID, NLS [oracle@orakawa-vgfvk1 ~]$ . dbcli01.env [oracle@orakawa-vgfvk1 ~]$ env | grep ORA ORACLE_UNQNAME=dbcli01uniq ORACLE_SID=dbclisid1 ORACLE_BASE=/u02/app/oracle ORACLE_HOSTNAME=orakawa-vgfvk1.sub03230643360.orakawavcn.oraclevcn.com ORACLE_HOME=/u02/app/oracle/product/19.0.0.0/dbhome_1 [oracle@orakawa-vgfvk1 ~]$ export NLS_LANG=Japanese_Japan.AL32UTF8 [oracle@orakawa-vgfvk1 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on 月 3月 28 09:52:55 2022 Version 19.11.0.0.0 Copyright (c) 1982, 2020, Oracle. All rights reserved. Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.11.0.0.0 SQL> SELECT PARAMETER, VALUE 2 FROM NLS_DATABASE_PARAMETERS 3 WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET'); PARAMETER VALUE NLS_NCHAR_CHARACTERSET UTF8 NLS_CHARACTERSET JA16SJISTILDE Database SQL> select * from v$nls_parameters; PARAMETER VALUE CON_ID NLS_LANGUAGE JAPANESE 1 NLS_TERRITORY JAPAN 1 NLS_CURRENCY ¥ 1 NLS_ISO_CURRENCY JAPAN 1 NLS_NUMERIC_CHARACTERS ., 1 NLS_CALENDAR GREGORIAN 1 NLS_DATE_FORMAT RR-MM-DD 1 NLS_DATE_LANGUAGE JAPANESE 1 NLS_CHARACTERSET JA16SJISTILDE 1 NLS_SORT BINARY 1 NLS_TIME_FORMAT HH24:MI:SSXFF 1 NLS_TIMESTAMP_FORMAT RR-MM-DD HH24:MI:SSXFF 1 NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR 1 NLS_TIMESTAMP_TZ_FORMAT RR-MM-DD HH24:MI:SSXFF TZR 1 NLS_DUAL_CURRENCY ¥ 1 NLS_NCHAR_CHARACTERSET UTF8 1 NLS_COMP BINARY 1 NLS_LENGTH_SEMANTICS BYTE 1 NLS_NCHAR_CONV_EXCP FALSE 1 19行が選択されました。 Database の作成（パラメーター指定） PDB作成、 PGA SGA SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY NO 3 DBCLI01PDB01 READ WRITE NO [root@orakawa-vgfvk1 ~]# dbaascli database list DBAAS CLI version 22.1.1.1.0 Executing command database list Retrieving dbs.. Database List 1.DB Name=dbcli01 CPU=4 PGA=2 GB SGA=2 GB DATA=0 GB FRA=0 GB Nodelist=orakawa-vgfvk1,orakawa-vgfvk2 Cluster Information Total CPU per Node=4 Total Memory per Node=1367 GB Total Nodes=orakawa-vgfvk1,orakawa-vgfvk2 86 varchar2 Database の作成（パラメーター指定） ※dbTerritory, dbLanguageが AMERICAになっている… [root@orakawa-vgfvk1 ~]# dbaascli database getDetails --dbname dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command database getDetails Job id: e3d753c9-3f66-44f7-b3e5-6cb6d92474bc { "id" : "79c3169c-f7e8-43b0-95db-ae884a85de37", "dbSyncTime" : 0, "createTime" : 1648393200000, "updateTime" : 0, "dbName" : "dbcli01", "dbUniqueName" : "dbcli01uniq", "dbDomain" : "sub03230643360.orakawavcn.oraclevcn.com", "dbId" : 3324078197, "cpuCount" : 4, "sgaTarget" : "2000MB", "pgaAggregateTarget" : "2000MB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.11.0.0.0", "resourceOCIDSettings" : null, "dbCharacterSet" : { "characterSet" : "JA16SJISTILDE", "nlsCharacterset" : "UTF8", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" "dbNodeLevelDetails" : { "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "instanceName" : "dbclisid1", "version" : "19.11.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "status" : "OPEN" }, "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "instanceName" : "dbclisid2", "version" : "19.11.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "status" : "OPEN" } }, "pdbs" : { "DBCLI01PDB01" : { "pdbName" : "DBCLI01PDB01", "pdbUID" : "3034439310", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB3D7503BCD57E96E0533500000A2869", "dbid" : "3034439310", "conId" : "3", "resourceOCIDSettings" : null, <> }, 87 varchar2 Database の作成（パラメーター指定） ※dbTerritory, dbLanguageが AMERICAになっている… <続き> "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_dbcli01pdb01.paas.oracle.com", "connectString" : "orakawa-vgfvk-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb01.paas.oracle.com" } ] } }, "messages" : [ ] } dbaascli execution completed [root@orakawa-vgfvk1 ~]# database dbaascli system getDatabases [root@wasabi-isfff1 ~]# dbaascli system getDatabases --help DBAAS CLI version 22.3.1.1.0 Executing command system getDatabases --help system getDatabases - list details of all the databases. Usage: dbaascli system getDatabases [--oracleHome ] Where: [--oracleHome - Oracle home path. ] [root@wasabi-isfff1 ~]# dbaascli system getDatabases [root@wasabi-isfff1 ~]# dbaascli system getDatabases DBAAS CLI version 22.3.1.1.0 Executing command system getDatabases Job id: 1f87b1dc-79bb-43fe-8f0e-e71485c13b0f { "DB1" : { "id" : "134663e7-60b8-41f9-bfb8-f438f32eb072", "dbSyncTime" : 1665558623416, "createTime" : 1664463600000, "updateTime" : 0, "dbName" : "DB1", "dbUniqueName" : "DB1_5jj_kix", "dbDomain" : "sub07160524340.testvcn.oraclevcn.com", "dbId" : 1710651431, "cpuCount" : 4, "sgaTarget" : "7600MB", "pgaAggregateTarget" : "5000MB", "dbSize" : "48GB", "dbUsedSize" : "7GB", "totalFraSize" : "28896GB", "fraSizeUsed" : "15GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.9.0.0.0", "resourceOCIDSettings" : null, "dbCharacterSet" : { "characterSet" : "AL32UTF8", 91 Co"pnylrsigChhta©ra2c0t2e4r,sOetra"cle: a"nAdL/o1r6iUtsTFa1ff6ili"a,tes, "dbTerritory" : "AMERICA", dbaascli system getDatabases [root@wasabi-isfff1 ~]# dbaascli system getDatabases --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_3 DBAAS CLI version 22.3.1.1.0 Executing command system getDatabases --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_3 Job id: 64a88d13-6ac5-4049-bd7d-1181a37293dc { "DB1" : { "id" : "134663e7-60b8-41f9-bfb8-f438f32eb072", "dbSyncTime" : 1665634730252, "createTime" : 1664463600000, "updateTime" : 0, "dbName" : "DB1", "dbUniqueName" : "DB1_5jj_kix", "dbDomain" : "sub07160524340.testvcn.oraclevcn.com", "dbId" : 1710651431, "cpuCount" : 4, "sgaTarget" : "7600MB", "pgaAggregateTarget" : "5000MB", "dbSize" : "48GB", "dbUsedSize" : "7GB", "totalFraSize" : "28896GB", "fraSizeUsed" : "15GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.9.0.0.0", "resourceOCIDSettings" : null, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "wasabi-isfff1" : { "nodeName" : "wasabi-isfff1", "instanceName" : "DB11", "version" : "19.9.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_3", "status" : "OPEN" }, "wasabi-isfff2" : { "nodeName" : "wasabi-isfff2", "instanceName" : "DB12", "version" : "19.9.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_3", "status" : "OPEN" } }, 92 varchar2 データベースの⼀覧 dbaascli system getDatabases "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "3093976667", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "E9E467DD272E037BE0536900000AA583", "dbid" : "3093976667", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "wasabi-isfff2" : { "nodeName" : "wasabi-isfff2", "openMode" : "READ_WRITE" }, "wasabi-isfff1" : { "nodeName" : "wasabi-isfff1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "DB1_PDB1.paas.oracle.com", "connectString" : "wasabi-isfff- scan.sub07160524340.testvcn.oraclevcn.com:1521/DB1_PDB1.paas.oracle.c om" } ], "pdbSize" : "4GB", "pdbUsedSize" : "1GB" } }, } 2:02[4,]Oracle and/or its affiliates, データベースの詳細確認 dbaascli database getDetails --help [root@orakawa-vgfvk1 ~]# dbaascli database getDetails --help DBAAS CLI version 22.1.1.1.0 Executing command database getDetails --help database getDetails - display details about a specific database. Usage: dbaascli database getDetails --dbname Where: --dbname - Oracle database name. dbaascli database getDetails [root@orakawa-vgfvk1 ~]# dbaascli database getDetails --dbname dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command database getDetails Job id: be584b63-dfc5-4bcf-8683-165f20b8747f { "id" : "79c3169c-f7e8-43b0-95db-ae884a85de37", "dbSyncTime" : 0, "createTime" : 1648393200000, "updateTime" : 0, "dbName" : "dbcli01", "dbUniqueName" : "dbcli01uniq", "dbDomain" : "sub03230643360.orakawavcn.oraclevcn.com", "dbId" : 3324078197, "cpuCount" : 4, "sgaTarget" : "2000MB", "pgaAggregateTarget" : "2000MB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.11.0.0.0", "resourceOCIDSettings" : null, "dbCharacterSet" : { "characterSet" : "JA16SJISTILDE", "nlsCharacterset" : "UTF8", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN“ "dbNodeLevelDetails" : { "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "instanceName" : "dbclisid1", "version" : "19.11.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "status" : "OPEN" }, "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "instanceName" : "dbclisid2", "version" : "19.11.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "status" : "OPEN" } }, }, dbaascli database getDetails "pdbs" : { "DBCLI01PDB01" : { "pdbName" : "DBCLI01PDB01", "pdbUID" : "3034439310", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB3D7503BCD57E96E0533500000A2869", "dbid" : "3034439310", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" "pdbConnectStrings" : [ { "serviceName" : "dbcli01_dbcli01pdb01.paas.oracle.com", "connectString" : "orakawa-vgfvk- scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb0 1.paas.oracle.com" } ] } }, "messages" : [ ] } dbaascli execution completed }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, Database Home dbaascli system getDBHomes [root@saburo-5puyv1 ~]# dbaascli system getDBHomes DBAAS CLI version 24.1.2.0.0 Executing command system getDBHomes Job id: 10ca839d-1d0e-4265-984e-0487d9cf0d97 Session log: /var/opt/oracle/log/system/getDBHomes/dbaastools_2024- 03-14_05-54-56-PM_165733.log { "OraHome1" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "homeName" : "OraHome1", "version" : "19.22.0.0.0", "createTime" : 1710147213945, "updateTime" : 1710317105918, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "saburo-5puyv2" : { "nodeName" : "saburo-5puyv2", "version" : "19.22.0.0.0", "patches" : [ "34697081", "35692839", "35239280", "35926646", "35949090", "35967489", "35943157" ] }, "saburo-5puyv1" : { "nodeName" : "saburo-5puyv1", "version" : "19.22.0.0.0", "patches" : [ "34697081", "35692839", "35239280", "35926646", "35949090", "35967489", "35943157" ] } }, "messages" : [ ] "OraHome2" : { "homePath" : "/u02/app/oracle/product/11.2.0/dbhome_1", "homeName" : "OraHome2", "version" : "11.2.0.4.231017", "createTime" : 1710314743029, "updateTime" : 1710314743029, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "saburo-5puyv2" : { "nodeName" : "saburo-5puyv2", "version" : "11.2.0.4.231017", "patches" : [ "25139545", "33613829", "33991024", "35638387", "22291453", "30432076", "31335037", "32327201", "32558369", "34006614", "34533061", "34698179", "35099667", "35220732", "35239280", "35313335", "35685663", "32224895", "22366322", "31228670", "21289564", "35574089" ] }, "saburo-5puyv1" : { "nodeName" : "saburo-5puyv1", "version" : "11.2.0.4.231017", "patches" : [ "25139545", "33613829", "33991024", "35638387", "22291453", "30432076", "31335037", "32327201", "32558369", "34006614", "34533061", "34698179", "35099667", "35220732", "35239280", "35313335", "35685663", "32224895", "22366322", "31228670", "21289564", "35574089" ] } }, "messages" : [ ] }, }, Database Home dbaascli system getDBHomes "OraHome3" : { "homePath" : "/u02/app/oracle/product/11.2.0/dbhome_2", "homeName" : "OraHome3", "version" : "11.2.0.4.231017", "createTime" : 1710394822227, "updateTime" : 1710395608351, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "saburo-5puyv2" : { "nodeName" : "saburo-5puyv2", "version" : "11.2.0.4.231017", "patches" : [ "25139545", "33613829", "33991024", "35638387", "22291453", "30432076", "31335037", "32327201", "32558369", "34006614", "34533061", "34698179", "35099667", "35220732", "35239280", "35313335", "35685663", "32224895", "22366322", "31228670", "21289564", "35574089" ] }, "saburo-5puyv1" : { "nodeName" : "saburo-5puyv1", "version" : "11.2.0.4.231017", "patches" : [ "25139545", "33613829", "33991024", "35638387", "22291453", "30432076", "31335037", "32327201", "32558369", "34006614", "34533061", "34698179", "35099667", "35220732", "35239280", "35313335", "35685663", "32224895", "22366322", "31228670", "21289564", "35574089" ] } }, "messages" : [ ] } } dbaascli execution completed [root@saburo-5puyv1 ~]# dbaascli database delete --help [root@wasabi-isfff1 ~]# dbaascli database delete --help DBAAS CLI version 22.3.1.1.0 Executing command database delete --help database delete - delete the given database. Usage: dbaascli database delete --dbname [--deleteArchiveLogs ] [--deleteBackups ] [--precheckOnly ] [-- waitForCompletion ] [--force] [--dbSID ] [--resume [--sessionID ]] Where: --dbname - Oracle database name. [--deleteArchiveLogs - specify true or false to indicate database archive logs deletion. ] [--deleteBackups - specify true or false to indicate database backups deletion. ] [--precheckOnly - specify yes to run only the prechecks for this operation. Valid values : yes|no ] [--waitForCompletion - specify false to run the operation in background. Valid values : true|false.] [--force - flag to force delete database.] [--dbSID - specify database SID] [--resume - to resume the previous execution] [--sessionID - to resume a specific session id.] [root@wasabi-isfff1 ~]# dbaascli database delete [root@orcl0329-pfutx1 ~]# dbaascli database delete --dbName dbcli02 DBAAS CLI version 22.1.1.1.0 Executing command database delete --dbName dbcli02 Job id: 222c0750-f49e-4d97-aa23-5f85c9351115 Loading PILOT... Session ID of the current execution is: 28 Log file location: /var/opt/oracle/log/dbcli02/database/delete/pilot_2022-03-30_11-55- 01-PM ----------------- Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Validate_version job Completed Validate_version job ----------------- Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job ----------------- Running DB_backup_assistant job Skipping. Job is detected as not applicable. ----------------- Running DB_deletion_acquire_lock job Completed DB_deletion_acquire_lock job Running Clear_crontab_entries job Completed Clear_crontab_entries job ----------------- Running Delete_db_network_directory job Completed Delete_db_network_directory job ----------------- Running Clear_asm_entries job Completed Clear_asm_entries job ----------------- Running DB_deletion_release_lock job Completed DB_deletion_release_lock job ----------------- Running Delete_db_login_environment_file job Completed Delete_db_login_environment_file job ----------------- Running Delete_creg_file job Completed Delete_creg_file job ----------------- Running Delete_db_acfs_directory job Completed Delete_db_acfs_directory job ----------------- Running Generate_dbsystem_details job Completed Generate_dbsystem_details job dbaascli execution completed Running DB_deletion job Completed DB_deletion job Running Remove_oratab_entry job Completed Remove_oratab_entry job dbaascli Databases ailed Terminate dbaascli database deleteInstance --help [root@taro-3nusm1 ~]# dbaascli database deleteinstance --help DBAAS CLI version 24.1.1.0.0 Executing command database deleteinstance --help database deleteInstance - allows user to delete the database instance on the specified node. Usage: dbaascli database deleteInstance --dbname --node [--continueOnUnreachableNode] { [--resume [--sessionID ]] | [--revert [--sessionID ]] } [--okvServer --okvAdminUserName [--okvServerRestPort ]] [--okvServerRestPort ] [--okvWalletName ] [-- waitForCompletion ] Where: --dbname - Oracle database name. --node - specifies the node name for database instance. [--continueOnUnreachableNode - perform the operation even if the node is unreachable.] [--resume | --revert] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--revert - to rollback the previous operation] [--sessionID - to resume a specific session id.] [--okvServer - Specifies the Oracle Key Vault server] --okvAdminUserName - Specifies the Oracle Key Vault admin user name [--okvServerRestPort - Specifies the rest port number for Oracle Key Vault] [--okvServerRestPort - Specifies the rest port number for Oracle Key Vault] [--okvWalletName - Specifies the Oracle Key Vault wallet name] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [root@taro-3nusm1 ~]# 103 varchar2 dbaascli database deleteInstance [root@orcl-jyvid1 ~]# dbaascli database getdetails --dbname DB19c DBAAS CLI version 22.2.1.0.1 Executing command database getdetails Job id: c31f0748-927d-4e1c-90f4-3ab5cddc9f30 { "id" : "91e07074-c0e7-499c-9dce-f7a1b005dff2", "dbSyncTime" : 0, "createTime" : 1652227200000, "updateTime" : 0, "dbName" : "DB19c", "dbUniqueName" : "DB19c_vxm_kix", "dbDomain" : "sub07160524340.testvcn.oraclevcn.com", "dbId" : 2232397119, "cpuCount" : 4, "sgaTarget" : "7600MB", "pgaAggregateTarget" : "5000MB", "dbSize" : "47GB", "dbUsedSize" : "7GB", "totalFraSize" : "28912GB", "fraSizeUsed" : "15GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.13.0.0.0", "resourceOCIDSettings" : null, 22.2.1.0.1 "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "orcl-jyvid1" : { "nodeName" : "orcl-jyvid1", "instanceName" : "DB19c1", "version" : "19.13.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" }, "orcl-jyvid2" : { "nodeName" : "orcl-jyvid2", "instanceName" : "DB19c2", "version" : "19.13.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" } }, "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "2902028327", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DEB2908B77A2DE19E053CA00000A9EE5", dbaascli database deleteInstance "dbid" : "2902028327", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orcl-jyvid1" : { "nodeName" : "orcl-jyvid1", "openMode" : "READ_WRITE" }, "orcl-jyvid2" : { "nodeName" : "orcl-jyvid2", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "DB19c_PDB1.paas.oracle.com", "connectString" : "orcl-jyvid-scan.sub07160524340.testvcn.oraclevcn.com:1521/DB19c_PDB1.paas.oracle.com" } ], "pdbSize" : "4GB", "pdbUsedSize" : "1GB" } }, "messages" : [ ] } dbaascli execution completed 22.2.1.0.1 dbaascli database deleteInstance [root@orcl-jyvid1 ~]# dbaascli database deleteInstance --dbname DB19c --node orcl-jyvid1 DBAAS CLI version 22.2.1.0.1 Executing command database deleteInstance --node orcl-jyvid1 Job id: 357de19c-6e75-4f77-9fb8-997238e2f618 Loading PILOT... Session ID of the current execution is: 17 Log file location: /var/opt/oracle/log/DB19c/database/deleteInstance/pilot_2022-05-11_12-58-24-AM Running Plugin_initialization job Completed Plugin_initialization job Running Validate_input job Execution of Validate_input failed [FATAL] [DBAAS-70126] An instance cannot be deleted from the local node. ACTION: Specify a different node. ******** PLUGIN EXECUTION FAILED ******** Executing jobs which need to be run always... Completed execution. [FATAL] [DBAAS-60022] Command '/var/opt/oracle/dbaastools/pilot/bin/pilot -plugin delete_db_instance_cloud NODE_NAME="orcl-jyvid1" DB_NAME="DB19c" -J-Doracle.install.commons.pilot.log.enablePID=true -logLevel FINE -logDir /var/opt/oracle/log/DB19c/database/deleteInstance -silent - checkpointDir /var/opt/oracle/log/pilot_checkpoints -jreLoc /usr/java/jdk1.8.0_311-amd64/jre ' execution has failed on nodes [localnode]. ACTION: Refer application log file for more information. *MORE DETAILS* Result of node:localnode [Execution of Validate_input failed, [FATAL] [DBAAS-70126] An instance cannot be deleted from the local node., ACTION: Specify a different node., ******** PLUGIN EXECUTION FAILED ********, Executing jobs which need to be run always..., Completed execution.] Exit code of the operation:255 22.2.1.0.1 dbaascli database deleteInstance（ [root@orcl-jyvid1 ~]# dbaascli database deleteInstance --dbname DB19c --node orcl-jyvid2 DBAAS CLI version 22.2.1.0.1 Executing command database deleteInstance --node orcl-jyvid2 Job id: 985eebdd-fea3-43ed-bf47-f02a1d53e820 Loading PILOT... Session ID of the current execution is: 18 Log file location: /var/opt/oracle/log/DB19c/database/deleteInstance/pilot_2022-05-11_12-58-53-AM Running Plugin_initialization job Completed Plugin_initialization job Running Validate_input job Execution of Validate_input failed [FATAL] [DBAAS-70127] The instance in node 'orcl-jyvid2' is a preferred instance for service 'DB19c_PDB1.paas.oracle.com'. ACTION: Specify a different node. ******** PLUGIN EXECUTION FAILED ******** Executing jobs which need to be run always... Completed execution. [FATAL] [DBAAS-60022] Command '/var/opt/oracle/dbaastools/pilot/bin/pilot -plugin delete_db_instance_cloud NODE_NAME="orcl-jyvid2" DB_NAME="DB19c" -J-Doracle.install.commons.pilot.log.enablePID=true -logLevel FINE -logDir /var/opt/oracle/log/DB19c/database/deleteInstance -silent - checkpointDir /var/opt/oracle/log/pilot_checkpoints -jreLoc /usr/java/jdk1.8.0_311-amd64/jre ' execution has failed on nodes [localnode]. ACTION: Refer application log file for more information. *MORE DETAILS* Result of node:localnode [Execution of Validate_input failed, [FATAL] [DBAAS-70127] The instance in node 'orcl-jyvid2' is a preferred instance for service 'DB19c_PDB1.paas.oracle.com'., ACTION: Specify a different node., ******** PLUGIN EXECUTION FAILED ********, Executing jobs which need to be run always..., Completed execution.] Exit code of the operation:255 DB19c_PDB1.paas.oracle.com preferred dbaascli database deleteInstance [root@orcl-jyvid1 ~]# dbaascli database deleteInstance --dbname DB19c --node orcl-jyvid2 DBAAS CLI version 22.2.1.0.1 Executing command database deleteInstance --node orcl-jyvid2 Job id: b5070c29-5a56-4cc6-9484-95ccf096ffa6 Loading PILOT... Session ID of the current execution is: 19 Log file location: /var/opt/oracle/log/DB19c/database/deleteInstance/pilot_2022-05-11_03-58-13-AM Running Plugin_initialization job Completed Plugin_initialization job Running Validate_input job Completed Validate_input job Running Delete_db_instance job Completed Delete_db_instance job Running Reload_db_details job Completed Reload_db_details job Running Remove_backup_jobs job Completed Remove_backup_jobs job Running Update_cloud_metadata job Completed Update_cloud_metadata job Running Generate_dbsystem_details job Completed Generate_dbsystem_details job dbaascli execution completed 108 varchar2 特定ノードのDBインスタンスを削除 dbaascli database deleteInstance --該当サービスの優先インスタンスからノード２を除外した後、再度削除処理を実施 [root@orcl-jyvid1 ~]# dbaascli database deleteInstance --dbname DB19c --node orcl-jyvid2 DBAAS CLI version 22.2.1.0.1 Executing command database deleteInstance --node orcl-jyvid2 Job id: b5070c29-5a56-4cc6-9484-95ccf096ffa6 Loading PILOT... Session ID of the current execution is: 19 Log file location: /var/opt/oracle/log/DB19c/database/deleteInstance/pilot_2022-05-11_03-58-13-AM Running Plugin_initialization job Completed Plugin_initialization job Running Validate_input job Completed Validate_input job Running Delete_db_instance job Completed Delete_db_instance job Running Reload_db_details job Completed Reload_db_details job Running Remove_backup_jobs job Completed Remove_backup_jobs job Running Update_cloud_metadata job Completed Update_cloud_metadata job Running Generate_dbsystem_details job Completed Generate_dbsystem_details job dbaascli execution completed 109 varchar2 dbaascli database deleteInstance [root@orcl-jyvid1 ~]# dbaascli database getdetails --dbname DB19c DBAAS CLI version 22.2.1.0.1 Executing command database getdetails Job id: 3330b270-92d7-4c79-9d6b-7486695c415c { "id" : "91e07074-c0e7-499c-9dce-f7a1b005dff2", "dbSyncTime" : 0, "createTime" : 1652227200000, "updateTime" : 0, "dbName" : "DB19c", "dbUniqueName" : "DB19c_vxm_kix", "dbDomain" : "sub07160524340.testvcn.oraclevcn.com", "dbId" : 2232397119, "cpuCount" : 4, "sgaTarget" : "7600MB", "pgaAggregateTarget" : "5000MB", "dbSize" : "29GB", "dbUsedSize" : "7GB", "totalFraSize" : "28912GB", "fraSizeUsed" : "16GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.13.0.0.0", "resourceOCIDSettings" : null, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "orcl-jyvid1" : { "nodeName" : "orcl-jyvid1", "instanceName" : "DB19c1", "version" : "19.13.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" } }, "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "2902028327", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DEB2908B77A2DE19E053CA00000A9EE5", "dbid" : "2902028327", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orcl-jyvid1" : { "nodeName" : "orcl-jyvid1", "openMode" : "READ_WRITE" 110 varchar2 特定ノードのDBインスタンスを削除 dbaascli database deleteInstance } }, "pdbConnectStrings" : [ { "serviceName" : "DB19c_PDB1.paas.oracle.com", "connectString" : "orcl-jyvid-scan.sub07160524340.testvcn.oraclevcn.com:1521/DB19c_PDB1.paas.oracle.com" } ], "pdbSize" : "4GB", "pdbUsedSize" : "1GB" } }, "messages" : [ ] } dbaascli execution completed 111 varchar2 特定ノードのDBインスタンスを削除 dbaascli database deleteInstance --インスタンス削除後、OCIコンソールでは下記メッセージが表示される 112 varchar2 インスタンスの追加 dbaascli database addInstance [root@vm01wasa-zb1hy1 ~]# dbaascli database addInstance --help DBAAS CLI version 23.1.1.0.1 Executing command database addInstance --help database addInstance - allows user to add the database instance on the specified node. Usage: dbaascli database addInstance --dbname --node [--newNodeSID ] { [--resume [--sessionID ]] | [--revert [--sessionID ]] } Where: --dbname - Oracle database name. --node - specifies the node name for database instance. [--newNodeSID - SID for the instance to add in the new node. ] [--resume | --revert] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--revert - to rollback the previous operation] [--sessionID - to resume a specific session id.] [root@vm01wasa-zb1hy1 ~]# 113 varchar2 データベースのduplicate dbaascli database duplicate [root@wasa-ycfpo1 ~]# dbaascli database duplicate --help DBAAS CLI version 24.1.1.0.0 Executing command database duplicate --help database duplicate - create a new database from active database. Usage: dbaascli database duplicate --dbName --sourceDBConnectionString { --oracleHome | --oracleHomeName } [--dbSID ] [--dbUniqueName ] [--sgaSizeInMB ] [--pgaSizeInMB ] [--datafileDestination ] [-- fraDestination ] [--fraSizeInMB ] [--sourceDBTDEWalletLocation ] [--nodeList ] { [--resume [--sessionID ]] | [--revert [--sessionID ]] } [--rmanParallelism ] [--rmanSectionSizeInGB ] [--tdeConfigMethod [--kmsKeyOCID ]] [--sourceDBTdeConfigMethod [--sourceDBKmsKeyOCID ]] [--executePrereqs] [--waitForCompletion ] [--skipPDBs ] Where: --dbName - Oracle database name. 複製先のDB名（db_unique_name） --sourceDBConnectionString - source database connection string in the format of :/. --oracleHome | --oracleHomeName --oracleHome - specifies Oracle home location 複製先のDBHOME（既存と同じだと既存DBHOME上に作成） --oracleHomeName - specifies Oracle home name [--dbSID - specifies database SID] [--dbUniqueName - specifies database unique name] [--sgaSizeInMB - specifies sga_target value in mega byte unit] duplicate dbaascli database duplicate [root@wasa-ycfpo1 ~]# dbaascli database duplicate --help DBAAS CLI version 24.1.1.0.0 続き Where: --dbName - Oracle database name. 複製先のDB名（db_unique_name） --sourceDBConnectionString - source database connection string in the format of :/. --oracleHome | --oracleHomeName --oracleHome - specifies Oracle home location 複製先のDBHOME（既存と同じDBHOMEを指定すると、既存DBHOME上に作成） --oracleHomeName - specifies Oracle home name [--dbSID - specifies database SID] [--dbUniqueName - specifies database unique name] [--sgaSizeInMB - specifies sga_target value in mega byte unit] [--pgaSizeInMB - specifies pga_aggregate_target value in mega byte unit] [--datafileDestination - specifies ASM disk group name to use for database datafiles] [--fraDestination - specifies ASM disk group name to use for database fast recovery area] [--fraSizeInMB - specifies fast recovery area size value in mega byte unit] [--sourceDBTDEWalletLocation - specifies location of source database TDE wallet on local file system which is copied from the source database node. ] [--nodeList - specifies comma separated node list for database] [--resume | --revert] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--revert - to rollback the previous operation] [--sessionID - to resume a specific session id.] [--rmanParallelism - specifies parallelsim value] [--rmanSectionSizeInGB - specifies RMAN section size in GB] [--tdeConfigMethod - specifies TDE configuration method. Allowed values are FILE, KMS] [--kmsKeyOCID - specifies KMS key OCID to use for TDE. This is applicable only if KMS is selected for TDE] [--sourceDBTdeConfigMethod - specifies source database TDE configuration method. Allowed values are FILE, KMS] [--sourceDBKmsKeyOCID - specifies source database KMS key OCID to use for TDE. This is applicable only if KMS is selected for TDE] [--executePrereqs - run the prerequisite checks and report the results. ] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] 115 Copy[r-ig-hstk©ip2P0D2B4s, O-rascpleecainfdi/oersitscoamffmiliaatesse,parated source database PDB names which needs to be excluded for the duplicate database operation. Example: pdb1,pdb2... ] データベースのduplicate dbaascli database duplicate --executePrereqs [root@taro-3nusm1 ~]# dbaascli database duplicate --dbName DB0207 --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --sourceDBConnectionString taro-3nusm- scan.sub04210756190.exavcn.oraclevcn.com:1521/DB0206_3cg_kix.sub04210756190.exavcn.oraclevcn.com --sourceDBTDEWalletLocation /var/opt/oracle/dbaas_acfs/DB0206/wallet_root/tde --sourceDBTdeConfigMethod FILE --tdeConfigMethod FILE --executePrereqs DBAAS CLI version 24.1.1.0.0 Executing command database duplicate --dbName DB0207 --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --sourceDBConnectionString taro-3nusm- scan.sub04210756190.exavcn.oraclevcn.com:1521/DB0206_3cg_kix.sub04210756190.exavcn.oraclevcn.com --sourceDBTDEWalletLocation /var/opt/oracle/dbaas_acfs/DB0206/wallet_root/tde --sourceDBTdeConfigMethod FILE --tdeConfigMethod FILE --executePrereqs Job id: 15b17842-84d3-44fe-84c7-474f647c34fe Session log: /var/opt/oracle/log/DB0207/database/duplicate/dbaastools_2024-02-19_10-34-49-AM_225678.log Enter Source DB SYS_PASSWORD: Enter Source DB TDE_PASSWORD: Enter SYS_PASSWORD: Enter SYS_PASSWORD (reconfirmation): Enter TDE_PASSWORD: Enter TDE_PASSWORD (reconfirmation): Loading PILOT... Enter SYS_PASSWORD ********** Enter SYS_PASSWORD (reconfirmation): ************ Enter TDE_PASSWORD *********** 116 varchar2 データベースのduplicate dbaascli database duplicate --executePrereqs 続き Enter TDE_PASSWORD (reconfirmation): ************ Session ID of the current execution is: 710 Log file location: /var/opt/oracle/log/DB0207/database/duplicate/pilot_2024-02-19_10-36-11-AM_233687 Running Plugin_initialization job Enter Source DB SYS_PASSWORD ********** Enter Source DB TDE_PASSWORD ************* Completed Plugin_initialization job Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_1 Running Default_value_initialization job Completed Default_value_initialization job Running Validate_input_params job Completed Validate_input_params job Running Validate_cpu_availability job Completed Validate_cpu_availability job Running Validate_asm_availability job Completed Validate_asm_availability job Running Validate_disk_space_availability job Completed Validate_disk_space_availability job 117 varchar2 データベースのduplicate dbaascli database duplicate --executePrereqs 続き Running Validate_huge_pages_availability job Completed Validate_huge_pages_availability job Running Validate_hostname_domain job Completed Validate_hostname_domain job Running Install_db_cloud_backup_module job Skipping. Job is detected as not applicable. Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job Running Validate_backup_report job Skipping. Job is detected as not applicable. Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_1 dbaascli execution completed [root@taro-3nusm1 ~]# 118 varchar2 データベースのduplicate dbaascli database duplicate --executePrereqs 119 varchar2 データベースのduplicate dbaascli database duplicate [root@taro-3nusm1 ~]# dbaascli database duplicate --dbName DB0207 --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --sourceDBConnectionString taro-3nusm- scan.sub04210756190.exavcn.oraclevcn.com:1521/DB0206_3cg_kix.sub04210756190.exavcn.oraclevcn.com --sourceDBTDEWalletLocation /var/opt/oracle/dbaas_acfs/DB0206/wallet_root/tde --sourceDBTdeConfigMethod FILE --tdeConfigMethod FILE DBAAS CLI version 24.1.1.0.0 Executing command database duplicate --dbName DB0207 --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_1 --sourceDBConnectionString taro-3nusm- scan.sub04210756190.exavcn.oraclevcn.com:1521/DB0206_3cg_kix.sub04210756190.exavcn.oraclevcn.com --sourceDBTDEWalletLocation /var/opt/oracle/dbaas_acfs/DB0206/wallet_root/tde --sourceDBTdeConfigMethod FILE --tdeConfigMethod FILE Job id: f8d5bd40-d667-418f-8685-1586ca0da9bf Session log: /var/opt/oracle/log/DB0207/database/duplicate/dbaastools_2024-02-19_10-44-27-AM_290111.log Enter Source DB SYS_PASSWORD: Enter Source DB TDE_PASSWORD: Enter SYS_PASSWORD: Enter SYS_PASSWORD (reconfirmation): Enter TDE_PASSWORD: Enter TDE_PASSWORD (reconfirmation): Loading PILOT... Enter SYS_PASSWORD ********** Enter SYS_PASSWORD (reconfirmation): ********* Enter TDE_PASSWORD ************** 120 varchar2 データベースのduplicate dbaascli database duplicate 続き Enter TDE_PASSWORD (reconfirmation): ************ Session ID of the current execution is: 711 Log file location: /var/opt/oracle/log/DB0207/database/duplicate/pilot_2024-02-19_10-45-19-AM_294035 Running Plugin_initialization job Enter Source DB SYS_PASSWORD ************* Enter Source DB TDE_PASSWORD *********** Completed Plugin_initialization job Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_1 Running Default_value_initialization job Completed Default_value_initialization job Running Validate_input_params job Completed Validate_input_params job Running Validate_cpu_availability job Completed Validate_cpu_availability job Running Validate_asm_availability job Completed Validate_asm_availability job Running Validate_disk_space_availability job Completed Validate_disk_space_availability job 121 varchar2 データベースのduplicate dbaascli database duplicate 続き Running Validate_huge_pages_availability job Completed Validate_huge_pages_availability job Running Validate_hostname_domain job Completed Validate_hostname_domain job Running Install_db_cloud_backup_module job Skipping. Job is detected as not applicable. Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job Running Validate_backup_report job Skipping. Job is detected as not applicable. Running Configure_gilistener_file_for_duplicatedb job Completed Configure_gilistener_file_for_duplicatedb job Acquiring write lock: create_db_cloud Running Setup_acfs_volumes job Completed Setup_acfs_volumes job Running Setup_db_folders job Completed Setup_db_folders job Running DB_creation job Completed DB_creation job Releasing lock: create_db_cloud 122 varchar2 データベースのduplicate dbaascli database duplicate 続き Running Generate_db_metadata job Completed Generate_db_metadata job Running Create_db_from_backup job Skipping. Job is detected as not applicable. Completed Create_db_from_backup job Running Load_db_details job Completed Load_db_details job Running Populate_creg job Completed Populate_creg job Running Register_ocids job Skipping. Job is detected as not applicable. Running Run_datapatch job Skipping. Job is detected as not applicable. Running Create_users_tablespace job Skipping. Job is detected as not applicable. Running Configure_pdb_service job Completed Configure_pdb_service job Running Set_pdb_admin_user_profile job Completed Set_pdb_admin_user_profile job 123 varchar2 データベースのduplicate dbaascli database duplicate 続き Running Lock_pdb_admin_user job Completed Lock_pdb_admin_user job Running Configure_flashback job Completed Configure_flashback job Running Update_cloud_service_recommended_config_parameters job Completed Update_cloud_service_recommended_config_parameters job Running Update_distributed_lock_timeout job Completed Update_distributed_lock_timeout job Running Configure_archiving job Completed Configure_archiving job Running Configure_huge_pages job Completed Configure_huge_pages job Running Set_credentials job Completed Set_credentials job Running Update_dba_directories job Completed Update_dba_directories job Running Set_cluster_interconnects job Completed Set_cluster_interconnects job Running Create_db_secure_profile job Completed Create_db_secure_profile job 124 varchar2 データベースのduplicate dbaascli database duplicate 続き Running Set_utc_timezone job Completed Set_utc_timezone job Running Run_dst_post_installs job Completed Run_dst_post_installs job Running Enable_auditing job Completed Enable_auditing job Running Apply_security_measures job Completed Apply_security_measures job Running Set_listener_init_params job Completed Set_listener_init_params job Running Update_db_wallet job Completed Update_db_wallet job Running Add_oratab_entry job Completed Add_oratab_entry job Running Configure_sqlnet_ora job Completed Configure_sqlnet_ora job Running Configure_tnsnames_ora job Completed Configure_tnsnames_ora job Running Enable_fips job Completed Enable_fips job 125 varchar2 データベースのduplicate dbaascli database duplicate 続き Running DTRS_DB_Configure_Job job Completed DTRS_DB_Configure_Job job Running Restart_database job Completed Restart_database job Running Create_db_login_environment_file job Completed Create_db_login_environment_file job Running Generate_dbsystem_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed Generate_dbsystem_details job Running Cleanup job Completed Cleanup job Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_1 dbaascli execution completed [root@taro-3nusm1 ~]# 126 varchar2 データベースのduplicate dbaascli database duplicate 127 varchar2 データベースの停⽌ dbaascli database stop --help [root@orakawa-vgfvk1 ~]# dbaascli database stop --help DBAAS CLI version 22.1.1.1.0 Executing command database stop --help database stop - help for database stop. Usage: dbaascli database stop [--dbname ] [--mode ] Where: [--dbname - Oracle database name. ] [--mode - abort|immediate|normal|transactional for DB. ] 128 varchar2 データベースの停⽌ dbaascli database stop [root@orakawa-vgfvk1 ~]# dbaascli database stop --dbname dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command database stop Job id: 11be0a84-80e7-4e53-b94a-dff2ce819fde dbaascli execution completed [root@orakawa-vgfvk1 ~]# dbaascli database status --dbname dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command database status Database Status: Instance dbclisid1 is not running on node orakawa-vgfvk1 Instance dbclisid2 is not running on node orakawa-vgfvk2 [root@orakawa-vgfvk1 ~]# ps -ef | grep ora_smon oracle 240797 1 0 15:10 ? 00:00:00 ora_smon_dbcli02sid1 root 325923 297968 0 15:22 pts/1 00:00:00 grep --color=auto ora_smon 129 varchar2 データベースの起動 dbaascli database start --help [root@orakawa-vgfvk1 ~]# dbaascli database start --help DBAAS CLI version 22.1.1.1.0 Executing command database start --help database start - help for database start. Usage: dbaascli database start [--dbname ] [--mode ] Where: [--dbname - Oracle database name. ] [--mode - mount|nomount for DB.] 130 varchar2 データベースの状態確認 dbaascli database status --help [root@taro-3nusm1 ~]# dbaascli database status --help DBAAS CLI version 24.1.1.0.0 Executing command database status --help database status - checks status of a database. Usage: dbaascli database status [--dbname ] [--service --user ] Where: [--dbname - Oracle database name. ] [--service - service name.] --user - username for the service. [root@taro-3nusm1 ~]# 131 varchar2 データベースの起動 dbaascli database start [root@orakawa-vgfvk1 ~]# dbaascli database start --dbname dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command database start Job id: d65598db-a4d0-419e-aa17-99362b572455 dbaascli execution completed [root@orakawa-vgfvk1 ~]# dbaascli database status --dbname dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command database status Database Status: Instance dbclisid1 is running on node orakawa-vgfvk1 with online services dbcli01_dbcli01pdb01.paas.oracle.com. Instance status: Open. Instance dbclisid2 is running on node orakawa-vgfvk2 with online services dbcli01_dbcli01pdb01.paas.oracle.com. Instance status: Open. Database name: dbcli01 Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 – Production [root@orakawa-vgfvk1 ~]# ps -ef | grep ora_smon oracle 240797 1 0 15:10 ? 00:00:00 ora_smon_dbcli02sid1 oracle 336376 1 0 15:23 ? 00:00:00 ora_smon_dbclisid1 root 348701 297968 0 15:25 pts/1 00:00:00 grep --color=auto ora_smon 132 varchar2 データベースの停⽌して再起動 dbaascli database bounce --help 指定したExadata Cloud Infrastructureデータベースを停止して再起動 [root@taro-3nusm1 ~]# dbaascli database bounce --help DBAAS CLI version 24.1.1.0.0 Executing command database bounce --help database bounce - bounce a specific database. Usage: dbaascli database bounce [--dbname ] [--rolling ] Where: [--dbname - Oracle database name. ] [--rolling - specifies true|false to bounce database in a rolling manner. Default value is false. ] [root@taro-3nusm1 ~]# 133 varchar2 データベースのパラメーター変更 dbaascli database modifyParameters --help [root@ecc2c1n1 ~]# dbaascli database modifyParameters --help DBAAS CLI version 21.4.1.1.0 Executing command database modifyParameters --help database modifyParameters - modifies or resets initialization parameters for a given Oracle database. Usage: dbaascli database modifyParameters --dbname { --setParameters [--backupPrepared] [--instance ] [--allowBounce] | --resetParameters [--backupPrepared] [--instance ] [--allowBounce] } Where: --dbname - Oracle database name. --setParameters | --resetParameters --setParameters - comma separated list of parameters to be modified with new values. E.g. parameter1=valueA,parameter2=valueB,etc. [--backupPrepared - flag to acknowledge that a proper database backup is in place prior to modifying critical or sensitive parameters.] [--instance - name of the instance on which the parameters will be processed. If not specified, the operation will be performed at the database level.] level.] [--allowBounce - flag to grant permission to bounce the database in order to reflect the changes on applicable static parameters.] --resetParameters - comma separated list of parameters to be reset to their corresponding default values. E.g. parameter1,parameter2,etc. [--backupPrepared - flag to acknowledge that a proper database backup is in place prior to modifying critical or sensitive parameters.] [--instance - name of the instance on which the parameters will be processed. If not specified, the operation will be performed at the database [--allowBounce - flag to grant permission to bounce the database in order to reflect the changes on applicable static parameters.] [root@ecc2c1n1 ~]# 134 varchar2 データベースのパラメーター変更 dbaascli database modifyParameters [root@orakawa-vgfvk1 ~]# dbaascli database modifyParameters --dbname dbcli01 --setParameters "sga_min_size=100M" DBAAS CLI version 22.1.1.1.0 Executing command database modifyParameters --setParameters sga_min_size=100M INFO : Review log file => /var/opt/oracle/log/dbcli01/modifyParameters/modifyParameters_2022-03-28_15:28:46.168027364905.log INFO : Validating inputs... INFO : Validation of inputs PASSED INFO : Processing parameters of the dbcli01 database... Loading PILOT... Session ID of the current execution is: 29 Log file location: /var/opt/oracle/log/dbcli01/modifyParameters/pilot_2022-03-28_03-28-47-PM Running Plugin_Initialize job Completed Plugin_Initialize job Running Validate_Parameters job Completed Validate_Parameters job Running Apply_Dynamic_Parameters_Changes job Completed Apply_Dynamic_Parameters_Changes job Running Apply_Static_Parameters_Changes job Completed Apply_Static_Parameters_Changes job INFO : Parameters processing of the dbcli01 database COMPLETED ・・・ SQL> show parameter sga_min_size NAME TYPE VALUE sga_min_size big integer 100M 135 varchar2 データベースのパラメーターリセット dbaascli database modifyParameters [root@orakawa-vgfvk1 ~]# dbaascli database modifyParameters --dbname dbcli01 --resetParameters sga_min_size DBAAS CLI version 22.1.1.1.0 Executing command database modifyParameters --resetParameters sga_min_size INFO : Review log file => /var/opt/oracle/log/dbcli01/modifyParameters/modifyParameters_2022-03-28_15:32:15.674018387709.log INFO : Validating inputs... INFO : Validation of inputs PASSED INFO : Processing parameters of the dbcli01 database... Loading PILOT... Session ID of the current execution is: 30 Log file location: /var/opt/oracle/log/dbcli01/modifyParameters/pilot_2022-03-28_03-32-16-PM Running Plugin_Initialize job Completed Plugin_Initialize job Running Validate_Parameters job Completed Validate_Parameters job Running Apply_Dynamic_Parameters_Changes job Completed Apply_Dynamic_Parameters_Changes job Running Apply_Static_Parameters_Changes job Completed Apply_Static_Parameters_Changes job INFO : Parameters processing of the dbcli01 database COMPLETED ・・・ SQL> show parameter sga_min_size NAME TYPE VALUE sga_min_size big integer 0 136 varchar2 データベースのパスワード変更 dbaascli database changePassword [root@wasa-ycfpo1 ~]# dbaascli database changepassword --help DBAAS CLI version 24.1.1.0.0 Executing command database changepassword --help database changePassword - change the password for a given user in the database. Usage: dbaascli database changePassword --dbname [--user ] { [--prepareStandbyBlob [--blobLocation ]] | [--standbyBlobFromPrimary ] } [--resume [--sessionID ]] [--executePrereqs] [--waitForCompletion ] Where: --dbname - Oracle database name. [--user - username whose password change is required. ] [--prepareStandbyBlob | --standbyBlobFromPrimary] [--prepareStandbyBlob - specifies true to generate a blob file containing the artifacts needed to perform the operation in a DG environment. ] [--blobLocation - custom directory location where the standby blob file will be generated in a DG environment.] [--standbyBlobFromPrimary - specifies the location of the standby blob file which is prepared from the primary database. This is required only for standby operations. ] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--executePrereqs - run the prerequisite checks and report the results. ] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [root@wasa-ycfpo1 ~]# 137 varchar2 データベースのパスワード変更 dbaascli database changePassword [root@wasa-ycfpo1 ~]# dbaascli database changepassword --dbname DB1120 --user SYS DBAAS CLI version 24.1.1.0.0 Executing command database changepassword --dbname DB1120 --user SYS Job id: e90c5469-126e-4d46-990c-02fc7ffd0bc2 Session log: /var/opt/oracle/log/DB1120/database/changePassword/dbaastools_2024-02-07_02-51-09-AM_108911.log Enter new password: Enter new password (reconfirmation): Loading PILOT... Session ID of the current execution is: 3315 Log file location: /var/opt/oracle/log/DB1120/database/changePassword/pilot_2024-02-07_02-51-23-AM_111145 Running Plugin_initialization job Enter new password *********** Completed Plugin_initialization job Running DB_change_password_prechecks job Completed DB_change_password_prechecks job Running Extract_blob_in_standby job Skipping. Job is detected as not applicable. Running Copy_blob_contents_in_standby job Skipping. Job is detected as not applicable. Running Change_password job Completed Change_password job Running Update_db_wallet job Completed Update_db_wallet job - C-o-p-y-r-ig-h-t--©--2024, Oracle and/or its affiliates, Running Prepare_blob_for_standby_in_primary job オラクル・ホームの情報表⽰ dbaascli dbHome getDatabases --help [root@orcl-jyvid1 ~]# dbaascli dbHome getDatabases --help DBAAS CLI version 22.2.1.0.1 Executing command dbHome getDatabases --help dbHome getDatabases - display details of databases in specified Oracle Home. Usage: dbaascli dbHome getDatabases { --oracleHomeName | --oracleHome } Where: --oracleHomeName | --oracleHome --oracleHomeName - Oracle home name. --oracleHome - Oracle home path. 139 varchar2 オラクル・ホーム内のデータベースの情報表⽰ dbaascli dbHome getDatabases [root@orcl-jyvid1 ~]# dbaascli dbHome getDatabases --oraclehomename OraHome4 DBAAS CLI version 22.2.1.0.1 Executing command dbHome getDatabases --oraclehomename OraHome4 Job id: 0f00a4b9-8ec2-4b2e-8977-a1fa2c91af99 { "DB19c" : { "id" : "91e07074-c0e7-499c-9dce-f7a1b005dff2", "dbSyncTime" : 0, "createTime" : 1652227200000, "updateTime" : 0, "dbName" : "DB19c", "dbUniqueName" : "DB19c_vxm_kix", "dbDomain" : "sub07160524340.testvcn.oraclevcn.com", "dbId" : 2232397119, "cpuCount" : 4, "sgaTarget" : "7600MB", "pgaAggregateTarget" : "5000MB", "dbSize" : "29GB", "dbUsedSize" : "7GB", "totalFraSize" : "28912GB", "fraSizeUsed" : "16GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.13.0.0.0", "resourceOCIDSettings" : null, 22.2.1.0.1 で追加 "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "orcl-jyvid1" : { "nodeName" : "orcl-jyvid1", "instanceName" : "DB19c1", "version" : "19.13.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" } }, "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "2902028327", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DEB2908B77A2DE19E053CA00000A9EE5", "dbid" : "2902028327", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orcl-jyvid1" : { "nodeName" : "orcl-jyvid1", "openMode" : "READ_WRITE" } 140 varchar2 オラクル・ホーム内のデータベースの情報表⽰ dbaascli dbHome getDatabases }, "pdbConnectStrings" : [ { "serviceName" : "DB19c_PDB1.paas.oracle.com", "connectString" : "orcl-jyvid-scan.sub07160524340.testvcn.oraclevcn.com:1521/DB19c_PDB1.paas.oracle.com" } ], "pdbSize" : "4GB", "pdbUsedSize" : "1GB" } }, "messages" : [ ] } } dbaascli execution completed 141 varchar2 Database Homeの削除 dbaascli dbhome purge --help [root@orakawa-vgfvk1 ~]# dbaascli dbhome purge --help DBAAS CLI version 22.1.1.1.0 Executing command dbhome purge --help dbHome purge - purge an empty Oracle Database Home/s existing on the VM. Usage: dbaascli dbHome purge [--hName ] [--hPath ] Where: [--hName - name of Oracle Home to be purged. ] [--hPath - path of Oracle Home to be purged. ] 142 varchar2 Database Homeの削除 dbaascli dbhome purge DBの存在している dbhome の削除はエラーになる [root@orakawa-vgfvk1 ~]# dbaascli dbhome info DBAAS CLI version 22.1.1.1.0 Executing command dbhome info Enter a homename or just press enter if you want details of all homes 1.HOME_NAME=OraHome1 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_2 VERSION=19.13.0.0 PATCH_LEVEL=19.13.0.0 DBs installed=dbcli01 Agent DB IDs=79c3169c-f7e8-43b0-95db-ae884a85de37 OH Backup=NOT Configured 2.HOME_NAME=OraHome2 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_3 VERSION=19.13.0.0 PATCH_LEVEL=19.13.0.0 DBs installed= OH Backup=NOT Configured 3.HOME_NAME=dbcli01 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_1 VERSION=19.12.0.0 PATCH_LEVEL=19.12.0.0 DBs installed=dbcli02 Agent DB IDs=cc9b557e-4112-4df0-b126-50fd87c67cf5 OH Backup=NOT Configured [root@orakawa-vgfvk1 ~]# dbaascli dbhome purge --hpath /u02/app/oracle/product/19.0.0.0/dbhome_2 DBAAS CLI version 22.1.1.1.0 Executing command dbhome purge --hpath /u02/app/oracle/product/19.0.0.0/dbhome_2 Number of databases in oracle home is 1: dbcli01 ERROR: Cannot purge with path /u02/app/oracle/product/19.0.0.0/dbhome_2: OH is in use (at least one db is running from this OH) For more information, check logs at /var/opt/oracle/log/deloh 143 varchar2 Database Homeの削除 dbaascli dbhome purge DBの存在していない dbhome は⼀瞬で削除 [root@orakawa-vgfvk1 ~]# dbaascli dbhome info DBAAS CLI version 22.1.1.1.0 Executing command dbhome info Enter a homename or just press enter if you want details of all homes 1.HOME_NAME=OraHome1 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_2 VERSION=19.13.0.0 PATCH_LEVEL=19.13.0.0 DBs installed=dbcli01 Agent DB IDs=79c3169c-f7e8-43b0-95db-ae884a85de37 OH Backup=NOT Configured 2.HOME_NAME=OraHome2 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_3 VERSION=19.13.0.0 PATCH_LEVEL=19.13.0.0 DBs installed= OH Backup=NOT Configured 3.HOME_NAME=dbcli01 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_1 VERSION=19.12.0.0 PATCH_LEVEL=19.12.0.0 DBs installed=dbcli02 Agent DB IDs=cc9b557e-4112-4df0-b126-50fd87c67cf5 OH Backup=NOT Configured [root@orakawa-vgfvk1 ~]# dbaascli dbhome purge --hpath /u02/app/oracle/product/19.0.0.0/dbhome_3 DBAAS CLI version 22.1.1.1.0 Executing command dbhome purge --hpath /u02/app/oracle/product/19.0.0.0/dbhome_3 INFO: Removing Oracle Home /u02/app/oracle/product/19.0.0.0/dbhome_3 Successfully removed with path /u02/app/oracle/product/19.0.0.0/dbhome_3 [root@orakawa-vgfvk1 ~]# dbaascli dbhome info DBAAS CLI version 22.1.1.1.0 Executing command dbhome info Enter a homename or just press enter if you want details of all homes 1.HOME_NAME=OraHome1 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_2 VERSION=19.13.0.0 PATCH_LEVEL=19.13.0.0 DBs installed=dbcli01 Agent DB IDs=79c3169c-f7e8-43b0-95db-ae884a85de37 OH Backup=NOT Configured 2.HOME_NAME=dbcli01 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_1 VERSION=19.12.0.0 PATCH_LEVEL=19.12.0.0 DBs installed=dbcli02 Agent DB IDs=cc9b557e-4112-4df0-b126-50fd87c67cf5 OH Backup=NOT Configured 144 varchar2 dbaascli から dbhome 削除後のコンソールからの⾒え⽅ Failed > ハンバーガーメニューから Delete 145 varchar2 Database timezone のアップグレード dbaascli database upgradeTimezone --help [root@taro-3nusm1 ~]# dbaascli database upgradeTimezone --help DBAAS CLI version 24.1.1.0.0 Executing command database upgradeTimezone --help database upgradeTimeZone - to upgrade the database time zone version Usage: dbaascli database upgradeTimeZone --dbname --restartDB [--resume [--sessionID ]] [--waitForCompletion ] [--executePrereqs] { [--pdbs ] | [--skipPDBs ] } [--skipClosedPDBs] Where: --dbname - Oracle database name. --restartDB - flag is needed for taking an acknowledgement to restart the database in non rolling mode. [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [--executePrereqs - run the prerequisite checks and report the results. ] [--pdbs | --skipPDBs] [--pdbs - specify comma separated pdbs to upgrade DST version.] [--skipPDBs - option to skip upgrading DST version on specified pdbs.] [--skipClosedPDBs - flag to skip upgrading dst version on closed pdbs.] [root@taro-3nusm1 ~]# 146 varchar2 Database テンプレートの作成 dbaascli database createTemplate --help 後でデータベースの作成に使用できるデータベース・テンプレート(DBCAテンプレート)を作成 [root@taro-3nusm1 ~]# dbaascli database createTemplate --help DBAAS CLI version 24.1.1.0.0 Executing command database createTemplate --help database createTemplate - create a new template from the specified database. Usage: dbaascli database createTemplate --dbname { --templateLocation | --uploadToObjectStorage --objectStorageLoginUser --objectStorageBucketName [--objectStorageUrl ] } [--templateName ] [--rmanParallelism ] Where: --dbname - Oracle database name. --templateLocation | --uploadToObjectStorage --templateLocation - specifies the template location --uploadToObjectStorage - to upload template to object storage --objectStorageLoginUser - object storage login user --objectStorageBucketName - object storage bucket name [--objectStorageUrl - object storage URL] [--templateName - specifies the template name] [--rmanParallelism - specifies Parallelsim value] [root@taro-3nusm1 ~]# 147 varchar2 dbaascliを使⽤したOracle Grid Infrastructure およびOracle Databasesへのパッチ適⽤ 148 varchar2 データベースへのパッチ適⽤ • インプレース適⽤ • 現在の Oracle Home にパッチを適⽤する • dbaascli dbhome patch • アウトオブプレース適⽤（推奨） • パッチ適⽤済（新しいバージョン）のOracle Home にデータベースを移動する • dbaascli database move 149 varchar2 Oracle Databasesへのインプレースパッチ適⽤ 150 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)事前確認 dbaascli dbhome info [root@vmem-6gl0h1 ~]# dbaascli dbhome info DBAAS CLI version 23.4.1.0.0 Executing command dbhome info [INFO] [DBAAS-14011] - The usage of this command is deprecated. ACTION: It is recommended to use 'dbaascli dbHome getDetails or dbaascli system getDBHomes' for this operation. Enter a homename or just press enter if you want details of all homes 1.HOME_NAME=OraHome2 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_2 VERSION=19.13.0.0 PATCH_LEVEL=19.13.0.0 DBs installed= OH Backup=NOT Configured 2.HOME_NAME=OraHome3 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_3 VERSION=19.14.0.0 PATCH_LEVEL=19.14.0.0 DBs installed= OH Backup=NOT Configured 3.HOME_NAME=OraHome1 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_1 VERSION=19.20.0.0 PATCH_LEVEL=19.20.0.0 DBs installed=DBFDSI DB19 Agent DB IDs=2b67088f-a84c-4b70-a2bc-9650d128fa97 d2705e01-7891- 4bf7-8e91-5f01988a5a64 OH Backup=NOT Configured 4.HOME_NAME=OraHome6 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_6 VERSION=19.21.0.0 PATCH_LEVEL=19.21.0.0 DBs installed=dbcli01 Agent DB IDs=e1546bda-82ae-4d56-b824-6d3a89e8afeb OH Backup=NOT Configured 5.HOME_NAME=OraHome4 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_4 VERSION=19.20.0.0 PATCH_LEVEL=19.20.0.0 DBs installed=Tutorial Agent DB IDs=56916e81-b9ed-436b-ad80-8c771b24da0a OH Backup=NOT Configured 151 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)コマンド⼀覧 dbaascli dbhome patch --help [root@vmem-6gl0h1 ~]# dbaascli dbhome patch --help DBAAS CLI version 23.4.1.0.0 Executing command dbhome patch --help dbHome patch - patches the dbhome from one patch level to another. Usage: dbaascli dbHome patch --targetVersion { --oracleHome | --oracleHomeName } [--imageFilePath ] [--executePrereqs] [--nodes ] { [--resume [--sessionID ]] | [--rollback [--sessionID ]] } [--skipDatapatch] [--skipClosedPDBs] [--skipPDBs ] [--continueWithDbDowntime] [--skipUnreachableNodes] [--waitForCompletion ] Where: --targetVersion - target version to be patched to, specified as five numeric segments separated by periods (e.g. 19.12.0.0.0). --oracleHome | --oracleHomeName --oracleHome - Oracle home path. --oracleHomeName - Oracle home name. [--imageFilePath - absolute path of the image file to be used. ] [--executePrereqs - run the prerequisite checks and report the results. ] [--nodes - comma separated list of nodes if operation has to be performed on subset of nodes. ] [--resume | --rollback] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--rollback - option to rollback patched Oracle home. ] [--sessionID - to resume a specific session id.] [--skipDatapatch - option to skip running datapatch on the databases. ] [--skipClosedPDBs - option to skip running datapatch on closed PDBs. ] [--skipPDBs - option to skip running datapatch on given PDBs. Example: cdb1:pdb1,cdb2:pdb2... ] [--continueWithDbDowntime - option to continue patching with database downtime. This option can be used in environments where there is only 1 active instance running and the patching operation can be continued even with downtime.] [--skipUnreachableNodes - option to skip operation on unreachable nodes. ] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] 152 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)事前確認 dbaascli dbhome patch --executePrereqs [root@vmem-6gl0h1 ~]# dbaascli dbhome patch --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_4 --targetVersion 19.21.0.0.0 --executePrereqs DBAAS CLI version 23.4.1.0.0 Executing command dbhome patch --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_4 --targetVersion 19.21.0.0.0 --executePrereqs Job id: 69e14da1-c965-44c1-97cc-857391ee9665 Session log: /var/opt/oracle/log/dbHome/patch/dbaastools_2023-11- 21_02-01-32-PM_85342.log Loading PILOT... Session ID of the current execution is: 1165 Log file location: /var/opt/oracle/log/dbHome/patch/pilot_2023-11- 21_02-01-36-PM_86313 Running initialization job Completed initialization job Running validate_user_input job Completed validate_user_input job Running validate_nodes job Completed validate_nodes job Running validate_oracle_home job Completed validate_oracle_home job Running validate_source_version job Completed validate_source_version job Running validate_target_version job Completed validate_target_version job ----------------- Running validate_creg_file_existence job Completed validate_creg_file_existence job ----------------- Running validate_diag_perm job Completed validate_diag_perm job ----------------- Running validate_backup_loc job Completed validate_backup_loc job ----------------- Running validate_patch_across_nodes job Completed validate_patch_across_nodes job ----------------- Running validate_databases job Completed validate_databases job ----------------- Running validate_users_umask job Completed validate_users_umask job 153 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)事前確認 dbaascli dbhome patch --executePrereqs <続き> Running validate_gold_image_url job Completed validate_gold_image_url job Running validate_disk_space job Completed validate_disk_space job Running validate_audit_files_in_source_home job Completed validate_audit_files_in_source_home job Running download_gold_image job Completed download_gold_image job Running validate_gold_image job Completed validate_gold_image job Running run_installer_prereqs job Completed run_installer_prereqs job Running check_patch_conflict job Completed check_patch_conflict job Running remove_unzip_loc job Completed remove_unzip_loc job dbaascli execution completed 154 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤ dbaascli dbhome patch [root@vmem-6gl0h1 ~]# dbaascli dbhome patch --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_4 --targetVersion 19.21.0.0.0 DBAAS CLI version 23.4.1.0.0 Executing command dbhome patch --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_4 --targetVersion 19.21.0.0.0 Job id: d086529e-2cf6-47b1-8a7e-f29e03de71b0 Session log: /var/opt/oracle/log/dbHome/patch/dbaastools_2023-11- 21_02-08-28-PM_148985.log Loading PILOT... Session ID of the current execution is: 1166 Log file location: /var/opt/oracle/log/dbHome/patch/pilot_2023-11- 21_02-08-32-PM_149942 ----------------- Running initialization job Completed initialization job ----------------- Running validate_user_input job Completed validate_user_input job ----------------- Running validate_nodes job Completed validate_nodes job ----------------- Running validate_oracle_home job Completed validate_oracle_home job ----------------- Running validate_source_version job Completed validate_source_version job ----------------- Running validate_target_version job Completed validate_target_version job ----------------- Running validate_creg_file_existence job Completed validate_creg_file_existence job ----------------- Running validate_diag_perm job Completed validate_diag_perm job ----------------- Running validate_backup_loc job Completed validate_backup_loc job ----------------- Running validate_patch_across_nodes job Completed validate_patch_across_nodes job ----------------- Running validate_databases job Completed validate_databases job ----------------- Running validate_users_umask job Completed validate_users_umask job ----------------- Running validate_gold_image_url job Completed validate_gold_image_url job ----------------- Running validate_disk_space job Completed validate_disk_space job ----------------- Running validate_audit_files_in_source_home job Completed validate_audit_files_in_source_home job ----------------- Running download_gold_image job Completed download_gold_image job ----------------- <> 155 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤ dbaascli dbhome patch <続き> Running validate_gold_image job Completed validate_gold_image job ----------------- Running update_inventory-vmem-6gl0h1 job Completed update_inventory-vmem-6gl0h1 job Running run_installer_prereqs job Completed run_installer_prereqs job Running root_script_execution-vmem-6gl0h1 job Completed root_script_execution-vmem-6gl0h1 job Running check_patch_conflict job Completed check_patch_conflict job Acquiring write lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 ----------------- Running pre_patch_lock_manager job Completed pre_patch_lock_manager job ----------------- Running copy_image-vmem-6gl0h1 job Completed copy_image-vmem-6gl0h1 job ----------------- Running stop_database_instance-vmem-6gl0h1 job Completed stop_database_instance-vmem-6gl0h1 job ----------------- Running detach_home-vmem-6gl0h1 job Completed detach_home-vmem-6gl0h1 job ----------------- Running move_home-vmem-6gl0h1 job Completed move_home-vmem-6gl0h1 job ----------------- Running move_image_to_home_loc-vmem-6gl0h1 job Completed move_image_to_home_loc-vmem-6gl0h1 job ----------------- Running setup_db_home-vmem-6gl0h1 job Completed setup_db_home-vmem-6gl0h1 job Running copy_home_to_backup_loc-vmem-6gl0h1 job Completed copy_home_to_backup_loc-vmem-6gl0h1 job ----------------- Running move_config_files-vmem-6gl0h1 job Completed move_config_files-vmem-6gl0h1 job ----------------- Running start_database_instance-vmem-6gl0h1 job Completed start_database_instance-vmem-6gl0h1 job ----------------- Running exacs_post_patch_node_updation-vmem-6gl0h1 job Completed exacs_post_patch_node_updation-vmem-6gl0h1 job ----------------- Running copy_image-vmem-6gl0h2 job Completed copy_image-vmem-6gl0h2 job ----------------- Running stop_database_instance-vmem-6gl0h2 job Completed stop_database_instance-vmem-6gl0h2 job ----------------- Running move_home-vmem-6gl0h2 job Completed move_home-vmem-6gl0h2 job ----------------- Running setup_db_home-vmem-6gl0h2 job Completed setup_db_home-vmem-6gl0h2 job ----------------- <> 156 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤ dbaascli dbhome patch <続き> Running update_inventory-vmem-6gl0h2 job Completed update_inventory-vmem-6gl0h2 job ----------------- Running root_script_execution-vmem-6gl0h2 job Completed root_script_execution-vmem-6gl0h2 job ----------------- Running move_config_files-vmem-6gl0h2 job Completed move_config_files-vmem-6gl0h2 job ----------------- Running start_database_instance-vmem-6gl0h2 job Completed start_database_instance-vmem-6gl0h2 job ----------------- Running exacs_post_patch_node_updation-vmem-6gl0h2 job Completed exacs_post_patch_node_updation-vmem-6gl0h2 job ----------------- Running post_patch_lock_manager job Completed post_patch_lock_manager job Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 ----------------- Running cleanup job Completed cleanup job ----------------- Running generate_dbsystem_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed generate_dbsystem_details job dbaascli execution completed Running remove_home_from_backup_loc job Completed remove_home_from_backup_loc job Running datapatch_and_recompile_invalid_objects job Datapatch execution on database 'Tutorial' is in progress Datapatch execution on database 'Tutorial' is complete Recompilation of invalid objects on database 'Tutorial' is in progress Recompilation of invalid objects on database 'Tutorial' is complete Completed datapatch_and_recompile_invalid_objects job Running backup_old_home job Completed backup_old_home job 157 varchar2 dbaascliを使⽤したデータベース・ホームへのパッチ適⽤ 再開 dbaascli dbhome patch --resume [root@vmem-6gl0h1 opc]# dbaascli dbhome patch --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_4 --targetVersion 19.20.0.0.0 --resume DBAAS CLI version 23.4.1.0.0 Executing command dbhome patch --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_4 --targetVersion 19.20.0.0.0 --resume Job id: 7255a0a9-82ce-47f0-bac9-e5e202490a61 Session log: /var/opt/oracle/log/dbHome/patch/dbaastools_2023-11- 16_04-03-10-PM_355722.log Loading PILOT... Session ID of the current execution is: 898 Log file location: /var/opt/oracle/log/dbHome/patch/pilot_2023-11- 16_04-03-14-PM_356469 ----------------- Running initialization job Completed initialization job Running validate_audit_files_in_source_home job Completed validate_audit_files_in_source_home job ----------------- Running download_gold_image job Completed download_gold_image job ----------------- Running validate_gold_image job Completed validate_gold_image job ----------------- Running run_installer_prereqs job Completed run_installer_prereqs job ----------------- Running check_patch_conflict job Completed check_patch_conflict job Acquiring write lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 Running validate_disk_space job Completed validate_disk_space job Running pre_patch_lock_manager job Completed pre_patch_lock_manager job 158 varchar2 dbaascliを使⽤したデータベース・ホームへのパッチ適⽤ 再開 dbaascli dbhome patch --resume Running copy_image-vmem-6gl0h1 job Completed copy_image-vmem-6gl0h1 job Running root_script_execution-vmem-6gl0h1 job Completed root_script_execution-vmem-6gl0h1 job Running stop_database_instance-vmem-6gl0h1 job Completed stop_database_instance-vmem-6gl0h1 job Running copy_home_to_backup_loc-vmem-6gl0h1 job Completed copy_home_to_backup_loc-vmem-6gl0h1 job Running detach_home-vmem-6gl0h1 job Completed detach_home-vmem-6gl0h1 job Running move_config_files-vmem-6gl0h1 job Completed move_config_files-vmem-6gl0h1 job Running move_home-vmem-6gl0h1 job Completed move_home-vmem-6gl0h1 job Running start_database_instance-vmem-6gl0h1 job Completed start_database_instance-vmem-6gl0h1 job Running move_image_to_home_loc-vmem-6gl0h1 job Completed move_image_to_home_loc-vmem-6gl0h1 job Running exacs_post_patch_node_updation-vmem-6gl0h1 job Completed exacs_post_patch_node_updation-vmem-6gl0h1 job Running setup_db_home-vmem-6gl0h1 job Completed setup_db_home-vmem-6gl0h1 job Running copy_image-vmem-6gl0h2 job Completed copy_image-vmem-6gl0h2 job Running update_inventory-vmem-6gl0h1 job Completed update_inventory-vmem-6gl0h1 job Running stop_database_instance-vmem-6gl0h2 job Completed stop_database_instance-vmem-6gl0h2 job 159 varchar2 Running dbaascliを使⽤したデータベース・ホームへのパッチ適⽤ 再開 dbaascli dbhome patch --resume Running move_home-vmem-6gl0h2 job Completed move_home-vmem-6gl0h2 job ----------------- Running setup_db_home-vmem-6gl0h2 job Completed setup_db_home-vmem-6gl0h2 job ----------------- Running update_inventory-vmem-6gl0h2 job Completed update_inventory-vmem-6gl0h2 job ----------------- Running root_script_execution-vmem-6gl0h2 job Completed root_script_execution-vmem-6gl0h2 job ----------------- Running move_config_files-vmem-6gl0h2 job Completed move_config_files-vmem-6gl0h2 job Running remove_home_from_backup_loc job Completed remove_home_from_backup_loc job Running datapatch_and_recompile_invalid_objects job Datapatch execution on database 'Tutorial' is in progress Datapatch execution on database 'Tutorial' is complete Recompilation of invalid objects on database 'Tutorial' is in progress Recompilation of invalid objects on database 'Tutorial' is complete Completed datapatch_and_recompile_invalid_objects job ----------------- Running backup_old_home job Completed backup_old_home job ----------------- Running post_patch_lock_manager job Completed post_patch_lock_manager job Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 Running start_database_instance-vmem-6gl0h2 job Completed start_database_instance-vmem-6gl0h2 job Running cleanup job Completed cleanup job Running exacs_post_patch_node_updation-vmem-6gl0h2 job Completed exacs_post_patch_node_updation-vmem-6gl0h2 job ----------------- 160 varchar2 Running generate_dbsystem_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed generate_dbsystem_details job dbaascli execution completed データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後確認 dbaascli dbhome patch [root@vmem-6gl0h1 ~]# dbaascli dbhome info DBAAS CLI version 23.4.1.0.0 Executing command dbhome info [INFO] [DBAAS-14011] - The usage of this command is deprecated. ACTION: It is recommended to use 'dbaascli dbHome getDetails or dbaascli system getDBHomes' for this operation. Enter a homename or just press enter if you want details of all homes 1.HOME_NAME=OraHome6 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_6 VERSION=19.21.0.0 PATCH_LEVEL=19.21.0.0 DBs installed=dbcli01 Agent DB IDs=e1546bda-82ae-4d56-b824-6d3a89e8afeb OH Backup=NOT Configured 2.HOME_NAME=OraHome4 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_4 VERSION=19.21.0.0 PATCH_LEVEL=19.21.0.0 DBs installed=Tutorial Agent DB IDs=56916e81-b9ed-436b-ad80-8c771b24da0a OH Backup=NOT Configured 3.HOME_NAME=OraHome2 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_2 VERSION=19.13.0.0 PATCH_LEVEL=19.13.0.0 DBs installed= OH Backup=NOT Configured 4.HOME_NAME=OraHome3 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_3 VERSION=19.14.0.0 PATCH_LEVEL=19.14.0.0 DBs installed= OH Backup=NOT Configured 5.HOME_NAME=OraHome1 HOME_LOC=/u02/app/oracle/product/19.0.0.0/dbhome_1 VERSION=19.20.0.0 PATCH_LEVEL=19.20.0.0 DBs installed=DBFDSI DB19 Agent DB IDs=2b67088f-a84c-4b70-a2bc-9650d128fa97 d2705e01-7891- 4bf7-8e91-5f01988a5a64 OH Backup=NOT Configure 161 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後確認 dbaascli database getDetails [root@vmem-6gl0h1 ~]# dbaascli database getDetails --dbname Tutorial DBAAS CLI version 23.4.1.0.0 Executing command database getDetails --dbname Tutorial Job id: 7ecf510c-4d24-48b1-85f7-baa324bafc64 Session log: /var/opt/oracle/log/Tutorial/database/getDetails/dbaastools_2023-11- 21_02-52-20-PM_237823.log { "dbSyncTime" : 1700544784902, "createTime" : 1699936138000, "updateTime" : 0, "dbName" : "Tutorial", "dbUniqueName" : "Tutorial_mss_kix", "dbDomain" : "sub04210756190.exavcn.oraclevcn.com", "dbId" : 2483528602, "cpuCount" : 4, "sgaTarget" : "3808MB", "pgaAggregateTarget" : "2500MB", "dbSize" : "51GB", "dbUsedSize" : "12GB", "totalFraSize" : "1162GB", "fraSizeUsed" : "20GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.21.0.0.0", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymb uazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37 iydjpezoghgmh7a", "resourceOCID" : "ocid1.database.oc1.ap-osaka- 1.anvwsljrssl65iqa4xs42liz2sz7v7723vynynp7w4uyvhs7nmm7ze6tf6aa", "resourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a", "resourceType" : "CDB", "parentResourceID" : null }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "AdyFgnerrE/+v3zjE/rRJJAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "instanceName" : "Tutorial1", "version" : "19.21.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" }, 162 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後確認 dbaascli database getDetails <続き> "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "instanceName" : "Tutorial2", "version" : "19.21.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" } }, "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "1370933588", "cdbId" : "56916e81-b9ed-436b-ad80-8c771b24da0a", "refreshablePDB" : false, "refreshMode" : null, "refreshIntervalInMinutes" : null, "cpuCount" : 4, "storageAllocated" : "UNLIMITED", "storageUsed" : "8544MB", "guid" : "0A165E6D95AD5FF4E0639500000AC2B9", "dbid" : "1370933588", "conId" : "3", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5 tkguca", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkg uca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezo ghgmh7a", "resourceOCID" : "ocid1.pluggabledatabase.oc1.ap-osaka- 1.anvwsljrssl65iqa7h7mkmvvk356cz3u3x3kbojiorfrsgdu6ccmgv3gvaia", "resourceID" : "1370933588", "resourceType" : "PDB", "parentResourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a" }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "ARbiuLLc6086v+JmNfEoia8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjp ezoghgmh7a", 163 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後確認 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後確認 "pdbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "openMode" : "READ_WRITE", "restricted" : false }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "openMode" : "READ_WRITE", "restricted" : false "pdbSize" : "8GB", "pdbUsedSize" : "1GB", "pdbSnapshotDetails" : null } }, "messages" : [ ] } dbaascli execution completed } }, "pdbConnectStrings" : [ { "serviceName" : "Tutorial_PDB1.paas.oracle.com", "connectString" : "vmem-6gl0h- scan.sub04210756190.exavcn.oraclevcn.com:1521/Tutorial_PDB1.paas.orac le.com", "tcpsConnectStrings" : [ "vmem-6gl0h- scan.sub04210756190.exavcn.oraclevcn.com:2484/Tutorial_PDB1.paas.orac le.com" ] } ], 164 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後 ロールバック データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後確認 Running validate_nodes job Completed validate_nodes job ----------------- Running validate_oracle_home job Completed validate_oracle_home job Session log: /var/opt/oracle/log/dbHome/patch/dbaastools_2023-11-21_02-56- 27-PM_318459.log Loading PILOT... Session ID of the current execution is: 1170 Log file location: /var/opt/oracle/log/dbHome/patch/pilot_2023-11-21_02- 56-32-PM_319554 ----------------- Running initialization job Completed initialization job ----------------- Running validate_user_input job Completed validate_user_input job ----------------- Running validate_creg_file_existence job Completed validate_creg_file_existence job ----------------- Running validate_diag_perm job Completed validate_diag_perm job ----------------- Running validate_backup_loc job Completed validate_backup_loc job ----------------- Running validate_patch_across_nodes job Completed validate_patch_across_nodes job ----------------- Running validate_databases job Completed validate_databases job 165 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後 ロールバック データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後確認 Running validate_users_umask job Completed validate_users_umask job Running pre_patch_lock_manager job Completed pre_patch_lock_manager job Running validate_gold_image_url job Completed validate_gold_image_url job Running copy_image-vmem-6gl0h1 job Completed copy_image-vmem-6gl0h1 job Running validate_disk_space job Completed validate_disk_space job Running stop_database_instance-vmem-6gl0h1 job Completed stop_database_instance-vmem-6gl0h1 job Running validate_audit_files_in_source_home job Completed validate_audit_files_in_source_home job Running detach_home-vmem-6gl0h1 job Completed detach_home-vmem-6gl0h1 job Running download_gold_image job Skipping. Job is detected as not applicable. Running move_home-vmem-6gl0h1 job Completed move_home-vmem-6gl0h1 job Running validate_gold_image job Completed validate_gold_image job Running move_image_to_home_loc-vmem-6gl0h1 job Completed move_image_to_home_loc-vmem-6gl0h1 job Running run_installer_prereqs job Completed run_installer_prereqs job Acquiring write lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 Running setup_db_home-vmem-6gl0h1 job Completed setup_db_home-vmem-6gl0h1 job ----------------- 166 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後 ロールバック データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後確認 Running update_inventory-vmem-6gl0h1 job Completed update_inventory-vmem-6gl0h1 job Running stop_database_instance-vmem-6gl0h2 job Completed stop_database_instance-vmem-6gl0h2 job Running root_script_execution-vmem-6gl0h1 job Completed root_script_execution-vmem-6gl0h1 job Running move_home-vmem-6gl0h2 job Completed move_home-vmem-6gl0h2 job Running copy_home_to_backup_loc-vmem-6gl0h1 job Completed copy_home_to_backup_loc-vmem-6gl0h1 job Running setup_db_home-vmem-6gl0h2 job Completed setup_db_home-vmem-6gl0h2 job Running move_config_files-vmem-6gl0h1 job Completed move_config_files-vmem-6gl0h1 job Running update_inventory-vmem-6gl0h2 job Completed update_inventory-vmem-6gl0h2 job Running start_database_instance-vmem-6gl0h1 job Completed start_database_instance-vmem-6gl0h1 job Running root_script_execution-vmem-6gl0h2 job Completed root_script_execution-vmem-6gl0h2 job Running exacs_post_patch_node_updation-vmem-6gl0h1 job Completed exacs_post_patch_node_updation-vmem-6gl0h1 job Running move_config_files-vmem-6gl0h2 job Completed move_config_files-vmem-6gl0h2 job Running copy_image-vmem-6gl0h2 job Completed copy_image-vmem-6gl0h2 job Running start_database_instance-vmem-6gl0h2 job Completed start_database_instance-vmem-6gl0h2 job 167 varchar2 データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後 ロールバック データベースホームへのパッチ適⽤(インプレース・パッチ適⽤)適⽤後確認 Running exacs_post_patch_node_updation-vmem-6gl0h2 job Completed exacs_post_patch_node_updation-vmem-6gl0h2 job ----------------- Running remove_home_from_backup_loc job Completed remove_home_from_backup_loc job ----------------- Running datapatch_and_recompile_invalid_objects job Datapatch execution on database 'Tutorial' is in progress Datapatch execution on database 'Tutorial' is complete Recompilation of invalid objects on database 'Tutorial' is in progress Recompilation of invalid objects on database 'Tutorial' is complete Completed datapatch_and_recompile_invalid_objects job Running post_patch_lock_manager job Completed post_patch_lock_manager job Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 ----------------- Running cleanup job Completed cleanup job ----------------- Running generate_dbsystem_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed generate_dbsystem_details job dbaascli execution completed 168 varchar2 Oracle Databasesへのアウトオブプレースパッチ適 ⽤ 169 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)コマンド⼀覧 dbaascli database move --help [root@vmem-6gl0h1 ~]# dbaascli database move --help DBAAS CLI version 23.4.1.0.0 Executing command database move --help database move - move DB from one home to another home. Usage: dbaascli database move { --oracleHome | --oracleHomeName } --dbname [--executePrereqs] { [--resume [--sessionID ]] | [--rollback [--sessionID ]] } [--skipDatapatch] [--skipPDBs ] [--skipClosedPDBs] [--continueWithDbDowntime] [--allowParallelDBMove] [--waitForCompletion ] [--nodeList ] Where: --oracleHome | --oracleHomeName --oracleHome - Oracle home path. --oracleHomeName - Oracle home name. --dbname - Oracle database name. [--executePrereqs - run the prerequisite checks and report the results. ] [--resume | --rollback] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--rollback - option to rollback database to previous home. ] [--sessionID - to resume a specific session id.] [--skipDatapatch - option to skip running datapatch on the databases. ] [--skipPDBs - option to skip patching on given PDBs. Example: pdb1,pdb2... ] [--skipClosedPDBs - option to skip patching on closed PDBs. ] [--continueWithDbDowntime - option to continue patching with database downtime. This option can be used in environments where there is only 1 active instance running and the patching operation can be continued even with downtime.] [--allowParallelDBMove - option to allow database move in parallel. ] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [--nodeList - comma separated list of nodes if operation has to be performed on subset of nodes. ] 170 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)現状確認 dbaascli database move [root@vmem-6gl0h1 ~]# dbaascli database getDetails --dbname Tutorial DBAAS CLI version 23.4.1.0.0 Executing command database getDetails --dbname Tutorial Job id: d6028009-c39b-4267-82d9-cb134d883acb Session log: /var/opt/oracle/log/Tutorial/database/getDetails/dbaastools_2023-11- 21_03-21-04-PM_165778. { "dbSyncTime" : 1700546894660, "createTime" : 1699936138000, "updateTime" : 0, "dbName" : "Tutorial", "dbUniqueName" : "Tutorial_mss_kix", "dbDomain" : "sub04210756190.exavcn.oraclevcn.com", "dbId" : 2483528602, "cpuCount" : 4, "sgaTarget" : "3808MB", "pgaAggregateTarget" : "2500MB", "dbSize" : "51GB", "dbUsedSize" : "12GB", "totalFraSize" : "1162GB", "fraSizeUsed" : "20GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.20.0.0.0", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymb uazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37 iydjpezogh "resourceOCID" : "ocid1.database.oc1.ap-osaka- 1.anvwsljrssl65iqa4xs42liz2sz7v7723vynynp7w4uyvhs7nmm "resourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a", "resourceType" : "CDB", "parentResourceID" : null }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "AdyFgnerrE/+v3zjE/rRJJAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, 171 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)現状確認 dbaascli database move "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "instanceName" : "Tutorial1", "version" : "19.20.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "instanceName" : "Tutorial2", "version" : "19.20.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" } }, "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "1370933588", "cdbId" : "56916e81-b9ed-436b-ad80-8c771b24da0a", "refreshablePDB" : false, "refreshMode" : null, "refreshIntervalInMinutes" : null, "cpuCount" : 4, "storageAllocated" : "UNLIMITED", "storageUsed" : "8544MB", "guid" : "0A165E6D95AD5FF4E0639500000AC2B9", "dbid" : "1370933588", "conId" : "3", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymb uazc5tkguc "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37 iydjpe "resourceOCID" : "ocid1.pluggabledatabase.oc1.ap-osaka- 1.anvwsljrssl65iqa7h7mkmvvk356cz3u3x3kbo "resourceID" : "1370933588", "resourceType" : "PDB", "parentResourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a" 172 varchar2 }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "ARbiuLLc6086v+JmNfEoia8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)現状確認 dbaascli database move "pdbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "openMode" : "READ_WRITE", "restricted" : false }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "openMode" : "READ_WRITE", "restricted" : false } }, "pdbConnectStrings" : [ { "serviceName" : "Tutorial_PDB1.paas.oracle.com", "connectString" : "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:1521/Tutorial_PDB1.paas. "tcpsConnectStrings" : [ "vmem-6gl0h-scan.sub04210756190.exavcn.oraclevcn.com:2484/Tutorial_PDB } ], "pdbSize" : "8GB", "pdbUsedSize" : "1GB", "pdbSnapshotDetails" : null } }, "messages" : [ ] } dbaascli execution completed 173 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)現状確認 dbaascli database move 移動先の DBHOME の確認 [root@vmem-6gl0h1 ~]# dbaascli system getDBHomes DBAAS CLI version 23.4.1.0.0 Executing command system getDBHomes Job id: a061464e-8d74-4d0d-ab6c-08e359d9a108 Session log: /var/opt/oracle/log/system/getDBHomes/dbaastools_2023- 11-21_03-29-34-PM_272098.log { "OraHome1" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "homeName" : "OraHome1", "version" : "19.20.0.0.0", "createTime" : 1697764298000, "updateTime" : 1697765609000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.20.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.20.0.0.0" } }, "messages" : [ ] }, "OraHome2" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_2", "homeName" : "OraHome2", "version" : "19.13.0.0.0", "createTime" : 1697776609000, "updateTime" : 1697777833000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.13.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.13.0.0.0" } }, "messages" : [ ] }, "OraHome3" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_3", "homeName" : "OraHome3", "version" : "19.14.0.0.0", "createTime" : 1697786065000, "updateTime" : 1697786065000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.14.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.14.0.0.0" } }, 174 varchar2 "messages" : [ ] }, データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)現状確認 dbaascli database move 移動先の DBHOME の確認 "OraHome4" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "homeName" : "OraHome4", "version" : "19.20.0.0.0", "createTime" : 1699923823000, "updateTime" : 1700546433000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.20.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.20.0.0.0" } }, "messages" : [ ] }, " "OraHome6" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_6", "homeName" : "OraHome6", "version" : "19.21.0.0.0", "createTime" : 1700455140000, "updateTime" : 1700474635000, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "version" : "19.21.0.0.0" }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "version" : "19.21.0.0.0" } }, "messages" : [ ] } } dbaascli execution completed 175 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)適⽤ dbaascli database move [root@vmem-6gl0h1 ~]# dbaascli database move --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 --dbname Tutorial DBAAS CLI version 23.4.1.0.0 Executing command database move --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 --dbname Tutorial Job id: c1b726e7-89af-4846-adab-d72533630f7e Session log: /var/opt/oracle/log/Tutorial/database/move/dbaastools_2023-11-21_03- 33-09-PM_304389.log Loading PILOT... Session ID of the current execution is: 1172 Log file location: /var/opt/oracle/log/Tutorial/database/move/pilot_2023-11-21_03-33-14- PM_305034 Running validate_major_version job Completed validate_major_version job ----------------- Running validate_oracle_home_type job Completed validate_oracle_home_type job ----------------- Running check_target_source_home_not_same job Completed check_target_source_home_not_same job ----------------- Running validate_home_existence job Completed validate_home_existence job ----------------- Running validate_home_consistency job Completed validate_home_consistency job Running initialization job Completed initialization job Running validate_home_options job Completed validate_home_options job Running validate_user_input job Completed validate_user_input job ----------------- Running validate_database job Completed validate_database job Running validate_disk_space job Completed validate_disk_space job Acquiring write lock: tutorial Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_6 Running validate_creg_file_existence job Completed validate_creg_file_existence job Running pre_patch_lock_manager job Completed pre_patch_lock_manager job Running validate_source_home job Completed validate_source_home job Running copy_config_files job Completed copy_config_files job 176 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)適⽤ dbaascli database move Running stop_database_instance-vmem-6gl0h1 job Completed stop_database_instance-vmem-6gl0h1 job ----------------- Running update_database_resource-vmem-6gl0h1 job Completed update_database_resource-vmem-6gl0h1 job ----------------- Running start_database_instance-vmem-6gl0h1 job Completed start_database_instance-vmem-6gl0h1 job ----------------- Running stop_database_instance-vmem-6gl0h2 job Completed stop_database_instance-vmem-6gl0h2 job ----------------- Running update_database_resource-vmem-6gl0h2 job Completed update_database_resource-vmem-6gl0h2 job ----------------- Running start_database_instance-vmem-6gl0h2 job Completed start_database_instance-vmem-6gl0h2 job ----------------- Running exacs_post_patch_node_updation job Completed exacs_post_patch_node_updation job ----------------- Running update_dba_directories job Completed update_dba_directories job ----------------- Running datapatch_and_recompile_invalid_objects job Datapatch execution on database 'Tutorial' is in progress Datapatch execution on database 'Tutorial' is complete Recompilation of invalid objects on database 'Tutorial' is in progress Recompilation of invalid objects on database 'Tutorial' is complete Completed datapatch_and_recompile_invalid_objects job ----------------- Running post_patch_lock_manager job Completed post_patch_lock_manager job Releasing lock: tutorial Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_6 ----------------- Running invoke_backup_asst job Completed invoke_backup_asst job ----------------- Running post_move_validation job Completed post_move_validation job ----------------- Running generate_dbsystem_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed generate_dbsystem_details job dbaascli execution completed 177 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)適⽤後確認 dbaascli database move [root@vmem-6gl0h1 ~]# dbaascli database getDetails --dbname Tutorial DBAAS CLI version 23.4.1.0.0 Executing command database getDetails --dbname Tutorial Job id: beaf2d8a-ab11-42fe-b991-c20f43e607d7 Session log: /var/opt/oracle/log/Tutorial/database/getDetails/dbaastools_2023-11- 21_03-44-33-PM_59171.log { "dbSyncTime" : 1700548919945, "createTime" : 1699936138000, "updateTime" : 0, "dbName" : "Tutorial", "dbUniqueName" : "Tutorial_mss_kix", "dbDomain" : "sub04210756190.exavcn.oraclevcn.com", "dbId" : 2483528602, "cpuCount" : 4, "sgaTarget" : "3808MB", "pgaAggregateTarget" : "2500MB", "dbSize" : "55GB", "dbUsedSize" : "12GB", "totalFraSize" : "1162GB", "fraSizeUsed" : "21GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.21.0.0.0", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymb uazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37 iydjpezoghgmh7a", "resourceOCID" : "ocid1.database.oc1.ap-osaka- 1.anvwsljrssl65iqa4xs42liz2sz7v7723vynynp7w4uyvhs7nmm7ze6tf6aa", "resourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a", "resourceType" : "CDB", "parentResourceID" : null }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "AdyFgnerrE/+v3zjE/rRJJAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "instanceName" : "Tutorial1", "version" : "19.21.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_6", "status" : "OPEN" 178 varchar2 }, データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)適⽤後確認 dbaascli database move "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "instanceName" : "Tutorial2", "version" : "19.21.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_6", "status" : "OPEN" } }, "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "1370933588", "cdbId" : "56916e81-b9ed-436b-ad80-8c771b24da0a", "refreshablePDB" : false, "refreshMode" : null, "refreshIntervalInMinutes" : null, "cpuCount" : 4, "storageAllocated" : "UNLIMITED", "storageUsed" : "8544MB", "guid" : "0A165E6D95AD5FF4E0639500000AC2B9", "dbid" : "1370933588", "conId" : "3", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkgu ca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezog hgmh7a", "resourceOCID" : "ocid1.pluggabledatabase.oc1.ap-osaka- 1.anvwsljrssl65iqa7h7mkmvvk356cz3u3x3kbojiorfrsgdu6ccmgv3gvaia", "resourceID" : "1370933588", "resourceType" : "PDB", "parentResourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a" "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "ARbiuLLc6086v+JmNfEoia8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "pdbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "openMode" : "READ_WRITE", "restricted" : false }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "openMode" : "READ_WRITE", "restricted" : false } }, "pdbConnectStrings" : [ { "serviceName" : "Tutorial_PDB1.paas.oracle.com", "connectString" : "vmem-6gl0h- scan.sub04210756190.exavcn.oraclevcn.com:1521/Tutorial_PDB1.paas.oracle.com", "tcpsConnectStrings" : [ "vmem-6gl0h- scan.sub04210756190.exavcn.oraclevcn.com:2484/Tutorial_PDB1.paas.oracle.com" ] } ], "pdbSize" : "8GB", "pdbUsedSize" : "1GB", "pdbSnapshotDetails" : null } }, "messages" : [ ] } dbaascli execution completed },179 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)適⽤後ロールバック dbaascli database move [root@vmem-6gl0h1 ~]# dbaascli database move --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 --dbname Tutorial -- rollback DBAAS CLI version 23.4.1.0.0 Executing command database move --oracleHome /u02/app/oracle/product/19.0.0.0/dbhome_6 --dbname Tutorial -- rollback Job id: 31050e2b-b205-4a16-9d7c-dac5275dff5e Session log: /var/opt/oracle/log/Tutorial/database/move/dbaastools_2023-11-21_03- 47-32-PM_89169.log Loading PILOT... Session ID of the current execution is: 1173 Log file location: /var/opt/oracle/log/Tutorial/database/move/pilot_2023-11-21_03-47-37- PM_91117 Running validate_oracle_home_type job Completed validate_oracle_home_type job ----------------- Running check_target_source_home_not_same job Completed check_target_source_home_not_same job ----------------- Running validate_home_existence job Completed validate_home_existence job ----------------- Running validate_home_consistency job Completed validate_home_consistency job Running initialization job Completed initialization job ----------------- Running validate_user_input job Completed validate_user_input job ----------------- Running validate_database job Completed validate_database job ----------------- Running validate_creg_file_existence job Completed validate_creg_file_existence job ----------------- Running validate_source_home job Completed validate_source_home job Running validate_home_options job Completed validate_home_options job ----------------- Running validate_disk_space job Completed validate_disk_space job Acquiring write lock: tutorial Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_6 Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 ----------------- 180 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)適⽤後ロールバック dbaascli database move Running pre_patch_lock_manager job Completed pre_patch_lock_manager job ----------------- Running copy_config_files job Completed copy_config_files job ----------------- Running stop_database_instance-vmem-6gl0h1 job Completed stop_database_instance-vmem-6gl0h1 job ----------------- Running update_database_resource-vmem-6gl0h1 job Completed update_database_resource-vmem-6gl0h1 job ----------------- Running start_database_instance-vmem-6gl0h1 job Completed start_database_instance-vmem-6gl0h1 job ----------------- Running stop_database_instance-vmem-6gl0h2 job Completed stop_database_instance-vmem-6gl0h2 job ----------------- Running update_database_resource-vmem-6gl0h2 job Completed update_database_resource-vmem-6gl0h2 job ----------------- Running start_database_instance-vmem-6gl0h2 job Completed start_database_instance-vmem-6gl0h2 job ----------------- Running exacs_post_patch_node_updation job Completed exacs_post_patch_node_updation job Running datapatch_and_recompile_invalid_objects job Datapatch execution on database 'Tutorial' is in progress Datapatch execution on database 'Tutorial' is complete Recompilation of invalid objects on database 'Tutorial' is in progress Recompilation of invalid objects on database 'Tutorial' is complete Completed datapatch_and_recompile_invalid_objects job ----------------- Running post_patch_lock_manager job Completed post_patch_lock_manager job Releasing lock: tutorial Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_6 Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_4 ----------------- Running invoke_backup_asst job Completed invoke_backup_asst job ----------------- Running post_move_validation job Completed post_move_validation job ----------------- Running generate_dbsystem_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed generate_dbsystem_details job dbaascli execution completed Running update_dba_directories job Completed update_dba_directories job 181 varchar2 データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)適⽤後ロールバック後確認 dbaascli database move [root@vmem-6gl0h1 ~]# dbaascli database getDetails --dbname Tutorial DBAAS CLI version 23.4.1.0.0 Executing command database getDetails --dbname Tutorial Job id: db3787a5-5d7a-48da-827c-bb45a470c975 Session log: /var/opt/oracle/log/Tutorial/database/getDetails/dbaastools_2023-11- 21_04-00-10-PM_287998.log { "dbSyncTime" : 1700549872565, "createTime" : 1699936138000, "updateTime" : 0, "dbName" : "Tutorial", "dbUniqueName" : "Tutorial_mss_kix", "dbDomain" : "sub04210756190.exavcn.oraclevcn.com", "dbId" : 2483528602, "cpuCount" : 4, "sgaTarget" : "3808MB", "pgaAggregateTarget" : "2500MB", "dbSize" : "55GB", "dbUsedSize" : "12GB", "totalFraSize" : "1162GB", "fraSizeUsed" : "22GB", "dbKmsKeyOcid" : null, "isCDB" : true, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.20.0.0.0", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymb uazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37 iydjpezoghgmh7a", "resourceOCID" : "ocid1.database.oc1.ap-osaka- 1.anvwsljrssl65iqa4xs42liz2sz7v7723vynynp7w4uyvhs7nmm7ze6tf6aa", "resourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a", "resourceType" : "CDB", "parentResourceID" : null }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "AdyFgnerrE/+v3zjE/rRJJAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "instanceName" : "Tutorial1", "version" : "19.20.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" 182 varchar2 }, データベースホームへのパッチ適⽤(アウト・オブ・プレース・パッチ適⽤)適⽤後ロールバック後確認 dbaascli database move "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "instanceName" : "Tutorial2", "version" : "19.20.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_4", "status" : "OPEN" } }, "pdbs" : { "PDB1" : { "pdbName" : "PDB1", "pdbUID" : "1370933588", "cdbId" : "56916e81-b9ed-436b-ad80-8c771b24da0a", "refreshablePDB" : false, "refreshMode" : null, "refreshIntervalInMinutes" : null, "cpuCount" : 4, "storageAllocated" : "UNLIMITED", "storageUsed" : "8544MB", "guid" : "0A165E6D95AD5FF4E0639500000AC2B9", "dbid" : "1370933588", "conId" : "3", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezoghgm h7a", "resourceOCID" : "ocid1.pluggabledatabase.oc1.ap-osaka- 1.anvwsljrssl65iqa7h7mkmvvk356cz3u3x3kbojiorfrsgdu6ccmgv3gvaia", "resourceID" : "1370933588", "resourceType" : "PDB", "parentResourceID" : "56916e81-b9ed-436b-ad80-8c771b24da0a" }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "ARbiuLLc6086v+JmNfEoia8AAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "pdbNodeLevelDetails" : { "vmem-6gl0h1" : { "nodeName" : "vmem-6gl0h1", "openMode" : "READ_WRITE", "restricted" : false }, "vmem-6gl0h2" : { "nodeName" : "vmem-6gl0h2", "openMode" : "READ_WRITE", "restricted" : false } }, "pdbConnectStrings" : [ { "serviceName" : "Tutorial_PDB1.paas.oracle.com", "connectString" : "vmem-6gl0h- scan.sub04210756190.exavcn.oraclevcn.com:1521/Tutorial_PDB1.paas.oracle.com", "tcpsConnectStrings" : [ "vmem-6gl0h- scan.sub04210756190.exavcn.oraclevcn.com:2484/Tutorial_PDB1.paas.oracle.com" ] } ], "pdbSize" : "8GB", "pdbUsedSize" : "1GB", "pdbSnapshotDetails" : null } }, "messages" : [ ] } dbaascli execution completed 183 varchar2 Grid Infrastructure へのパッチ適⽤/ロールバック 184 varchar2 グリッド・インフラストラクチャへのパッチ適⽤前の事前チェック dbaascli grid patch --help [root@vmem-6gl0h1 ~]# dbaascli grid patch --help DBAAS CLI version 23.4.1.0.0 Executing command grid patch --help grid patch - patch the Grid Infrastructure to the specified minor version. Usage: dbaascli grid patch { --targetVersion | --targetHome } [--executePrereqs] [--nodeList ] [--continueWithDbDowntime] [--containerURL ] { [--createImage [--createImageDir ]] | [--imageFile ] } [--patchInParallel] { [--resume [--sessionID ]] | [--rollback [--sessionID ]] } [--waitForCompletion ] <> 185 varchar2 グリッド・インフラストラクチャへのパッチ適⽤前の事前チェック dbaascli grid patch --help <続き> Where: --targetVersion | --targetHome --targetVersion - target version to be patched to, specified as five numeric segments separated by periods (e.g. 19.12.0.0.0). --targetHome - fully qualified path of the target Grid Infrastructure home for the out of place patching. [--executePrereqs - run the prerequisite checks and report the results. ] [--nodeList - comma separated list of nodes if patching has to be performed on subset of nodes. ] [--continueWithDbDowntime - option to continue patching with database downtime. This option can be used in environments where there is only 1 active instance running and the patching operation can be continued even with downtime.] [--containerURL - custom URL for fetching Oracle Grid Infrastructure Image. ] [--createImage | --imageFile] [--createImage - create an image from a copy of the active Grid Infrastructure home, patched to the specified target version.] [--createImageDir - fully qualified path of the directory where the image is to be created.] [--imageFile - fully qualified path of the image to be used.] [--patchInParallel - perform the patching of the remote nodes in parallel.] [--resume | --rollback] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--rollback - option to rollback patched OH. ] [--sessionID - to resume a specific session id.] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [root@vmem-6gl0h1 ~]# 186 varchar2 グリッド・インフラストラクチャへのパッチ適⽤前の事前チェックの実⾏ dbaascli grid patch --executePrereqs [root@orakawa-vgfvk1 ~]# dbaascli grid patch --targetversion 19.14.0.0.0 - -executePrereqs DBAAS CLI version 22.1.1.1.0 Executing command grid patch --targetversion 19.14.0.0.0 --executePrereqs ----------------- Setting up parameters... Patch Parameters setup successful. ----------------- Loading PILOT... Session ID of the current execution is: 21 Log file location: /var/opt/oracle/log/gridPatch/pilot_2022-03-28_01-33-05- PM ----------------- Running initialization job Completed initialization job ----------------- Running validate_crs_stack_state job Completed validate_crs_stack_state job ----------------- Running validate_databases job Completed validate_databases job ----------------- Running validate_disk_space job Completed validate_disk_space job ----------------- Running validate_perm_on_dir job Completed validate_perm_on_dir job ----------------- Running validate_users_umask job Completed validate_users_umask job Running validate_nodes job Completed validate_nodes job Running download_patches job Completed download_patches job Running validate_target_version job Completed validate_target_version job Running unpackage_patches job Completed unpackage_patches job Running validate_backup_locations job Completed validate_backup_locations job Running replace_opatch job Completed replace_opatch job Running validate_source_home job Completed validate_source_home job Running validate_patches job Completed validate_patches job Running validate_creg_file_existence job Completed validate_creg_file_existence job Running check_patch_conflicts job Completed check_patch_conflicts job <> 187 varchar2 グリッド・インフラストラクチャへのパッチ適⽤前の事前チェックの実⾏ dbaascli grid patch --executePrereqs <続き> Running restore_opatch_prereqs_only job Completed restore_opatch_prereqs_only job Running cleanup_prereqs_only job Completed cleanup_prereqs_only job Grid Patching Prereqs Execution Successful. [root@orakawa-vgfvk1 ~]# 188 varchar2 dbaascliを使⽤したOracle Grid Infrastructureへのパッチ適⽤ dbaascli grid patch [root@vmem-6gl0h1 opc]# dbaascli grid patch --targetVersion 19.21.0.0.0 DBAAS CLI version 23.4.1.0.0 Executing command grid patch --targetVersion 19.21.0.0.0 Job id: 837916c6-3496-4124-9ff9-48dc55dbe5a0 Session log: /var/opt/oracle/log/grid/patch/dbaastools_2023-11-17_11- 53-52-AM_163990.log Loading PILOT... Session ID of the current execution is: 946 Log file location: /var/opt/oracle/log/grid/patch/pilot_2023-11- 17_11-53-56-AM_164600 Running validate_databases job Completed validate_databases job ----------------- Running validate_disk_space job Completed validate_disk_space job ----------------- Running validate_perm_on_dir job Completed validate_perm_on_dir job ----------------- Running validate_users_umask job Completed validate_users_umask job Running initialization job Completed initialization job Running unpackage_patches job Completed unpackage_patches job Running validate_nodes job Completed validate_nodes job Running remove_zipped_patches job Completed remove_zipped_patches job Running validate_target_version job Completed validate_target_version job Running replace_opatch job Completed replace_opatch job Running validate_backup_locations job Completed validate_backup_locations job ----------------- Running validate_source_home job Completed validate_source_home job ----------------- Running validate_creg_file_existence job Completed validate_creg_file_existence job ----------------- Running validate_crs_stack_state job Completed validate_crs_stack_state job 1--8-9--C-o-p-y-r-ig-h-t-©--2-0-24, Oracle and/or its affiliates, Running check_patch_conflicts job Completed check_patch_conflicts job Acquiring write lock: _u01_app_19.0.0.0_grid Acquiring write lock: provisioning ----------------- Running pre_patch_lock_manager job Completed pre_patch_lock_manager job ----------------- Running create_global_backup_loc job Completed create_global_backup_loc job <> dbaascliを使⽤したOracle Grid Infrastructureへのパッチ適⽤ dbaascli grid patch <続き> ----------------- Running rotate_image_backup job Completed rotate_image_backup job ----------------- Running backup_image job Completed backup_image job Running rollback_conflicting_patches-vmem-6gl0h1 job Completed rollback_conflicting_patches-vmem-6gl0h1 job ----------------- Running apply_gi_oneoffs_prepatch-vmem-6gl0h1 job Completed apply_gi_oneoffs_prepatch-vmem-6gl0h1 job ----------------- Running apply_ru-vmem-6gl0h1 job Completed apply_ru-vmem-6gl0h1 job Running rotate_config_backup job Completed rotate_config_backup job Running stop_processes-vmem-6gl0h1 job Completed stop_processes-vmem-6gl0h1 job Running backup_config-vmem-6gl0h1 job Completed backup_config-vmem-6gl0h1 job Running apply_gi_oneoffs_postpatch-vmem-6gl0h1 job Completed apply_gi_oneoffs_postpatch-vmem-6gl0h1 job Running save_local_backup-vmem-6gl0h1 job Completed save_local_backup-vmem-6gl0h1 job Running rootadd_rdbms_script-vmem-6gl0h1 job Completed rootadd_rdbms_script-vmem-6gl0h1 job Running stop_db_instances-vmem-6gl0h1 job Completed stop_db_instances-vmem-6gl0h1 job Running run_rootcrs_postpatch-vmem-6gl0h1 job Completed run_rootcrs_postpatch-vmem-6gl0h1 job Running run_rootcrs_prepatch-vmem-6gl0h1 job Completed run_rootcrs_prepatch-vmem-6gl0h1 job Running start_db_instances-vmem-6gl0h1 job Completed start_db_instances-vmem-6gl0h1 job Running stop_tfa-vmem-6gl0h1 job Completed stop_tfa-vmem-6gl0h1 job Running update_opatch_log_ownership-vmem-6gl0h1 job Completed update_opatch_log_ownership-vmem-6gl0h1 job Running check_processes-vmem-6gl0h1 job Completed check_processes-vmem-6gl0h1 job Running disable_diagsnap-vmem-6gl0h1 job Completed disable_diagsnap-vmem-6gl0h1 job 190 varchar2 <> dbaascliを使⽤したOracle Grid Infrastructureへのパッチ適⽤ dbaascli grid patch <続き> Running restore_tfa_status-vmem-6gl0h1 job Completed restore_tfa_status-vmem-6gl0h1 job ----------------- Running remove_local_backup-vmem-6gl0h1 job Completed remove_local_backup-vmem-6gl0h1 job ----------------- Running cleanup-vmem-6gl0h1 job Completed cleanup-vmem-6gl0h1 job ----------------- Running backup_config_on_node-vmem-6gl0h2 job Completed backup_config_on_node-vmem-6gl0h2 job ----------------- Running save_local_backup_on_node-vmem-6gl0h2 job Completed save_local_backup_on_node-vmem-6gl0h2 job ----------------- Running stop_db_instances_on_node-vmem-6gl0h2 job Completed stop_db_instances_on_node-vmem-6gl0h2 job ----------------- Running run_rootcrs_prepatch_on_node-vmem-6gl0h2 job Completed run_rootcrs_prepatch_on_node-vmem-6gl0h2 job ----------------- Running stop_tfa_on_node-vmem-6gl0h2 job Completed stop_tfa_on_node-vmem-6gl0h2 job Running stop_processes_on_node-vmem-6gl0h2 job Completed stop_processes_on_node-vmem-6gl0h2 job Running copy_patched_home_from_local_node-vmem-6gl0h2 job Completed copy_patched_home_from_local_node-vmem-6gl0h2 job ----------------- Running unpackage_config_backup_on_node-vmem-6gl0h2 job Completed unpackage_config_backup_on_node-vmem-6gl0h2 job ----------------- Running run_rootcrs_postpatch_on_node-vmem-6gl0h2 job Completed run_rootcrs_postpatch_on_node-vmem-6gl0h2 job ----------------- Running start_db_instances_on_node-vmem-6gl0h2 job Completed start_db_instances_on_node-vmem-6gl0h2 job ----------------- Running disable_diagsnap_on_node-vmem-6gl0h2 job Completed disable_diagsnap_on_node-vmem-6gl0h2 job ----------------- Running restore_tfa_status_on_node-vmem-6gl0h2 job Completed restore_tfa_status_on_node-vmem-6gl0h2 job ----------------- Running remove_local_backup_on_node-vmem-6gl0h2 job Completed remove_local_backup_on_node-vmem-6gl0h2 job ----------------- Running remove_local_patched_home_on_node-vmem-6gl0h2 job Completed remove_local_patched_home_on_node-vmem-6gl0h2 job ----------------- <> Running remove_home_on_node-vmem-6gl0h2 job Completed remove_home_on_node-vmem-6gl0h2 job 191 varchar2 dbaascliを使⽤したOracle Grid Infrastructureへのパッチ適⽤ dbaascli grid patch <続き> Running cleanup_patched_home_backup job Completed cleanup_patched_home_backup job Running post_patch_validation job Completed post_patch_validation job Running update_creg job Completed update_creg job Running post_patch_lock_manager job Completed post_patch_lock_manager job Releasing lock: _u01_app_19.0.0.0_grid Releasing lock: provisioning Running generate_system_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed generate_system_details job dbaascli execution completed 192 varchar2 dbaascliを使⽤したOracle Grid Infrastructureへのパッチ適⽤確認 dbaascli grid patch [grid@vmem-6gl0h1 ~]$ opatch lspatches 35762404;OCW Interim patch for 35762404 35763448;ENFORCE V2 CHECKS ONLY FOR CLIENT CLOUD MNEMONIC QUERIES 34697081;NOT SHIPPING LIBAUTH_SDK_IAM.SO IN 23 SHIPHOME INSTALL 35638318;JDK BUNDLE PATCH 19.0.0.0.231017 35652062;ACFS RELEASE UPDATE 19.21.0.0.0 (35652062) 35643107;Database Release Update : 19.21.0.0.231017 (35643107) 35553096;TOMCAT RELEASE UPDATE 19.0.0.0.0 (35553096) 35099674;DSTV41 UPDATE - TZDATA2022G - NEED OJVM FIX 35050341;OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341) 33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402) OPatch succeeded. 193 varchar2 dbaascliを使⽤したOracle Grid Infrastructureへのパッチのロールバック適⽤ dbaascli grid patch --rollback [opc@vmem-6gl0h1 ~]$ sudo -s [root@vmem-6gl0h1 opc]# dbaascli grid patch --targetVersion 19.21.0.0.0 --rollback DBAAS CLI version 23.4.1.0.0 Executing command grid patch --targetVersion 19.21.0.0.0 --rollback Job id: 740847a4-c20f-4dc9-9486-6c632ce1d548 Session log: /var/opt/oracle/log/grid/patch/dbaastools_2023-11-17_01- 09-55-PM_240689.log Loading PILOT... Session ID of the current execution is: 950 Log file location: /var/opt/oracle/log/grid/patch/pilot_2023-11- 17_01-09-59-PM_241789 ----------------- Running initialization job Completed initialization job ----------------- Running validate_backup_existence job Completed validate_backup_existence job Acquiring write lock: _u01_app_19.0.0.0_grid Acquiring write lock: provisioning Running unpackage_image_backup-vmem-6gl0h2 job Completed unpackage_image_backup-vmem-6gl0h2 job ----------------- Running unpackage_config_backup-vmem-6gl0h2 job Completed unpackage_config_backup-vmem-6gl0h2 job ----------------- Running run_rootcrs_postpatch_for_rollback-vmem-6gl0h2 job Completed run_rootcrs_postpatch_for_rollback-vmem-6gl0h2 job ----------------- Running remove_local_backup_for_rollback-vmem-6gl0h2 job Completed remove_local_backup_for_rollback-vmem-6gl0h2 job ----------------- Running remove_global_config_backup_for_rollback-vmem-6gl0h2 job Completed remove_global_config_backup_for_rollback-vmem-6gl0h2 job ----------------- Running cleanup_for_rollback-vmem-6gl0h2 job Completed cleanup_for_rollback-vmem-6gl0h2 job ----------------- Running save_local_backup_for_rollback-vmem-6gl0h1 job Completed save_local_backup_for_rollback-vmem-6gl0h1 job Running pre_rollback_lock_manager job Completed pre_rollback_lock_manager job Running save_local_backup_for_rollback-vmem-6gl0h2 job Completed save_local_backup_for_rollback-vmem-6gl0h2 job Running run_rootcrs_prepatch_for_rollback-vmem-6gl0h1 job Completed run_rootcrs_prepatch_for_rollback-vmem-6gl0h1 job Running remove_home-vmem-6gl0h1 job Completed remove_home-vmem-6gl0h1 job Running run_rootcrs_prepatch_for_rollback-vmem-6gl0h2 job Completed run_rootcrs_prepatch_for_rollback-vmem-6gl0h2 job Running unpackage_image_backup-vmem-6gl0h1 job Completed unpackage_image_backup-vmem-6gl0h1 job Running remove_home-vmem-6gl0h2 job Completed remove_home-vmem-6gl0h2 job 1--9-4--C-o-p-y-r-ig-h-t-©--2-0-24, Oracle and/or its affiliates, <> dbaascliを使⽤したOracle Grid Infrastructureへのパッチのロールバック適⽤ dbaascli grid patch --rollback <続き> Running unpackage_config_backup-vmem-6gl0h1 job Completed unpackage_config_backup-vmem-6gl0h1 job ----------------- Running run_rootcrs_postpatch_for_rollback-vmem-6gl0h1 job Completed run_rootcrs_postpatch_for_rollback-vmem-6gl0h1 job Running generate_system_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed generate_system_details job dbaascli execution completed Running remove_local_backup_for_rollback-vmem-6gl0h1 job Completed remove_local_backup_for_rollback-vmem-6gl0h1 job Running remove_global_config_backup_for_rollback-vmem-6gl0h1 job Completed remove_global_config_backup_for_rollback-vmem-6gl0h1 job Running cleanup_for_rollback-vmem-6gl0h1 job Completed cleanup_for_rollback-vmem-6gl0h1 job Running cleanup_patched_home_backup_on_rollback job Completed cleanup_patched_home_backup_on_rollback job Running post_rollback_validation job Completed post_rollback_validation job Running update_creg_for_rollback job Completed update_creg_for_rollback job Running post_rollback_lock_manager job Completed post_rollback_lock_manager job Releasing lock: _u01_app_19.0.0.0_grid Releasing lock: provisioning 195 varchar2 dbaascliを使⽤したOracle Grid Infrastructureパッチのロールバック後確認 dbaascli grid patch --rollback [grid@vmem-6gl0h1 ~]$ opatch lspatches 34243634;AIM ORA-600 [ATBMMN 1] - ATBMMN_MAKE_MODV_NULLABLE 34697081;NOT SHIPPING LIBAUTH_SDK_IAM.SO IN 23 SHIPHOME INSTALL 35080170;APPLIANCE.MODE IS DEFAULTED TO FALSE WITH ASM DISKGROUPS ON X10 EF CELLS AND CANNOT BE CHANGED 34993018;CLSF NEEDS TO CHECK I/O OSS ERROR CODE 34975490;14 SECS BLACKOUT WITH GRACEFUL CELL SERVICES SHUTDOWN 34810987;CACHE ASM METADATA IOS INTO EXADATA FLASHCACHE 35309390;OCW Interim patch for 35309390 35099674;DSTV41 UPDATE - TZDATA2022G - NEED OJVM FIX 35004974;JDK BUNDLE PATCH 19.0.0.0.230418 35050341;OJVM RELEASE UPDATE: 19.19.0.0.230418 (35050341) 35107512;TOMCAT RELEASE UPDATE 19.0.0.0.0 (35107512) 35050325;ACFS RELEASE UPDATE 19.19.0.0.0 (35050325) 35042068;Database Release Update : 19.19.0.0.230418 (35042068) 33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402) OPatch succeeded. 196 varchar2 GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli grid getDetails 現状確認 [root@wasa-ycfpo1 ~]# dbaascli grid getDetails DBAAS CLI version 24.1.2.0.0 Executing command grid getDetails Job id: 05f17098-517c-492c-a17a-814a58af0256 Session log: /var/opt/oracle/log/grid/getDetails/dbaastools_2024-04- 23_07-05-09-AM_17538.log { "createTime" : 1697432913000, "updateTime" : 1697432913000, "activeVersion" : "19.0.0.0.0", "state" : "NORMAL", "scanListenerTCPPorts" : [ 1521 ], "scanListenerTCPSPorts" : [ 2484 ], "diskGroupDetails" : [ { "name" : "DATA", "redundancy" : "HIGH", "totalSize" : "4896GB", "freeSpace" : "3146GB" }, { "name" : "RECO", "redundancy" : "HIGH", "totalSize" : "1224GB", "freeSpace" : "607GB" }, { "name" : "SPR", "redundancy" : null, "totalSize" : null, "freeSpace" : null } ], "giNodeLevelDetails" : { "wasa-ycfpo1" : { "nodeName" : "wasa-ycfpo1", "homePath" : "/u01/app/19.0.0.0/grid", "version" : "19.19.0.0.0", "status" : null }, "wasa-ycfpo2" : { "nodeName" : "wasa-ycfpo2", "homePath" : "/u01/app/19.0.0.0/grid", "version" : "19.19.0.0.0", "status" : null } }, "messages" : [ ] } dbaascli execution completed [root@wasa-ycfpo1 ~]# 197 varchar2 GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli grid patch --createImage 空き領域が⾜りないとエラーになる [root@wasa-ycfpo1 ~]# dbaascli grid patch --targetVersion 19.20.0.0.0 --createImage DBAAS CLI version 24.1.2.0.0 Executing command grid patch --targetVersion 19.20.0.0.0 --createImage Job id: b65770e8-920c-4759-b3f8-bc1e60ca3946 Session log: /var/opt/oracle/log/grid/patch/dbaastools_2024-04-23_07-06-46-AM_26993.log Loading PILOT... Session ID of the current execution is: 7227 Log file location: /var/opt/oracle/log/grid/patch/pilot_2024-04-23_07-06-53-AM_28972 Running initialization job Completed initialization job Running validate_target_version job Completed validate_target_version job Running validate_target_image_location job Completed validate_target_image_location job Running validate_backup_locations job Completed validate_backup_locations job Running validate_source job Completed validate_source job Running validate_disk_space job Execution of validate_disk_space failed [FATAL] [DBAAS-60032] Not enough space available on mount point '/acfs01' on node 'wasa-ycfpo1'. CAUSE: Following directory paths ([/var/opt/oracle/dbaas_acfs/exapatch/custom_images, /var/opt/oracle/dbaas_acfs/exapatch/temp_create_loc_2024-04- 23_07-08-41-AM/inventory, /var/opt/oracle/dbaas_acfs/exapatch/temp_create_loc_2024-04-23_07-08-41-AM/base, /var/opt/oracle/dbaas_acfs/exapatch/temp_create_loc_2024-04-23_07-08-41-AM/home]) are mounted on '/acfs01' which requires a free space of 57,633 MB; only 50,163 MB of space is available on the mount point. *** Executing jobs which need to be run always... *** ******** PLUGIN EXECUTION FAILED ******** To resume this failed session, run the following command: GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli cswlib deleteLocal 空き容量を広げる [root@wasa-ycfpo1 ~]# df -Th /acfs01 Filesystem Type Size Used Avail Use% Mounted on /dev/asm/acfsvol01-24 acfs 100G 52G 49G 52% /acfs01 [root@wasa-ycfpo1 ~]# [root@wasa-ycfpo1 dbnid]# ls -lart total 480 drwx------ 2 oracle oinstall 20480 Oct 16 2023 19.18.0.0.0 lrwxrwxrwx 1 oracle oinstall 65 Oct 16 2023 db19000_bits_EXA.zip -> /var/opt/oracle/dbaas_acfs/dbnid/19.18.0.0.0/db19000_bits_EXA.zip drwx------ 2 oracle oinstall 20480 Nov 24 06:10 19.20.0.0.0 drwx------ 2 oracle oinstall 20480 Jan 16 06:24 11.2.0.4.231017 lrwxrwxrwx 1 oracle oinstall 69 Jan 16 06:24 db11204_bits_EXA.zip -> /var/opt/oracle/dbaas_acfs/dbnid/11.2.0.4.231017/db11204_bits_EXA.zip lrwxrwxrwx 1 oracle oinstall 68 Jan 16 06:24 exadbf_11204.tar.gz -> /var/opt/oracle/dbaas_acfs/dbnid/11.2.0.4.231017/exadbf_11204.tar.gz drwx 2 oracle oinstall 20480 Jan 16 06:38 OCT2023 drwx------ 2 oracle oinstall 20480 Mar 7 05:52 19.22.0.0.0 drwxr-xr-x 9 oracle oinstall 20480 Mar 14 01:43 . drwx------ 2 oracle oinstall 20480 Mar 14 01:46 19.21.0.0.0 drwxrwx 2 oracle oinstall 20480 Mar 14 05:44 tmp drwxr-xr-x 30 oracle oinstall 20480 Apr 23 07:02 .. [root@wasa-ycfpo1 dbnid]# du -sh . 27G . [root@wasa-ycfpo1 dbnid]# [root@wasa-ycfpo1 dbnid]# dbaascli cswlib deleteLocal mageTag 19.20.0.0.0 DBAAS CLI version 24.1.2.0.0 Executing command cswlib deleteLocal mageTag 19.20.0.0.0 Job id: ffe3c7ee-d6d6-4f64-9f70-6e2a5569ecc1 Session log: /var/opt/oracle/log/cswLib/deleteLocal/dbaastools_2024-04-23_07-15-59-AM_94033.log Log file location: /var/opt/oracle/log/cswLib/deleteLocal/dbaastools_2024-04-23_07-15-59-AM_94033.log dbaascli execution completed [root@wasa-ycfpo1 dbnid]# du -sh . 22G . [root@wasa-ycfpo1 dbnid]# 199 varchar2 GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli grid patch --createImage [root@wasa-ycfpo1 ~]# dbaascli grid patch --targetVersion 19.20.0.0.0 --createImage DBAAS CLI version 24.1.2.0.0 Executing command grid patch --targetVersion 19.20.0.0.0 -- createImage Job id: 003bbeb3-11aa-4fec-b5d6-69d70a600860 Session log: /var/opt/oracle/log/grid/patch/dbaastools_2024-04-23_07- 19-36-AM_118326.log Loading PILOT... Session ID of the current execution is: 7228 Log file location: /var/opt/oracle/log/grid/patch/pilot_2024-04- 23_07-19-41-AM_118596 ----------------- Running initialization job Completed initialization job ----------------- Running validate_target_version job Completed validate_target_version job ----------------- Running validate_target_image_location job Completed validate_target_image_location job ----------------- Running validate_backup_locations job Completed validate_backup_locations job ----------------- Running validate_source job Completed validate_source job ----------------- Running validate_disk_space job Completed validate_disk_space job ----------------- Running unpackage_patches job Completed unpackage_patches job ----------------- Running create_temp_locations job Completed create_temp_locations job ----------------- Running copy_source_home job Completed copy_source_home job ----------------- Running unlock_temp_home job Completed unlock_temp_home job ----------------- Running attach_temp_home job Completed attach_temp_home job ----------------- Running replace_opatch job Completed replace_opatch job ----------------- Running check_patch_conflict job Completed check_patch_conflict job ----------------- Running rollback_conflicting_patches job Completed rollback_conflicting_patches job ----------------- Running apply_oneoffs_prepatch job Completed apply_oneoffs_prepatch job ----------------- Running apply_ru job Completed apply_ru job ----------------- Running apply_oneoffs_postpatch job Completed apply_oneoffs_postpatch job 200 varchar2 ----------------- Running create_gold_image job GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli grid patch --createImage [root@wasa-ycfpo1 ~]# ls -alh /var/opt/oracle/dbaas_acfs/exapatch/custom_images/grid1920_2024-04-23_07-20-55-AM.zip -rw-r--r-- 1 grid oinstall 7.7G Apr 23 08:01 /var/opt/oracle/dbaas_acfs/exapatch/custom_images/grid1920_2024-04-23_07-20-55-AM.zip [root@wasa-ycfpo1 ~]# 実⾏33分、 201 varchar2 GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli grid patch --imageLocation [root@wasa-ycfpo1 ~]# dbaascli grid patch --targetVersion 19.20.0.0.0 --imageLocation /var/opt/oracle/dbaas_acfs/exapatch/custom_images/grid1920_2024-04- 23_07-20-55-AM.zip DBAAS CLI version 24.1.2.0.0 Executing command grid patch --targetVersion 19.20.0.0.0 -- imageLocation /var/opt/oracle/dbaas_acfs/exapatch/custom_images/grid1920_2024-04- 23_07-20-55-AM.zip Job id: 303467f5-e26a-4ec4-84ab-8937d7a20fab Session log: /var/opt/oracle/log/grid/patch/dbaastools_2024-04-23_08- 51-46-AM_15916.log Loading PILOT... Session ID of the current execution is: 7232 Log file location: /var/opt/oracle/log/grid/patch/pilot_2024-04- 23_08-51-52-AM_16539 ----------------- Running initialization job Completed initialization job ----------------- Running validate_nodes job Completed validate_nodes job ----------------- Running validate_image_location job Completed validate_image_location job ----------------- Running validate_target_version job Completed validate_target_version job ----------------- Running validate_backup_locations job Completed validate_backup_locations job ----------------- Running validate_source_home job Completed validate_source_home job ----------------- Running validate_creg_file_existence job Completed validate_creg_file_existence job ----------------- Running validate_crs_stack_state job Completed validate_crs_stack_state job ----------------- Running validate_databases job Completed validate_databases job ----------------- Running validate_disk_space job Completed validate_disk_space job ----------------- Running validate_perm_on_dir job Completed validate_perm_on_dir job ----------------- Running unpackage_image job Completed unpackage_image job ----------------- Running validate_image_product job Completed validate_image_product job ----------------- Running validate_image_version job Completed validate_image_version job 202 varchar2 GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli grid patch --imageLocation Running validate_image_patches job Completed validate_image_patches job Acquiring write lock: _u01_app_19.0.0.0_grid Acquiring write lock: provisioning ----------------- Running pre_patch_lock_manager job Completed pre_patch_lock_manager job ----------------- Running create_global_backup_loc job Completed create_global_backup_loc job ----------------- Running rotate_image_backup job Completed rotate_image_backup job ----------------- Running rotate_config_backup job Completed rotate_config_backup job ----------------- Running backup_image job Completed backup_image job ----------------- Running backup_config-wasa-ycfpo1 job Completed backup_config-wasa-ycfpo1 job ----------------- Running save_local_backup-wasa-ycfpo1 job Completed save_local_backup-wasa-ycfpo1 job ----------------- Running stop_db_instances-wasa-ycfpo1 job Completed stop_db_instances-wasa-ycfpo1 job ----------------- Running run_rootcrs_prepatch-wasa-ycfpo1 job Completed run_rootcrs_prepatch-wasa-ycfpo1 job ----------------- Running stop_tfa-wasa-ycfpo1 job Completed stop_tfa-wasa-ycfpo1 job ----------------- Running detach_source_home-wasa-ycfpo1 job Completed detach_source_home-wasa-ycfpo1 job ----------------- Running clean_source_home-wasa-ycfpo1 job Completed clean_source_home-wasa-ycfpo1 job ----------------- Running set_source_home_ownership-wasa-ycfpo1 job Completed set_source_home_ownership-wasa-ycfpo1 job ----------------- Running move_image_software_to_source_home-wasa-ycfpo1 job Completed move_image_software_to_source_home-wasa-ycfpo1 job ----------------- Running install_source_home-wasa-ycfpo1 job Completed install_source_home-wasa-ycfpo1 job ----------------- Running set_inventory_crs_flag-wasa-ycfpo1 job Completed set_inventory_crs_flag-wasa-ycfpo1 job ----------------- Running relink_options-wasa-ycfpo1 job Completed relink_options-wasa-ycfpo1 job ----------------- Running unpackage_config_files-wasa-ycfpo1 job Completed unpackage_config_files-wasa-ycfpo1 job 203 varchar2 GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli grid patch --imageLocation Running software_root_script-wasa-ycfpo1 job Completed software_root_script-wasa-ycfpo1 job Running stop_db_instances_on_node-wasa-ycfpo2 job Completed stop_db_instances_on_node-wasa-ycfpo2 job Running root_script_init-wasa-ycfpo1 job Completed root_script_init-wasa-ycfpo1 job Running run_rootcrs_prepatch_on_node-wasa-ycfpo2 job Completed run_rootcrs_prepatch_on_node-wasa-ycfpo2 job Running run_rootcrs_postpatch-wasa-ycfpo1 job Completed run_rootcrs_postpatch-wasa-ycfpo1 job Running stop_tfa_on_node-wasa-ycfpo2 job Completed stop_tfa_on_node-wasa-ycfpo2 job Running start_db_instances-wasa-ycfpo1 job Completed start_db_instances-wasa-ycfpo1 job Running stop_processes_on_node-wasa-ycfpo2 job Completed stop_processes_on_node-wasa-ycfpo2 job Running disable_diagsnap-wasa-ycfpo1 job Completed disable_diagsnap-wasa-ycfpo1 job Running remove_home_on_node-wasa-ycfpo2 job Completed remove_home_on_node-wasa-ycfpo2 job Running restore_tfa_status-wasa-ycfpo1 job Completed restore_tfa_status-wasa-ycfpo1 job Running copy_patched_home_from_local_node-wasa-ycfpo2 job Completed copy_patched_home_from_local_node-wasa-ycfpo2 job Running remove_local_backup-wasa-ycfpo1 job Completed remove_local_backup-wasa-ycfpo1 job Running unpackage_config_backup_on_node-wasa-ycfpo2 job Completed unpackage_config_backup_on_node-wasa-ycfpo2 job Running cleanup-wasa-ycfpo1 job Completed cleanup-wasa-ycfpo1 job Running run_rootcrs_postpatch_on_node-wasa-ycfpo2 job Completed run_rootcrs_postpatch_on_node-wasa-ycfpo2 job Running backup_config_on_node-wasa-ycfpo2 job Completed backup_config_on_node-wasa-ycfpo2 job Running start_db_instances_on_node-wasa-ycfpo2 job Completed start_db_instances_on_node-wasa-ycfpo2 job Running save_local_backup_on_node-wasa-ycfpo2 job Completed save_local_backup_on_node-wasa-ycfpo2 job Running disable_diagsnap_on_node-wasa-ycfpo2 job Completed disable_diagsnap_on_node-wasa-ycfpo2 job 204 varchar2 GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli grid patch --imageLocation Running restore_tfa_status_on_node-wasa-ycfpo2 job Completed restore_tfa_status_on_node-wasa-ycfpo2 job Running remove_local_backup_on_node-wasa-ycfpo2 job Completed remove_local_backup_on_node-wasa-ycfpo2 job Running remove_local_patched_home_on_node-wasa-ycfpo2 job Completed remove_local_patched_home_on_node-wasa-ycfpo2 job Running cleanup_patched_home_backup job Completed cleanup_patched_home_backup job Running post_patch_validation job Completed post_patch_validation job Running update_creg job Completed update_creg job Running post_patch_lock_manager job Completed post_patch_lock_manager job Releasing lock: _u01_app_19.0.0.0_grid Releasing lock: provisioning Running generate_system_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed generate_system_details job dbaascli execution completed [root@wasa-ycfpo1 ~]# 33分 createImage しないと 68分なので、早く終了できる 205 varchar2 GIソフトウェア・イメージを使⽤したOracle Grid Infrastructure (GI)へのパッチ適⽤ dbaascli grid getDetails 事後確認 [root@wasa-ycfpo1 ~]# dbaascli grid getDetails DBAAS CLI version 24.1.2.0.0 Executing command grid getDetails Job id: d43965a5-b588-4e1b-b453-fb7cae66d8eb Session log: /var/opt/oracle/log/grid/getDetails/dbaastools_2024-04- 23_09-26-18-AM_374957.log { "createTime" : 1713863573000, "updateTime" : 1713863573000, "activeVersion" : "19.0.0.0.0", "state" : "NORMAL", "scanListenerTCPPorts" : [ 1521 ], "scanListenerTCPSPorts" : [ 2484 ], "diskGroupDetails" : [ { "name" : "DATA", "redundancy" : "HIGH", "totalSize" : "4896GB", "freeSpace" : "3146GB" }, { "name" : "RECO", "redundancy" : "HIGH", "totalSize" : "1224GB", "freeSpace" : "588GB" }, { "name" : "SPR", "redundancy" : null, "totalSize" : null, "freeSpace" : null } ], "giNodeLevelDetails" : { "wasa-ycfpo1" : { "nodeName" : "wasa-ycfpo1", "homePath" : "/u01/app/19.0.0.0/grid", "version" : "19.20.0.0.0", "status" : null }, "wasa-ycfpo2" : { "nodeName" : "wasa-ycfpo2", "homePath" : "/u01/app/19.0.0.0/grid", "version" : "19.20.0.0.0", "status" : null } }, "messages" : [ ] } dbaascli execution completed [root@wasa-ycfpo1 ~]# 206 varchar2 アップグレード 207 varchar2 データベースのアップグレード dbaascli database upgrade --help [root@saburo-5puyv1 ~]# dbaascli database upgrade --help DBAAS CLI version 24.1.2.0.0 Executing command database upgrade --help database upgrade - performs the upgrade of an Oracle database. Usage: dbaascli database upgrade --dbname { --targetHome | --targetHomeName } { [--executePrereqs] | [--rollback [--sessionID ]] | [--resume [--sessionID ]] } { [--standBy] | ( [--allStandbyPrepared] [--upgradeOptions ] [--increaseCompatibleParameter] ) } [--removeGRP] [--waitForCompletion ] 208 varchar2 データベースのアップグレード dbaascli database upgrade --help Where: --dbname - Oracle database name. --targetHome | --targetHomeName --targetHome - target Oracle database home location. --targetHomeName - target Oracle database home name. [--executePrereqs | --rollback | --resume] [--executePrereqs - to run the Pre-Upgrade checks only. ] [--rollback - to revert an Oracle database to its original Oracle home. ] [--sessionID - to resume a specific session id.] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--standBy | (--allStandbyPrepared --upgradeOptions --increaseCompatibleParameter)] [--standBy - use this to upgrade Oracle standby databases in Data Guard configurations. ] [--allStandbyPrepared - required for Data Guard configured Oracle primary databases. Flag to acknowledge that all the required operations are performed on the Oracle standby databases prior to performing the upgrade of Oracle primary database. ] [--upgradeOptions - to pass DBUA specific arguments to perform the Oracle database upgrade. Refer to the corresponding Oracle documentation for the supported arguments and options. ] [--increaseCompatibleParameter - to automatically increase the compatible parameter as part of the database upgrade. The parameter will get increased only if the database upgrade was successful. ] [--removeGRP - to automatically remove the Guaranteed Restore Point (GRP) backup only if the upgrade of the database was successful. ] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [root@saburo-5puyv1 ~]# 209 varchar2 データベースのアップグレード 事前確認 dbaascli database --getDetails [root@saburo-5puyv1 ~]# dbaascli system getDatabases DBAAS CLI version 24.1.2.0.0 Executing command system getDatabases Job id: a6387237-447a-4f4b-b978-7b7cd614d8ad Session log: /var/opt/oracle/log/system/getDatabases/dbaastools_2024-03- 14_05-28-21-PM_389149.log { "DB0313" : { "dbSyncTime" : 1710404749576, "createTime" : 1710395479000, "updateTime" : 0, "dbName" : "DB0313", "dbUniqueName" : "DB0313_3k9_kix", "dbDomain" : "sub04210756190.exavcn.oraclevcn.com", "dbId" : 2000465870, "cpuCount" : 4, "sgaTarget" : "7600MB", "pgaAggregateTarget" : "5000MB", "dbSize" : "40GB", "dbUsedSize" : "1GB", "totalFraSize" : "383GB", "fraSizeUsed" : "15GB", "dbKmsKeyOcid" : null, "isCDB" : false, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "11.2.0.4.231017", "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tk guca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpez oghgmh7a", "resourceOCID" : "ocid1.database.oc1.ap-osaka- 1.anvwsljrssl65iqads3wtth4ijbjp2apzaffzfawkc6jay2h5dtteedwocqq", "resourceID" : "fd3d4810-e9cf-42c5-8a73-d5abfc53f50c", "resourceType" : "CDB", "parentResourceID" : null }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : null }, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "saburo-5puyv2" : { "nodeName" : "saburo-5puyv2", "instanceName" : "DB03132", "version" : "11.2.0.4.231017", "homePath" : "/u02/app/oracle/product/11.2.0/dbhome_2", "status" : "OPEN" 210 varchar2 データベースのアップグレード 事前確認 dbaascli database --getDetails <続き> }, "saburo-5puyv1" : { "nodeName" : "saburo-5puyv1", "instanceName" : "DB03131", "version" : "11.2.0.4.231017", "homePath" : "/u02/app/oracle/product/11.2.0/dbhome_2", "status" : "OPEN" } }, "pdbs" : null, "messages" : [ ] } } dbaascli execution completed [root@saburo-5puyv1 ~]# 211 varchar2 データベースのアップグレード 事前確認 dbaascli system getDBHomes [root@saburo-5puyv1 ~]# dbaascli system getDBHomes DBAAS CLI version 24.1.2.0.0 Executing command system getDBHomes Job id: 10ca839d-1d0e-4265-984e-0487d9cf0d97 Session log: /var/opt/oracle/log/system/getDBHomes/dbaastools_2024-03-14_05-54-56-PM_165733.log { "OraHome1" : { "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "homeName" : "OraHome1", "version" : "19.22.0.0.0", "createTime" : 1710147213945, "updateTime" : 1710317105918, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "saburo-5puyv2" : { "nodeName" : "saburo-5puyv2", "version" : "19.22.0.0.0", "patches" : [ "34697081", "35692839", "35239280", "35926646", "35949090", "35967489", "35943157" ] }, "saburo-5puyv1" : { "nodeName" : "saburo-5puyv1", "version" : "19.22.0.0.0", "patches" : [ "34697081", "35692839", "35239280", "35926646", "35949090", "35967489", "35943157" ] } }, "messages" : [ ] }, 212 varchar2 データベースのアップグレード 事前確認 dbaascli system getDBHomes 続き "OraHome2" : { "homePath" : "/u02/app/oracle/product/11.2.0/dbhome_1", "homeName" : "OraHome2", "version" : "11.2.0.4.231017", "createTime" : 1710314743029, "updateTime" : 1710314743029, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { "saburo-5puyv2" : { "nodeName" : "saburo-5puyv2", "version" : "11.2.0.4.231017", "patches" : [ "25139545", "33613829", "33991024", "35638387", "22291453", "30432076", "31335037", "32327201", "32558369", "34006614", "34533061", "34698179", "35099667", "35220732", "35239280", "35313335", "35685663", "32224895", "22366322", "31228670", "21289564", "35574089" ] }, "saburo-5puyv1" : { "nodeName" : "saburo-5puyv1", "version" : "11.2.0.4.231017", "patches" : [ "25139545", "33613829", "33991024", "35638387", "22291453", "30432076", "31335037", "32327201", "32558369", "34006614", "34533061", "34698179", "35099667", "35220732", "35239280", "35313335", "35685663", "32224895", "22366322", "31228670", "21289564", "35574089" ] } }, "messages" : [ ] }, "OraHome3" : { "homePath" : "/u02/app/oracle/product/11.2.0/dbhome_2", "homeName" : "OraHome3", "version" : "11.2.0.4.231017", "createTime" : 1710394822227, "updateTime" : 1710395608351, "unifiedAuditEnabled" : false, "ohNodeLevelDetails" : { 213 C"ospaybruigrhot-5©pu2y0v224", O:ra{cle and/or its affiliates, "nodeName" : "saburo-5puyv2", データベースのアップグレード 実⾏ dbaascli database upgrade [root@saburo-5puyv1 ~]# dbaascli database upgrade --dbname DB0313 -- targetHome /u02/app/oracle/product/19.0.0.0/dbhome_1 DBAAS CLI version 24.1.2.0.0 Executing command database upgrade --dbname DB0313 --targetHome /u02/app/oracle/product/19.0.0.0/dbhome_1 Job id: 6cbc9f3f-df1b-418c-a31e-e939db44639e Session log: /var/opt/oracle/log/DB0313/database/upgrade/dbaastools_2024-03- 14_06-00-29-PM_207042.log Loading PILOT... Session ID of the current execution is: 519 Log file location: /var/opt/oracle/log/DB0313/database/upgrade/pilot_2024- 03-14_06-00-35-PM_207477 ----------------- Running Initialize_plugin job Completed Initialize_plugin job ----------------- Running Validate_plugin_inputs job Completed Validate_plugin_inputs job ----------------- Running Validate_required_passwords job Completed Validate_required_passwords job ----------------- Running Check_database_role job Completed Check_database_role job ----------------- Running Check_tde_autologin_wallet_configuration job Completed Check_tde_autologin_wallet_configuration job ----------------- Running RDBMS_pre_upgrade_checks job Logs directory: /u02/app/oracle/cfgtoollogs/DB0313_3k9_kix/preupgrade/2024- 03-14180046 Performing Pre-Upgrade Checks... ============================ Pre-Upgrade Checks Results ============================= /u02/app/oracle/cfgtoollogs/DB0313_3k9_kix/preupgrade/2024-03- 14180046/DB0313_3k9_kix/upgrade.xml /u02/app/oracle/cfgtoollogs/DB0313_3k9_kix/preupgrade/2024-03- 14180046/DB0313_3k9_kix/preupgrade_fixups.sql /u02/app/oracle/cfgtoollogs/DB0313_3k9_kix/preupgrade/2024-03- 14180046/DB0313_3k9_kix/postupgrade_fixups.sql [INFO] [DBAAS-51024] Refer to the following log file for any required action(s) that need to be reviewed or addressed: /var/opt/oracle/log/DB0313/database/upgrade/preupgrade_summary_2024-03- 14_06-01-37-PM.log. [INFO] [DBAAS-51023] No required manual actions were detected as part of the pre-upgrade check results. Completed RDBMS_pre_upgrade_checks job Running Create_pre_upgrade_log_location job Completed Create_pre_upgrade_log_location job Running Pre_upgrade_fixups job Completed Pre_upgrade_fixups job Running Check_database_statistics job Completed Check_database_statistics job Running Check_valid_db_components job Completed Check_valid_db_components job 214 varchar2 データベースのアップグレード 実⾏ dbaascli database upgrade Running Collect_pre_upgrade_diagnostics job [INFO] [DBAAS-51025] Refer to the following log file for a database diagnostics report before performing the upgrade: /var/opt/oracle/log/DB0313/database/upgrade/pre_upgrade_diagnostics_DB0313_2 024-03-14_06-02-34-PM.log. Completed Collect_pre_upgrade_diagnostics job ----------------- Running Check_em_database_control_repository job Completed Check_em_database_control_repository job Running Create_configuration_files_backup job [INFO] [DBAAS-52014] Backup of CREG, ENV, SPFILE and PFILE to /var/opt/oracle/dbaas_acfs/upgrade_backup/DB0313. Completed Create_configuration_files_backup job ----------------- Running Remove_database_cron_jobs job [INFO] [DBAAS-52015] Crontab entry deleted. After upgrade reconfigure the backup again. Completed Remove_database_cron_jobs job Running Check_spfile_pointer_integrity job Completed Check_spfile_pointer_integrity job ----------------- Running Check_archive_log_enabling job Completed Check_archive_log_enabling job ----------------- Running Check_source_timezone_version job Completed Check_source_timezone_version job ----------------- Running Check_required_gi_version job Completed Check_required_gi_version job ----------------- Running Check_network_configuration_permissions job Completed Check_network_configuration_permissions job Acquiring read lock: _u02_app_oracle_product_11.2.0_dbhome_2 ----------------- Running Create_guaranteed_restore_point job [INFO] [DBAAS-52013] Guaranteed restore point created, restore point name: DBAAS#UPGRADE#2024037418838. Completed Create_guaranteed_restore_point job Running Disable_concurrent_stats_collection job [INFO] [DBAAS-52016] CONCURRENT statistics set to FALSE. Completed Disable_concurrent_stats_collection job ----------------- Running Fixup_for_oracle_label_security job Completed Fixup_for_oracle_label_security job Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_1 ----------------- Running Copy_network_configuration job Completed Copy_network_configuration job ----------------- Running Update_timezone_files job Completed Update_timezone_files job ----------------- Running Create_upgrade_log_location job Completed Create_upgrade_log_location job Acquiring write lock: db0313 ----------------- 215 varchar2 データベースのアップグレード 実⾏ dbaascli database upgrade Running Perform_database_upgrade job 39% complete Logs directory: /u02/app/oracle/cfgtoollogs/DB0313_3k9_kix/upgrade/2024-03- 39% complete 14180247 40% complete Performing Pre-Upgrade Checks... 40% complete ============================ 40% complete Pre-Upgrade Checks Results 40% complete ============================= 41% complete /u02/app/oracle/cfgtoollogs/DB0313_3k9_kix/upgrade/2024-03- 41% complete 14180247/DB0313_3k9_kix/upgrade.xml 41% complete /u02/app/oracle/cfgtoollogs/DB0313_3k9_kix/upgrade/2024-03- 41% complete 14180247/DB0313_3k9_kix/preupgrade_fixups.sql 42% complete /u02/app/oracle/cfgtoollogs/DB0313_3k9_kix/upgrade/2024-03- 42% complete 14180247/DB0313_3k9_kix/postupgrade_fixups.sql 42% complete [WARNING] [DBT-20060] One or more Oracle upgrade pre-checks resulted in 42% complete warning conditions that may require further review. 43% complete ACTION: Refer to the pre-upgrade results location for details: 43% complete /u02/app/oracle/cfgtoollogs/DB0313_3k9_kix/upgrade/2024-03- 43% complete 14180247/DB0313_3k9_kix 43% complete 12% complete 44% complete 15% complete 44% complete 25% complete 44% complete 37% complete 44% complete 37% complete 45% complete 37% complete 45% complete 38% complete 45% complete 38% complete 45% complete 38% complete 46% complete 38% complete 46% complete 39% complete 46% complete 39% complete 46% complete 216 varchar2 データベースのアップグレード 実⾏ dbaascli database upgrade 47% complete 47% complete 47% complete 47% complete 48% complete 48% complete 48% complete 48% complete 49% complete 49% complete 49% complete 49% complete 50% complete 62% complete 75% complete 76% complete 77% complete 87% complete 100% complete Completed Perform_database_upgrade job Releasing lock: db0313 Running Collect_post_upgrade_diagnostics job [INFO] [DBAAS-52017] Refer to the following log file for a database diagnostics report after the upgrade: /var/opt/oracle/log/DB0313/database/upgrade/post_upgrade_diagnostics_DB0313_ 2024-03-14_06-26-33-PM.log. Completed Collect_post_upgrade_diagnostics job ----------------- Running Update_database_upgrade_status job Completed Update_database_upgrade_status job ----------------- Running Post_upgrade_fixups job Completed Post_upgrade_fixups job ----------------- Running Update_tns_admin_environment_variable job Completed Update_tns_admin_environment_variable job ----------------- Running Sync_database_pfile job Completed Sync_database_pfile job ----------------- Running Move_database_password_file_to_asm job Completed Move_database_password_file_to_asm job Running Update_source_cloud_registry_metadata job Completed Update_source_cloud_registry_metadata job Running Verify_tde_configuration job Completed Verify_tde_configuration job Running Verify_database_upgrade_logs job Completed Verify_database_upgrade_logs job Running Update_oratab job Completed Update_oratab job Running Update_oraenv_files job Completed Update_oraenv_files job 217 varchar2 データベースのアップグレード 実⾏ dbaascli database upgrade Running Update_database_metadata job Completed Update_database_metadata job Running Sync_network_configuration job Completed Sync_network_configuration job Releasing lock: _u02_app_oracle_product_11.2.0_dbhome_2 Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_1 Running Perform_cluster_configuration_sync job Completed Perform_cluster_configuration_sync job Running Verify_cluster_configuration_sync job Completed Verify_cluster_configuration_sync job Running Configure_backup_assistant job Completed Configure_backup_assistant job Running Generate_dbsystem_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed Generate_dbsystem_details job dbaascli execution completed [root@saburo-5puyv1 ~]# 218 varchar2 データベースのアップグレード 事後確認 dbaascli system getDatabases [root@saburo-5puyv1 ~]# dbaascli system getDatabases DBAAS CLI version 24.1.2.0.0 Executing command system getDatabases Job id: 0b4e25a4-7d36-411c-9d9e-79cbce9a3755 Session log: /var/opt/oracle/log/system/getDatabases/dbaastools_2024-03-15_10-02-22-AM_329676.log { "DB0313" : { "dbSyncTime" : 1710464290337, "createTime" : 1710395479000, "updateTime" : 0, "dbName" : "DB0313", "dbUniqueName" : "DB0313_3k9_kix", "dbDomain" : "sub04210756190.exavcn.oraclevcn.com", "dbId" : 2000465870, "cpuCount" : 4, "sgaTarget" : "7600MB", "pgaAggregateTarget" : "5000MB", "dbSize" : "40GB", "dbUsedSize" : "1GB", "totalFraSize" : "383GB", "fraSizeUsed" : "20GB", "dbKmsKeyOcid" : null, "isCDB" : false, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "19.22.0.0.0", 219 varchar2 データベースのアップグレード 事後確認 dbaascli system getDatabases "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezoghgmh7a", "resourceOCID" : "ocid1.database.oc1.ap-osaka-1.anvwsljrssl65iqads3wtth4ijbjp2apzaffzfawkc6jay2h5dtteedwocqq", "resourceID" : "fd3d4810-e9cf-42c5-8a73-d5abfc53f50c", "resourceType" : "CDB", "parentResourceID" : null }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : "AZyE5LWDU099vwICh3f/cxEAAAAAAAAAAAAAAAAAAAAAAAAAAAAA" }, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "saburo-5puyv2" : { "nodeName" : "saburo-5puyv2", "instanceName" : "DB03132", "version" : "19.22.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", "status" : "OPEN" }, "saburo-5puyv1" : { "nodeName" : "saburo-5puyv1", "instanceName" : "DB03131", "version" : "19.22.0.0.0", "homePath" : "/u02/app/oracle/product/19.0.0.0/dbhome_1", 220 Cop"ysrtigahttus©" 2:02"4O,POENra"cle and/or its affiliates, } データベースのアップグレード ロールバック dbaascli database upgrade --rollback [root@saburo-5puyv1 ~]# dbaascli database upgrade --dbname DB0313 -- rollback --targetHome /u02/app/oracle/product/11.2.0/dbhome_2 DBAAS CLI version 24.1.2.0.0 Executing command database upgrade --dbname DB0313 --rollback --targetHome /u02/app/oracle/product/11.2.0/dbhome_2 Job id: a7918a25-e88c-42f1-a7e7-aa659f96f58c Session log: /var/opt/oracle/log/DB0313/database/upgrade/dbaastools_2024-03- 15_10-05-11-AM_348524.log Loading PILOT... Session ID of the current execution is: 552 Log file location: /var/opt/oracle/log/DB0313/database/upgrade/pilot_2024- 03-15_10-05-22-AM_350165 ----------------- Running Initialize_plugin job Completed Initialize_plugin job ----------------- Running Validate_plugin_inputs job Completed Validate_plugin_inputs job ----------------- Running Validate_required_passwords job Completed Validate_required_passwords job Acquiring write lock: db0313 Acquiring read lock: _u02_app_oracle_product_19.0.0.0_dbhome_1 Acquiring read lock: _u02_app_oracle_product_11.2.0_dbhome_2 ----------------- Running Verify_upgrade_operation_state job Completed Verify_upgrade_operation_state job ----------------- Running Shutdown_database job Completed Shutdown_database job Running Disable_database job Completed Disable_database job ----------------- Running Mount_database_in_source_home job Completed Mount_database_in_source_home job ----------------- Running Flashback_source_database job Completed Flashback_source_database job ----------------- Running Shutdown_local_instance job Completed Shutdown_local_instance job ----------------- Running Restore_oraenv_files job Completed Restore_oraenv_files job ----------------- Running Restore_network_configuration job Completed Restore_network_configuration job ----------------- Running Restore_database_metadata job Completed Restore_database_metadata job ----------------- Running Restore_oratab job Completed Restore_oratab job ----------------- Running Mount_restored_local_instance job Completed Mount_restored_local_instance job ----------------- Running Open_local_instance job Completed Open_local_instance job ----------------- 221 varchar2 データベースのアップグレード ロールバック dbaascli database upgrade --rollback Running Downgrade_database_service job Completed Downgrade_database_service job Running Restore_tns_admin_environment_variable job Completed Restore_tns_admin_environment_variable job Running Restore_source_spfile_pointer job Completed Restore_source_spfile_pointer job Running Verify_rac_database_configuration job Completed Verify_rac_database_configuration job Running Update_database_reference job Completed Update_database_reference job Running Enable_restored_database job Completed Enable_restored_database job Running Start_restored_database job Completed Start_restored_database job Running Clean_upgrade_operation_metadata job Completed Clean_upgrade_operation_metadata job Releasing lock: db0313 Releasing lock: _u02_app_oracle_product_19.0.0.0_dbhome_1 Releasing lock: _u02_app_oracle_product_11.2.0_dbhome_2 Running Generate_dbsystem_details job Acquiring native write lock: global_dbsystem_details_generation Releasing native lock: global_dbsystem_details_generation Completed Generate_dbsystem_details job dbaascli execution completed 2[r2o2ot@Csoapbyurrigoh-t5p©uy2v0124~,]O#racle and/or its affiliates, データベースのアップグレード ロールバック 事後確認 dbaascli system getDatabases [root@saburo-5puyv1 ~]# dbaascli system getDatabases DBAAS CLI version 24.1.2.0.0 Executing command system getDatabases Job id: 483dbf36-3999-4322-a77b-e6437fa51365 Session log: /var/opt/oracle/log/system/getDatabases/dbaastools_2024-03-15_10-44-30-AM_218044.log { "DB0313" : { "dbSyncTime" : 1710466135535, "createTime" : 1710395479000, "updateTime" : 0, "dbName" : "DB0313", "dbUniqueName" : "DB0313_3k9_kix", "dbDomain" : "sub04210756190.exavcn.oraclevcn.com", "dbId" : 2000465870, "cpuCount" : 4, "sgaTarget" : "7600MB", "pgaAggregateTarget" : "5000MB", "dbSize" : "40GB", "dbUsedSize" : "1GB", "totalFraSize" : "383GB", "fraSizeUsed" : "21GB", "dbKmsKeyOcid" : null, "isCDB" : false, "dbRole" : "PRIMARY", "dbType" : "RAC", "dbClass" : "OLTP", "dbEdition" : "EE", "dgEnabled" : false, "patchVersion" : "11.2.0.4.231017", 223 varchar2 データベースのアップグレード ロールバック 事後確認 dbaascli system getDatabases "resourceOCIDSettings" : { "tenancyOCID" : "ocid1.tenancy.oc1..aaaaaaaa3mb7wrcy2ls3u3jsy2soq5ck3lc3q4mczitpdaymbuazc5tkguca", "compartmentOCID" : "ocid1.compartment.oc1..aaaaaaaa5lyxq3znb3vnngfmlpkdcksqw4oxe5zzg3i37iydjpezoghgmh7a", "resourceOCID" : "ocid1.database.oc1.ap-osaka-1.anvwsljrssl65iqads3wtth4ijbjp2apzaffzfawkc6jay2h5dtteedwocqq", "resourceID" : "fd3d4810-e9cf-42c5-8a73-d5abfc53f50c", "resourceType" : "CDB", "parentResourceID" : null }, "tdeDetails" : { "tdeKeystoreType" : "FILE", "keyVersionOcid" : null, "tdeMasterKeyId" : null }, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbNodeLevelDetails" : { "saburo-5puyv2" : { "nodeName" : "saburo-5puyv2", "instanceName" : "DB03132", "version" : "11.2.0.4.231017", "homePath" : "/u02/app/oracle/product/11.2.0/dbhome_2", "status" : "OPEN" }, "saburo-5puyv1" : { "nodeName" : "saburo-5puyv1", "instanceName" : "DB03131", "version" : "11.2.0.4.231017", "homePath" : "/u02/app/oracle/product/11.2.0/dbhome_2", 224 Cop"ysrtigahttus©" 2:02"4O,POENra"cle and/or its affiliates, } gridのアップグレード dbaascli grid upgrade --help [root@orcl0329-pfutx1 ~]# dbaascli grid upgrade --help DBAAS CLI version 22.1.1.1.0 Executing command grid upgrade --help grid upgrade - upgrade the grid from one major version to another. Usage: dbaascli grid upgrade --targetVersion [--containerURL ] [--executePrereqs] [--resume [--sessionID ]] [--rollback] [-- targetHome ] [--softwareOnly] Where: --targetVersion - target version to be upgraded to. [--containerURL - custom url for fetching GI Image. ] [--executePrereqs - option to execute prereqs. ] [--resume - To resume the previous execution] [--sessionID - to resume a specific session id.] [--rollback - option to revert failed execution. ] [--targetHome - path of the target grid home for the operation which is different from the current grid home. ] [--softwareOnly - option to install only grid software. ] 225 varchar2 gridのアップグレード 事前確認 dbaascli grid upgrade --executePrereqs 226 varchar2 gridのアップグレード 実⾏ dbaascli grid upgrade 227 varchar2 gridのアップグレード 実⾏後確認 dbaascli grid upgrade 228 varchar2 PDBの管理 229 varchar2 PDBコマンド⼀覧 dbaascli pdb --help [root@wasa-ycfpo1 ~]# dbaascli pdb --help DBAAS CLI version 24.1.1.0.0 Executing command pdb --help pdb localClone - clone a PDB from another PDB in the same database. pdb getConnectString - get connectString of the specified PDB. pdb remoteClone - clone the specified PDB from an another database. pdb close - close a PDB. pdb create - create a new PDB. pdb open - open a PDB. pdb relocate - relocate the specified PDB from remote DB into local DB. pdb delete - delete a PDB. pdb bounce - bounce the PDB. pdb getDetails - get the details of provided PDB in the database. pdb backup - performs PDB backup operations. pdb recover - performs PDB recovery. pdb refresh - refresh a specified PDB. [root@wasa-ycfpo1 ~]# 230 varchar2 PDBコマンド⼀覧 dbaascli pdb --getConnectString [root@taro-3nusm1 ~]# dbaascli pdb getConnectString --help DBAAS CLI version 24.1.1.0.0 Executing command pdb getConnectString --help pdb getConnectString - get connectString of the specified PDB. Usage: dbaascli pdb getConnectString --dbname { --pdbName | --pdbUID } Where: --dbname - Oracle database name. --pdbName | --pdbUID --pdbName - PDB name. --pdbUID - identifier of PDB. [root@taro-3nusm1 ~]# 232 varchar2 PDBコマンド⼀覧 dbaascli pdb --getConnectString [root@taro-3nusm1 ~]# dbaascli pdb getConnectString --dbname DB0206 --pdbname PDB1 DBAAS CLI version 24.1.1.0.0 Executing command pdb getConnectString --dbname DB0206 --pdbname PDB1 Job id: e91c2b5a-9698-44fd-b3c3-c5bf0db39ee5 Session log: /var/opt/oracle/log/DB0206/pdb/getConnectString/dbaastools_2024-02-19_03-34-50-PM_214258.log [ { "serviceName" : "DB0206_PDB1.paas.oracle.com", "connectString" : "taro-3nusm-scan.sub04210756190.exavcn.oraclevcn.com:1521/DB0206_PDB1.paas.oracle.com", "tcpsConnectStrings" : [ "taro-3nusm-scan.sub04210756190.exavcn.oraclevcn.com:2484/DB0206_PDB1.paas.oracle.com" ] } ] dbaascli execution completed [root@taro-3nusm1 ~]# 233 varchar2 PDBのバウンス dbaascli pdb bounce [root@orakawa-vgfvk1 ~]# dbaascli pdb bounce --dbName dbcli01 --pdbname DBCLI01PDB01 DBAAS CLI version 22.1.1.1.0 Executing command pdb bounce --dbName dbcli01 --pdbname DBCLI01PDB01 Job id: 0f60aad0-e23d-418c-973c-46994dbbb9ec dbaascli execution completed 234 varchar2 PDBを停⽌ dbaascli pdb close [root@orakawa-vgfvk1 ~]# dbaascli pdb close --dbName dbcli01 --pdbname DBCLI01PDB01 DBAAS CLI version 22.1.1.1.0 Executing command pdb close --dbName dbcli01 --pdbname DBCLI01PDB01 Job id: 336d0d67-408a-4859-9f65-31412c2de034 dbaascli execution completed [oracle@orakawa-vgfvk1 ~]$ sqlplus / as sysdba SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY NO 3 DBCLI01PDB01 MOUNTED 235 varchar2 PDBを停⽌ dbaascli pdb close [root@orakawa-vgfvk1 ~]# dbaascli pdb list --dbName dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command pdb list --dbName dbcli01 Job id: 1ec38883-d4d4-4235-896f-cfb337c45ce1 [ { "pdbName" : "DBCLI01PDB01", "pdbUID" : "3034439310", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB3D7503BCD57E96E0533500000A2869", "dbid" : "3034439310", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "MOUNTED" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "MOUNTED" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_dbcli01pdb01.paas.oracle.com", "connectString" : "orakawa-vgfvk-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb01.paas.oracle.com" } ] } ] dbaascli execution completed 236 varchar2 PDBのオープン dbaascli pdb open --help [root@taro-3nusm1 ~]# dbaascli pdb open --help DBAAS CLI version 24.1.1.0.0 Executing command pdb open --help pdb open - open a PDB. Usage: dbaascli pdb open { --pdbName | --pdbUID } --dbname [--openMode ] [--startServices ] [--waitForCompletion ] [--setPDBRefreshModeNone [--skipPDBRefresh] [-- pdbAdminUserName ]] [--executePrereqs] [--resume [--sessionID ]] [--blobLocation ] Where: --pdbName | --pdbUID --pdbName - PDB name. --pdbUID - identifier of PDB. --dbname - Oracle database name. [--openMode - Specify one of PDB open modes 'READ_ONLY', 'READ_WRITE'.] [--startServices - start all or list all services corresponding to a PDB. Accepted values are ''all'' or comma separated PDB services.] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [--setPDBRefreshModeNone - to convert refreshable PDB to non-refreshable PDB ] [--skipPDBRefresh - to skip refreshable PDB refresh] [--pdbAdminUserName - specifies new PDB admin user name] [--executePrereqs - run the prerequisite checks and report the results. ] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--blobLocation - custom directory location where the standby blob file will be generated in a DG environment.] [root@taro-3nusm1 ~]# 237 varchar2 PDBのオープン dbaascli pdb open [root@orakawa-vgfvk1 ~]# dbaascli pdb open --dbName dbcli01 --pdbname DBCLI01PDB01 DBAAS CLI version 22.1.1.1.0 Executing command pdb open --dbName dbcli01 --pdbname DBCLI01PDB01 Job id: be9f07c6-b3b7-46ec-a997-94fb36377a21 dbaascli execution completed 238 varchar2 PDBのオープン dbaascli pdb open [root@orakawa-vgfvk1 ~]# dbaascli pdb getdetails --dbName dbcli01 --pdbname DBCLI01PDB01 DBAAS CLI version 22.1.1.1.0 Executing command pdb getdetails --dbName dbcli01 --pdbname DBCLI01PDB01 Job id: a67c12f8-8a3f-4d8a-89dd-8460b359a01b { "pdbName" : "DBCLI01PDB01", "pdbUID" : "3034439310", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB3D7503BCD57E96E0533500000A2869", "dbid" : "3034439310", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_dbcli01pdb01.paas.oracle.com", "connectString" : "orakawa-vgfvk-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb01.paas.oracle.com" } ] } dbaascli execution completed 239 varchar2 PDBの作成 dbaascli pdb create --help [root@wasa-ycfpo1 ~]# dbaascli pdb create --help DBAAS CLI version 24.1.1.0.0 Executing command pdb create --help pdb create - create a new PDB. Usage: dbaascli pdb create --pdbName --dbName [--maxCPU ] [--maxSize ] [--pdbAdminUserName ] [--lockPDBAdminAccount ] [--resume [--sessionID ]] [--executePrereqs] [--waitForCompletion ] { [--blobLocation ] | [--standbyBlobFromPrimary ] } [--pdbKMSKeyVersionOCID ] Where: --pdbName - specifies new PDB name. --dbName - Oracle database name. [--maxCPU - specifies max number of CPUs to be allocated for the PDB. ] [--maxSize - specifies max storage size in GB for the new PDB. ] [--pdbAdminUserName - specifies new PDB admin user name] [--lockPDBAdminAccount - specifies true or false to lock the PDB admin user account. Default value is true] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--executePrereqs - run the prerequisite checks and report the results. ] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [--blobLocation | --standbyBlobFromPrimary] [--blobLocation - custom directory location where the standby blob file will be generated in a DG environment.] [--standbyBlobFromPrimary - specifies the location of the standby blob file which is prepared from the primary database. This is required only for standby operations. ] [--pdbKMSKeyVersionOCID - OCI Vault key version OCID to be set for PDB. This is applicable only if database is OCI Vault configured] [root@wasa-ycfpo1 ~]# 240 varchar2 PDBの作成 dbaascli pdb create [root@orakawa-vgfvk1 ~]# dbaascli pdb create --dbName dbcli01 --pdbname DBCLI01PDB02 DBAAS CLI version 22.1.1.1.0 Executing command pdb create --dbName dbcli01 --pdbname DBCLI01PDB02 Job id: 047929e7-9ae9-45d0-8dd7-3e6df1d82435 Loading PILOT... Session ID of the current execution is: 37 Log file location: /var/opt/oracle/log/dbcli01/pdb/create/pilot_2022-03- 28_04-51-39-PM ----------------- Running Set_pdb_admin_user_profile job Completed Set_pdb_admin_user_profile job ----------------- Running Lock_pdb_admin_user job Completed Lock_pdb_admin_user job ----------------- Running Register_ocids job Skipping. Job is detected as not applicable. Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Validate_input_params job Completed Validate_input_params job Running Generate_dbsystem_details job Completed Generate_dbsystem_details job dbaascli execution completed Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job Running PDB_creation job Completed PDB_creation job Running Load_pdb_details job Completed Load_pdb_details job Running Configure_pdb_service job Completed Configure_pdb_service job Running Configure_tnsnames_ora job Completed Configure_tnsnames_ora job 242 varchar2 PDBの削除 dbaascli pdb delete --help [oracle@vm01wasa-zb1hy1 ~]$ dbaascli pdb delete --help DBAAS CLI version 23.1.1.0.1 Executing command pdb delete --help pdb delete - delete a PDB. Usage: dbaascli pdb delete --dbName { --pdbName | --pdbUID } [--executePrereqs] [--waitForCompletion ] [--resume [--sessionID ]] [--allStandbyPrepared] [--cleanupRelocatedPDB] Where: --dbName - Oracle database name. --pdbName | --pdbUID --pdbName - specifies name of the PDB to delete. --pdbUID - specifies UID of the PDB to delete. [--executePrereqs - run the prerequisite checks and report the results. ] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--allStandbyPrepared - specifies to confirm that the operation has been successfully run on all the standby databases.] [--cleanupRelocatedPDB - option to cleanup source database after a PDB has been relocated. ] [oracle@vm01wasa-zb1hy1 ~]$ 243 varchar2 PDBの削除 dbaascli pdb delete [root@orakawa-vgfvk1 ~]# dbaascli pdb delete --dbName dbcli01 --pdbname DBCLI01PDB02 DBAAS CLI version 22.1.1.1.0 Executing command pdb delete --dbName dbcli01 --pdbname DBCLI01PDB02 Job id: 82612c7f-4725-4c88-9bca-90b6ee66a147 Loading PILOT... Session ID of the current execution is: 38 Log file location: /var/opt/oracle/log/dbcli01/pdb/delete/pilot_2022-03-28_04-56-00-PM Running Plugin_initialization job Completed Plugin_initialization job Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job Running Delete_pdb_service job Completed Delete_pdb_service job Running PDB_deletion job Completed PDB_deletion job Running Delete_tnsnames_entry job Completed Delete_tnsnames_entry job Running Cleanup_resource_ocid_file job Completed Cleanup_resource_ocid_file job Running Generate_dbsystem_details job Completed Generate_dbsystem_details job dbaascli execution completed 245 varchar2 PDBの削除 コンソールからの⾒え⽅ DB削除時と同じく、Failedになるので、コンソールから Terminated する 削除後 246 varchar2 PDBの詳細確認 dbaascli pdb getDetails --help [root@orakawa-vgfvk1 ~]# dbaascli pdb getDetails --help DBAAS CLI version 22.1.1.1.0 Executing command pdb getDetails --help pdb getDetails - get the details of provided PDB in the database. Usage: dbaascli pdb getDetails --dbname { --pdbName | --pdbUID } Where: --dbname - Oracle database name. --pdbName | --pdbUID --pdbName - PDB name. --pdbUID - Identifier of PDB. 247 varchar2 PDBの詳細確認 dbaascli pdb getDetails [root@orakawa-vgfvk1 ~]# dbaascli pdb getDetails --dbname dbcli01 --pdbname DBCLI01PDB01 DBAAS CLI version 22.1.1.1.0 Executing command pdb getDetails --pdbname DBCLI01PDB01 Job id: 64be9375-4ff6-44d2-b0d8-89f40468afb8 { "pdbName" : "DBCLI01PDB01", "pdbUID" : "3034439310", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB3D7503BCD57E96E0533500000A2869", "dbid" : "3034439310", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_dbcli01pdb01.paas.oracle.com", "connectString" : "orakawa-vgfvk-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb01.paas.oracle.com" } ] } dbaascli execution completed 248 varchar2 CDB内のPDBの⼀覧 dbaascli pdb list --help [root@orakawa-vgfvk1 ~]# dbaascli pdb list --help DBAAS CLI version 22.1.1.1.0 Executing command pdb list --help pdb list - get information of PDBs in a db. Usage: dbaascli pdb list --dbname Where: --dbname - Oracle database name. 249 varchar2 CDB内のPDBの⼀覧 dbaascli pdb list [root@orakawa-vgfvk1 ~]# dbaascli pdb list --dbName dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command pdb list --dbName dbcli01 Job id: 0cc22b44-5f05-40fd-b460-ed95f0307dff [ { "pdbName" : "DBCLI01PDB01", "pdbUID" : "3034439310", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB3D7503BCD57E96E0533500000A2869", "dbid" : "3034439310", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_dbcli01pdb01.paas.oracle.com", "connectString" : "orakawa-vgfvk-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb01.paas.oracle.com" } ] } ] dbaascli execution completed 250 varchar2 同⼀CDB内のローカルクローンPDB作成 dbaascli pdb localClone --help [root@wasa-ycfpo1 ~]# dbaascli pdb localclone --help DBAAS CLI version 24.1.1.0.0 Executing command pdb localclone --help pdb localClone - clone a PDB from another PDB in the same database. Usage: dbaascli pdb localClone --pdbName --dbName [--targetPDBName ] [--powerLimit ] [--maxCPU ] [--maxSize ] [--resume [--sessionID ]] [--executePrereqs] [--waitForCompletion ] { [--blobLocation ] | [--standbyBlobFromPrimary ] } [--excludeUserTablespaces ] [--excludePDBData ] [--pdbAdminUserName ] [--lockPDBAdminAccount ] [-- sourcePDBServiceConvertList ] Where: --pdbName - specifies source PDB name to clone. --dbName - Oracle database name. [--targetPDBName - specifies name for the target PDB (new cloned PDB). ] [--powerLimit - specifies degree of parallelism to be used for the clone operation.] [--maxCPU - specifies max number of CPUs to be allocated for the PDB. ] [--maxSize - specifies max storage size in GB for the new PDB. ] [--resume - to resume the previous operation] [--sessionID - to resume a specific session id.] [--executePrereqs - run the prerequisite checks and report the results. ] [--waitForCompletion - specifies false to run the operation in background. Valid values : true|false.] [--blobLocation | --standbyBlobFromPrimary] [--blobLocation - custom directory location where the standby blob file will be generated in a DG environment.] [--standbyBlobFromPrimary - specifies the location of the standby blob file which is prepared from the primary database. This is required only for standby operations. ] [--excludeUserTablespaces - option to skip user tablespaces, example t1,t2,t3. ] [--excludePDBData - specifies true/yes to skip user data from source PDB. ] [--pdbAdminUserName - specifies new PDB admin user name] 251 Cop[y-r-iglhotck©PD2B0A2d4m,iOnAracccloeuanntd/-orsiptsecaifffiliiaetsest,rue or false to lock the PDB admin user account. Default value is true] [--sourcePDBServiceConvertList - specifies comma separated list of source to target service names which need to be converted. Syntax is 同⼀CDB内のローカルクローンPDB作成 dbaascli pdb localClone [root@orakawa-vgfvk1 ~]# dbaascli pdb localClone --dbName dbcli01 -- pdbName DBCLI01PDB01 DBAAS CLI version 22.1.1.1.0 Executing command pdb localClone --dbName dbcli01 --pdbName DBCLI01PDB01 Job id: b06c6f36-fd17-4df8-a0a1-07de4ca90b34 Loading PILOT... Session ID of the current execution is: 40 Log file location: /var/opt/oracle/log/dbcli01/pdb/localClone/pilot_2022-03- 28_05-02-12-PM ----------------- Running Set_pdb_admin_user_profile job Completed Set_pdb_admin_user_profile job ----------------- Running Lock_pdb_admin_user job Completed Lock_pdb_admin_user job ----------------- Running Register_ocids job Skipping. Job is detected as not applicable. Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Validate_input_params job Completed Validate_input_params job Running Generate_dbsystem_details job Completed Generate_dbsystem_details job dbaascli execution completed Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job Running PDB_creation job Completed PDB_creation job Running Load_pdb_details job Completed Load_pdb_details job Running Configure_pdb_service job Completed Configure_pdb_service job Running Configure_tnsnames_ora job Completed Configure_tnsnames_ora job 253 varchar2 同⼀CDB内のローカルクローンPDB作成作成後の確認 dbaascli pdb localClone [root@orakawa-vgfvk1 ~]# dbaascli pdb list --dbName dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command pdb list --dbName dbcli01 Job id: 946bf399-972b-4f8d-8d86-aec9b0112bcb [ { “pdbName” : “DBCLI01PDB01”, ★クローン元 "pdbUID" : "3034439310", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB3D7503BCD57E96E0533500000A2869", "dbid" : "3034439310", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_dbcli01pdb01.paas.oracle.com", "connectString" : "orakawa-vgfvk- scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb01.paas. oracle.com" } ] }, { “pdbName” : “DBCLI01_DBCLI01PDB01”, ★クローンして作成したPDB "pdbUID" : "2527289634", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB43BDF61CB7F94DE0533500000AF910", "dbid" : "2527289634", "conId" : "4", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_DBCLI01_DBCLI01PDB01.paas.oracle.com", "connectString" : "orakawa-vgfvk- scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_DBCLI01_DBCLI01PDB 01.paas.oracle.com" } ] } ] dbaascli execution completed 254 varchar2 同⼀CDB内のローカルクローンPDB作成クローンのPDB名を指定して作成 dbaascli pdb localClone [root@orakawa-vgfvk1 ~]# dbaascli pdb localClone --dbName dbcli01 -- pdbName DBCLI01PDB01 --targetPDBName CLONE_PDB01 DBAAS CLI version 22.1.1.1.0 Executing command pdb localClone --dbName dbcli01 --pdbName DBCLI01PDB01 -- targetPDBName CLONE_PDB01 Job id: 84f2296c-3f09-444d-81c2-3ad2a7f8a140 Loading PILOT... Session ID of the current execution is: 42 Log file location: /var/opt/oracle/log/dbcli01/pdb/localClone/pilot_2022-03- 28_05-07-34-PM ----------------- Running Plugin_initialization job Completed Plugin_initialization job ----------------- Running Set_pdb_admin_user_profile job Completed Set_pdb_admin_user_profile job ----------------- Running Lock_pdb_admin_user job Completed Lock_pdb_admin_user job ----------------- Running Register_ocids job Skipping. Job is detected as not applicable. ----------------- Running Generate_dbsystem_details job Completed Generate_dbsystem_details job dbaascli execution completed Running Validate_input_params job Completed Validate_input_params job Running Perform_dbca_prechecks job Completed Perform_dbca_prechecks job Running PDB_creation job Completed PDB_creation job Running Load_pdb_details job Completed Load_pdb_details job Running Configure_pdb_service job Completed Configure_pdb_service job Running Configure_tnsnames_ora job Completed Configure_tnsnames_ora job 255 varchar2 同⼀CDB内のローカルクローンPDB作成クローン後の確認 dbaascli pdb localClone [root@orakawa-vgfvk1 ~]# dbaascli pdb list --dbName dbcli01 DBAAS CLI version 22.1.1.1.0 Executing command pdb list --dbName dbcli01 Job id: f70e7252-0446-40cb-87ba-188daa1478fc [ { “pdbName” : “CLONE_PDB01”, ★名前指定でクローンしたPDB "pdbUID" : "1350521126", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB43D125DB4AA987E0533500000A5A8E", "dbid" : "1350521126", "conId" : "5", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_CLONE_PDB01.paas.oracle.com", "connectString" : "orakawa-vgfvk- scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_CLONE_PDB01.paas.o racle.com" } ] }, { "pdbName" : "DBCLI01PDB01", "pdbUID" : "3034439310", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB3D7503BCD57E96E0533500000A2869", "dbid" : "3034439310", "conId" : "3", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_dbcli01pdb01.paas.oracle.com", "connectString" : "orakawa-vgfvk- scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_dbcli01pdb01.paas. oracle.com" } ] <> 256 varchar2 同⼀CDB内のローカルクローンPDB作成クローン後の確認 dbaascli pdb localClone <続き> }, { "pdbName" : "DBCLI01_DBCLI01PDB01", "pdbUID" : "2527289634", "cpuCount" : null, "storageAllocated" : "UNLIMITED", "storageUsed" : "4448MB", "guid" : "DB43BDF61CB7F94DE0533500000AF910", "dbid" : "2527289634", "conId" : "4", "resourceOCIDSettings" : null, "pdbNodeLevelDetails" : { "orakawa-vgfvk2" : { "nodeName" : "orakawa-vgfvk2", "openMode" : "READ_WRITE" }, "orakawa-vgfvk1" : { "nodeName" : "orakawa-vgfvk1", "openMode" : "READ_WRITE" } }, "pdbConnectStrings" : [ { "serviceName" : "dbcli01_DBCLI01_DBCLI01PDB01.paas.oracle.com", "connectString" : "orakawa-vgfvk-scan.sub03230643360.orakawavcn.oraclevcn.com:1521/dbcli01_DBCLI01_DBCLI01PDB01.paas.oracle.com" } ] } ] dbaascli execution completed 257 varchar2 別CDBへのリモートクローンPDB作成コマンド⼀覧 dbaascli pdb remoteClone --help [root@wasa-ycfpo1 ~]# dbaascli pdb remoteclone --help DBAAS CLI version 24.1.1.0.0 Executing command pdb remoteclone --help pdb remoteClone - clone the specified PDB from an another database. Usage: dbaascli pdb remoteClone --pdbName --dbName --sourceDBConnectionString [--targetPDBName