Thursday, August 19, 2021

 


This is an Innovation release (not long term like 19c) that introduces many cool new features, including also the 20c new features which DB release didn't happen: Oracle is mindful of the unprecedented economic and business disruption our customers faced in 2020. We decided to not promote our Database 20c Preview version to General Availability. Instead, we incorporated all of the 20c functionality into the 21c release and made 21c available in our Autonomous Database Free Tier so that all can test drive the new features and enhancements for free. However, as sometimes we want to be disconnected from the outer world during our lab tests (or maybe to give a live demo session without requiring internet), in this video I will show how you can deploy 21c in your VirtualBox environment for testing and lab purposes. So for this lab, I've created a VBox VM compute with the following specifications: Processor: 2 CPU RAM: 8GB OS: Oracle Linux 7.9 Disk: 100G Storage


Oracle 21c Lab Specification: Processor : 2 CPU Physical Memory : 8GB RAM OS : Oracle Linux 7.9 Storage : 100GB Oracle VirtualBox : VMs Oracle_Home : u01/app/oracle/product/21.0.0.0/db_1 OS User : oracle Now I will connect on my VirtualBox compute, move this image and install 21c pre-reqs package: From root user: [root@srlab21c softwares]# yum -y install oracle-database-preinstall-19c.x86_64 [root@srlab21c softwares]# mkdir -p /u01/app/oracle/product/21.0.0.0/db_1 [root@srlab21c softwares]# mkdir -p /u01/app/oraInventory [root@srlab21c softwares]# chown -R oracle:oinstall /u01/app/oracle/product/21.0.0.0/db_1 /u01/app/oraInventory Now as Oracle User: [oracle@srlab21c softwares]$ unzip LINUX.X64_213000_db_home.zip -d /u01/app/oracle/product/21.0.0.0/db_1 [oracle@srlab21c softwares]$ export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_1 [oracle@srlab21c softwares]$ export PATH=$PATH:$ORACLE_HOME/bin [oracle@srlab21c softwares]$ sqlplus /nolog Even though it's working, let's use the runInstaller to fully deploy this database installation. First I will create a response file with the following lines under /home/oracle : srlab21c_software_only.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v21.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install.db.OSBACKUPDBA_GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba Now calling the responsefile through runInstaller: [oracle@srlab21c~]$ $ORACLE_HOME/runInstaller -responseFile /home/oracle/srlab21c_software_only.rsp -silent Worklog output from Root User: [root@srlab21c ~]# cd /softwares/ [root@srlab21c softwares]# ls -lrt total 3036364 drwxr-xr-x. 7 oracle oinstall 4096 Jan 26 2017 database_EE -rwxr-x---. 1 oracle oinstall 3109225519 Aug 15 13:46 LINUX.X64_213000_db_home.zip [root@srlab21c softwares]# rpm -qa |grep preinstall oracle-database-preinstall-19c-1.0-3.el7.x86_64 oracle-database-server-12cR2-preinstall-1.0-5.el7.x86_64 [root@srlab21c softwares]# ls -ld /u01/app/oracle/product/21.0.0.0/db_1 ls: cannot access /u01/app/oracle/product/21.0.0.0/db_1: No such file or directory [root@srlab21c softwares]# [root@srlab21c softwares]# mkdir -p /u01/app/oracle/product/21.0.0.0/db_1 [root@srlab21c softwares]# ls -ld /u01/app/oracle/product/21.0.0.0/db_1 drwxr-xr-x. 2 root root 4096 Aug 15 14:16 /u01/app/oracle/product/21.0.0.0/db_1 [root@srlab21c softwares]# mkdir -p /u01/app/oraInventory [root@srlab21c softwares]# chown -R oracle:oinstall /u01/app/oracle/product/21.0.0.0/db_1 /u01/app/oraInventory [root@srlab21c softwares]# [root@srlab21c softwares]# ls -ld /u01/app/oraInventory drwxr-xr-x. 2 oracle oinstall 4096 Aug 15 14:16 /u01/app/oraInventory [root@srlab21c softwares]# ls -ld /u01/app/oracle/product/21.0.0.0/db_1 drwxr-xr-x. 2 oracle oinstall 4096 Aug 15 14:16 /u01/app/oracle/product/21.0.0.0/db_1 [root@srlab21c softwares]# chmod 755 LINUX.X64_213000_db_home.zip [root@srlab21c softwares]# chmod -R 755 /u01/app/oraInventory /u01/app/oracle/product/21.0.0.0/db_1 [root@srlab21c softwares]# ping www.databaselogwriter.com PING ghs.googlehosted.com (142.250.67.51) 56(84) bytes of data. 64 bytes from maa05s12-in-f19.1e100.net (142.250.67.51): icmp_seq=1 ttl=118 time=17.1 ms 64 bytes from maa05s12-in-f19.1e100.net (142.250.67.51): icmp_seq=2 ttl=118 time=7.39 ms 64 bytes from maa05s12-in-f19.1e100.net (142.250.67.51): icmp_seq=3 ttl=118 time=5.84 ms 64 bytes from maa05s12-in-f19.1e100.net (142.250.67.51): icmp_seq=4 ttl=118 time=7.14 ms 64 bytes from maa05s12-in-f19.1e100.net (142.250.67.51): icmp_seq=5 ttl=118 time=6.23 ms 64 bytes from maa05s12-in-f19.1e100.net (142.250.67.51): icmp_seq=6 ttl=118 time=19.6 ms 64 bytes from maa05s12-in-f19.1e100.net (142.250.67.51): icmp_seq=7 ttl=118 time=6.65 ms 64 bytes from maa05s12-in-f19.1e100.net (142.250.67.51): icmp_seq=8 ttl=118 time=8.00 ms 64 bytes from maa05s12-in-f19.1e100.net (142.250.67.51): icmp_seq=9 ttl=118 time=6.96 ms [root@srlab21c softwares]# tail -f /u01/app/oraInventory/logs/InstallActions2021-08-15_02-28-05PM/installActions2021-08-15_02-28-05PM.log [root@srlab21c softwares]# /u01/app/oracle/product/21.0.0.0/db_1/root.sh Check /u01/app/oracle/product/21.0.0.0/db_1/install/root_srlab21c_2021-08-15_14-35-54-941618273.log for the output of root script [root@srlab21c softwares]# view /u01/app/oracle/product/21.0.0.0/db_1/install/root_srlab21c_2021-08-15_14-35-54-941618273.log Log output from Oracle user: login as: oracle oracle@192.168.56.104's password: Last login: Sun Aug 15 13:56:50 2021 from gateway [oracle@srlab21c ~]$ [oracle@srlab21c ~]$ pwd /home/oracle [oracle@srlab21c ~]$ cd /softwares/ [oracle@srlab21c softwares]$ ls -lrt total 3036364 drwxr-xr-x. 7 oracle oinstall 4096 Jan 26 2017 database_EE -rwxr-xr-x. 1 oracle oinstall 3109225519 Aug 15 13:46 LINUX.X64_213000_db_home.zip [oracle@srlab21c softwares]$ unzip LINUX.X64_213000_db_home.zip -d /u01/app/oracle/product/21.0.0.0/db_1 Archive: LINUX.X64_213000_db_home.zip creating: /u01/app/oracle/product/21.0.0.0/db_1/addnode/ inflating: /u01/app/oracle/product/21.0.0.0/db_1/addnode/addnode.sh inflating: /u01/app/oracle/product/21.0.0.0/db_1/addnode/addnode_oraparam.ini.sbs inflating: /u01/app/oracle/product/21.0.0.0/db_1/addnode/addnode_oraparam.ini [oracle@srlab21c softwares]$ ls -lrt total 3036364 drwxr-xr-x. 7 oracle oinstall 4096 Jan 26 2017 database_EE -rwxr-xr-x. 1 oracle oinstall 3109225519 Aug 15 13:46 LINUX.X64_213000_db_home.zip [oracle@srlab21c softwares]$ [oracle@srlab21c softwares]$ export ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_1 [oracle@srlab21c softwares]$ export PATH=$PATH:$ORACLE_HOME/bin [oracle@srlab21c softwares]$ [oracle@srlab21c softwares]$ env |grep ORA ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_1 [oracle@srlab21c db_1]$ cd /home/oracle [oracle@srlab21c ~]$ pwd /home/oracle [oracle@srlab21c ~]$ vi srlab21c_software_only.rsp [oracle@srlab21c ~]$ [oracle@srlab21c ~]$ ls -lrt srlab21c_software_only.rsp total 18368 -rw-r--r--. 1 oracle oinstall 509 Aug 15 14:27 srlab21c_software_only.rsp [oracle@srlab21c ~]$ cat srlab21c_software_only.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v21.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install.db.OSBACKUPDBA_GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba [oracle@srlab21c ~]$ $ORACLE_HOME/runInstaller -responseFile /home/oracle/srlab21c_software_only.rsp -silent Launching Oracle Database Setup Wizard... [WARNING] [INS-13014] Target environment does not meet some optional requirements. CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2021-08-15_02-28-05PM/installActions2021-08-15_02-28-05PM.log ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2021-08-15_02-28-05PM/installActions2021-08-15_02-28-05PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually. The response file for this session can be found at: /u01/app/oracle/product/21.0.0.0/db_1/install/response/db_2021-08-15_02-28-05PM.rsp You can find the log of this install session at: /u01/app/oraInventory/logs/InstallActions2021-08-15_02-28-05PM/installActions2021-08-15_02-28-05PM.log As a root user, execute the following script(s): 1. /u01/app/oracle/product/21.0.0.0/db_1/root.sh Execute /u01/app/oracle/product/21.0.0.0/db_1/root.sh on the following nodes: [srlab21c] Successfully Setup Software with warning(s). [oracle@srlab21c ~]$ env |grep ORA ORACLE_HOME=/u01/app/oracle/product/21.0.0.0/db_1 [oracle@srlab21c ~]$ [oracle@srlab21c ~]$ cd /u01/app/oracle/product/21.0.0.0/db_1 [oracle@srlab21c db_1]$ cd bin [oracle@srlab21c bin]$ sqlplus /nolog SQL*Plus: Release 21.0.0.0.0 - Production on Sun Aug 15 14:36:56 2021 Version 21.3.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. SQL> exit [oracle@srlab21c bin]$

Hope this helps!

Cheers!

Ramesh.



Post a Comment: