cat /etc/oracle-release cat /etc/redhat-release cat /etc/os-release lsb_release -id lsb_release -a [root@oragrid ~]# lsb_release -a LSB Version: :core-4.1-amd64:core-4.1-noarch Distributor ID: CentOS Description: CentOS Linux release 8.5.2111 Release: 8.5.2111 Codename: n/a [root@oragrid ~]# lsb_release -d Description: CentOS Linux release 8.5.2111 [root@oragrid ~]# lsb_release -i -s CentOS [root@oragrid ~]# lsb_release -rcs 8.5.2111 n/a [root@oragrid ~]# lsb_release -s :core-4.1-amd64:core-4.1-noarch [root@oragrid ~]# lsb_release -si CentOS [root@oragrid ~]# cat /etc/redhat-release CentOS Linux release 8.5.2111 [root@oragrid ~]# cat /etc/os-release NAME="CentOS Linux" VERSION="8" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="8" PLATFORM_ID="platform:el8" PRETTY_NAME="CentOS Linux 8" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:8" HOME_URL="https://centos.org/" BUG_REPORT_URL="https://bugs.centos.org/" CENTOS_MANTISBT_PROJECT="CentOS-8" CENTOS_MANTISBT_PROJECT_VERSION="8"
Search This Blog
Total Pageviews
Sunday, 22 December 2024
Linux version Or unix version
Friday, 20 December 2024
[INS-30502] No ASM Disk Group found
[INS-30502] No ASM Disk Group found
as root
vi /etc/group
dba:x:54322:grid,oracle oper:x:54323:oracle backupdba:x:54324: dgdba:x:54325: kmdba:x:54326: asmdba:x:54327:grid,oracle <<<<< oracle should be part of asmdba asmoper:x:54328:grid asmadmin:x:54329:grid racdba:x:54330: postdrop:x:90: postfix:x:89: osdba:x:1020:oracle,grid osoper:x:1030:oracle osbackupdba:x:1040:oracle oskmdba:x:1050:oracle osdgdba:x:1060:oracle osracdba:x:1070:oracle [root@oragrid ~]#
Monday, 16 December 2024
How To Relink The Oracle Grid Infrastructure Standalone (Restart) Installation.
Metalink Note : How To Relink The Oracle Grid Infrastructure Standalone (Restart) Installation Or Oracle Grid Infrastructure RAC/Cluster Installation (11.2 to 21c). (Doc ID 1536057.1) =========================================================================================================== as Grid .. [grid@oragrid ~]$ id uid=1100(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54327(asmdba),54328(asmoper),54329(asmadmin) [grid@oragrid ~]$ . oraenv ORACLE_SID = [+ASM] ? The Oracle base remains unchanged with value /u01/app/grid [grid@oragrid ~]$ stop has via grid user [grid@oragrid ~]$ crsctl stop has CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oragrid' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'oragrid' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oragrid' CRS-2677: Stop of 'ora.DATA.dg' on 'oragrid' succeeded CRS-2673: Attempting to stop 'ora.evmd' on 'oragrid' CRS-2673: Attempting to stop 'ora.asm' on 'oragrid' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oragrid' succeeded CRS-2677: Stop of 'ora.asm' on 'oragrid' succeeded CRS-2677: Stop of 'ora.evmd' on 'oragrid' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'oragrid' CRS-2677: Stop of 'ora.cssd' on 'oragrid' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oragrid' has completed CRS-4133: Oracle High Availability Services has been stopped. [grid@oragrid ~]$ grid@oragrid ~]$ crsctl check has CRS-4639: Could not contact Oracle High Availability Services 2. # as root !!!!!!!! unlock the Oracle Grid Infrastructure Standalone installation as root !!!! [root@oragrid ~]# . oraenv ORACLE_SID = [root] ? +ASM The Oracle base has been set to /u01/app/grid [root@oragrid ~]# id uid=0(root) gid=0(root) groups=0(root) [root@oragrid ~]# below error !!! XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX [root@oragrid ~]# id uid=0(root) gid=0(root) groups=0(root) [root@oragrid ~]# $ORACLE_HOME/crs/install/roothas.pl -unlock /u01/app/21.3.0/grid/crs/install/roothas.pl: line 8: =head1: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 10: roothas.pl: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 12: =head1: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 14: roothas.pl: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 15: parameter-file: No such file or directory /u01/app/21.3.0/grid/crs/install/roothas.pl: line 16: path: No such file or directory /u01/app/21.3.0/grid/crs/install/roothas.pl: line 17: path: No such file or directory /u01/app/21.3.0/grid/crs/install/roothas.pl: line 18: [[-prepatch: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 18: path: No such file or directory /u01/app/21.3.0/grid/crs/install/roothas.pl: line 19: [-lockacfs]: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 20: path: No such file or directory /u01/app/21.3.0/grid/crs/install/roothas.pl: line 22: Options:: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 23: -verbose: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 24: -upgrade: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 25: -lock: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 26: -paramfile: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 27: -deconfig: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 28: -force: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 29: is: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 30: -unlock: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 31: -hahome: command not found /u01/app/21.3.0/grid/crs/install/roothas.pl: line 32: syntax error near unexpected token `(' /u01/app/21.3.0/grid/crs/install/roothas.pl: line 32: ` -prepatch Perform required steps before the Oracle patching tool (Opatch) is invoked' [root@oragrid ~]# echo $ORACLE_HOME /u01/app/21.3.0/grid XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX On 12.1/12.2/21c releases, roothas.sh can be used instead of roothas.pl. <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< roothas.sh Command to unlock the GI home is/crs/install/roothas.sh -unlock [root@oragrid ~]# ls -ltr $ORACLE_HOME/crs/install/roothas.pl -rwxr-x--- 1 root oinstall 10305 Oct 10 09:07 /u01/app/21.3.0/grid/crs/install/roothas.pl [root@oragrid ~]# ls -ltr $ORACLE_HOME/crs/install/roothas.sh -rwxr-x--- 1 grid oinstall 3926 Dec 12 15:08 /u01/app/21.3.0/grid/crs/install/roothas.sh <<<< use this [root@oragrid ~]# [root@oragrid ~]# ls -ltr $ORACLE_HOME/crs/install/roothas.pl -rwxr-x--- 1 root oinstall 10305 Oct 10 09:07 /u01/app/21.3.0/grid/crs/install/roothas.pl [root@oragrid ~]# ls -ltr $ORACLE_HOME/crs/install/roothas.sh -rwxr-x--- 1 grid oinstall 3926 Dec 12 15:08 /u01/app/21.3.0/grid/crs/install/roothas.sh [root@oragrid ~]# $ORACLE_HOME/crs/install/roothas.sh -unlock Using configuration parameter file: /u01/app/21.3.0/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/grid/crsdata/oragrid/crsconfig/haunlock__2024-12-16_09-43-56AM.log 2024/12/16 09:44:07 CLSRSC-347: Successfully unlock /u01/app/21.3.0/grid [root@oragrid ~]# [root@oragrid ~]# ls -ltr $ORACLE_HOME/rdbms/lib/config.o* -rw-r--r-- 1 grid oinstall 1352 Dec 12 15:10 /u01/app/21.3.0/grid/rdbms/lib/config.o_BAK [root@oragrid ~]# env| egrep 'ORA|PATH' | sort LD_LIBRARY_PATH=/u01/app/21.3.0/grid/lib ORACLE_BASE=/u01/app/grid ORACLE_HOME=/u01/app/21.3.0/grid ORACLE_SID=+ASM PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/app/21.3.0/grid/bin [root@oragrid ~]# as Grid [grid@oragrid ~]$ script /tmp/relink_gi.txt Script started, file is /tmp/relink_gi.txt [grid@oragrid ~]$ id uid=1100(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54327(asmdba),54328(asmoper),54329(asmadmin) [grid@oragrid ~]$ env| egrep 'ORA|PATH' | sort LD_LIBRARY_PATH=/u01/app/21.3.0/grid/lib ORACLE_BASE=/u01/app/grid ORACLE_HOME=/u01/app/21.3.0/grid ORACLE_SID=+ASM PATH=/home/grid/.local/bin:/home/grid/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/u01/app/21.3.0/grid/bin [grid@oragrid ~]$ lock back the Oracle Grid Infrastructure Standalone installation AS root # [root@oragrid ~]# ls -ltr /u01/app/21.3.0/grid/crs/install/roothas.sh -rwxr-x--- 1 grid oinstall 3926 Dec 12 15:08 /u01/app/21.3.0/grid/crs/install/roothas.sh ================================ [root@oragrid ~]# /u01/app/21.3.0/grid/crs/install/roothas.sh -postpatch Using configuration parameter file: /u01/app/21.3.0/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/grid/crsdata/oragrid/crsconfig/hapatch_2024-12-16_10-00-09AM.log 2024/12/16 10:00:14 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service' 2024/12/16 10:01:01 CLSRSC-672: Post-patch steps for patching GI home successfully completed. [root@oragrid ~]# [root@oragrid ~]# crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE oragrid STABLE ora.LISTENER.lsnr ONLINE ONLINE oragrid STABLE ora.asm ONLINE ONLINE oragrid Started,STABLE ora.ons OFFLINE OFFLINE oragrid STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd 1 ONLINE ONLINE oragrid STABLE ora.diskmon 1 OFFLINE OFFLINE STABLE ora.evmd 1 ONLINE ONLINE oragrid STABLE -------------------------------------------------------------------------------- [root@oragrid ~]# [root@oragrid ~]# crsctl status res | awk -F= '/NAME=/{n=$2}/TYPE=/{t=$2}/TARGET=/{g=$2}/STATE=/{s=$2; printf("%-60s%-30s%-10s%-30s\n", n,t,g,s)}' ora.DATA.dg ora.diskgroup.type ONLINE ONLINE on oragrid ora.LISTENER.lsnr ora.listener.type ONLINE ONLINE on oragrid ora.asm ora.asm.type ONLINE ONLINE on oragrid ora.cssd ora.cssd.type ONLINE ONLINE on oragrid ora.diskmon ora.diskmon.type OFFLINE OFFLINE ora.evmd ora.evm.type ONLINE ONLINE on oragrid ora.ons ora.ons.type OFFLINE OFFLINE [root@oragrid ~]#
Friday, 13 December 2024
How to Deinstall Old Clusterware Home Once Upgrade to Newer Version is Complete
How to Deinstall Old Clusterware Home Once Upgrade to Newer Version is Complete (Doc ID 1346305.1) ============================================================================ [grid@oragrid ContentsXML]$ pwd /u01/app/oraInventory/ContentsXML [grid@oragrid ContentsXML]$ cat inventory.xml[grid@oragrid ContentsXML]$ ==================================================== export OLD_HOME=/u01/app/19.2.0/grid export ORACLE_HOME=$OLD_HOME [grid@oragrid ~]$ echo $ORACLE_HOME /u01/app/19.2.0/grid [grid@oragrid ~]$ $OLD_HOME/oui/bin/runInstaller -detachHome -silent ORACLE_HOME=$OLD_HOME Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 6759 MB Passed The inventory pointer is located at /etc/oraInst.loc You can find the log of this install session at: /u01/app/oraInventory/logs/DetachHome2024-12-13_12-30-06PM.log 'DetachHome' was successful. [grid@oragrid ContentsXML]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml 12.2.0.9.0 2.1.0.6.0 [grid@oragrid ContentsXML]$ $NEW_HOME/OPatch/opatch lsinventory -all /u01/app/21.3.0/grid/OPatch/opatch lsinventory -all /u01/app/21.3.0/grid/OPatch/opatch lsinventory -all Oracle Interim Patch Installer version 12.2.0.1.26 Copyright (c) 2024, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/19.2.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/19.2.0/grid/oraInst.loc OPatch version : 12.2.0.1.26 OUI version : 12.2.0.7.0 Log file location : /u01/app/19.2.0/grid/cfgtoollogs/opatch/opatch2024-12-13_12-34-42PM_1.log List of Homes on this system: Home name= OraGI21Home1, Location= "/u01/app/21.3.0/grid" LsInventorySession failed: RawInventory gets null OracleHomeInfo OPatch failed with error code 73 [grid@oragrid ContentsXML]$ [root@oragrid ~]# export OLD_HOME=/u01/app/19.2.0/grid [root@oragrid ~]# rm -rf $OLD_HOME [root@oragrid ~]# ls -ltr /u01/app/19.2.0/grid 12.2.0.7.0 2.1.0.6.0 <<<< now we are good
Upgrading Oracle Restart from 19c to 21c on centos 8.5
Upgrading Oracle Restart from 19c to 21c on centos 8.5 ======================================== To check resource crsctl status res | awk -F= '/NAME=/{n=$2}/TYPE=/{t=$2}/TARGET=/{g=$2}/STATE=/{s=$2; printf("%-60s%-30s%-10s%-30s\n", n,t,g,s)}'
ora.DATA.dg ora.diskgroup.type ONLINE ONLINE on oragrid ora.LISTENER.lsnr ora.listener.type ONLINE ONLINE on oragrid ora.asm ora.asm.type ONLINE ONLINE on oragrid ora.cssd ora.cssd.type ONLINE ONLINE on oragrid ora.diskmon ora.diskmon.type OFFLINE OFFLINE ora.evmd ora.evm.type ONLINE ONLINE on oragrid ora.ons ora.ons.type OFFLINE OFFLINE
[grid@oragrid ~]$ crsctl query has releaseversion Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@oragrid ~]$ crsctl query has softwareversion Oracle High Availability Services version on the local node is [19.0.0.0.0] [grid@oragrid ~]$
Download
LINUX.X64_213000_grid_home.zip
mkdir -p /u01/app/21.3.0/grid
[grid@oragrid ~]$ cd /u01/app/21.3.0/grid/ [grid@oragrid grid]$ pwd /u01/app/21.3.0/grid [grid@oragrid grid]$ unzip -oq /home/grid/LINUX.X64_213000_grid_home.zip
./runcluvfy.sh stage -pre hacfg
This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.
Performing following verification checks ...
Physical Memory ...FAILED (PRVF-7530) Available Physical Memory ...PASSED Swap Size ...PASSED Free Space: oragrid:/usr,oragrid:/var,oragrid:/etc,oragrid:/sbin,oragrid:/tmp ...PASSED User Existence: grid ... Users With Same UID: 1100 ...PASSED User Existence: grid ...PASSED Group Existence: dba ...PASSED Group Existence: oinstall ...PASSED Group Membership: dba ...FAILED (PRVG-10460) Group Membership: oinstall(Primary) ...PASSED Run Level ...PASSED Architecture ...PASSED OS Kernel Version ...PASSED OS Kernel Parameter: semmsl ...PASSED OS Kernel Parameter: semmns ...PASSED OS Kernel Parameter: semopm ...PASSED OS Kernel Parameter: semmni ...PASSED OS Kernel Parameter: shmmax ...PASSED OS Kernel Parameter: shmmni ...PASSED OS Kernel Parameter: shmall ...PASSED OS Kernel Parameter: file-max ...PASSED OS Kernel Parameter: ip_local_port_range ...PASSED OS Kernel Parameter: rmem_default ...PASSED OS Kernel Parameter: rmem_max ...PASSED OS Kernel Parameter: wmem_default ...PASSED OS Kernel Parameter: wmem_max ...PASSED OS Kernel Parameter: aio-max-nr ...PASSED OS Kernel Parameter: panic_on_oops ...PASSED Package: kmod-20-21 (x86_64) ...PASSED Package: kmod-libs-20-21 (x86_64) ...PASSED Package: binutils-2.30-49.0.2 ...PASSED Package: libgcc-8.2.1 (x86_64) ...PASSED Package: libstdc++-8.2.1 (x86_64) ...PASSED Package: sysstat-10.1.5 ...PASSED Package: ksh ...PASSED Package: make-4.2.1 ...PASSED Package: glibc-2.28 (x86_64) ...PASSED Package: glibc-devel-2.28 (x86_64) ...PASSED Package: libaio-0.3.110 (x86_64) ...PASSED Package: nfs-utils-2.3.3-14 ...PASSED Package: smartmontools-6.6-3 ...PASSED Package: net-tools-2.0-0.51 ...PASSED Package: policycoreutils-2.9-3 ...PASSED Package: policycoreutils-python-utils-2.9-3 ...PASSED Users With Same UID: 0 ...PASSED Current Group ID ...PASSED Root user consistency ...PASSED
Pre-check for Oracle Restart configuration was unsuccessful.
Failures were encountered during execution of CVU verification request "stage -pre hacfg".
Physical Memory ...FAILED oragrid: PRVF-7530 : Sufficient physical memory is not available on node "oragrid" [Required physical memory = 8GB (8388608.0KB)]
Group Membership: dba ...FAILED oragrid: PRVG-10460 : User "grid" does not belong to group "dba" selected for privileges "OSDBA" on node "oragrid".
CVU operation performed: stage -pre hacfg Date: 12-Dec-2024 13:06:32 CVU home: /u01/app/21.3.0/grid Grid home: /u01/app/19.2.0/grid User: grid Operating system: Linux4.18.0-348.7.1.el8_5.x86_64 [grid@oragrid grid]$
*******************************
oragrid: PRVG-10460 : User "grid" does not belong to group "dba" selected for privileges "OSDBA" on node "oragrid".
cat /etc/group|grep -i grid dba:x:54322:grid <<<<<--- add grid into dba group asmdba:x:54327:grid asmoper:x:54328:grid asmadmin:x:54329:grid
********************************
./runcluvfy.sh stage -pre hacfg This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.
Performing following verification checks ...
Physical Memory ...FAILED (PRVF-7530) Available Physical Memory ...PASSED Swap Size ...PASSED Free Space: oragrid:/usr,oragrid:/var,oragrid:/etc,oragrid:/sbin,oragrid:/tmp ...PASSED User Existence: grid ... Users With Same UID: 1100 ...PASSED User Existence: grid ...PASSED Group Existence: dba ...PASSED Group Existence: oinstall ...PASSED Group Membership: dba ...PASSED Group Membership: oinstall(Primary) ...PASSED Run Level ...PASSED Architecture ...PASSED OS Kernel Version ...PASSED OS Kernel Parameter: semmsl ...PASSED OS Kernel Parameter: semmns ...PASSED OS Kernel Parameter: semopm ...PASSED OS Kernel Parameter: semmni ...PASSED OS Kernel Parameter: shmmax ...PASSED OS Kernel Parameter: shmmni ...PASSED OS Kernel Parameter: shmall ...PASSED OS Kernel Parameter: file-max ...PASSED OS Kernel Parameter: ip_local_port_range ...PASSED OS Kernel Parameter: rmem_default ...PASSED OS Kernel Parameter: rmem_max ...PASSED OS Kernel Parameter: wmem_default ...PASSED OS Kernel Parameter: wmem_max ...PASSED OS Kernel Parameter: aio-max-nr ...PASSED OS Kernel Parameter: panic_on_oops ...PASSED Package: kmod-20-21 (x86_64) ...PASSED Package: kmod-libs-20-21 (x86_64) ...PASSED Package: binutils-2.30-49.0.2 ...PASSED Package: libgcc-8.2.1 (x86_64) ...PASSED Package: libstdc++-8.2.1 (x86_64) ...PASSED Package: sysstat-10.1.5 ...PASSED Package: ksh ...PASSED Package: make-4.2.1 ...PASSED Package: glibc-2.28 (x86_64) ...PASSED Package: glibc-devel-2.28 (x86_64) ...PASSED Package: libaio-0.3.110 (x86_64) ...PASSED Package: nfs-utils-2.3.3-14 ...PASSED Package: smartmontools-6.6-3 ...PASSED Package: net-tools-2.0-0.51 ...PASSED Package: policycoreutils-2.9-3 ...PASSED Package: policycoreutils-python-utils-2.9-3 ...PASSED Users With Same UID: 0 ...PASSED Current Group ID ...PASSED Root user consistency ...PASSED
Pre-check for Oracle Restart configuration was unsuccessful.
Failures were encountered during execution of CVU verification request "stage -pre hacfg".
Physical Memory ...FAILED oragrid: PRVF-7530 : Sufficient physical memory is not available on node "oragrid" [Required physical memory = 8GB (8388608.0KB)]
CVU operation performed: stage -pre hacfg Date: 12-Dec-2024 13:24:10 CVU home: /u01/app/21.3.0/grid Grid home: /u01/app/19.2.0/grid User: grid Operating system: Linux4.18.0-348.7.1.el8_5.x86_64 [grid@oragrid grid]$
unset ORACLE_HOME unset ORACLE_BASE unset ORACLE_SID
[grid@oragrid grid]$ export CV_ASSUME_DISTID=OEL7.8 [grid@oragrid grid]$ ./gridSetup.sh & [1] 11065 [grid@oragrid grid]$ ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable. Launching Oracle Grid Infrastructure Setup Wizard...
The response file for this session can be found at: /u01/app/21.3.0/grid/install/response/grid_2024-12-12_03-04-14PM.rsp
You can find the log of this install session at: /u01/app/oraInventory/logs/GridSetupActions2024-12-12_03-04-14PM/gridSetupActions2024-12-12_03-04-14PM.log
[root@oragrid ~]# /u01/app/21.3.0/grid/rootupgrade.sh Performing root user operation.
The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /u01/app/21.3.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ...
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. Using configuration parameter file: /u01/app/21.3.0/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/grid/crsdata/oragrid/crsconfig/roothas_2024-12-12_03-17-27PM.log 2024/12/12 15:17:30 CLSRSC-595: Executing upgrade step 1 of 12: 'UpgPrechecks'. 2024/12/12 15:17:36 CLSRSC-595: Executing upgrade step 2 of 12: 'GetOldConfig'. 2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 3 of 12: 'GenSiteGUIDs'. 2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 4 of 12: 'SetupOSD'. Redirecting to /bin/systemctl restart rsyslog.service 2024/12/12 15:17:41 CLSRSC-595: Executing upgrade step 5 of 12: 'PreUpgrade'. 2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 6 of 12: 'UpgradeAFD'. 2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 7 of 12: 'UpgradeOLR'. clscfg: EXISTING configuration version 0 detected. Creating OCR keys for user 'grid', privgrp 'oinstall'.. Operation successful. 2024/12/12 15:18:23 CLSRSC-595: Executing upgrade step 8 of 12: 'UpgradeOCR'. LOCAL ONLY MODE Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. CRS-4664: Node oragrid successfully pinned. 2024/12/12 15:18:27 CLSRSC-595: Executing upgrade step 9 of 12: 'CreateOHASD'. 2024/12/12 15:18:29 CLSRSC-595: Executing upgrade step 10 of 12: 'ConfigOHASD'. 2024/12/12 15:18:29 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service' 2024/12/12 15:18:48 CLSRSC-595: Executing upgrade step 11 of 12: 'UpgradeSIHA'.
oragrid 2024/12/12 15:19:45 /u01/app/grid/crsdata/oragrid/olr/backup_20241212_151945.olr 0
oragrid 2024/12/10 15:51:48 /u01/app/grid/crsdata/oragrid/olr/backup_20241210_155148.olr 724960844 2024/12/12 15:19:45 CLSRSC-595: Executing upgrade step 12 of 12: 'InstallACFS'. 2024/12/12 15:20:51 CLSRSC-327: Successfully configured Oracle Restart for a standalone server [root@oragrid ~]#
[grid@oragrid grid]$ crsctl query has releaseversion Oracle High Availability Services release version on the local node is [21.0.0.0.0] [grid@oragrid grid]$ crsctl query has softwareversion Oracle High Availability Services version on the local node is [21.0.0.0.0] [grid@oragrid grid]$
[grid@oragrid grid]$ $ORACLE_HOME/OPatch/opatch lspatches There are no Interim patches installed in this Oracle Home "/u01/app/21.3.0/grid".
OPatch succeeded. [grid@oragrid grid]$
====
[1]+ Done ./gridSetup.sh [grid@oragrid grid]$
[grid@oragrid grid]$ cluvfy stage -post hacfg This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.
Performing following verification checks ...
Oracle Restart Integrity ...PASSED OLR Integrity ...PASSED
Post-check for Oracle Restart configuration was successful.
CVU operation performed: stage -post hacfg Date: 12-Dec-2024 15:28:01 CVU home: /u01/app/21.3.0/grid Grid home: /u01/app/21.3.0/grid User: grid Operating system: Linux4.18.0-348.7.1.el8_5.x86_64 [grid@oragrid grid]$
|
Oracle GI and DB to 19c or downgrading to previous release (Doc ID 2539751.1)
Patches
to apply before upgrading Oracle GI and DB to 19c or downgrading to previous
release (Doc ID 2539751.1)
Oracle DBA
anuj blog Archive
- ► 2011 (362)