You want to access your database over SQL*Net with a client application that is running locally on your machine. How would you enable access to port 1521 of the Compute Node (VM)?

Question

Options

• AUse Oracle Compute Cloud Service to enable the ora_p2_dblistener security rule.
• BRun the lsnrctl reload listener command.
• CUse the Oracle GlassFish Server Administration Console to start the listener application.
• DChange the firewall rules.

• A
  12% (2)
• C
  6% (1)
• D
  82% (14)

Explanation

The DBaaS services are run under the Oracle Compute Cloud (IaaS). This has it's own firewall configuration, allowing you to limit access to your services. By default, all endpoints except SSH are disabled. There are a number of predefined "Security Rules" to open up the assorted endpoints, but they typically open the endpoints to public, which is rather risky. Instead, you should define custom rules, opening access to ports from specific machines. Navigate to the main "Oracle Database Cloud Service". Click on the hamburger next to the service of interest. Click the "Access Rules" option on the popup menu. Click the "Create Rule" button. Enter a "Rule Name". Select "" as the "Source" and enter your IP address in resulting box. Select "DB" as the "Destination". Enter "1521" as the "Destination Port(s)". Leave "TCP" as the "Protocol". Click the "Create" button. You should now be able to connect to the database from the specified IP address. https://oracle-base.com/articles/vm/oracle-cloud-database-as-a-service-dbaas-create-service

No community discussion yet for this question.