![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Nutanix-Era-logo-2.png\"){kind=logo}
<\/a><\/td>\n![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aws-logo.jpg\"){kind=logo}
<\/a><\/td>\n<\/tr>\n<\/table>\n<\/p>\n
Check<\/h3>\n
As we can see our VM template has been previously correctly registered in Nutanix Era and is currently stopped. No need to have the VM template up and running to use it provisioning new databases.<\/p>\n
<\/br><\/br><\/br><\/p>\n We first need to create a software profile using our recently VM template. This will be the reference and used as template to provision new oracle database.<\/p>\n From the “Profiles” Menu, we will choose Software, create, Oracle and Single Instance Database : <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n We will then provide :<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n We can check the progress from the “Operations” menu.<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n And see that our software profile has been created.<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n This operation is of course only needed one time as long as we would like to use this software profile as reference.<\/p>\n If none compute profile answer our needs, we will have to create one. The compute profile needs to be set accordingly of which database parameter profile we are using. <\/br><\/br><\/br><\/p>\n Let’s create a compute profile named SMALL_COMPUTE with 2 cores and 16 GB RAM.<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n Let’s finally create a database parameters profile to match configuration for database we would like to provision.<\/p>\n From the profile menu, database parameters part, chose create, then Oracle and click next.<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n We will not use AMM (Automatic Memory Management) here, so resetting memory_target parameter, and use ASMM (Automatic Shared Memory Management) instead. We will therefore set both sga and pga parameters.<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n All is now ready for us to provision a database.<\/p>\n This will be done from the “Databases” Menu, choosing “Oracle Source DBs” :<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n Click on Provision, Oracle, Single Instance Database :<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n We will choose to create a new VM. Of course we could deploy a new database on an existing VM that would have previously already registered in Nutanix Era.<\/p>\n We will provide :<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n We will then provide :<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n Additional information for the Time Machine Snapshots.<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n We can now push the provision button to start provisioning the database. And with the Operations menu we can check that all is going as expected.<\/p>\n <\/br><\/br><\/br><\/br><\/br><\/br><\/p>\n Let’s see how Nutanix Era provisioned the oracle database and if it is working.<\/p>\n We will first connect with ssh on the new created VM. As expected, we can connect with the private key of the oracle user we generated on the VM template :<\/p>\n <\/br><\/p>\n We can check the file system :<\/p>\n <\/br><\/p>\n We can check the database files :<\/p>\n <\/br><\/p>\n We can see that Nutanix Era used our software profile, let’s say our VM template we created in previous blog, and setted up :<\/p>\n On the other hand the directory we used on the VM template for the ORACLE_HOME does not exist any more…<\/p>\n <\/br><\/p>\n The ORACLE variables are setted up :<\/p>\n <\/br><\/p>\n So here we can see that Nutanix Era created the Oracle Binaries home directory in \/u02.<\/p>\n <\/br><\/p>\n Let’s check what version of binaries we have :<\/p>\n <\/br><\/p>\n This is as expected and the version we installed on the VM template.<\/p>\n Is the database even started?<\/p>\n <\/br><\/p>\n No, and as expected from the \/etc\/oratab, which by the way has been updated accordingly by Nutanix Era :<\/p>\n <\/br><\/p>\n Let’s start the database :<\/p>\n <\/br><\/p>\n Database is up and running :<\/p>\n <\/br><\/p>\n Let’s check the datapatch version of the database :<\/p>\n <\/br><\/p>\n How was the database created? Simply using dbca tool :<\/p>\n <\/br><\/p>\n The database has been provisioned with success.<\/p>\n This is the recovery area destination Nutanix Era have been setting :<\/p>\n <\/br><\/p>\n On Nutanix Era GUI side we can see that we have now 2 VMs. Our template VM which is stopped and does not need to be started to provision databases, and the new created test1-VM.<\/p>\n And we can see our ORATEST database been provisionned.<\/p>\n<\/a><\/p>\nSoftware profile<\/h3>\n
\n<\/a><\/p>\n\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nCompute profile<\/h3>\n
\nWe need to provide enough resource in compute profile that will be provided to oracle SGA and PGA in the database parameter. Otherwise the provisioning might fail with following error :<\/p>\n<\/a><\/p>\n<\/a><\/p>\nDatabase parameters profile<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nProvision a database<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n\n
<\/a><\/p>\n\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nConnect to the new provisioned database and do some checks<\/h3>\n
\nec2-user@ip-10-0-129-41 .ssh]$ ssh -i oracle-nutanix-era-template-oracleDB-vm.pem oracle@X.X.X.174\nThe authenticity of host 'X.X.X.174 (X.X.X.174)' can't be established.\nECDSA key fingerprint is SHA256:FbmiWaGZ51o+Y9oCusUYt4IpSyji3YxehWs\/hnXQ4hY.\nECDSA key fingerprint is MD5:c9:38:14:5f:7f:a8:41:7b:14:04:42:c6:fd:c8:54:f1.\nAre you sure you want to continue connecting (yes\/no)? yes\nWarning: Permanently added 'X.X.X.174' (ECDSA) to the list of known hosts.\nLast login: Wed Aug 11 14:33:44 2021 from X.X.X.253\n[oracle@test1-VM ~]$\n<\/pre>\n
\n[oracle@test1-VM .ssh]$ df -h\nFilesystem Size Used Avail Use% Mounted on\ndevtmpfs 7.7G 0 7.7G 0% \/dev\ntmpfs 3.0G 0 3.0G 0% \/dev\/shm\ntmpfs 7.7G 8.7M 7.7G 1% \/run\ntmpfs 7.7G 0 7.7G 0% \/sys\/fs\/cgroup\n\/dev\/mapper\/vgroot--lv-root 6.0G 108M 5.9G 2% \/\n\/dev\/mapper\/vgroot--lv-usr 3.0G 1.6G 1.5G 53% \/usr\n\/dev\/sda1 496M 224M 273M 46% \/boot\n\/dev\/sda2 1022M 12K 1022M 1% \/boot\/efi\n\/dev\/sdb 50G 9.8G 38G 21% \/u02\n\/dev\/mapper\/vgroot--lv-home 4.0G 72M 4.0G 2% \/home\n\/dev\/mapper\/vgroot--lv-opt 4.0G 69M 4.0G 2% \/opt\n\/dev\/mapper\/vgroot--lv-tmp 3.0G 911M 2.2G 30% \/tmp\n\/dev\/mapper\/vgroot--lv-var 3.0G 3.0G 60M 99% \/var\n\/dev\/mapper\/ntnx_era_agent_vg_f5f089e315114644a8921b21a51d82f2-ntnx_era_agent_lv_era_software_f5f089e315114644a8921b21a51d82f2 2.9G 668M 2.1G 25% \/opt\/era_base\/era_engine\n\/dev\/mapper\/ntnx_era_agent_vg_47aab96bac4343b2a4a73453130a22fd-ntnx_era_agent_lv_db_stagging_logs_47aab96bac4343b2a4a73453130a22fd 98G 71M 93G 1% \/opt\/era_base\/db_logs\/ORATEST\n\/dev\/mapper\/ntnx_era_agent_vg_f5f089e315114644a8921b21a51d82f2-ntnx_era_agent_lv_era_config_f5f089e315114644a8921b21a51d82f2 93M 1.6M 85M 2% \/opt\/era_base\/cfg\n\/dev\/mapper\/ntnx_era_agent_vg_f5f089e315114644a8921b21a51d82f2-ntnx_era_agent_lv_era_logs_f5f089e315114644a8921b21a51d82f2 7.7G 72M 7.2G 1% \/opt\/era_base\/logs\n\/dev\/mapper\/oradata_fra_ORATEST_vg-oradata_fra_ORATEST_lv 9.8G 955M 8.4G 11% \/u02\/app\/oracle\/oradata\/fra_ORATEST\n\/dev\/mapper\/oradata_ORATEST_vg-oradata_ORATEST_lv 20G 2.9G 16G 16% \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\ntmpfs 1.6G 0 1.6G 0% \/run\/user\/54321 \n<\/pre>\n
\n[oracle@test1-VM .ssh]$ ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/\ntotal 12K\ndrwxr-x---. 2 oracle oinstall 4.0K Aug 11 14:35 controlfile\ndrwxr-x---. 2 oracle oinstall 4.0K Aug 11 14:35 onlinelog\ndrwxr-x---. 2 oracle oinstall 4.0K Sep 29 12:03 datafile\n\n[oracle@test1-VM .ssh]$ ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/controlfile\/\ntotal 12M\n-rw-r-----. 1 oracle oinstall 12M Sep 30 08:58 o1_mf_jk7r16xw_.ctl\n\n[oracle@test1-VM .ssh]$ ls -ltrh \/u02\/app\/oracle\/oradata\/fra_ORATEST\/ORATEST\/controlfile\/\ntotal 12M\n-rw-r-----. 1 oracle oinstall 12M Sep 30 08:56 o1_mf_jk7r16ys_.ctl\n\n[oracle@test1-VM .ssh]$ ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/onlinelog\/\ntotal 601M\n-rw-r-----. 1 oracle oinstall 201M Sep 30 08:16 o1_mf_1_jk7r195y_.log\n-rw-r-----. 1 oracle oinstall 201M Sep 30 08:45 o1_mf_2_jk7r196j_.log\n-rw-r-----. 1 oracle oinstall 201M Sep 30 08:59 o1_mf_3_jk7r1986_.log\n\n[oracle@test1-VM .ssh]$ ls -ltrh \/u02\/app\/oracle\/oradata\/fra_ORATEST\/ORATEST\/onlinelog\ntotal 601M\n-rw-r-----. 1 oracle oinstall 201M Sep 30 08:16 o1_mf_1_jk7r19br_.log\n-rw-r-----. 1 oracle oinstall 201M Sep 30 08:45 o1_mf_2_jk7r19gf_.log\n-rw-r-----. 1 oracle oinstall 201M Sep 30 08:59 o1_mf_3_jk7r19lz_.log\n\n[oracle@test1-VM .ssh]$ ls -ltrh \/u02\/app\/oracle\/oradata\/datafiles_ORATEST\/ORATEST\/datafile\/\ntotal 2.7G\n-rw-r-----. 1 oracle oinstall 129M Sep 29 22:00 o1_mf_temp_jk7rk1xc_.tmp\n-rw-r-----. 1 oracle oinstall 11M Sep 30 08:50 o1_mf_tstsourc_jo8ok0yn_.dbf\n-rw-r-----. 1 oracle oinstall 5.1M Sep 30 08:50 o1_mf_users_jk7r05t2_.dbf\n-rw-r-----. 1 oracle oinstall 1001M Sep 30 08:55 o1_mf_system_jk7qywmo_.dbf\n-rw-r-----. 1 oracle oinstall 1.2G Sep 30 08:56 o1_mf_sysaux_jk7qzopd_.dbf\n-rw-r-----. 1 oracle oinstall 513M Sep 30 09:00 o1_mf_undotbsp_jk7rk221_.dbf\n[oracle@test1-VM .ssh]$\n<\/pre>\n
\n
\n[oracle@test1-VM .ssh]$ ls -l \/u01\/app\ntotal 0\ndrwxrwxr-x. 5 oracle oinstall 51 Aug 13 12:59 oraInventory\n<\/pre>\n
\n[oracle@test1-VM ~]$ echo $ORACLE_HOME\n\/u02\/app\/oracle\/product\/19.0.0\/dbhome_1\n\n[oracle@test1-VM ~]$ echo $ORACLE_SID\nORATEST\n<\/pre>\n
\n[oracle@test1-VM ~]$ ls \/u02\/app\/oracle\/product\/19.0.0\/dbhome_1\naddnode bin crs data demo env.ora instantclient jdk log nls OPatch.v.17 ord owm QOpatch relnotes root.sh.old.2 root.sh.ouibak slax sqlplus usm\nadmin cfgtoollogs css dbjava diagnostics has inventory jlib md odbc opmn ords perl R root.sh root.sh.old.3 runInstaller sqldeveloper srvm utl\napex client ctx dbs drdaas hs javavm ldap mgw olap oracore oss plsql racg root.sh.old root.sh.old.4 schagent.conf sqlj suptools wwg\nassistants clone cv deinstall dv install jdbc lib network OPatch oraInst.loc oui precomp rdbms root.sh.old.1 root.sh.old.5 sdk sqlpatch ucp xdk\n[oracle@test1-VM ~]$\n<\/pre>\n
\n[oracle@test1-VM ~]$ cd $ORACLE_HOME\/OPatch\n[oracle@test1-VM OPatch]$ .\/opatch lsinv | grep -i description\nARU platform description:: Linux x86-64\nPatch description: \"Database Release Update : 19.12.0.0.210720 (32904851)\"\nPatch description: \"OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)\"\nPatch description: \"OCW RELEASE UPDATE 19.3.0.0.0 (29585399)\"\n[oracle@test1-VM OPatch]$\n<\/pre>\n
\n[oracle@test1-VM OPatch]$ ps -ef | grep pmon | grep -v grep\n[oracle@test1-VM OPatch]$\n<\/pre>\n
\n[oracle@test1-VM OPatch]$ grep -i ORATEST \/etc\/oratab\nORATEST:\/u02\/app\/oracle\/product\/19.0.0\/dbhome_1:N\n[oracle@test1-VM OPatch]$\n<\/pre>\n
\n[oracle@test1-VM OPatch]$ echo $ORACLE_SID\nORATEST\n\n[oracle@test1-VM OPatch]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Aug 13 13:31:02 2021\nVersion 19.12.0.0.0\n\nCopyright (c) 1982, 2021, Oracle. All rights reserved.\n\nConnected to an idle instance.\n\nSQL> startup\nORACLE instance started.\n\nTotal System Global Area 2147481648 bytes\nFixed Size\t\t 8898608 bytes\nVariable Size\t\t 486539264 bytes\nDatabase Buffers\t 1644167168 bytes\nRedo Buffers\t\t 7876608 bytes\nDatabase mounted.\nDatabase opened.\n<\/pre>\n
\n[oracle@test1-VM OPatch]$ ps -ef | grep pmon | grep -v grep\noracle 107265 1 0 13:31 ? 00:00:00 ora_pmon_ORATEST\n[oracle@test1-VM OPatch]$\n<\/pre>\n
\n[oracle@test1-VM OPatch]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Aug 13 13:33:37 2021\nVersion 19.12.0.0.0\n\nCopyright (c) 1982, 2021, Oracle. All rights reserved.\n\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.12.0.0.0\n\nSQL> set linesize window\nSQL> select instance_name, host_name from v$instance;\n\nINSTANCE_NAME\t HOST_NAME\n---------------- ----------------------------------------------------------------\nORATEST \t test1-VM\n\nSQL> select patch_id, source_version, target_version, status, description from dba_registry_sqlpatch;\n\n PATCH_ID SOURCE_VERSION TARGET_VERSION STATUS\t\t DESCRIPTION\n---------- --------------- --------------- ------------------------- ----------------------------------------------------------------------------------------------------\n 32876380 19.1.0.0.0\t 19.1.0.0.0\t SUCCESS\t\t OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)\n 32904851 19.1.0.0.0\t 19.12.0.0.0\t SUCCESS\t\t Database Release Update : 19.12.0.0.210720 (32904851)\n\nSQL>\n<\/pre>\n
\noracle@test1-VM:\/u02\/app\/oracle\/cfgtoollogs\/dbca\/ORATEST\/ [ORATEST] pwd\n\/u02\/app\/oracle\/cfgtoollogs\/dbca\/ORATEST\n\noracle@test1-VM:\/u02\/app\/oracle\/cfgtoollogs\/dbca\/ORATEST\/ [ORATEST] ls -l\ntotal 19272\n-rw-r-----. 1 oracle oinstall 4951 Aug 11 14:41 cloneDBCreation.log\n-rw-r-----. 1 oracle oinstall 560 Aug 11 14:34 CloneRmanRestore.log\n-rw-r-----. 1 oracle oinstall 910 Aug 11 14:41 lockAccount.log\n-rw-r-----. 1 oracle oinstall 1026 Aug 11 14:43 ORATEST.log\n-rw-r-----. 1 oracle oinstall 2316 Aug 11 14:43 postDBCreation.log\n-rw-r-----. 1 oracle oinstall 0 Aug 11 14:41 postScripts.log\n-rw-r-----. 1 oracle oinstall 0 Aug 11 14:34 rmanUtil\n-rw-r-----. 1 oracle oinstall 18726912 Aug 11 14:34 tempControl.ctl\n-rw-r-----. 1 oracle oinstall 981858 Aug 11 14:43 trace.log_2021-08-11_02-33-45PM\n<\/pre>\n
\nSQL> show parameter recovery\n\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\ndb_recovery_file_dest string \/u02\/app\/oracle\/oradata\/fra_OR\n ATEST\ndb_recovery_file_dest_size big integer 10G\nrecovery_parallelism integer 0\nremote_recovery_file_dest string\n<\/pre>\n
And what from Nutanix Era GUI side?<\/h3>\n
<\/a>
\n<\/br><\/br><\/br><\/br><\/p>\n