exam questions

Exam 1z0-160 All Questions

View all questions & answers for the 1z0-160 exam

Exam 1z0-160 topic 1 question 62 discussion

Actual exam question from Oracle's 1z0-160
Question #: 62
Topic #: 1
[All 1z0-160 Questions]

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 the ora_p2_dblistener security rule.
  • B. Run the lsnrctl reload listener command.
  • C. Use the Oracle GlassFish Server Administration Console to start the listener application.
  • D. Change the firewall rules.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
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.
References:
https://oracle-base.com/articles/vm/oracle-cloud-database-as-a-service-dbaas-create-service

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Currently there are no comments in this discussion, be the first to comment!
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...