{"id":388,"date":"2022-07-15T10:19:34","date_gmt":"2022-07-15T10:19:34","guid":{"rendered":"http:\/\/wp.chaoyu.nl\/?p=388"},"modified":"2022-07-15T10:44:13","modified_gmt":"2022-07-15T10:44:13","slug":"use-bastion-service-to-connect-to-autonomous-db-within-a-private-subnet-plsql-developer","status":"publish","type":"post","link":"https:\/\/chaoyu.nl\/?p=388","title":{"rendered":"Use Bastion Service to Connect To Autonomous DB within a private subnet PLSQL Developer"},"content":{"rendered":"\n

Validate VCN security list ingression rule.<\/p><\/blockquote>\n\n\n\n

  1. Find your database subnet<\/li>
  2. check security list settings<\/li>
  3. if 1522 ingress rule not existing, add it <\/li><\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Create A Bastion in the same VCN or existing bastion in the same VCN where your Autonomous DB reside<\/p>\n\n\n\n

    Create Session<\/p><\/blockquote>\n\n\n\n

    \"\"
    type: SSH port forwarding | IP address | Port: 1522 | Paste SSH Key <\/figcaption><\/figure>\n\n\n\n

    Open SSH Tunnel<\/p><\/blockquote>\n\n\n\n

    \"\"
    View SSH commands and Copy it<\/figcaption><\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \n
    \n

    “-i <privateKey><\/s><\/kbd><\/code><\/em><\/strong>\"<\/code> is not needed since we use public key, change “<localPort><\/em><\/strong>” to “1522<\/em><\/strong>“, add “-v<\/em><\/strong>” ( verbose) at the end of the ssh command and run command<\/p>\n<\/div>\n<\/div>\n\n\n\n

    Download DB wallet<\/p><\/blockquote>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Unzip file and edit tnsnames.ora<\/p><\/blockquote>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
    1. Copy all tns settings from Wallet_APEXPROCDBS\/tnsnames.ora<\/strong><\/em> to tnsnames.ora<\/strong><\/em><\/li>
    2. Open sqlnet.ora<\/em><\/strong> in Admin folder<\/em><\/strong>, change the DIRECTORY and point it to your wallet folder<\/li>
    3. open tnsnames.ora<\/strong><\/em> in admin<\/strong> <\/em>folder, and change host<\/strong> to localhost<\/strong>.<\/li>
    4. open PLSQL Developer and add new connection<\/li><\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

      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 Create Session Open SSH Tunnel “-i <privateKey>” is not needed since we use public…<\/p>\n","protected":false},"author":1,"featured_media":412,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,11,12],"tags":[],"class_list":["post-388","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apex","category-oci","category-oralce-db"],"_links":{"self":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=388"}],"version-history":[{"count":20,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions"}],"predecessor-version":[{"id":420,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/posts\/388\/revisions\/420"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=\/wp\/v2\/media\/412"}],"wp:attachment":[{"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chaoyu.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}