Tag: Database 12.2

 

• Create the new Oracle Database Home (ORACLE_HOME) directory where 12.2.0.1 will be installed

[root@dm01db01 ~]# dcli -g ~/dbs_group -l root mkdir -p /u01/app/oracle

[root@dm01db01 ~]# dcli -g ~/dbs_group -l root chown -R oracle:oinstall /u01/app/oracle

[root@dm01db01 ~]# dcli -g ~/dbs_group -l root chmod -R 775 /u01/app/oracle

[oracle@dm01db01 oracle]$ dcli -g ~/dbs_group -l oracle mkdir -p /u01/app/oracle/product/12.2.0.1/dbhome

[oracle@dm01db01 oracle]$ dcli -g ~/dbs_group -l oracle ls -l  /u01/app/oracle/product/12.2.0.1
dm01db01: total 4
dm01db01: drwxr-xr-x 2 oracle oinstall 4096 Mar 10 07:48 dbhome
dm01db02: total 4
dm01db02: drwxr-xr-x 2 oracle oinstall 4096 Mar 10 07:48 dbhome
dm01db03: total 4
dm01db03: drwxr-xr-x 2 oracle oinstall 4096 Mar 10 07:48 dbhome
dm01db04: total 4
dm01db04: drwxr-xr-x 2 oracle oinstall 4096 Mar 10 07:48 dbhome
dm01db05: total 4
dm01db05: drwxr-xr-x 2 oracle oinstall 4096 Mar 10 07:48 dbhome
dm01db06: total 4
dm01db06: drwxr-xr-x 2 oracle oinstall 4096 Mar 10 07:48 dbhome
dm01db07: total 4
dm01db07: drwxr-xr-x 2 oracle oinstall 4096 Mar 10 07:48 dbhome
dm01db08: total 4
dm01db08: drwxr-xr-x 2 oracle oinstall 4096 Mar 10 07:48 dbhome

• Unzip installation software

Database Software

dm01db01-orp258c1 {/home/oracle}:cd /u01/app/oracle/software/
dm01db01-orp258c1 {/u01/app/oracle/software}:unzip linuxx64_12201_database.zip
Archive:  linuxx64_12201_database.zip
   creating: database/
   creating: database/sshsetup/
  inflating: database/sshsetup/sshUserSetup.sh
   creating: database/rpm/
  inflating: database/rpm/cvuqdisk-1.0.10-1.rpm
   creating: database/response/
  inflating: database/response/dbca.rsp
  inflating: database/response/netca.rsp
  inflating: database/response/db_install.rsp
   creating: database/install/
  inflating: database/install/detachHome.sh
 extracting: database/install/addLangs.sh
  inflating: database/stage/OuiConfigVariables.xml
   creating: database/stage/Actions/
   creating: database/stage/Actions/jarActions/
   creating: database/stage/Actions/jarActions/10.2.0.0.0/
   creating: database/stage/Actions/jarActions/10.2.0.0.0/1/
  inflating: database/stage/Actions/jarActions/10.2.0.0.0/1/jarActionLib.jar
   creating: database/stage/Actions/customFileActions/
   creating: database/stage/Actions/customFileActions/1.2.1/
   creating: database/stage/Actions/customFileActions/1.2.1/1/
  inflating: database/stage/Actions/customFileActions/1.2.1/1/customFileActions.jar
   creating: database/stage/Actions/ntGrpActionLib/
   creating: database/stage/Actions/ntGrpActionLib/10.2.0.1.0/
   creating: database/stage/Actions/ntGrpActionLib/10.2.0.1.0/1/
  inflating: database/stage/Actions/ntGrpActionLib/10.2.0.1.0/1/ntGrpActionLib.jar
   creating: database/stage/Actions/ServiceProcessActions/
   creating: database/stage/Actions/ServiceProcessActions/1.0/
   creating: database/stage/Actions/ServiceProcessActions/1.0/1/
  inflating: database/stage/Actions/ServiceProcessActions/1.0/1/ServiceProcessActions.jar
   creating: database/stage/Actions/fileActions/
   creating: database/stage/Actions/fileActions/12.2.0.1.1/
   creating: database/stage/Actions/fileActions/12.2.0.1.1/1/
  inflating: database/stage/Actions/fileActions/12.2.0.1.1/1/fileActionLib.jar
   creating: database/stage/Actions/unixActions/
   creating: database/stage/Actions/unixActions/10.2.0.3.0/
   creating: database/stage/Actions/unixActions/10.2.0.3.0/1/
  inflating: database/stage/Actions/unixActions/10.2.0.3.0/1/unixActions.jar
….

