{"id":132,"date":"2023-08-31T13:46:39","date_gmt":"2023-08-31T11:46:39","guid":{"rendered":"http:\/\/130.61.57.200\/?p=132"},"modified":"2023-09-01T09:53:03","modified_gmt":"2023-09-01T07:53:03","slug":"access-autonomous-database-thfough-cloudshell","status":"publish","type":"post","link":"http:\/\/130.61.57.200\/index.php\/2023\/08\/31\/access-autonomous-database-thfough-cloudshell\/","title":{"rendered":"Access Autonomous Database through CloudShell"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">To access the Autonomous Database using CloudShell you need to set the following parameters:<\/p>\n\n\n\n<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-1f26014c wp-block-group-is-layout-flex\">\n<p class=\"wp-block-paragraph\"><strong>export ADBID<\/strong>=ocid1&#8230;.. &#8211;This is the OCID of the Autonomous database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>export WNAME<\/strong>=wallet.zip &#8212;This is the wallet file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>export WPWD<\/strong>=<em>password<\/em>  &#8212; This is the password of the wallet.<\/p>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Then we downloa the wallet to our user&#8217;s home:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>oci db autonomous-database generate-wallet &#8211;autonomous-database-id $ADBID \\<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>&#8211;file $WNAME &#8211;password $WPWD<br>export TNS_ADMIN=`<code>pwd<\/code>`<br>unzip wallet.zip<br><\/strong>edit sqlnet.ora to point to wallet folder<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>sql -cloudconfig $WNAME admin@adb<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To access the Autonomous Database using CloudShell you need to set the following parameters: export ADBID=ocid1&#8230;.. &#8211;This is the OCID of the Autonomous database. export WNAME=wallet.zip &#8212;This is the wallet file. export WPWD=password &#8212; This is the password of the wallet. Then we downloa the wallet to our user&#8217;s home: oci db autonomous-database generate-wallet &#8211;autonomous-database-id [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":138,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44,3],"tags":[48,49],"class_list":["post-132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oci","category-oracle","tag-autonomous-database","tag-cloudshell"],"blocksy_meta":[],"_links":{"self":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/comments?post=132"}],"version-history":[{"count":2,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/132\/revisions"}],"predecessor-version":[{"id":134,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/posts\/132\/revisions\/134"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media\/138"}],"wp:attachment":[{"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/media?parent=132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/categories?post=132"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/130.61.57.200\/index.php\/wp-json\/wp\/v2\/tags?post=132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}