Connect DBaaS instance from SQL Developer
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.
great job! The author giving the present post, this is very unique and worthy content. I am waiting for your another post…
Oracle Training in Chennai
Oracle Training institute in chennai
Tableau Training in Chennai
Spark Training in Chennai
Unix Training in Chennai
Power BI Training in Chennai
Oracle DBA Training in Chennai
Oracle Training in Chennai
Oracle Training institute in chennai
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
Commenting on a blog is an art. Good comments create relations. You’re doing great work. Keep it up.
Oracle Training in Chennai
Best Oracle Training in Chennai
Oracle Training Course in Chennai
Best Oracle Training Institute in Chennai
Oracle Training Center in Chennai