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)?
A.
Use Oracle Compute Cloud Service to enable theora_p2_dblistenersecurity rule.
B.
Run thelsnrctl reload listenercommand.
C.
Use the Oracle GlassFish Server Administration Console to start the listener application.
D.
Change the firewall rules.
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” asthe “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-dbaascreate-service
A
A
ora_p2_dblistener, which controls access to the port used by SQL*Net.
A
A
A
.. That seems to be the best answer.
In order to make this remote connection to the db you must connect to the listener.
The listener port number is 1521.
****************
The target database must be network accessible on the listener port.
To enable access on the listener port, you need to enable the ora_p2_dblistener
security rule automatically created for the Database Cloud Service database
deployment when the deployment was created.
Creating an Oracle Net Connection When the Listener Port Is Unblocked
To create an Oracle Net connection when the listener port is unblocked, you can use
the easy connect method to specify a connect identifier with the following format:
node-ip-address:listener-port-number/sid-or-service-name
For example:
198.51.100.101:1521/ORCL
or
198.51.100.102:1521/PDB1.usexample5822.oraclecloud.internal
********************
Of course….the question asks “enable access to port 1521”, not “how do you open port 1521”. If it asked the latter, the answer would be A, but to solve the problem in this question, creating and enabling another access rule that would open por 1521 but only for my machine and no others would be more appropriate. In the absence of this, “change the firewall rules” is right, even if a bit diffuse…
A
A and D are both right!
A opens communication to public – so access from local machine will work BUT is risky to do
D on the other hand can be used to open specific access (Now if local machine has dynamic ip this will not work but it is not specified so in question)
I would go for D. Any other suggestions? Anyone taken the exam and already answered?