26AI RAC Installation steps

-

 



yum install -y oracle-database-preinstall-19c

groupadd asmadmin

groupadd asmdba

groupadd asmoper

useradd -g oinstall -G asmadmin,asmdba,asmoper grid


usermod -G asmdba -a oracle


systemctl stop avahi-daemon.service

systemctl stop avahi-daemon.socket


systemctl disable avahi-daemon.service

systemctl disable avahi-daemon.socket


mkdir -p /u01/app/oraInventory

chown grid:oinstall /u01/app/oraInventory

chmod 775 /u01/app/oraInventory


mkdir -p /u01/app/grid

chown grid:oinstall /u01/app/grid

chmod 775 /u01/app/grid


mkdir -p /u01/app/21.1.0/grid

chown grid:oinstall /u01/app/21.1.0/grid


mkdir -p /u01/gridtmp

chown grid:oinstall /u01/gridtmp

chmod 775 /u01/app/21.1.0/grid

mkdir -p /u01/app/oracle

chown oracle:oinstall /u01/app/oracle

mkdir -p /u01/oratmp

chown oracle:oinstall /u01/oratmp

chmod 775 /u01/app/oracle

mkdir -p /u01/app/oracle/product/21.1.0/dbhome_1

chown -R oracle:oinstall /u01/app/oracle/product/21.1.0/dbhome_1

chmod -R 775 /u01/app/oracle/product/21.0.0/dbhome_1

mkdir -p /u01/software

cd /u01/

chown oracle:oinstall software

passwd grid

passwd oracle

chmod 777 software

systemctl stop firwalld.service

systemctl disable firewalld.service

setenforce 0

vi /etc/selinux/config


192.168.56.80        testrac21c01.oracle.com       testrac21c01

10.0.0.80    testrac21c01-priv.oracle.com   testrac21c01-priv

192.168.56.82  testrac21c01-vip.oracle.com       testrac21c01-vip


192.168.56.81        testrac21c02.oracle.com       testrac21c02

10.0.0.81         testrac21c02-priv.oracle.com   testrac21c02-priv

192.168.56.84       testrac21c02-vip.oracle.com       testrac21c02-vip


192.168.56.85      testracscan.oracle.com       testracscan

192.168.56.86      testracscan.oracle.com       testracscan

192.168.56.87      testracscan.oracle.com       testracscan


vi /etc/security/limits.d/oracle-database-preinstall-21c.conf


@oinstall soft nofile 1024

@oinstall hard nofile 65536

@oinstall soft nproc 16384

@oinstall hard nproc 16384

@oinstall soft stack 10240

@oinstall hard stack 32768

@oinstall hard memlock 134217728

@oinstall soft memlock 134217728

@oinstall soft data unlimited

@oinstall hard data unlimited


:wq!

dnf config-manager --set-enabled ol9_addons

 dnf install oracleasm-support

 systemctl start oracleasm

systemctl enable oracleasm

yum install -y oracleasm-support


oracleasm configure -i

grid

asmdba

Y

Y


shutdown OVM ==> clone to node2


hostnamectl set-hostname fhgtest01.uclidit.com




oracleasm createdisk asmdisk1 /dev/sdb1    5 gb

oracleasm createdisk asmdisk2 /dev/sdc1    25 gb

oracleasm createdisk asmdisk3 /dev/sdd1   25 gb


oracleasm createdisk asmcrs /dev/sdb1

oracleasm createdisk asmdata /dev/sdc1

oracleasm createdisk asmfra /dev/sdd1


cd



export ORACLE_BASE=/u01/app/grid/

export ORACLE_HOME=/u01/app/21.1.0/grid

export ORACLE_SID=+ASM1

export PATH=$PATH:$ORACLE_HOME/bin

export LD_LIBRARY_PATH=${ORACLE_HOME}/lib

export LIBPATH=$ORACLE_HOME/lib:${LIBPATH};

export TMP=/u01/gridtmp

export TMPDIR=$TMP

export DISPLAY=':0'

export CV_ASSUME_DISTID=OL7



export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/21.1.0/dbhome_1

export PATH=$ORACLE_HOME/OPatch:$PATH

export JAVA_HOME=$ORACLE_HOME/jdk

