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. dbaascli dataguard switchover [–password password]
Category: ORACLE DBAAS
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. dbaascli dataguard status [–details yes|no]
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. dbaascli database stop
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. dbaascli database status
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. dbaascli database start
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 […]
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 […]
Create Database on Oracle Cloud
We will show you how to create database on oracl cloud database. Log into your Oracle Cloud Services account Go to the “Oracle Database Cloud Service” and create a new service Select “Oracle Database Cloud Service” as the type of subscription from the Dropdown Select the SSH Public Key as shown in the attached figure […]