{"id":7299,"date":"2021-12-23T08:30:02","date_gmt":"2021-12-23T08:30:02","guid":{"rendered":"https:\/\/rax-stg-wp-aws.com\/blogs\/create-connect-database-in-oci-on-public-subnet\/"},"modified":"2026-11-03T19:28:25","modified_gmt":"2026-11-03T19:28:25","slug":"create-connect-database-in-oci-on-public-subnet","status":"publish","type":"blogs","link":"https:\/\/www.rackspace.com\/de\/blogs\/create-connect-database-in-oci-on-public-subnet\/","title":{"rendered":"Create\/Connect Database in OCI on Public Subnet"},"content":{"rendered":"<p><strong>Introduction&nbsp;<\/strong><br \/>\nBy following the steps outlined in this blog, you will be able to configure a Database in Oracle Cloud Interface. The steps in the entire process can comprise the following:&nbsp;<\/p>\n<ol>\n<li>Generating SSH Keys Pairs In OCI<\/li>\n<li>Create a Database in a Public Subnet<\/li>\n<li>Connect to VM DB system.<\/li>\n<\/ol>\n<p><strong>Pre-Requisites<\/strong><\/p>\n<p>Considering that the following pre-requisites are already in place:&nbsp;<\/p>\n<ul>\n<li>Oracle Cloud Account (Free Trial\/Paid Version)<\/li>\n<li>The Network Configuration for Virtual Machine (VM)\/ Bare Metal (BM) should be configured<\/li>\n<li>Public Subnet<\/li>\n<li>Security List &amp; Open Port 22 &amp; 1521<\/li>\n<li>Internet Gateway<\/li>\n<li>Route Table<\/li>\n<\/ul>\n<p><strong>Let us begin by generating SSH key pairs in OCI:<\/strong><\/p>\n<p><strong>Section 1: Generating SSH Key Pairs in OCI<\/strong><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture1_13.png\" alt=\"OCI pic 1\" \/><\/p>\n<p class=\"text-align-center\"><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/GSG\/Tasks\/creatingkeys.htm\">Image Source<\/a><\/p>\n<p>\nOpen WinSCP &amp; Click on Tools -&gt; Run PuTTYgen<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture2_16.png\" alt=\"OCI pic 2\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture3_11.png\" alt=\"OCI Pic 3\" \/><\/p>\n<p>\n1. To generate the private &amp; public keys, Click on Generate and move the mouse around the blank area in the box as shown above:&nbsp;<\/p>\n<p>2. Key gets generated, as shown in the following screenshot<\/p>\n<p>3. Click on Save private key in your local system.&nbsp;<br \/>\nAdd the key passphrase (Password) and re-enter it again to confirm the passphrase.&nbsp;<\/p>\n<p>4. For public key, copy the Key content in a file on your local system which is shown in the following snippet. Sometimes it is required in case of any issue in accepting public key files.&nbsp;<\/p>\n<p>5. Copied key content of public key can be used in such cases.&nbsp;<br \/>\nThen click on Save Public Key to save the file in the same location where the private key was stored in step 3.<\/p>\n<p><strong>Note:<\/strong> Public key format starts with ssh-rsa &amp; ends with rsa-key-20211015<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture4_10.png\" alt=\"oci pic 4\" \/><\/p>\n<p>\n6. Save public key with .pub &amp; private key with.ppk extension<\/p>\n<p>7. After generating and saving both the keys, you can go back to the Cloud Portal.<\/p>\n<p><strong>Section 2: Create Database in Public Subnet<\/strong><\/p>\n<p>This section involves steps in creating an Oracle Database in Public Subnet on OCI.&nbsp;<br \/>\nLogin to OCI console with your tenant. &nbsp;Here ohravi is the Tenant I already created. &nbsp;<br \/>\nSo below is the URL<br \/>\n&nbsp; &nbsp;<a href=\"https:\/\/cloud.oracle.com\/?tenant=ohravi\"><em>https:\/\/cloud.oracle.com\/?tenant=ohravi<\/em><\/a><\/p>\n<p>Select the links that are highlighted in Box as per the below snippet<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture5_8.png\" alt=\"oci pic 5\" \/><\/p>\n<p>\nSelect the AD &amp; shape as VM with standard shape as per below snippet on the options available<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture6_5.png\" alt=\"oci pic 6\" \/><\/p>\n<p>&nbsp;Select the highlighted\/indicated in Box as per the below snippet on the options available while configuring the DB system<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture7_3.png\" alt=\"oci pic 7\" \/><\/p>\n<p><strong>SSH PUBLIC KEY:<\/strong>&nbsp;Paste your Public key created earlier in Section 1 point 5 as shown in the following screenshot<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture8_2.png\" alt=\"oci pic 8\" \/><\/p>\n<p>Select a name for the VCN, I have used as POC_VCN &amp; the subnet.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture9_3.png\" alt=\"oci pic 9\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Provide a database name here. I am using POC &amp; 19c in my example<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture10_0.png\" alt=\"oci pic 10\" \/><\/p>\n<p>Select create DB system option as indicated in the following snippet<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture11_0.png\" alt=\"oci pic 11\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>It takes 50-60 minutes to keep the instance Up &amp; Running.<\/p>\n<p>When the DB creation is done, the status changes from Provisioning to Available as shown in the following snapshot.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture12_0.png\" alt=\"oci pic 12\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Section 3: Connect to VM DB System which was created in previous steps&nbsp;<\/strong><\/p>\n<p>Login to the OCI Console, &amp; navigate to Database Section select database POC_Ravi<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture13.png\" alt=\"oci pic 13\" \/><\/p>\n<p>\nWhen you click on pocDB above, next page will show the Public IP address as per the following snippet.<br \/>\nUse that IP address in connection as the Host Name in the next step<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture14.png\" alt=\"oci pic 14\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Open <em>putty<\/em><\/p>\n<p>\n1. Enter the following&nbsp;<\/p>\n<p>&#8211; Host Name (or IP Address): Enter opc@Public IP of your instance&nbsp;<\/p>\n<p>&#8211; Port: Enter 22&nbsp;<\/p>\n<p>&#8211; Connection type: Select SSH<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture15.png\" alt=\"oci pic 15\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Now, expand <em>SSH<\/em>&nbsp;and select <em>Auth<\/em>&nbsp;and browse your <em>private key<\/em>&nbsp;and click <em>open<\/em>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture16_0.png\" alt=\"oci pic 16\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Click on <em>Open<\/em><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture17.png\" alt=\"oci pic 17\" \/><\/p>\n<p>Switch to Oracle user to connect with the <em>SQLPLUS<\/em><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture18.png\" alt=\"oci pic 18\" \/><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/blog_article_images\/26388-body-Picture19.png\" alt=\"oci pic 19\" \/><\/p>\n<p><strong>Conclusion&nbsp;<\/strong><\/p>\n<p>The blog explains the basic steps of configuring a Database on the Public subnet along with SSH key generation. Also, the above-explained steps help connect to the Database using the SSH keys which are essential for an Oracle Cloud DBA\u2019s routine activity.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create\/Connect Database in OCI on Public Subnet<\/p>\n","protected":false},"author":2,"featured_media":7301,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","format":"standard","meta":{"content-type":"","nid":"26388","content_type":"blog","created_by":"10130","authored_on":"2023-12-18T08:30:02+00:00","field_article_industries":"","tag_category":"Technical","field_blog_author_text":"by Ravishekhar Yelemane, Oracle Applications Database Administrator, Rackspace Technology","seo_description":"Audit Oracle Database superuser actions with AUDIT_SYS_OPERATIONS parameter. Set up and security implications.\r\n","field_featured_image":"","insights_image":"\/wp-content\/uploads\/2026\/blog_technical_images\/26388-insights_image-oracle-technical-blog-1-insights.jpg","field_partners":"","rxt_platforms":"Oracle","product":"","publisheddate":"2021-12-23T08:30:02","rxt_solutions":"Databases","opengraph_tag":"","x_tag":"","teaser_flag":"Technical Blog","seo_titile":"Create Database in OCI on Public Subnet | Rackspace","field_topics":"","field_slug":"create-connect-database-in-oci-on-public-subnet","footnotes":""},"categories":[178],"tags":[204],"class_list":["post-7299","blogs","type-blogs","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-technical"],"_links":{"self":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs"}],"about":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/types\/blogs"}],"author":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/comments?post=7299"}],"version-history":[{"count":2,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7299\/revisions"}],"predecessor-version":[{"id":9377,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/blogs\/7299\/revisions\/9377"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media\/7301"}],"wp:attachment":[{"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/media?parent=7299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/categories?post=7299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rackspace.com\/de\/wp-json\/wp\/v2\/tags?post=7299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}