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:
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).
And Thank You Liat Sabag!