dbaascli listener status

The listener status subcommand of the dbaascli utility is used to obtain information about the status of the listener. Execute this command as the oracle user.

Read More

dbaascli dataguard reinstate

The dataguard reinstate subcommand of the dbaascli utility is used to reinstate a failed primary database as a standby database after a failover. Execute this command as the oracle user.

Read More

dbaascli dataguard failover

The dataguard failover subcommand of the dbaascli utility is used to perform a manual failover to the standby database in your Oracle Data Guard configuration. Execute this command as the oracle user.

Read More

dbaascli dataguard switchover

The dataguard switchover subcommand of the dbaascli utility is used to perform a switchover to the standby database in your Oracle Data Guard configuration. Execute this command as the oracle user.

Read More

dbaascli dataguard status

The dataguard status subcommand of the dbaascli utility is used to check the status of the Oracle Data Guard configuration. Execute this command as the oracle user.

Read More

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.

Read More

dbaascli database status

The database status subcommand of the dbaascli utility can be used to check the status of the database in your database deployment. Execute this command as the oracle user.

Read More

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.

Read More

Connect to Oracle Cloud Database with SQL Developer using SSH

Let’s turn off the 1521 port if we can already open so that to make sure our connection using SSH works. It will confirm us that SSH is enabled. Moreover SSH connection is more secure. In SQL Developer menu, click on View –> SSH. Then right click and choose “Create New SSH Host”. Provide the […]

Read More

Connect to Oracle Cloud Database using SQL Developer

By default, the Oracle DBaaS Cloud Service blocks access port 1521 used by tnsping. You have to open the port before you can connect using SQL Developer or Connecting to another instance via sqlplus. Log in to the Oracle Database Cloud Service and click on the service name which you already created. Note down the […]

Read More