Use Bastion Service to Connect To Autonomous DB within a private subnet PLSQL Developer

Posted on

Validate VCN security list ingression rule.

  1. Find your database subnet
  2. check security list settings
  3. if 1522 ingress rule not existing, add it

Create A Bastion in the same VCN or existing bastion in the same VCN where your Autonomous DB reside

Create Session

type: SSH port forwarding | IP address | Port: 1522 | Paste SSH Key

Open SSH Tunnel

View SSH commands and Copy it

“-i <privateKey>" is not needed since we use public key, change “<localPort>” to “1522“, add “-v” ( verbose) at the end of the ssh command and run command

Download DB wallet

Unzip file and edit tnsnames.ora

  1. Copy all tns settings from Wallet_APEXPROCDBS/tnsnames.ora to tnsnames.ora
  2. Open sqlnet.ora in Admin folder, change the DIRECTORY and point it to your wallet folder
  3. open tnsnames.ora in admin folder, and change host to localhost.
  4. open PLSQL Developer and add new connection

Leave a Reply