export ORACLE_SID=HRDB

export PATH=$PATH:$ORACLE_HOME/bin:$JAVA_HOME

export LD_LIBRARY_PATH=${ORACLE_HOME}/lib

export LIBPATH=$ORACLE_HOME/lib:${LIBPATH};

export SQLPATH=$SQLPATH:/stage/sqls/

export TMP=/u01/oratmp

export TMPDIR=$TMP

export CV_ASSUME_DISTID=OL7

export CV_ASSUME_DISTID=OEL7.9

umask 022

export ORACLE_TERM=xterm

stty erase ^?

export nls_date_format='MM/DD/YYYY HH24:MI:SS'

lsblk
fdisk  /dev/ssb

n

w or partprobe

partprobe /dev/sdc

dd if=/dev/sdc1 bs=1024 count=1 | strings

install required packages 
-------------------------------------------

oracleasmlib-3.0.0-13.el9.x86_64.rpm

oracleasmlib-3.1.1-1.el9.x86_64.rpm




Comments

Post a Comment

Popular posts from this blog

MY NOTEPAD

-
set lines 200 pages 200; col END_TIME for a20; col ELAPSED_TIME for a25; col START_TIME for a20 SELECT T.SESSION_KEY, T.INPUT_TYPE, T.STATUS, T.SUM_BACKUP_PIECES_IN_GB, T.START_TIME, T.END_TIME, T.SECONDS ELAPSED_TIME FROM ( SELECT SESSION_KEY, INPUT_TYPE, STATUS, OUTPUT_BYTES/1024/1024/1024 SUM_BACKUP_PIECES_IN_GB, TO_CHAR (START_TIME, 'dd/mm/yyyy hh24:mi') START_TIME, TO_CHAR (END_TIME, 'dd/mm/yyyy hh24:mi') END_TIME, TIME_TAKEN_DISPLAY SECONDS FROM V$RMAN_BACKUP_JOB_DETAILS WHERE INPUT_TYPE='ARCHIVELOG' ORDER BY SESSION_KEY DESC) T WHERE ROWNUM <= 1; ================ ASM disk group free space ============== set sqlblanklines on set lines 180 set pages 999le col "Group Name" form a25 col "Disk Name" form a30 col "State" form a15 ...
Read more

Oracle OEM Holistic Patch

-
  Oracle OEM Holistic Patch  The Concept Starting with Oracle Enterprise Manager (OEM) 13.5 RU24 (October 2024), Oracle introduced the Holistic Patch for OEM — a unified patching model that consolidates several separate updates into a single coordinated package. Previously, administrators had to patch: * The OMS and Agents with the quarterly Release Update (RU). * OEM Application via the System Patch Bundle (SPB). * WebLogic CPU and JDK manually. There was an element of complication because of the need to keep the solution homogeneous. With the Holistic Patch, the last two steps are merged into a single patch bundle. Now we have a new Holistic patch for OEM that is released with each new OMS Release Update. Prerequisites Apply RU 24 Patch  PATCH 36761595  /later on all OMSes before applying Oct Holistic Patch   PATCH 37305292             (OR) Apply RU 25 Patch  PATCH 37057635  /later on all OMSes before applying ...
Read more

Upgrade Oracle 19c DB to 21c using Auto Upgrade utility inprogress

-
Image
  Upgrade Oracle 11g to 21c using AutoUpgrade utility: How do I upgrade Oracle database to 21c?  install the 21c oracle binaries into the server . Oracle Virtual Bix  Oracle Linux 7 Oracle Database 19c currently running Upgrading 19c database to 21c directly Oracle Database 19c on premises is available – and one of the key features is the new Auto Upgrade utility. In the following days I will publish several blog posts explaining and showcasing the new Auto Upgrade. What is the Auto Upgrade? The Oracle Database Auto Upgrade utility is a new tiny little command line tool which allows you to upgrade your databases in an unattended way. I call it the Hands-Free Upgrade. The new Auto Upgrade utility in Oracle 19che idea of the tool is to run the prechecks against multiple databases, fix 99% of the potential issues, set a restore point in case something goes wrong – and then upgrade your databases. And of course, do the post upgrade, recompilation and time zone adjustment. The...
Read more