dm01db01-orp258c1 {/u01/app/oracle/software}:ls -l database/
total 36
drwxr-xr-x  4 oracle oinstall 4096 Jan 26 08:39 install
drwxrwxr-x  2 oracle oinstall 4096 Jan 26 09:53 response
drwxr-xr-x  2 oracle oinstall 4096 Jan 26 08:39 rpm
-rwxr-xr-x  1 oracle oinstall 8771 Jan 26 08:39 runInstaller
drwxrwxr-x  2 oracle oinstall 4096 Jan 26 09:53 sshsetup
drwxr-xr-x 14 oracle oinstall 4096 Jan 26 09:55 stage
-rwxr-xr-x  1 oracle oinstall  500 Feb  6  2013 welcome.html

• Setup User equivalance

dm01db01-orcldb1 {/home/oracle}: dcli -g dbs_group -l oracle -k

• Create user’s profile

dm01db01-orcldb1 {/u01/app/oracle/software}: vi .bash_profile

export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/12.2.0.1/grid
export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/dbhome
export ORACLE_TERM=xterm
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

• Validate Readiness for Oracle Clusterware upgrade using CVU

dm01db01-orp258c1 {/home/oracle}: /u01/app/12.2.0.1/grid/runcluvfy.sh stage -pre dbinst -n

dm01db01,dm01db02,dm01db03,dm01db04,dm01db05,dm01db06,dm01db07,dm01db08 -r 12.2 -fixupnoexec

Verifying Physical Memory …PASSED
Verifying Available Physical Memory …PASSED
Verifying Swap Size …PASSED
Verifying Free Space: dm01db05:/tmp …PASSED
Verifying Free Space: dm01db04:/tmp …PASSED
Verifying Free Space: dm01db03:/tmp …PASSED
Verifying Free Space: dm01db02:/tmp …PASSED
Verifying Free Space: dm01db01:/tmp …PASSED
Verifying Free Space: dm01db08:/tmp …PASSED
Verifying Free Space: dm01db07:/tmp …PASSED
Verifying Free Space: dm01db06:/tmp …PASSED
Verifying User Existence: oracle …
  Verifying Users With Same UID: 1000 …PASSED
Verifying User Existence: oracle …PASSED
Verifying Group Existence: dba …PASSED
Verifying Group Existence: oinstall …PASSED
Verifying Group Membership: oinstall(Primary) …PASSED
Verifying Group Membership: dba …PASSED
Verifying Run Level …PASSED
Verifying Hard Limit: maximum open file descriptors …PASSED
Verifying Soft Limit: maximum open file descriptors …PASSED
Verifying Hard Limit: maximum user processes …PASSED
Verifying Soft Limit: maximum user processes …PASSED
Verifying Soft Limit: maximum stack size …PASSED
Verifying Architecture …PASSED
Verifying OS Kernel Version …PASSED
Verifying OS Kernel Parameter: semmsl …PASSED
Verifying OS Kernel Parameter: semmns …PASSED
Verifying OS Kernel Parameter: semopm …PASSED
Verifying OS Kernel Parameter: semmni …PASSED
Verifying OS Kernel Parameter: shmmax …PASSED
Verifying OS Kernel Parameter: shmmni …PASSED
Verifying OS Kernel Parameter: shmall …PASSED
Verifying OS Kernel Parameter: file-max …PASSED
Verifying OS Kernel Parameter: ip_local_port_range …PASSED
Verifying OS Kernel Parameter: rmem_default …PASSED
Verifying OS Kernel Parameter: rmem_max …PASSED
Verifying OS Kernel Parameter: wmem_default …PASSED
Verifying OS Kernel Parameter: wmem_max …PASSED
Verifying OS Kernel Parameter: aio-max-nr …PASSED
Verifying Package: binutils-2.20.51.0.2 …PASSED
Verifying Package: compat-libcap1-1.10 …PASSED
Verifying Package: compat-libstdc++-33-3.2.3 (x86_64) …PASSED
Verifying Package: libgcc-4.4.7 (x86_64) …PASSED
Verifying Package: libstdc++-4.4.7 (x86_64) …PASSED
Verifying Package: libstdc++-devel-4.4.7 (x86_64) …PASSED
Verifying Package: sysstat-9.0.4 …PASSED
Verifying Package: ksh …PASSED
Verifying Package: make-3.81 …PASSED
Verifying Package: glibc-2.12 (x86_64) …PASSED
Verifying Package: glibc-devel-2.12 (x86_64) …PASSED
Verifying Package: libaio-0.3.107 (x86_64) …PASSED
Verifying Package: libaio-devel-0.3.107 (x86_64) …PASSED
Verifying Package: smartmontools-5.43-1 …PASSED
Verifying Package: net-tools-1.60-110 …PASSED
Verifying Users With Same UID: 0 …PASSED
Verifying Current Group ID …PASSED
Verifying Root user consistency …PASSED
Verifying Node Connectivity …
  Verifying Hosts File …PASSED
  Verifying Check that maximum (MTU) size packet goes through subnet …PASSED
  Verifying subnet mask consistency for subnet “192.168.2.0” …PASSED
  Verifying subnet mask consistency for subnet “10.220.30.128” …PASSED
