{"id":16615,"date":"2021-08-13T11:46:29","date_gmt":"2021-08-13T09:46:29","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/"},"modified":"2021-08-13T11:46:29","modified_gmt":"2021-08-13T09:46:29","slug":"nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/","title":{"rendered":"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM"},"content":{"rendered":"<p>This is the part 2 of Nutanix Era blogs related to the use with Oracle databases. Before using Nutanix Era with Oracle and be able to provision oracle databases, we need to create a template VM. To do so, we will need to use prism. This template VM will only be used as a reference each time we will provision a database mainly to get the operation system and the Oracle environment. The cpu cores and memory resource to allocate to the VM hosting the database we want to provision will be configured independently of the configuration of this VM template. The template VM can even later be shutdown once registered in Nutanix Era.<\/p>\n<p>For more information on Nutanix products, I would encourage you to visit <a href=\"http:\/\/www.nutanix.com\/switzerland\">Nutanix website<\/a>.<\/p>\n<table style=\"border: none\">\n<tr>\n<td bgcolor=\"#FFFFFF\" style=\"border: none;vertical-align: middle\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-Era-logo-2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-Era-logo-2.png\" alt=\"\" width=\"300\" height=\"57\" class=\"alignleft size-medium wp-image-51055\" \/><\/a><\/td>\n<td bgcolor=\"#FFFFFF\" style=\"border: none\"><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aws-logo.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aws-logo.jpg\" alt=\"\" width=\"227\" height=\"170\" class=\"alignleft size-medium wp-image-51435\" \/><\/a><\/td>\n<\/tr>\n<\/table>\n<p><!--more--><\/p>\n<h3>Connecting to prism<\/h3>\n<p>Once logged on the Nutanix cluster trial page, launch Nutanix Clusters :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png\" alt=\"\" width=\"300\" height=\"239\" class=\"alignleft size-medium wp-image-51081\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>Click on your cluster :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-cluster.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-cluster.png\" alt=\"\" width=\"300\" height=\"169\" class=\"alignleft size-medium wp-image-51083\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>And then click on the button &#8220;Go to Prism Element&#8221;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-cluster_2-2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-cluster_2-2.png\" alt=\"\" width=\"300\" height=\"267\" class=\"alignleft size-medium wp-image-51096\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>Here you will have to login with the admin user created during the deployment :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prims-login.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prims-login.png\" alt=\"\" width=\"300\" height=\"202\" class=\"alignleft size-medium wp-image-51088\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<h3>Creating physical VM<\/h3>\n<p>From the prism VM menu, we will create a new VM specifying mainly the number of cores and the memory. Knowing it is a template, we do not need a lot of resource. This  is done as following :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-create-VM_1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-create-VM_1.png\" alt=\"\" width=\"300\" height=\"162\" class=\"alignleft size-medium wp-image-51098\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-create-VM_2-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-create-VM_2-1.png\" alt=\"\" width=\"248\" height=\"300\" class=\"alignleft size-medium wp-image-51100\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<h3>Creating Image Configuration<\/h3>\n<p>We will install the VM template with Oracle Linux 8.4. Therefore we need to first upload the OS image into prism. This is achieved using the &#8220;Image Configuration&#8221; part from the &#8220;Settings&#8221; menu : <\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-image_1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-image_1.png\" alt=\"\" width=\"300\" height=\"69\" class=\"alignleft size-medium wp-image-51107\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-image_2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-image_2.png\" alt=\"\" width=\"300\" height=\"236\" class=\"alignleft size-medium wp-image-51108\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>From the task menu we can check the progress :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-image_3.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-image_3.png\" alt=\"\" width=\"300\" height=\"71\" class=\"alignleft size-medium wp-image-51109\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/p>\n<p>Once completed the image has been uploaded and is ready to be used :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-image_4.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Prism-image_4.png\" alt=\"\" width=\"300\" height=\"121\" class=\"alignleft size-medium wp-image-51111\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/p>\n<h3>Install OS on the VM template<\/h3>\n<p>Now we need to turn our VM template on, with a right click on the VM :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_1.png\" alt=\"\" width=\"300\" height=\"184\" class=\"alignleft size-medium wp-image-51117\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>Once the VM is started, we can launch the console, still with a right click on the VM :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_2.png\" alt=\"\" width=\"300\" height=\"181\" class=\"alignleft size-medium wp-image-51118\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>And we can mount our ISO image :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_3-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_3-1.png\" alt=\"\" width=\"300\" height=\"270\" class=\"alignleft size-medium wp-image-51121\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_4.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_4.png\" alt=\"\" width=\"270\" height=\"300\" class=\"alignleft size-medium wp-image-51120\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>And reset the VM :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_5.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_5.png\" alt=\"\" width=\"300\" height=\"244\" class=\"alignleft size-medium wp-image-51125\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_6.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_6.png\" alt=\"\" width=\"301\" height=\"206\" class=\"alignleft size-full wp-image-51122\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>And this will then be a normal linux installation :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_7.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_7.png\" alt=\"\" width=\"300\" height=\"244\" class=\"alignleft size-medium wp-image-51123\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_8.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/VM_installation_8.png\" alt=\"\" width=\"300\" height=\"197\" class=\"alignleft size-medium wp-image-51128\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<h3>Oracle binaries 19.3 installation<\/h3>\n<p>Once the VM is installed and up and running with the linux OS, you might certainly have to configure your AWS Cloud to be able to ssh the VM template. This steps is not covered here, as fully related to AWS Cloud operations.<\/p>\n<p>We will install the needed prerequirement package : <\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[root@Nutanix_OracleDB_template ~]# rpm -qa | grep oracle-database-preinstall-19c-1.0-2.el8.x86_64\noracle-database-preinstall-19c-1.0-2.el8.x86_64\n<\/pre>\n<p><\/br><\/p>\n<p>And create the directory for the oracle binaries :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template ~]$ mkdir -p \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\n[oracle@Nutanix_OracleDB_template ~]$ cd \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\n<\/pre>\n<p><\/br><\/p>\n<p>We will then download following files from Oracle website :<br \/>\nLINUX.X64_193000_db_home.zip<br \/>\np32900021_190000_Linux-x86-64.zip (COMBO OF OJVM RU COMPONENT 19.12.0.0.210720 + DB RU 19.12.0.0.210720)<\/p>\n<p>We will extract Oracle binaries 19.3 :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template ~]$ cd \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/\n[oracle@Nutanix_OracleDB_template db_0_210701]$ unzip LINUX.X64_193000_db_home.zip\n<\/pre>\n<p><\/br><\/p>\n<p>We will create following response file :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template install]$ pwd\n\/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/install\n[oracle@Nutanix_OracleDB_template install]$ vi rdbms_install_19300.rsp\n[oracle@Nutanix_OracleDB_template install]$ cat rdbms_install_19300.rsp\n#------------------------------------------------------------------------------\n# Do not change the following system generated value.\n#------------------------------------------------------------------------------\noracle.install.responseFileVersion=\/oracle\/install\/rspfmt_dbinstall_response_schema_v19.0.0\n\n#-------------------------------------------------------------------------------\n# Specify the installation option.\n# It can be one of the following:\n#   - INSTALL_DB_SWONLY\n#   - INSTALL_DB_AND_CONFIG\n#-------------------------------------------------------------------------------\noracle.install.option=INSTALL_DB_SWONLY\n\n#-------------------------------------------------------------------------------\n# Specify the Unix group to be set for the inventory directory.\n#-------------------------------------------------------------------------------\nUNIX_GROUP_NAME=oinstall\n\n#-------------------------------------------------------------------------------\n# Specify the location which holds the inventory files.\n# This is an optional parameter if installing on\n# Windows based Operating System.\n#-------------------------------------------------------------------------------\nINVENTORY_LOCATION=\/u01\/app\/oraInventory\n\n#-------------------------------------------------------------------------------\n# Specify the complete path of the Oracle Home.\n#-------------------------------------------------------------------------------\nORACLE_HOME=\/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\n\n#-------------------------------------------------------------------------------\n# Specify the complete path of the Oracle Base.\n#-------------------------------------------------------------------------------\nORACLE_BASE=\/u01\/app\/oracle\n\n#-------------------------------------------------------------------------------\n# Specify the installation edition of the component.\n#\n# The value should contain only one of these choices.\n#   - EE     : Enterprise Edition\n#   - SE2    : Standard Edition 2\n#-------------------------------------------------------------------------------\noracle.install.db.InstallEdition=EE\n\n#------------------------------------------------------------------------------\n# The OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges.\n#-------------------------------------------------------------------------------\noracle.install.db.OSDBA_GROUP=dba\n\n#------------------------------------------------------------------------------\n# The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges.\n# The value to be specified for OSOPER group is optional.\n#------------------------------------------------------------------------------\noracle.install.db.OSOPER_GROUP=dba\n\n#------------------------------------------------------------------------------\n# The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges.\n#------------------------------------------------------------------------------\noracle.install.db.OSBACKUPDBA_GROUP=dba\n\n#------------------------------------------------------------------------------\n# The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges.\n#------------------------------------------------------------------------------\noracle.install.db.OSDGDBA_GROUP=dba\n\n#------------------------------------------------------------------------------\n# The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges.\n#------------------------------------------------------------------------------\noracle.install.db.OSKMDBA_GROUP=dba\n\n#------------------------------------------------------------------------------\n# The OSRACDBA_GROUP is the OS group which is to be granted SYSRAC privileges.\n#------------------------------------------------------------------------------\noracle.install.db.OSRACDBA_GROUP=dba\n<\/pre>\n<p><\/br><\/p>\n<p>And run the installer :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template db_0_210701]$ .\/runInstaller -silent -responseFile \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/install\/rdbms_install_19300.rsp\nLaunching Oracle Database Setup Wizard...\n\n[WARNING] [INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck'\n   CAUSE: No additional information available.\n   ACTION: Contact Oracle Support Services or refer to the software manual.\n   SUMMARY:\n       - java.lang.NullPointerException\nMoved the install session logs to:\n \/u01\/app\/oraInventory\/logs\/InstallActions2021-08-05_11-41-37AM\n<\/pre>\n<p><\/br><\/p>\n<p>The following error is coming from the fact that although Oracle Linux 8.4 is supported for installation of 19.3 release, this OS version was at that time not available.<\/p>\n<p>See following Doc Id :<br \/>\nRequirements for Installing Oracle Database\/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)<\/p>\n<p>Since 19c(19.3) is already released a while ago,It does not contain Pre-req checks specific to OL \/RHEL 8. Workaround solution is to set first the CV_ASSUME_DISTID variable to a previous release.<\/p>\n<p>We can then execute again the installation which will be successful :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template db_0_210701]$ export CV_ASSUME_DISTID=OL7\n[oracle@Nutanix_OracleDB_template db_0_210701]$ .\/runInstaller -silent -responseFile \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/install\/rdbms_install_19300.rsp\nLaunching Oracle Database Setup Wizard...\n\n[WARNING] [INS-32047] The location (\/u01\/app\/oraInventory) specified for the central inventory is not empty.\n   ACTION: It is recommended to provide an empty location for the inventory.\n[WARNING] [INS-13014] Target environment does not meet some optional requirements.\n   CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2021-08-05_12-04-18PM.log\n   ACTION: Identify the list of failed prerequisite checks from the log: installActions2021-08-05_12-04-18PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.\nThe response file for this session can be found at:\n \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/install\/response\/db_2021-08-05_12-04-18PM.rsp\n\nYou can find the log of this install session at:\n \/tmp\/InstallActions2021-08-05_12-04-18PM\/installActions2021-08-05_12-04-18PM.log\n\n\nAs a root user, execute the following script(s):\n\t1. \/u01\/app\/oraInventory\/orainstRoot.sh\n\t2. \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/root.sh\n\nExecute \/u01\/app\/oraInventory\/orainstRoot.sh on the following nodes:\n[Nutanix_OracleDB_template]\nExecute \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/root.sh on the following nodes:\n[Nutanix_OracleDB_template]\n\n\nSuccessfully Setup Software with warning(s).\nMoved the install session logs to:\n \/u01\/app\/oraInventory\/logs\/InstallActions2021-08-05_12-04-18PM\n<\/pre>\n<p><\/br><\/p>\n<p>We can now execute both root scripts :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,9]\">\nroot@Nutanix_OracleDB_template ~]# \/u01\/app\/oraInventory\/orainstRoot.sh\nChanging permissions of \/u01\/app\/oraInventory.\nAdding read,write permissions for group.\nRemoving read,write,execute permissions for world.\n\nChanging groupname of \/u01\/app\/oraInventory to oinstall.\nThe execution of the script is complete.\n\n[root@Nutanix_OracleDB_template ~]# \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/root.sh\nCheck \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/install\/root_Nutanix_OracleDB_template_2021-08-05_14-14-35-159856510.log for the output of root script\n[root@Nutanix_OracleDB_template ~]# more \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/install\/root_Nutanix_OracleDB_template_2021-08-05_14-14-35-159856510.log\nPerforming root user operation.\n\nThe following environment variables are set as:\n    ORACLE_OWNER= oracle\n    ORACLE_HOME=  \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\n   Copying dbhome to \/usr\/local\/bin ...\n   Copying oraenv to \/usr\/local\/bin ...\n   Copying coraenv to \/usr\/local\/bin ...\n\n\nCreating \/etc\/oratab file...\nEntries will be added to the \/etc\/oratab file as needed by\nDatabase Configuration Assistant when a database is created\nFinished running generic part of root script.\nNow product-specific root actions will be performed.\nOracle Trace File Analyzer (TFA) is available at : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/bin\/tfactl\n<\/pre>\n<p><\/br><\/p>\n<h3>Oracle Patch 32900021 (COMBO OF OJVM RU COMPONENT 19.12.0.0.210720 + DB RU 19.12.0.0.210720) installation<\/h3>\n<p>Check current version :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template OPatch]$ .\/opatch lsinv | grep -i description\nARU platform description:: Linux x86-64\nPatch description:  \"OCW RELEASE UPDATE 19.3.0.0.0 (29585399)\"\nPatch description:  \"Database Release Update : 19.3.0.0.190416 (29517242)\"\n[oracle@Nutanix_OracleDB_template OPatch]$\n<\/pre>\n<p><\/br><\/p>\n<p>Check last opatch Version :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template OPatch]$ .\/opatch version\nOPatch Version: 12.2.0.1.17\n\nOPatch succeeded.\n<\/pre>\n<p><\/br><\/p>\n<p>We need version 24. We will download version 25 and install it :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template OPatch]$ cd $ORACLE_HOME\n[oracle@Nutanix_OracleDB_template db_0_210701]$ mv OPatch OPatch.v.17\n[oracle@Nutanix_OracleDB_template db_0_210701]$ cp -p ~\/p6880880_210000_Linux-x86-64.zip .\n[oracle@Nutanix_OracleDB_template db_0_210701]$ unzip p6880880_210000_Linux-x86-64.zip\nArchive:  p6880880_210000_Linux-x86-64.zip\n   creating: OPatch\/\n  inflating: OPatch\/README.txt\n  inflating: OPatch\/datapatch\n  ...\n  ...\n  ...\n<\/pre>\n<p><\/br><\/p>\n<p>Check opatch version :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template db_0_210701]$ cd OPatch\n[oracle@Nutanix_OracleDB_template OPatch]$ .\/opatch version\nOPatch Version: 12.2.0.1.25\n\nOPatch succeeded.\n<\/pre>\n<p><\/br><\/p>\n<p>We will transfer the needed patch and unzip it :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template ~]$ mkdir \/u01\/app\/patching\n[oracle@Nutanix_OracleDB_template ~]$ mv p32900021_190000_Linux-x86-64.zip \/u01\/app\/patching\/\n[oracle@Nutanix_OracleDB_template ~]$ ls\nsqldb360-19.4\n[oracle@Nutanix_OracleDB_template ~]$ cd \/u01\/app\/patching\/\n[oracle@Nutanix_OracleDB_template patching]$ ls -l\ntotal 1489976\n-rw-r--r--. 1 oracle oinstall 1525734197 Aug  5 14:59 p32900021_190000_Linux-x86-64.zip\n[oracle@Nutanix_OracleDB_template patching]$ unzip p32900021_190000_Linux-x86-64.zip\n...\n...\n...\n\n[oracle@Nutanix_OracleDB_template patching]$ ls\n32900021  p32900021_190000_Linux-x86-64.zip  PatchSearch.xml\n\n[oracle@Nutanix_OracleDB_template patching]$ tree -d -L 1 32900021\n32900021\n\u251c\u2500\u2500 32876380\n\u2514\u2500\u2500 32904851\n\n2 directories\n[oracle@Nutanix_OracleDB_template patching]$\n<\/pre>\n<p><\/br><\/p>\n<p>We will do some first conflict checks for both patches :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,2,20,38,39,57,]\">\n[oracle@Nutanix_OracleDB_template patching]$ cd 32900021\/32876380\/\n[oracle@Nutanix_OracleDB_template 32876380]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph .\nOracle Interim Patch Installer version 12.2.0.1.25\nCopyright (c) 2021, Oracle Corporation.  All rights reserved.\n\nPREREQ session\n\nOracle Home       : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/oraInst.loc\nOPatch version    : 12.2.0.1.25\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/cfgtoollogs\/opatch\/opatch2021-08-05_15-48-33PM_1.log\n\nInvoking prereq \"checkconflictagainstohwithdetail\"\n\nPrereq \"checkConflictAgainstOHWithDetail\" passed.\n\nOPatch succeeded.\n[oracle@Nutanix_OracleDB_template 32876380]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckSystemSpace -ph .\/\nOracle Interim Patch Installer version 12.2.0.1.25\nCopyright (c) 2021, Oracle Corporation.  All rights reserved.\n\nPREREQ session\n\nOracle Home       : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/oraInst.loc\nOPatch version    : 12.2.0.1.25\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/cfgtoollogs\/opatch\/opatch2021-08-05_15-49-05PM_1.log\n\nInvoking prereq \"checksystemspace\"\n\nPrereq \"checkSystemSpace\" passed.\n\nOPatch succeeded.\n[oracle@Nutanix_OracleDB_template 32876380]$ cd ..\/32904851\/\n[oracle@Nutanix_OracleDB_template 32904851]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph .\nOracle Interim Patch Installer version 12.2.0.1.25\nCopyright (c) 2021, Oracle Corporation.  All rights reserved.\n\nPREREQ session\n\nOracle Home       : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/oraInst.loc\nOPatch version    : 12.2.0.1.25\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/cfgtoollogs\/opatch\/opatch2021-08-05_15-49-42PM_1.log\n\nInvoking prereq \"checkconflictagainstohwithdetail\"\n\nPrereq \"checkConflictAgainstOHWithDetail\" passed.\n\nOPatch succeeded.\n[oracle@Nutanix_OracleDB_template 32904851]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckSystemSpace -ph .\/\nOracle Interim Patch Installer version 12.2.0.1.25\nCopyright (c) 2021, Oracle Corporation.  All rights reserved.\n\nPREREQ session\n\nOracle Home       : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/oraInst.loc\nOPatch version    : 12.2.0.1.25\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/cfgtoollogs\/opatch\/opatch2021-08-05_15-49-51PM_1.log\n\nInvoking prereq \"checksystemspace\"\n\nPrereq \"checkSystemSpace\" passed.\n\nOPatch succeeded.\n[oracle@Nutanix_OracleDB_template 32904851]$\n<\/pre>\n<p><\/br><\/p>\n<p>And now finally we can patch our Oracle binaries 19.3 with both 19.12 patches :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1; highlight: [1,2,45,46]\">\n[oracle@Nutanix_OracleDB_template 32904851]$ cd ..\/32876380\/\n[oracle@Nutanix_OracleDB_template 32876380]$ $ORACLE_HOME\/OPatch\/opatch apply\nOracle Interim Patch Installer version 12.2.0.1.25\nCopyright (c) 2021, Oracle Corporation.  All rights reserved.\n\n\nOracle Home       : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/oraInst.loc\nOPatch version    : 12.2.0.1.25\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/cfgtoollogs\/opatch\/opatch2021-08-05_15-51-02PM_1.log\n\nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   32876380\n\nDo you want to proceed? [y|n]\ny\nUser Responded with: Y\nAll checks passed.\n\nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\n(Oracle Home = '\/u01\/app\/oracle\/product\/19.12.0\/db_0_210701')\n\n\nIs the local system ready for patching? [y|n]\ny\nUser Responded with: Y\nBacking up files...\nApplying interim patch '32876380' to OH '\/u01\/app\/oracle\/product\/19.12.0\/db_0_210701'\n\nPatching component oracle.javavm.server, 19.0.0.0.0...\n\nPatching component oracle.javavm.server.core, 19.0.0.0.0...\n\nPatching component oracle.rdbms.dbscripts, 19.0.0.0.0...\n\nPatching component oracle.rdbms, 19.0.0.0.0...\n\nPatching component oracle.javavm.client, 19.0.0.0.0...\nPatch 32876380 successfully applied.\nLog file location: \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/cfgtoollogs\/opatch\/opatch2021-08-05_15-51-02PM_1.log\n\nOPatch succeeded.\n[oracle@Nutanix_OracleDB_template 32876380]$ cd ..\/32904851\/\n[oracle@Nutanix_OracleDB_template 32904851]$ $ORACLE_HOME\/OPatch\/opatch apply\nOracle Interim Patch Installer version 12.2.0.1.25\nCopyright (c) 2021, Oracle Corporation.  All rights reserved.\n\n\nOracle Home       : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\nCentral Inventory : \/u01\/app\/oraInventory\n   from           : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/oraInst.loc\nOPatch version    : 12.2.0.1.25\nOUI version       : 12.2.0.7.0\nLog file location : \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/cfgtoollogs\/opatch\/opatch2021-08-05_15-51-54PM_1.log\n\nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   32904851\n\nDo you want to proceed? [y|n]\ny\nUser Responded with: Y\nAll checks passed.\n\nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\n(Oracle Home = '\/u01\/app\/oracle\/product\/19.12.0\/db_0_210701')\n\n\nIs the local system ready for patching? [y|n]\ny\nUser Responded with: Y\nBacking up files...\nApplying interim patch '32904851' to OH '\/u01\/app\/oracle\/product\/19.12.0\/db_0_210701'\nApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.\n\nPatching component oracle.perlint, 5.28.1.0.0...\n\nPatching component oracle.rdbms.locator, 19.0.0.0.0...\n\nPatching component oracle.rdbms.rsf, 19.0.0.0.0...\n\nPatching component oracle.rdbms.util, 19.0.0.0.0...\n\nPatching component oracle.rdbms, 19.0.0.0.0...\n\nPatching component oracle.assistants.acf, 19.0.0.0.0...\n\nPatching component oracle.assistants.deconfig, 19.0.0.0.0...\n\nPatching component oracle.assistants.server, 19.0.0.0.0...\n\nPatching component oracle.buildtools.rsf, 19.0.0.0.0...\n\nPatching component oracle.ctx, 19.0.0.0.0...\n\nPatching component oracle.dbjava.ic, 19.0.0.0.0...\n\nPatching component oracle.dbjava.jdbc, 19.0.0.0.0...\n\nPatching component oracle.dbjava.ucp, 19.0.0.0.0...\n\nPatching component oracle.duma, 19.0.0.0.0...\n\nPatching component oracle.javavm.client, 19.0.0.0.0...\n\nPatching component oracle.ldap.owm, 19.0.0.0.0...\n\nPatching component oracle.ldap.rsf, 19.0.0.0.0...\n\nPatching component oracle.marvel, 19.0.0.0.0...\n\nPatching component oracle.network.rsf, 19.0.0.0.0...\n\nPatching component oracle.oracore.rsf, 19.0.0.0.0...\n\nPatching component oracle.precomp.common.core, 19.0.0.0.0...\n\nPatching component oracle.rdbms.dbscripts, 19.0.0.0.0...\n\nPatching component oracle.rdbms.deconfig, 19.0.0.0.0...\n\nPatching component oracle.rdbms.oci, 19.0.0.0.0...\n\nPatching component oracle.rhp.db, 19.0.0.0.0...\n\nPatching component oracle.sdo, 19.0.0.0.0...\n\nPatching component oracle.sdo.locator.jrf, 19.0.0.0.0...\n\nPatching component oracle.sqlplus, 19.0.0.0.0...\n\nPatching component oracle.sqlplus.ic, 19.0.0.0.0...\n\nPatching component oracle.wwg.plsql, 19.0.0.0.0...\n\nPatching component oracle.odbc, 19.0.0.0.0...\n\nPatching component oracle.rdbms.drdaas, 19.0.0.0.0...\n\nPatching component oracle.xdk.parser.java, 19.0.0.0.0...\n\nPatching component oracle.dbtoolslistener, 19.0.0.0.0...\n\nPatching component oracle.ctx.atg, 19.0.0.0.0...\n\nPatching component oracle.javavm.server, 19.0.0.0.0...\n\nPatching component oracle.ldap.security.osdt, 19.0.0.0.0...\n\nPatching component oracle.rdbms.hs_common, 19.0.0.0.0...\n\nPatching component oracle.ons, 19.0.0.0.0...\n\nPatching component oracle.precomp.rsf, 19.0.0.0.0...\n\nPatching component oracle.oraolap.api, 19.0.0.0.0...\n\nPatching component oracle.ons.ic, 19.0.0.0.0...\n\nPatching component oracle.rdbms.install.common, 19.0.0.0.0...\n\nPatching component oracle.xdk, 19.0.0.0.0...\n\nPatching component oracle.rdbms.dv, 19.0.0.0.0...\n\nPatching component oracle.ldap.rsf.ic, 19.0.0.0.0...\n\nPatching component oracle.rdbms.scheduler, 19.0.0.0.0...\n\nPatching component oracle.rdbms.lbac, 19.0.0.0.0...\n\nPatching component oracle.nlsrtl.rsf, 19.0.0.0.0...\n\nPatching component oracle.rdbms.rman, 19.0.0.0.0...\n\nPatching component oracle.oraolap, 19.0.0.0.0...\n\nPatching component oracle.rdbms.crs, 19.0.0.0.0...\n\nPatching component oracle.dbdev, 19.0.0.0.0...\n\nPatching component oracle.rdbms.hsodbc, 19.0.0.0.0...\n\nPatching component oracle.network.client, 19.0.0.0.0...\n\nPatching component oracle.xdk.xquery, 19.0.0.0.0...\n\nPatching component oracle.ldap.client, 19.0.0.0.0...\n\nPatching component oracle.rdbms.install.plugins, 19.0.0.0.0...\n\nPatching component oracle.ctx.rsf, 19.0.0.0.0...\n\nPatching component oracle.oraolap.dbscripts, 19.0.0.0.0...\n\nPatching component oracle.xdk.rsf, 19.0.0.0.0...\n\nPatching component oracle.network.listener, 19.0.0.0.0...\n\nPatching component oracle.ovm, 19.0.0.0.0...\n\nPatching component oracle.sdo.locator, 19.0.0.0.0...\n\nPatching component oracle.mgw.common, 19.0.0.0.0...\n\nPatching component oracle.rdbms.rsf.ic, 19.0.0.0.0...\n\nPatching component oracle.precomp.common, 19.0.0.0.0...\n\nPatching component oracle.precomp.lang, 19.0.0.0.0...\n\nPatching component oracle.jdk, 1.8.0.201.0...\nPatch 32904851 successfully applied.\nSub-set patch [29517242] has become inactive due to the application of a super-set patch [32904851].\nPlease refer to Doc ID 2161861.1 for any possible further required actions.\nLog file location: \/u01\/app\/oracle\/product\/19.12.0\/db_0_210701\/cfgtoollogs\/opatch\/opatch2021-08-05_15-51-54PM_1.log\n\nOPatch succeeded.\n<\/pre>\n<p><\/br><\/p>\n<h3>Configure sudo access for oracle user<\/h3>\n<p>This is a mandatory step to be able to register our VM template into ERA.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[root@Nutanix_OracleDB_template ~]# echo \"%oinstall ALL=(ALL) NOPASSWD: ALL\" &gt; \/etc\/sudoers.d\/oinstall\n<\/pre>\n<p><\/br><\/p>\n<p>Checking sudo permissions for oracle user :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\noracle@Nutanix_OracleDB_template ~]$ sudo pvs\n  PV         VG        Fmt  Attr PSize  PFree\n  \/dev\/sda3  vgroot-lv lvm2 a--  79.00g 4.00m\n<\/pre>\n<p><\/br><\/p>\n<p>So, we can confirm that the sudo access are working for oracle user.<\/p>\n<h3>Create sshkey for oracle user<\/h3>\n<p>We will create ssh key for oracle user :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;highlight: [1,2,5,26]\">\n[oracle@Nutanix_OracleDB_template ~]$ cd .ssh\n[oracle@Nutanix_OracleDB_template .ssh]$ ls -ltrh\ntotal 4.0K\n-rw-r--r--. 1 oracle oinstall 176 Aug  5 10:30 known_hosts\n[oracle@Nutanix_OracleDB_template .ssh]$ ssh-keygen -t rsa\nGenerating public\/private rsa key pair.\nEnter file in which to save the key (\/home\/oracle\/.ssh\/id_rsa):\nEnter passphrase (empty for no passphrase):\nEnter same passphrase again:\nYour identification has been saved in \/home\/oracle\/.ssh\/id_rsa.\nYour public key has been saved in \/home\/oracle\/.ssh\/id_rsa.pub.\nThe key fingerprint is:\nSHA256:VbABMrlBAmHovI7uXvi+DOagg3mQTUB1o5soLKpoxb0 oracle@Nutanix_OracleDB_template\nThe key's randomart image is:\n+---[RSA 3072]----+\n|.o=+.++...o..    |\n|o.  o.+o   +     |\n|o. .   o  o      |\n|.oo o .  .       |\n|o*oo.   S        |\n|*.oo .           |\n|**..  .          |\n|%o*  E           |\n|OB.=.            |\n+----[SHA256]-----+\n[oracle@Nutanix_OracleDB_template .ssh]$ ls -ltrh\ntotal 12K\n-rw-r--r--. 1 oracle oinstall  176 Aug  5 10:30 known_hosts\n-rw-r--r--. 1 oracle oinstall  586 Aug 11 09:05 id_rsa.pub\n-rw-------. 1 oracle oinstall 2.6K Aug 11 09:05 id_rsa\n<\/pre>\n<p><\/br><\/p>\n<p>And add public key in the authorized_keys :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[oracle@Nutanix_OracleDB_template .ssh]$ cat id_rsa.pub &gt;&gt; authorized_keys\n<\/pre>\n<p><\/br><\/p>\n<h3>Register VM template into Era<\/h3>\n<p>Now that our VM template is ready we will log into Nutanix Era with https and admin Era user :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-era-login.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-era-login.png\" alt=\"\" width=\"300\" height=\"201\" class=\"alignleft size-medium wp-image-51139\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>We will need to go in the &#8220;Database Server VMs&#8221; menu, and choose Oracle :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_1.png\" alt=\"\" width=\"300\" height=\"185\" class=\"alignleft size-medium wp-image-51140\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>We will then Register our VM template with the Register button :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_2.png\" alt=\"\" width=\"300\" height=\"177\" class=\"alignleft size-medium wp-image-51141\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>And we will provide all needed information :<\/p>\n<ul>\n<li>IP Address of the VM template : The VM is recognized and provided in the list of the VM that was not so far registered.<\/li>\n<li>Listener Port : We are using default one.<\/li>\n<li>A description.<\/li>\n<li>The Era Drive User which should have sudo permissions and will be used to mount partition and take snapshots, in our installation oracle user.<\/li>\n<li>The Oracle Database Home : The directory where we installed Oracle binaries on the VM template.<\/li>\n<li>Grid Infrastructure Home : We are not using any grid architecture, but this would be possible.<\/li>\n<li>The Credentials for oracle user either through password or ssh keys. We use ssh keys and provide the private keys.<\/li>\n<\/ul>\n<p>VM template is recognized :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_6-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_6-1.png\" alt=\"\" width=\"300\" height=\"192\" class=\"alignleft size-medium wp-image-51153\" \/><\/a><br \/>\n<\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>We will fill all needed information :<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_3.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_3.png\" alt=\"\" width=\"300\" height=\"239\" class=\"alignleft size-medium wp-image-51142\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>The VM could be registered successfully. We need to install some missing packages for further use. We will do this on the OS side using yum command.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_4-2.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Register_VM_4-2.png\" alt=\"\" width=\"300\" height=\"265\" class=\"alignleft size-medium wp-image-51159\" \/><\/a><\/p>\n<p><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n<p>Installation of missing packages :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1;\">\n[root@Nutanix_OracleDB_template ~]# yum install gcc\n[root@Nutanix_OracleDB_template ~]# yum install zip\n[root@Nutanix_OracleDB_template ~]# yum install rsync\n[root@Nutanix_OracleDB_template ~]# yum install sshpass\n[root@Nutanix_OracleDB_template ~]# yum install lsof\n<\/pre>\n<p><\/br><\/p>\n<h3>Conclusion<\/h3>\n<p>As for now we are ready to go and have all we need in order to provision oracle databases with Nutanix Era inside the Nutanix Cluster. This will be explained in a next blog.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the part 2 of Nutanix Era blogs related to the use with Oracle databases. Before using Nutanix Era with Oracle and be able to provision oracle databases, we need to create a template VM. To do so, we will need to use prism. This template VM will only be used as a reference [&hellip;]<\/p>\n","protected":false},"author":48,"featured_media":16616,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[2384],"type_dbi":[],"class_list":["post-16615","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-nutanix-era"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM\" \/>\n<meta property=\"og:description\" content=\"This is the part 2 of Nutanix Era blogs related to the use with Oracle databases. Before using Nutanix Era with Oracle and be able to provision oracle databases, we need to create a template VM. To do so, we will need to use prism. This template VM will only be used as a reference [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-13T09:46:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1731\" \/>\n\t<meta property=\"og:image:height\" content=\"1380\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Marc Wagner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marc Wagner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/\"},\"author\":{\"name\":\"Marc Wagner\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"headline\":\"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM\",\"datePublished\":\"2021-08-13T09:46:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/\"},\"wordCount\":899,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png\",\"keywords\":[\"Nutanix ERA\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/\",\"name\":\"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png\",\"datePublished\":\"2021-08-13T09:46:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png\",\"width\":1731,\"height\":1380},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628\",\"name\":\"Marc Wagner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g\",\"caption\":\"Marc Wagner\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/","og_locale":"en_US","og_type":"article","og_title":"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM","og_description":"This is the part 2 of Nutanix Era blogs related to the use with Oracle databases. Before using Nutanix Era with Oracle and be able to provision oracle databases, we need to create a template VM. To do so, we will need to use prism. This template VM will only be used as a reference [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/","og_site_name":"dbi Blog","article_published_time":"2021-08-13T09:46:29+00:00","og_image":[{"width":1731,"height":1380,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png","type":"image\/png"}],"author":"Marc Wagner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marc Wagner","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/"},"author":{"name":"Marc Wagner","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"headline":"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM","datePublished":"2021-08-13T09:46:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/"},"wordCount":899,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png","keywords":["Nutanix ERA"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/","url":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/","name":"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png","datePublished":"2021-08-13T09:46:29+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix.com_-1.png","width":1731,"height":1380},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/nutanix-era-with-oracle-databases-part-2-create-an-oracle-database-template-vm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Nutanix Era with oracle databases : Part 2 \u2013 Create an oracle database template VM"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/225d9884b8467ead9a872823acb14628","name":"Marc Wagner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a873cc6e7fbdbbcbdbcaf5dbded14ad9a77b2ec2c3e03b4d724ed33d35d5f328?s=96&d=mm&r=g","caption":"Marc Wagner"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/marc-wagner\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16615"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16615\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16616"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16615"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}