Setup: Oracle Cloud Infrastructure Oracle Cloud DB: Autonomous DB. DB#1( Data Warehouse), DB#2(Transaction Processing)
Problem: I can access DBs from Oracle Cloud Infrastructure Website, and using SQL Developer from my local computer, but I am not able to access them from SSH instance from my local computer.
I ssh to the instance with abc ID, next I look for Oracle DBs that I created; I cannot find them. I don't have abc id listed in those 2 DBs.
What do I need to do to access my DBs from SSH ?
Thanks.
As I understood you are trying to connect to the DB from your instance. In that case, I would recommend you to configure a service gateway in that particular VCN (where the instance belongs) to connect to your DB service. Even after that make sure you have the proper rules in the route table and the security list.
Please refer the document on connecting to ADB, this might be useful.