OAC connection with Oracle DB VM (DBCS) on OCI, the host name and service name

 I created a DB system of Oracle DB on OCI (Oracle Cloud).

I want to create connection from OAC (Oracle Analytics Cloud) to that DB.

What are the host and Service values?

This is my DB:

This is the connection screen in OAC (create / connection / Oracle Datbase):

What should be the Host value?

It is the combination of "Hostname Prefix"."Host Domain name" from the Database screen. 

In my case: dbvm.sub04211323391.bdahabvcn.oraclevcn.com

You can find it easier by going to the databases at the bottom of he DB screen, entering the DB and  pressing database connection. There press "show" for the Long connection string.

There we can see both the service name and the host name.

With this information we can get back to OAC and create a connection:

Please note, if your user is local to specific PDB, the Service Name is slightly different:

One more thing.

If you need to connect to a DB that is on Private Subnet, you have to set a NAT gateway or set up the OAC Private Access Channel (event if the OAC and the DB are on the same subnet).

See:

https://www.ateam-oracle.com/post/preparing-network-gateways-for-private-oracle-analytics-cloud-data-sources

https://www.ateam-oracle.com/post/connecting-to-private-data-sources-using-oracle-analytics-cloud-private-access-channel

Or

http://obieeil.blogspot.com/2021/09/connecting-public-oac-to-private-adw.html

And Thank You Liat Sabag!

P.S.

From the experience with RPD development on DBCS it seems that OAC prefers the host name, rather then IP address.

On the other hand some clients need the IP address and not the host name. 

So we can maintain 2 connection in the RPD. One (the FIRST) with the syntax similar to the example above that will provide the actual connection in OAC and the second with IP as host as source for importing metadata while working with Data Model Admin client.