Disclaimer

Monday 9 August 2021

Oracle 19c RAC Installation know issues

1) Create Users and FS groups

 

Only half groups will be installed with this package dnf install oracle-database-preinstall-19c package.

 

Note: dnf package will install all rpms related to GRID and ORACLE installation but it also create some groups so you need to modify group as per below

 

Acutal GRID : Create below groups for GRID

 

[root@node1 ~]# groupadd -g 54329 asmadmin

[root@node1 ~]# groupadd -g 54328 asmoper

 

 

[root@node1 disks]# id grid

uid=54331(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54330(racdba),54327(asmdba),54329(asmadmin),54328(asmoper)

                                                                                                                  

[root@node1 ~]# usermod -u 54331 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid

 

Actual ORACLE:-

[root@node1 disks]# id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba)

 

[root@node1 ~]# usermod -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,racdba oracle

 

[root@node1 ~]# id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba)

 

 

 

Group Details:

# groupadd -g 54421 oinstall

# groupadd -g 54322 dba

# groupadd -g 54323 oper

# groupadd -g 54324 backupdba

# groupadd -g 54325 dgdba

# groupadd -g 54326 kmdba

# groupadd -g 54327 asmdba

# groupadd -g 54328 asmoper

# groupadd -g 54329 asmadmin

# groupadd -g 54330 racdba



   2) Time Sync on RAC  servers

Note:

Oracle Linux - 7 , we can use NTP

If Oracle Linux - 8 , NTP is deprecated and chronyd service needs to be used.

 

If you Oracle 19.3.0.0 (default) Grid Software doesn't support so you need to apply patch (19.10 or 19.11) so you can enable chronyd for time sync on both nodes otherwise you will have to depend on CTSSD.

 

-If you disable chronyd service then CTSSD will be in ACTIVE state

-If you enable chronyd service then CTSSD will be in OBSERVER state.

 


3)  Kmod package issue :

Note: You need to install kmod package before installing ASM otherwise you will get below error

[root@node1 ~]# oracleasm init

Creating /dev/oracleasm mount point: /dev/oracleasm

Loading module "oracleasm": oracleasm

Configuring "oracleasm" to use device logical block size

Mounting ASMlib driver filesystem: failed

Unable to fix ASM driver permissions

 

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=453890984027661&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2603034.1&_afrWindowMode=0&_adf.ctrl-state=aszlzpmy0_151

 

 

[root@node1 ~]# yum install kmod-oracleasm



4)  Error during installation 


NS-08101 Unexpected error while executing the action at state: ‘supportedOSCheck’






Note :- Enable CV_ASSUME_DISTID parameter value as per your OS version for GRID HOME and ORACLE HOME

node1$] cd /applications/oracle/d19.3.0/oracle_home/cv/admin

Solution (Permanent):

 

Edit the cvu_config file under $ORACLE_HOME/cv/admin and change the below line:

from

# Fallback to this distribution id

#CV_ASSUME_DISTID=OEL5

to

# Fallback to this distribution id

CV_ASSUME_DISTID=OEL8

 

 

5)  RPM Package Manager Database




Note: RUN THIS BELOW COMMAND AS GRID AND PROVIDE THE ROOT PASSWORD TO FIX THE ABOVE ISSUE

  

[grid@node1 bin]$ ./cluvfy stage -pre crsinst -n node1,node1 -method root

 

 

To overcome on above error, kindly give ROOT password 







6)  Error at SSH



INS-06006 GI RunInstaller Fails If OpenSSH Is Upgraded to 8.x (Doc ID 2555697.1)

 

[root@node1 bin]# mv /usr/bin/scp /usr/bin/scp.orig

 

[root@node1 bin]# ls -lrt *scp*
-rwxr-xr-x. 1 root root  77408 Apr  1  2019 escputil
-rwxr-xr-x. 1 root root     90 May 11  2019 scp-dbus-service
-rwxr-xr-x. 1 root root 105440 Jul 31  2020 scp.orig
-rwxr-xr-x. 1 root root  79616 Aug  9  2020 lscpu
[root@node1 bin]#
[root@node1 bin]# vi /usr/bin/scp
[root@node1 bin]# ls -lrt *scp*
-rwxr-xr-x. 1 root root  77408 Apr  1  2019 escputil
-rwxr-xr-x. 1 root root     90 May 11  2019 scp-dbus-service
-rwxr-xr-x. 1 root root 105440 Jul 31  2020 scp.orig
-rwxr-xr-x. 1 root root  79616 Aug  9  2020 lscpu
-rw-r--r--. 1 root root     24 Jul 12 17:05 scp
[root@node1 bin]#
[root@node1 bin]# chmod 555 /usr/bin/scp
[root@node1 bin]# ls -lrt *scp*
-rwxr-xr-x. 1 root root  77408 Apr  1  2019 escputil
-rwxr-xr-x. 1 root root     90 May 11  2019 scp-dbus-service
-rwxr-xr-x. 1 root root 105440 Jul 31  2020 scp.orig
-rwxr-xr-x. 1 root root  79616 Aug  9  2020 lscpu
-r-xr-xr-x. 1 root root     24 Jul 12 17:05 scp

 



Oracle Update: -

 

# Rename the original scp.

mv /usr/bin/scp /usr/bin/scp.orig   -- done

 

Note: You need to mv with scp.orig only otherwise you will not able to resolve the issue 😉

 

# Create a new file </usr/bin/scp>.

vi /usr/bin/scp

 

# Add the below line to the new created file </usr/bin/scp>.

/usr/bin/scp.orig -T $*

 

# Change the file permission.

chmod 555 /usr/bin/scp

 

After installation:

 

mv /usr/bin/scp.orig /usr/bin/scp








No comments:

Post a Comment

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...