Search This Blog

Total Pageviews

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 ~]#




No comments:

Oracle DBA

anuj blog Archive