The dbaascli Utility -- Part 1

The dbaascli Utility :-

The dbaascli utility is provided on Oracle Database Cloud Service deployments to

perform a variety of life-cycle and administration operations. Using the dbaascli utility, you can perform operations like:

  •   Changing the password of the SYS user
  •  Checking the status of the Oracle Data Guard configuration
  •  Switchover and failover in an Oracle Data Guard configuration
  •  Patching the database deployment
  •  Database recovery
  • Rotating the master encryption key

dbaascli database bounce

The database bounce subcommand of the dbaascli utility can be used to shut down and restart the database.


[oracle@prod-dg01 ~]$ dbaascli database bounce

DBAAS CLI version 1.0.0

Executing command database bounce

Executing command database stop

Database stopped in immediate

Executing command database start

Database started

[oracle@prod-dg01 ~]$ dbaascli database status

DBAAS CLI version 1.0.0

Executing command database status

Database Status:

Database is open

Database name: PROD

 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0      Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 – Production


dbaascli database changepassword

The database changepassword subcommand of the dbaascli utility is used to change the

password of a database user.

Execute this command as the oracle user.

 

[oracle@prod-dg01 ~]$ dbaascli database changepassword

DBAAS CLI version 1.0.0

Executing command database changepassword

Enter username whose password change is required: system

Enter new  password:

Re-enter new password:

Successfully changed the password for user sys/system

[oracle@prod-dg01 ~]$


dbaascli database stop

The database stop subcommand of the dbaascli utility can be used to shut down the

database.

Execute this command as the oracle user.

[oracle@prod-dg01 ~]$ dbaascli database stop

DBAAS CLI version 1.0.0

Executing command database stop

Database stopped in immediate

[oracle@prod-dg01 ~]$




dbaascli database start

The database start subcommand of the dbaascli utility can be used to start the

database instance and open the database.

Execute this command as the oracle user.

[oracle@prod-dg01 ~]$ dbaascli database start

DBAAS CLI version 1.0.0

Executing command database start

Database started

[oracle@prod-dg01 ~]$


dbaascli database status

The database status subcommand of the dbaascli utility can be used to check thestatus of the database in your database deployment.

Execute this command as the oracle user.

[oracle@prod-dg01 ~]$ dbaascli database status

DBAAS CLI version 1.0.0

Executing command database status

Database Status:

Database is open

Database name: PROD

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0      Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production


dbaascli pdb checkdb 

The pdb checkdb subcommand of the dbaascli utility lists information about a container database (CDB) 

Connect to a compute node as the oracle user and execute this command.

$ dbaascli pdb checkdb --dbname dbname

dbaascli pdb checknode :

The pdb checknode subcommand of the dbaascli utility lists status information about pluggable databases (PDBs) that are associated with a specific container database (CDB) and a specific compute node 

Connect to a compute node as the oracle user and execute this command.

$ dbaascli pdb checknode --node nodenum --dbname dbname


Remaining Dbaascli command i will publish in part-2 


Thanks

Rajan







Comments

Post a Comment

Popular posts from this blog

AUTONOMOUS DATABASE SERVICES

  AUTONOMOUS DATABASE SERVICES :- Database capabilities of the Oracle Database enable the AutonomousDatabase to be offered in two editions that are specifically tailored to a workload . Oracle Autonomous Data Warehouse (ADW) is tailored to Data Warehousing, Data Marts, Data Lakes, and Machine Learning workloads. Oracle Autonomous Transaction Processing (ATP) is tailored to On-Line Transaction Processing, Batch, reporting, IoT, application development, machine learning, and mixed workload environments. 1) Autonomous Data Warehouse 2) Autonomous Transaction Processing Thanks Rajan
Read more

Oracle Dbaastool version upgrade

1) How to validate which version dbaas tool running       rpm -qa --last | grep -i dbaastools_exa The command below output :- dbaastools_exa-1.0-1+18.2.3.2.0_190708.2222.x86_64 2) Validate the latest tools version available . Run below command as root user  dbaascli patch tools list  Below output for the command  DBAAS CLI version 18.2.3.2.0 Executing command patch tools list Checking tools on all nodes Current Patchid on : 18.2.3.2.0_190708.2222  Available Patches Patchid : 18.2.3.2.0_190801.1500 Patchid : 18.2.3.2.0_190826.0552 Patchid : 19.4.1.0.0_190827.1034(LATEST)  Install tools patch using dbaascli patch tools apply --patchid 19.4.1.0.0_190827.1034    or dbaascli patch tools apply --patchid LATEST this is latest version(19.4.1.0.0_190827.1034(LATEST)) available on the server . 3) Upgrade the the tools as root user .  dbaascli patch tools apply --patchid LATEST  It will take approx 2 hours to complete this command ....
Read more