{"id":31,"date":"2023-06-05T13:25:46","date_gmt":"2023-06-05T11:25:46","guid":{"rendered":"http:\/\/cbleile.de\/wordpress\/?p=31"},"modified":"2023-06-05T13:35:13","modified_gmt":"2023-06-05T11:35:13","slug":"installing-oracle-23c-free-developer-release-on-proxmox","status":"publish","type":"post","link":"http:\/\/cbleile.de\/wordpress\/installing-oracle-23c-free-developer-release-on-proxmox\/","title":{"rendered":"Installing Oracle 23c Free developer release on Proxmox"},"content":{"rendered":"\n<p>Oracle provides an OVA (Open Virtual Appliance) file to install the 23c Free Developer Release on Virtualbox. An OVA file contains metadata and file elements in the Open Virtual Format (OVF) to package and distribute one or more virtual machines. The OVA-file provided by Oracle can also be used to import the Oracle 23c Free VM to Proxmox. Here are steps on how to do that:<\/p>\n\n\n\n<p>First download the OVA-file from <a href=\"https:\/\/www.oracle.com\/database\/free\/download\/\">here<\/a>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/Screenshot-2023-06-05-at-11.15.06-1024x224.png\" alt=\"\" class=\"wp-image-25591\"\/><\/figure>\n\n\n\n<p>The next step is to create a VM in Proxmox without disks and without CD (ISO) attached to it:<\/p>\n\n\n\n<p>First provide a name:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-4.png\" alt=\"\" class=\"wp-image-25592\"\/><\/figure>\n\n\n\n<p>Then provide the OS-details and select to not use any CD\/DVD media.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-6.png\" alt=\"\" class=\"wp-image-25596\"\/><\/figure>\n\n\n\n<p>At the System settings you may leave everything on default:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-7.png\" alt=\"\" class=\"wp-image-25597\"\/><\/figure>\n\n\n\n<p>Delete the disk, which is pre-selected by clicking on the waste-baskett at the left side:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-8.png\" alt=\"\" class=\"wp-image-25598\"\/><\/figure>\n\n\n\n<p>So that it looks as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-9.png\" alt=\"\" class=\"wp-image-25599\"\/><\/figure>\n\n\n\n<p>Provide the number of CPUs you want to use on your VM. In my case I do use 2 cores. I usually set the <em>Type<\/em> to &#8222;host&#8220; to provide all features my host-CPU provides to the VM:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-10.png\" alt=\"\" class=\"wp-image-25600\"\/><\/figure>\n\n\n\n<p>Set the amount of RAM you want to provide to your VM:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-11.png\" alt=\"\" class=\"wp-image-25601\"\/><\/figure>\n\n\n\n<p>In the last step define your network settings. I left everything on default on my setup:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-12.png\" alt=\"\" class=\"wp-image-25602\"\/><\/figure>\n\n\n\n<p>Finally check the confirmation page and make sure to NOT select the &#8222;Start after created&#8220; box. Then click on Finish:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-13.png\" alt=\"\" class=\"wp-image-25603\"\/><\/figure>\n\n\n\n<p>After a couple of seconds the VM is visible on your Proxmox GUI:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-14.png\" alt=\"\" class=\"wp-image-25604\"\/><\/figure>\n\n\n\n<p>To import the OVA-file downloaded, follow the steps below:<\/p>\n\n\n\n<p>scp the OVA-file to the hypervisor in e.g. the \/tmp-directory (my Proxmox hypervisor has IP 192.168.2.2):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ scp Oracle_Database_23c_Free_Developer_Appliance.ova root@192.168.2.2:\/tmp<\/code><\/pre>\n\n\n\n<p>Login to the hypervisor and untar the OVA-file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>root@pve-sandbox:~# cd \/tmp\nroot@pve-sandbox:\/tmp# ls -ltr *.ova\n-rw-r--r-- 1 root root 6996211200 Jun  2 20:50 Oracle_Database_23c_Free_Developer_Appliance.ova\nroot@pve-sandbox:\/tmp# tar xvf Oracle_Database_23c_Free_Developer_Appliance.ova\nOracle DB Developer VM.ovf\nOracle DB Developer VM-disk001.vmdk\nOracle DB Developer VM-disk002.vmdk\nroot@pve-sandbox:\/tmp# <\/code><\/pre>\n\n\n\n<p>List the VMs you have. In my case I only have the one with VM ID 100 I just created:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>root@pve-sandbox:\/tmp# qm list\n      VMID NAME                 STATUS     MEM(MB)    BOOTDISK(GB) PID       \n       100 Ora23cFREE           stopped    8192               0.00 0         \nroot@pve-sandbox:\/tmp# <\/code><\/pre>\n\n\n\n<p>Check the storage on my system:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>root@pve-sandbox:\/tmp# pvesm status\nName             Type     Status           Total            Used       Available        %\nlocal             dir     active        98497780        17173872        76274360   17.44%\nlocal-lvm     lvmthin     active       366276608               0       366276608    0.00%\nroot@pve-sandbox:\/tmp# <\/code><\/pre>\n\n\n\n<p>I.e. I have storage local-lvm, which I can use to import the disks to.<\/p>\n\n\n\n<p>Import the 2 disks to my VM with VM ID 100, storage <em>local-lvm<\/em>. Due to blanks in the file-name, please consider the single quotes around the vmdk-file:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>root@pve-sandbox:\/tmp# qm importdisk 100 'Oracle DB Developer VM-disk001.vmdk' local-lvm -format qcow2\nimporting disk 'Oracle DB Developer VM-disk001.vmdk' to VM 100 ...\n  Logical volume \"vm-100-disk-0\" created.\ntransferred 0.0 B of 29.3 GiB (0.00%)\ntransferred 300.0 MiB of 29.3 GiB (1.00%)\ntransferred 600.0 MiB of 29.3 GiB (2.00%)\ntransferred 900.0 MiB of 29.3 GiB (3.00%)\ntransferred 1.2 GiB of 29.3 GiB (4.00%)\n...\ntransferred 29.0 GiB of 29.3 GiB (99.07%)\ntransferred 29.3 GiB of 29.3 GiB (100.00%)\ntransferred 29.3 GiB of 29.3 GiB (100.00%)\nSuccessfully imported disk as 'unused0:local-lvm:vm-100-disk-0'\nroot@pve-sandbox:\/tmp# \n\nroot@pve-sandbox:\/tmp# qm importdisk 100 'Oracle DB Developer VM-disk002.vmdk' local-lvm -format qcow2\nimporting disk 'Oracle DB Developer VM-disk002.vmdk' to VM 100 ...\n  Logical volume \"vm-100-disk-1\" created.\ntransferred 0.0 B of 29.3 GiB (0.00%)\ntransferred 300.0 MiB of 29.3 GiB (1.00%)\ntransferred 600.0 MiB of 29.3 GiB (2.00%)\ntransferred 900.0 MiB of 29.3 GiB (3.00%)\ntransferred 1.2 GiB of 29.3 GiB (4.00%)\n...\ntransferred 29.0 GiB of 29.3 GiB (99.04%)\ntransferred 29.3 GiB of 29.3 GiB (100.00%)\ntransferred 29.3 GiB of 29.3 GiB (100.00%)\nSuccessfully imported disk as 'unused1:local-lvm:vm-100-disk-1'\nroot@pve-sandbox:\/tmp# \nroot@pve-sandbox:\/tmp# pvesm list local-lvm\nVolid                   Format  Type             Size VMID\nlocal-lvm:vm-100-disk-0 raw     images    31457280000 100\nlocal-lvm:vm-100-disk-1 raw     images    31457280000 100\nroot@pve-sandbox:\/tmp# <\/code><\/pre>\n\n\n\n<p>Add the disks as scsci-disks to the VM in the Proxmox GUI by going the the VM hardware and double click on the &#8222;Unused disk 0&#8220;:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-15.png\" alt=\"\" class=\"wp-image-25608\"\/><\/figure>\n\n\n\n<p>Click on Add:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-16.png\" alt=\"\" class=\"wp-image-25609\"\/><\/figure>\n\n\n\n<p>Do the same for Unused disk 1:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-17.png\" alt=\"\" class=\"wp-image-25611\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-18.png\" alt=\"\" class=\"wp-image-25612\"\/><\/figure>\n\n\n\n<p>Afterwards the disks are listed as normal scsci-harddisks:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-19.png\" alt=\"\" class=\"wp-image-25613\"\/><\/figure>\n\n\n\n<p>The last step is to adjust the boot order. Go to the VM options, double click on &#8222;boot order&#8220; and drag and drop the first disk to the top and enable it:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-20.png\" alt=\"\" class=\"wp-image-25614\"\/><\/figure>\n\n\n\n<p>Before:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-21.png\" alt=\"\" class=\"wp-image-25615\"\/><\/figure>\n\n\n\n<p>After:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-23.png\" alt=\"\" class=\"wp-image-25617\"\/><\/figure>\n\n\n\n<p>The VM options then look as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-24.png\" alt=\"\" class=\"wp-image-25618\"\/><\/figure>\n\n\n\n<p>Then start the VM the first time. After booting the console shows:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-25-1024x475.png\" alt=\"\" class=\"wp-image-25620\"\/><\/figure>\n\n\n\n<p>I opened a terminal in the console and had an IP address assigned automatically:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/06\/image-26-1024x516.png\" alt=\"\" class=\"wp-image-25621\"\/><\/figure>\n\n\n\n<p>So I could login as oracle (password oracle) via ssh:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>dbi-lt-cbl2:AWS cbl$ ssh oracle@192.168.122.1\nAre you sure you want to continue connecting (yes\/no\/&#91;fingerprint])? yes\nWarning: Permanently added '192.168.122.1' (ED25519) to the list of known hosts.\noracle@192.168.122.1's password: \nActivate the web console with: systemctl enable --now cockpit.socket\n\nLast login: Mon Jun  5 10:18:36 2023\n&#91;oracle@localhost ~]$ <\/code><\/pre>\n\n\n\n<p>And connect to my DB after unsetting the TWO_TASK:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;oracle@localhost ~]$ ps -ef | grep pmon | grep -v grep \noracle      1900       1  0 10:18 ?        00:00:00 db_pmon_FREE\n&#91;oracle@localhost ~]$ echo $ORACLE_SID\n\n&#91;oracle@localhost ~]$ . oraenv\nORACLE_SID = &#91;oracle] ? FREE\nThe Oracle base has been set to \/opt\/oracle\n&#91;oracle@localhost ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 23.0.0.0.0 - Developer-Release on Mon Jun 5 10:26:24 2023\nVersion 23.2.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\nERROR:\nORA-01017: invalid credential or not authorized; logon denied\n\n\nEnter user-name: ^C\n&#91;oracle@localhost ~]$ echo $TWO_TASK\nFREEPDB1\n&#91;oracle@localhost ~]$ unset TWO_TASK\n&#91;oracle@localhost ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 23.0.0.0.0 - Developer-Release on Mon Jun 5 10:26:43 2023\nVersion 23.2.0.0.0\n\nCopyright (c) 1982, 2023, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release\nVersion 23.2.0.0.0\n\nSQL&gt; show pdbs\n\n    CON_ID CON_NAME\t\t\t  OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n\t 2 PDB$SEED\t\t\t  READ ONLY  NO\n\t 3 FREEPDB1\t\t\t  READ WRITE NO\nSQL&gt; <\/code><\/pre>\n\n\n\n<p><strong>Summary:<\/strong> Setting up an Oracle 23c Free Developer DB on Proxmox is fast and easy in a couple of steps.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle provides an OVA (Open Virtual Appliance) file to install the 23c Free Developer Release on Virtualbox. An OVA file contains metadata and file elements in the Open Virtual Format (OVF) to package and distribute one or more virtual machines. The OVA-file provided by Oracle can also be used to import the Oracle 23c Free [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[32,34,33,3,31],"class_list":["post-31","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-23c","tag-developer","tag-free","tag-oracle","tag-proxmox"],"_links":{"self":[{"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/posts\/31","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/comments?post=31"}],"version-history":[{"count":1,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/posts\/31\/revisions"}],"predecessor-version":[{"id":32,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/posts\/31\/revisions\/32"}],"wp:attachment":[{"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/media?parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/categories?post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/cbleile.de\/wordpress\/wp-json\/wp\/v2\/tags?post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}