How would you connect from your local machine to the database instance on the DBaaS server by using SQL*Net?
A.
You start an SSH process on your local machine to communicate to a tunnel created on the DBaaS server.
B.
You must use port 1521 and the TCPS communication protocol.
C.
You can use only the SSH connection that is defined on port 22 that is configured by default during DBaaS instance installation.
D.
You must use Transparent Data Encryption (TDE) to secure connections to the DBaaS database instance when using SQL*Net connections from your local
machine to DBaaS database instances.
Explanation:
To confirm remote access to the database through the SQL*Net security rule, create a connection to the database in Oracle SQL Developer. When creating the
connection, fill out the fields as follows:
Username: enter SYSTEM.
Password: enter Pa55_WoRd.
Hostname: enter the Public IP address of the compute node associated with the database deployment. To find out this address, display details of the service as
described in Viewing Detailed Information for a Database Deployment
Port: enter 1521.
SID: enter ORCL.
After entering values, click Test to test the connection.
Note: TCPS is TCP/IP with SSL.
Using Oracle Database Cloud Service (February 2017), 4-24
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf
I have taken an exam.
I checked B but it was incorrect.
“Connect remotely to the DBaaS database using SQL*NET”
What is correct?
I think the correct answer is : A
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf ( 5-10 )
Connecting Remotely to the Database by Using Oracle Net Services
Creating an Oracle Net Connection When the Listener Port Is Blocked
To create an Oracle Net connection when the listener port is blocked, you must create an SSH tunnel from your client (localhost) to the port of the compute node hosting the Oracle Net Listener. For information about creating an SSH tunnel, see Creating an SSH Tunnel to a Compute Node Port.
To create an Oracle Net connection that uses the SSH tunnel, you can use the easy connect method to specify a connect identifier with the following format:
localhost:listener-port-number/sid-or-service-name
For example:
localhost:1521/ORCL
or
localhost:1521/PDB1.usexample5822.oraclecloud.internal
Note:
Some database access products, such as Oracle SQL Developer 4.0.3 or later,include functionality to connect to a database through an SSH tunnel. When using these products, you create the SSH tunnel to the listener port within the product and do not need to follow the instructions in Creating an SSH Tunnel to a Compute Node Port
A
C
C
Tunnel is created on your Putty session not on the Dbaas server. Hence A is wrong.
Can some one Please confirm A is the correct answer?