Verifying Node Connectivity …PASSED
Verifying Multicast check …PASSED
Verifying User Mask …PASSED
Verifying CRS Integrity …
  Verifying Clusterware Version Consistency …PASSED
Verifying CRS Integrity …PASSED
Verifying Cluster Manager Integrity …PASSED
Verifying Node Application Existence …PASSED
Verifying Clock Synchronization …
CTSS is in Observer state. Switching over to clock synchronization checks using NTP

  Verifying Network Time Protocol (NTP) …
    Verifying ‘/etc/ntp.conf’ …PASSED
    Verifying ‘/var/run/ntpd.pid’ …PASSED
    Verifying Daemon ‘ntpd’ …PASSED
    Verifying NTP daemon command line for slewing option “-x” …PASSED
    Verifying NTP daemon’s boot time configuration, in file “/etc/sysconfig/ntpd”, for slewing option “-x”…PASSED
    Verifying NTP daemon or service using UDP port 123 …PASSED
    Verifying NTP daemon is synchronized with at least one external time source …PASSED
  Verifying Network Time Protocol (NTP) …PASSED
Verifying Clock Synchronization …PASSED
Verifying resolv.conf Integrity …
  Verifying (Linux) resolv.conf Integrity …PASSED
Verifying resolv.conf Integrity …PASSED
Verifying Time zone consistency …PASSED
Verifying Single Client Access Name (SCAN) …
  Verifying DNS/NIS name service ‘dm01-scan’ …
    Verifying Name Service Switch Configuration File Integrity …PASSED
  Verifying DNS/NIS name service ‘dm01-scan’ …PASSED
Verifying Single Client Access Name (SCAN) …PASSED
Verifying VIP Subnet configuration check …PASSED
Verifying Database Clusterware Version Compatibility …PASSED
Verifying ASM storage privileges for the user: oracle …
  Verifying Group Membership: asmdba …PASSED
Verifying ASM storage privileges for the user: oracle …PASSED
Verifying Daemon “proxyt” not configured and running …PASSED
Verifying ACFS device special file …PASSED
Verifying /dev/shm mounted as temporary file system …PASSED
Verifying Maximum locked memory check …PASSED

Pre-check for database installation was successful.

CVU operation performed:      stage -pre dbinst
Date:                         Mar 11, 2017 4:29:40 AM
CVU home:                     /u01/app/12.2.0.1/grid/
User:                         oracle
dm01db01-orp258c1 {/home/oracle}:

• Unset the environment variables

dm01db01-orcldb1 {/u01/app/oracle/software}:unset ORACLE_HOME ORACLE_BASE ORACLE_SID

• Set the display and execute runInstaller

dm01db01- {/u01/app/oracle/software/database}:export DISPLAY=10.30.21.30:0.0
dm01db01- {/u01/app/oracle/software}:cd /u01/app/oracle/software/database
[oracle@dm01db01 database]$ ./runInstaller
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 500 MB.   Actual 27165 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 16350 MB    Passed
Checking monitor: must be configured to display at least 256 colors

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-03-10_07-58-20AM. Please wait …
[oracle@dm01db01 database]$

You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2017-03-10_07-58-20AM.log
[oracle@dm01db01 database]$ 


The Installer appears with the first page. Uncheck the security updates.

Click Yes to continue

Select Install database software only

Select Oracle Real Application Clusters database installation

Click select all, and click next

Select Enterprise Edition

Specify the Oracle Base and Oracle Home where you want to install Oracle Database software

Select OS groups for OS authentication

Prerequisites checks are in progress

Prerequisite checks failed for soft limit. Check the ignore all box and click next

Click Yes to continue.

Review the summary page and click Install

Software Installation  in progress

Execute the root.sh script on all the nodes

Open a new terminal and execute the root.sh script on all the nodes as follows.

[root@dm01db01 ~]# /u01/app/oracle/product/12.2.0.1/dbhome/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/12.2.0.1/dbhome

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of “dbhome” have not changed. No need to overwrite.
The contents of “oraenv” have not changed. No need to overwrite.
The contents of “coraenv” have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.

Repeat the above step on all other nodes in the cluster.

Go back to the installer screen and click ok

Click close to complete the Installation