I install the Instant Client at work on my servers, and have reinstalled three times so I'm quite sure the issues is not there.įinally, I installed SQLPlus and it, within a reasonable amount of time, shows this error: I've also installed the Oracle Instant Client and the required environment variables for it to work. I've followed the Oracle instructions on how to connect () and get what feels like a timeout, but SQLcl never did indicate it just hung. I've tried about everything under the sun, and cannot for the life of me get my Oracle Cloud Free Tier Compute Instance to connect to my Oracle Cloud Free Tier ATP Database. Networking -> Virtual Cloud Networks -> VirtualCloudNetwork-YOURID -> Security List Details -> Egress Rules Looks like it was an issue with the Oracle Virtual Cloud Network Egress rules.įor some reason, my Egress rules only allowed 80/443 so either open it to all ports or add 1522/PORT as needed. Deploy ODI in a different VCN from the ADB instance, and configure local VCN Peering to route traffic between the VCNs, and then the security list to allow the traffic between the different VCN subnets. Similar to option 1 but with the use of a different VCN. ODI and the database will reside in the same subnet and the security list should only allow routing of database traffic in the private subnet. This subnet, if in the same VCN, should have a security list configured to allow traffic inbound to the subnet of the ATP/ADW instances.Ĭonfigure ODI in the same private subnet as a bastion instance, to create vnc connections and forward from the bastion instance to the local client (to access odi studio).
ODI in a public subnet with public IP and using a routing table that has an internet gateway. The use of the private endpoint allows for better security and simple management of the network services used by the Autonomous Database instances.įor more information about Private endpoints refer here.Īs ODI typically requires vnc access, you will have the following type of options to configure ODI: ODI and ATP/ADW will follow the OCI network configuration, routing, security lists etc. Yes, there is no restriction toward using this option.
0 kommentar(er)
