Step 3 - View the Databases and Database Homes Using the CLI
You can also manage databases from the command line. Go to the command line window.
Use the odacli list-databases
command to view your databases. Then use odacli describe-database
to see the details for a specific database. Be sure to use the database ID shown in the odacli list-databases
command, not the ID shown in the example.
$ odacli describe-database -i d1e615c3-5855-4b19-9ad0-40b620ac5f13
Database details
----------------------------------------------------------------
ID: d1e615c3-5855-4b19-9ad0-40b620ac5f13
Description: db2
DB Name: db2
DB Version: 19.13.0.0.211019
DB Type: SI
DB Role: PRIMARY
DB Target Node Name: node_0
DB Edition: EE
DBID:
Instance Only Database: false
CDB: false
PDB Name:
PDB Admin User Name:
SEHA Enabled: false
Class: OLTP
Shape: odb1
Storage: ASM
DB Redundancy: MIRROR
CharacterSet: AL32UTF8
National CharacterSet: AL16UTF16
Language: AMERICAN
Territory: AMERICA
Home ID: a1314be1-2c6f-411f-b2c7-61444449f02b
Console Enabled: false
TDE Wallet Management:
TDE Enabled: false
Level 0 Backup Day: Sunday
AutoBackup Enabled: true
Created: February 26, 2022 1:18:48 AM UTC
DB Domain Name: example.com
Associated Networks: