[Oracle Cloud] : START/STOP Oracle DBAAS Cloud Database Instance using dbaascli

STOP/START/RESTART Oracle DBAAS Cloud Database Service Database Instance using dbaascli command line utility.

In this blog post, I will demonstrate the dbaascli database sub-commands to play with oracle database instance that how we stop, start, bounce(here bounce means, your oracle database cloud instance will me stopped with immediate option and then it starts back normally in read-write mode).

You can also change the password of SYS user from the dbaascli command line:


Login to the Oracle cloud compute node using oracle user:

Invoke dbaascli command line utility:

[oracle@RAJDB121 ~]$ dbaascli
DBAAS CLI version 1.0.0
DBAAS>

You can check options of database sub-command of dbaascli command as following:

DBAAS>database -h
Executing command database -h
Valid Subcommands:
   bounce
   stop
   changepassword
   status
   start
DBAAS>

You can check the status of current oracle database cloud service instance:

DBAAS>database status
Executing command database status
Database Status:
Database is open
Database name: RCDB121

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


DBAAS>

You can restart/bounce the oracle database cloud service instance using the database bounce command of dbaascli command line utility as below:

bounce option of database sub-command is actually shuts down the oracle database cloud service database instance with immediate option and starts it up normally in read-write mode.

DBAAS>database bounce
Executing command database bounce
Executing command database stop
Database stopped in immediate
Executing command database start
Database started
DBAAS>

You can shutdown the oracle cloud database service database instance using following command, it shuts down the oracle cloud database instance with immediate option.

DBAAS>database stop
Executing command database stop
Database stopped in immediate
DBAAS>

You can start the oracle database cloud service database instance using following command.

DBAAS>database start
Executing command database start
Database started
DBAAS>

Finally, after starting the oracle cloud database service database instance, you can check its status.

DBAAS>database status
Executing command database status
Database Status:
Database is open
Database name: RCDB121

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


DBAAS>