Enter your keyword


Connect DBaaS instance from SQL Developer

In the previous article, we have provisioned a Oracle Database (DBaaS) instance. This article will show how to connect DBaaS instance from SQL developer from public network. 

By default, the rule to access the Database instance from SQL Developer is disabled.

Let’s see what happens when we try to connect DB instance using SQL developer before we enable the rule.

Find out the DB details by clicking the DB instance which we have created

See the Public IP and try to connect with SQL developer. Will get the error “Test failed: IO Error: The Network Adapter could not establish the connection

The port 1521 is not allowed from the public network. Let’s enable the port and try again.

When a database instance is created a number of Oracle Compute Cloud Service access rules are created, but set to a disabled status. When we enable one of these predefined access rules, the given port on the compute node is opened to the public internet.

In order to connect the DB with SQL developer one predefined rule “ora_p2_dblistener” need to enable

To enable the rule “ora_p2_dblistener”, Click on the hamburger menu beside the database service name and Click “Access Rules

To enable SQL Developer access, click the menu  hamburger menu beside  the “ora_p2_dblistener” access rule, and select Enable

Click Enable from the Enable Access rule popup

Once the rule is enabled, a red cross sign will go away which indicates the rule has been enabled successfully

Now try again to make connection using SQL developer, this time connection should be successful.


Some Toughts (3)

  1. added on 22 Apr, 2019

    You have provided a nice article, Thank you very much for this one. And I hope this will be useful for many people. And I am waiting for your next post keep on updating these kinds of knowledgeable things
    SEO Training in Chennai
    SEO Course in Chennai
    Advanced Java Training in Chennai
    Hadoop Course in Chennai
    Big Data Analytics Courses in Chennai
    Big Data Course in Chennai
    Selenium Training in Chennai
    SEO Training in Tambaram

  2. added on 16 Jul, 2019

Leave a Reply

Your email address will not be published.