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:

  •   Database stop/start/bounce and status
[oracle@Clouddb01 ~]$ dbaascli database stop
DBAAS CLI version 1.0.0
Executing command database stop
Database stopped in immediate
[oracle@Clouddb01 ~]$ dbaascli database start
DBAAS CLI version 1.0.0
Executing command database start
Database started
[oracle@Clouddb01 ~]$ dbaascli database status
DBAAS CLI version 1.0.0
Executing command database status
Database Status:
Database is open
Database name: CDB01

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production
[oracle@Clouddb01 ~]$ dbaascli database bounce
  • Listener stop/start/status/Bounce
[oracle@Clouddb01 ~]$ dbaascli listener stop
DBAAS CLI version 1.0.0
Executing command listener stop
Starting listener
The command completed successfully
[oracle@Clouddb01 ~]$ dbaascli listener start
DBAAS CLI version 1.0.0
Executing command listener start
Starting listener
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 06-NOV-2017 15:38:27
Copyright (c) 1991, 2017, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...
.......
.......
The listener supports no services
The command completed succssfully
[oracle@Clouddb01 ~]$ dbaascli listener status
[oracle@Clouddb01 ~]$ dbaascli listener bounce
[oracle@Clouddb01 ~]$ dbaascli listener bounce
DBAAS CLI version 1.0.0
Executing command listener bounce
Bouncing listener
Executing command listener stop
Starting listener
....
....
The listener supports no services
The command completed successfully
  • Change database user password. Login as oracle
[oracle@Clouddb01 ~]$ dbaascli database changepassword
DBAAS CLI version 1.0.0
Executing command database changepassword
Enter username whose password change is required: test
Enter new password:
Re-enter new password:
password changed
  • List the avaiable commands and press q to quit.
[oracle@Clouddb01 ~]$ dbaascli list
DBAAS CLI version 1.0.0
Very Long Text, press q to quit
Available commands:
cloud sync
database bounce
database changepassword
database start
database status
database stop
 ....
  • History
[oracle@Clouddb01 ~]$ dbaascli history
DBAAS CLI version 1.0.0
  • Help
[oracle@Clouddb01 ~]$ dbaascli database -help
DBAAS CLI version 1.0.0
Executing command database -help
Valid Subcommands:
bounce
stop
changepassword
status
start
  • Dataguard
dbaascli dataguard failover [--force yes|no] [--password password]

Will through other commands in future oracle cloud blogs.

Mandy!!!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s