Enabling access to compute node using “access rules”
For database deployments created in Oracle Cloud Infrastructure Classic, Oracle Database Cloud Service uses access rules to provide secure network access to database deployments. You can use the Oracle Database Cloud Service console to perform network access operations such as enabling and disabling access rules and creating new access rules. When a database deployment is created, the following access rules are created, but set to a disabled status
- ora_p2_dbconsole, which controls access to port 1158, the port used by Enterprise Manager 11g Database Control.
- ora_p2_dbexpress, which controls access to port 5500, the port used by Enterprise Manager Database Express 12c.
- ora_p2_dblistener, which controls access to the port used by SQL*Net.
- ora_p2_http, which controls access to port 80, the port used for HTTP connections.
- ora_p2_httpssl, which controls access to port 443, the port used for HTTPS connections, including Oracle REST Data Services, Oracle Application Express, and Oracle DBaaS Monitor.Please never touch following access control which is only used by oracle support.
I will now enable access to compute node.Please press button highlighted here
Please select “Access Rules” option
ADDITIONAL ACCESS RULES FOR RAC CONFIGURATION
Please enable port 1521 now.
Now you can directly connect to SQL Developer using port 1521 from your desktop.No need for creating SSH tunnel.
Defining a Custom Host Name or Domain Name for Database Cloud Service
You can associate a custom host name or domain name to the public IP address of a compute node associated with your Oracle Database Cloud Service environment.
To associate a custom host name to the public IP address of a compute node, please contact the administrator of your DNS (Domain Name Service) and request a custom DNS record for the compute node’s public IP address.
For example, if your domain is world.com and you wanted to use clouddba as the custom host name for a compute node, you would request a DNS record that associates clouddba.world.com to your compute node’s public IP address.
To associate a custom domain name to the public IP address of a compute node:
- Register your domain name through a third-party domain registration vendor, such as Register.com, Namecheap, and so on. For example, example.com.
- Resolve your domain name to the IP address of the Database Cloud Service compute node, using the third-party domain registration vendor console. For more information, refer to the third-party domain registration documentation.