ExaCS- Frequently used dbaascli commands

In this blog, we will discuss the dbaascli utility to perform various life-cycle and administration operations on Oracle Database Exadata Cloud Service. When using the dbaascli, we have to connect to the root user and execute the code.

Exadata Version

[root@node1 ~]# /usr/local/bin/imageinfo -ver

20.1.2.0.0.201125.2

 

dbaascli version

[root@node1 ~]# rpm -qa | grep -i dbaastools

dbaastools_exa-1.0-1+22.1.1.2.0_220405.0353.x86_64

 

ExaCS DB Home Info

[root@node1 ~]# dbaascli dbhome info

DBAAS CLI version 22.1.1.2.0

Executing command dbhome info

Enter a homename or just press enter if you want details of all homes

 

  HOME_NAME=OraHome1

  HOME_LOC=/mnt/dev/oracle/product/12.1.0/dbhome_1

  VERSION=12.1.0.2

  PATCH_LEVEL=12.1.0.2.211019

  DBs installed=TESTCD

  Agent DB IDs=1293ndj-knskjaf

 OH Backup=NOT Configured

 

 

ExaCS dbaascli patch tool list update status

 

[root@node1 ~]# dbaascli patch tools list

DBAAS CLI version 22.1.1.2.0

Executing command patch tools list

Checking Current tools on all nodes

 node1: Patchid : 22.1.1.2.0_220405.0353

 Available Patches

Patchid : 22.2.1.0.1_220423.1318(LATEST)

 Install the latest version of dbaastools by using the command: dbaascli admin updateStack

 node2: Patchid : 22.1.1.2.0_220405.0353

 Available Patches

Patchid : 22.2.1.0.1_220423.1318(LATEST)

 Install the latest version of dbaastools by using the command: dbaascli admin updateStack

 All Nodes have the same tools version

Install latest version of dbaastools

dbaascli admin updateStack

  

ExaCS available database software version

 

[root@node1 ~]# dbaascli cswlib list

DBAAS CLI version 22.1.1.2.0

Executing command cswlib list

 

INFO : Log file => /var/opt/oracle/log/list/list_2022-04-28_07:25:14.618957212606.log

[INFO] [DBAAS-14011] - The usage of this command is deprecated.

   ACTION: It is recommended to use 'dbaascli cswlib showImages' for this operation.

INFO : dbimage fixup executed.

INFO: exabm=1 and oss_uri from return_exabm_url() :https://swiftobjectstorage.ca-montreal-1.oraclecloud.com

 

############ List of Available BP #############

-JAN2021 (For DB Versions  18000 12201 12102 11204 19000)

-APR2021 (For DB Versions  18000 12201 12102 11204 19000)

-JUL2021 (For DB Versions  18000 12201 12102 11204 19000)

-OCT2021 (For DB Versions  18000 12201 12102 11204 19000)

-JAN2022 (For DB Versions  18000 12201 12102 11204 19000)

-APR2022 (For DB Versions  18000 12201 11204)

 

############ List of Available NONCDB BP #######

-JAN2021 (For DB Versions  18000 12201 12102 19000)

-APR2021 (For DB Versions  18000 12201 12102 19000)

-JUL2021 (For DB Versions  18000 12201 12102 19000)

-OCT2021 (For DB Versions  18000 12201 12102 19000)

-JAN2022 (For DB Versions  18000 12201 12102 19000)

  

dbaascli cswlib showImages

 

[root@node1 ~]# dbaascli cswlib showImages

DBAAS CLI version 22.1.1.2.0

Executing command cswlib showImages

Job id: 9800jk-4553-bcf1-0eca2a607f5d

 

############ List of Available Database Images  #############

 

1.IMAGE_TAG=11.2.0.4.200714
  VERSION=11.2.0.4.200714
  DESCRIPTION=11.2 JUL 2020 DB Image
  IMAGE_ALIASES=[11204-200714, 11204-JUL2020]
 
19.IMAGE_TAG=12.1.0.2.210420-NC
  VERSION=12.1.0.2.210420
  DESCRIPTION=12.1 APR 2021 Non CDB Image
  IMAGE_ALIASES=[12102-NC210420, 12102-NCAPR2021]
 
6.IMAGE_TAG=18.15.0.0.0-NC
  VERSION=18.15.0.0.0
  DESCRIPTION=18c JUL 2021 Non CDB Image
  IMAGE_ALIASES=[18000-NC181500, 18000-NCJUL2021, NC18.15.0.0.0-NC]
 
62.IMAGE_TAG=19.14.0.0.0-NC
  VERSION=19.14.0.0.0
  DESCRIPTION=19c Jan 2022 Non CDB Image
  IMAGE_ALIASES=[19000-NC191400, 19000-NCJAN2022, NC19.14.0.0.0-NC]
 
############ List of Available Grid Images  #############
 
1.IMAGE_TAG=19.14.0.0.0
  VERSION=19.14.0.0.0
  DESCRIPTION=19c JAN 2022 GI Image
 
2.IMAGE_TAG=19.13.0.0.0
  VERSION=19.13.0.0.0
  DESCRIPTION=19c OCT 2021 GI Image

 

 

dbaascli database status

 

[root@node1 ~]# dbaascli database status --dbname TESTC

DBAAS CLI version 22.1.1.2.0

Executing command database status

Database Status:

Instance TESTC1 is running on node node1 with online services TEST_suggestcloud.com. Instance status: Open.

Instance TESTC2 is running on node node2 with online services TEST_suggestcloud.com. Instance status: Open.

 

Database name: TESTC

Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production

 

 
dbaascli listener status

 

[root@node1 ~]# dbaascli listener status --dbname TESTC

DBAAS CLI version 22.1.1.2.0

Executing command listener status

Geting listener status

Listener LISTENER is enabled

Listener LISTENER is running on node(s): node2,node1

[root@node1 ~]#

 

Database Bounce

dbaascli database bounce --dbname TESTC

 

[root@node1 ~]# dbaascli database bounce --dbname TESTC

DBAAS CLI version 22.1.1.2.0

Executing command database bounce

Job id: 090jjjb-ec9b-483f-a4f8-7eee4a2d3227

dbaascli execution completed

[root@node1 ~]#

 
Database Stop

dbaascli database stop --dbname TESTC

[root@node1 ~]# dbaascli database stop --dbname TESTC

DBAAS CLI version 22.1.1.2.0

Executing command database stop

Job id: 909jih-ec9b-483f-a4f8-7eee4a2d3227

dbaascli execution completed

[root@node1 ~]#

 

 
Database Start

dbaascli database start --dbname TESTC

[root@node1 ~]# dbaascli database start --dbname TESTC

DBAAS CLI version 22.1.1.2.0

Executing command database start

Job id: kkhoh-ec9b-483f-a4f8-7eee4a2d3227

dbaascli execution completed

[root@node1 ~]#

 

 

Also, Read

ExaCS- EBS 12.2.11 upgrade steps

ExaCS - Create Database Home

Create an Oracle Integration Cloud Instance

ExaCS: 19c Upgrade from 12c Database

adopmon utility in EBS 12.2 | Monitor adop sessions