- Provisioning a Database Cloud Service Instance
- Connecting to a Database Cloud Service Instance
- Monitoring and Managing the Database Cloud Service Instance
1. Provisioning Database Cloud Service
Answer: You can still run the manual setup discussed at How To Manually Set Up Oracle GoldenGate in DBaaS.
2. Connecting to Database Cloud Service
- Connect to the database server via SSH and run SQL*Plus [1]
- Connect to the data server via SQL Developer [2]
2.1. Using SSH and SQL*Plus
Each Database Cloud Service instance has a public IP assigned. You can find the information on the detailed page of each Database Cloud Service instance as shown in the following screenshot. After getting the IP address, you can configure an SSH connection using either using PuTTY or SSH command. You need to provide the hostname (Database Cloud Service IP address), port (22) and the private key for the connection. The following is an example of PuTTY setup.
2.2 Using SQL Developer
To connect Database CS with SQL Developer, you can follow the instruction described at [2]. This includes setting up an SSH host and then creating a JDBC connection using the SSH tunnel.
3. Monitoring and Managing the Database Cloud Service Instance
- DBaaS Monitor Console: This requires port 443 used for HTTPS connection. (login with dbaas_monitor)
- EM Console: This requires port 1158 used by Enterprise Manager 11g Database Control (login with system)
ssh -N -L 8080:129.144.2.30:443 [email protected] ssh -N -L 8081:129.144.2.30:5500 [email protected]
- https://127.0.0.1:8080/dbaas_monitor
- https://127.0.0.1:8081/em
- Connecting to a Database Cloud Service (DBaaS) Instance Through an SSH Tunnel, Oracle Online Tutorial
- Connecting to a Database Cloud Service with SQL Developer and SSH, Oracle Blog by Brian Spendolini
- Creating an SSH Proxy Tunnel with PuTTY