Validate VCN security list ingression rule.
- Find your database subnet
- check security list settings
- 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
Open SSH Tunnel
" 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
- Copy all tns settings from Wallet_APEXPROCDBS/tnsnames.ora to tnsnames.ora
- Open sqlnet.ora in Admin folder, change the DIRECTORY and point it to your wallet folder
- open tnsnames.ora in admin folder, and change host to localhost.
- open PLSQL Developer and add new connection