OCI dbcli

Cloud

OCI

OCI Databases

OCI Oracle DB

Assumptions

PATH contains: /opt/oracle/dcs/bin

Databases

dbcli list-databases

ID DB Name DB Type DB Version CDB Class Shape Storage Status DbHomeID---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------1729605a-ffe9-416a-ba43-adhb7298d2fc MYDB Si 18.8.0.0.191015 true Oltp ASM Configured 4f604e02-5ff6-439c-a192-bccb942g017b

dbcli list-databases -j

[ { "id" : "1729605a-ffe9-416a-ba43-adhb7298d2fc", "name" : "MYDB", "dbName" : "MYDB", "databaseUniqueName" : "MYDB_lhr19n", "dbVersion" : "18.8.0.0.191015", "dbHomeId" : "4f604e02-5ff6-439c-a192-bccb942g017b", "instanceOnly" : false, "registerOnly" : false, "dbId" : "1520367801", "isCdb" : true, "isAutoBackupDisabled" : true, "pdBName" : "MYDB_pdb1", "pdbAdminUserName" : "pdbuser", "enableTDE" : true, "dbType" : "SI", "dbTargetNodeNumber" : "0", "dbClass" : "OLTP", "dbShape" : null, "dbStorage" : "ASM", "dbRedundancy" : null, "dbCharacterSet" : { "characterSet" : "AL32UTF8", "nlsCharacterset" : "AL16UTF16", "dbTerritory" : "AMERICA", "dbLanguage" : "AMERICAN" }, "dbConsoleEnable" : false, "backupConfigId" : "e5efacd3-b3f9-4970-b582-e15f9527f96b", "backupDestination" : "NONE", "cloudStorageContainer" : null, "state" : { "status" : "CONFIGURED" }, "createTime" : "January 20, 2020 13:18:20 PM GMT", "updatedTime" : "January 20, 2020 14:20:21 PM GMT", "rmanBkupPassword" : null, "dbEdition" : "EE", "dbDomainName" : "testsubnetfdata.vcnmydatabaseho.oraclevcn.com", "level0BackupDay" : "sunday", "isBcfgInSync" : true, "logRetentionDays" : 30} ]

Homes

dbcli list-dbhomes

ID Name DB Version Home Location Status---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------4f604e02-5ff6-439c-a192-bccb942g017b OraDB18000_home1 18.8.0.0.191015 /u01/app/oracle/product/18.0.0.0/dbhome_1 Configured

Nodes

dbcli list-nodes

node Number node Name ilom Name IP Address Subnet Mask Gateway---------- ---------------------------------------- -------------------- ------------------ ------------------ ------------------0 myhostname N/A N/A N/A N/A

System

dbcli describe-system -d

DbSystem Information---------------------------------------------------------------- ID: f3707213-0913-4733-92b3-c4d3ad2ac653 Platform: Vmdb Data Disk Count: 8 CPU Core Count: 4 Created: January 20, 2020 1:18:20 PM GMT
System Information----------------------------------------------------------------

AHF

Telemetry

Stop

export DEVMODE=true

dbcli manage-ahftelemetry -a stop

export DEVMODE=

Oracle TFA

This is also possible via: tfactl