When installing Oracle 19c on redhate 8.6

team already fix the plan on OS, so we can't change now.

please offer suggestions on my steps if any 

sir, 

one thing is, should I do the same setting when we was for SUSE linux to redhate 8.6 ?

e.g.

#oracle limits setting 

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft nofile 2048

oracle hard nofile 65536

oracle soft stack 10240

oracle hard stack 32768

oracle soft memlock 3145728  (in KB)

oracle hard memlock 6291456   <<90% RAM(in KB)

redhat 8.6 too ?

FYI: if you run oracle-database-preinstall-19c, below are what Oracle will set for you with explanations:

# oracle-database-preinstall-19c setting for nofile soft limit is 1024
oracle   soft   nofile    1024

# oracle-database-preinstall-19c setting for nofile hard limit is 65536
oracle   hard   nofile    65536

# oracle-database-preinstall-19c setting for nproc soft limit is 16384
# refer orabug15971421 for more info.
oracle   soft   nproc    16384

# oracle-database-preinstall-19c setting for nproc hard limit is 16384
oracle   hard   nproc    16384

# oracle-database-preinstall-19c setting for stack soft limit is 10240KB
oracle   soft   stack    10240

# oracle-database-preinstall-19c setting for stack hard limit is 32768KB
oracle   hard   stack    32768

# oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
oracle   hard   memlock    134217728

# oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
oracle   soft   memlock    134217728

# oracle-database-preinstall-19c setting for data soft limit is 'unlimited'
oracle   soft   data    unlimited

# oracle-database-preinstall-19c setting for data hard limit is 'unlimited'
oracle   hard   data    unlimited

Select allOpen in new window

FYI: if you run oracle-database-preinstall-19c, below are what Oracle will set for you with explanations:

you mean those has been set for us and there is no need to set it /change again ? 

Yes, if you run Oracle pre-install rpm, it will create oracle user, set sysctl.conf, ulimits.conf, install required Linux packages. etc. 

In my practice, I do not directly use it. I use it in a test box (which have internal or external repo access) so that I can see what Oracle have been done to the settings, so that use them for a reference point to my build.

so if we do:

curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
 yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

then all that will be set and we don't have to do it again :

oracle   soft   nofile    1024 

oracle   hard   nofile    65536 

oracle   soft   nproc    16384 

oracle   hard   nproc    16384 

oracle   soft   stack    10240 

oracle   hard   stack    32768 

oracle   hard   memlock    134217728 

oracle   soft   memlock    134217728 

?

That is true. The pre-install RPM will prepare the system ready.

BTW, there is a version for Linux version 8

https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

To save space, below I will show a small portion of some of the settings done by pre-install

$ tail -3 /etc/sysctl.conf 
# oracle-database-preinstall-19c setting for net.ipv4.ip_local_port_range is 9000 65500
net.ipv4.ip_local_port_range = 9000 65500

$ tail -2 /etc/security/limits.d/oracle-database-preinstall-19c.conf 
# oracle-database-preinstall-19c setting for data hard limit is 'unlimited'
oracle   hard   data    unlimited

Select allOpen in new window

hi,

tks.

https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

so this one is for redhat 8.6 too ?

but if we install this one :

https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm 

on redhat 8.6 it is NOT going to be ok ?

I think it is fine.

There should be minor differences between ......-1.el7 vs .......-1.el8 or ......-2.e18 pre-install rpm

so it is either:

 # curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

OR 

# yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

right?

not both ?

I know, but what I meant is, 2 x command for me seems doing the same thing.

so I doubt run twice!

Pretty sure the localinstall means to install from a 'local' file though.  So, you need to get the rpm locally first.  That is what curl does............

yes!

Why would you want the el7 binaries on RHEL 8?

that;s why I say :

# yum -y localinstall https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm   

just one rpm 

Pretty sure it is still two steps:
1:  Download the rpm.
2:  Install it.

sure

 but just someone said we can DIRECTLY download the rpm via HTTP

If the db server do not have "internet" access, it is typically three steps

download the rpm package

upload the rpm package to the server

install the package

If the db server have "internet" access, it is typically two steps

download the rpm package 

install the package

The above two steps can be combined into one step (install while downloading) as posted previously 

yum install https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm 

Select allOpen in new window

what I get from source is, there is no rpm for OL8 . It is the same for OL7 and OL8 .

so finally it is :

# curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

#yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm 

You should use the EL8 one. See, for example, below for the differences EL7 vs EL8

[root@c8 ~]# ls -lrt oracle-database-preinstall-19c-1.0-*
-rwxr-x---. 1 root root 18204 Jan  4 08:17 oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
-rwxr-x---. 1 root root 31828 Jan  4 08:17 oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

[root@c8 ~]# md5sum oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
669cabae730b3e8487d09149ca921456  oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
[root@c8 ~]# md5sum oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
28e181a8703a605d712fd566a5ab9d36  oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

Select allOpen in new window

what I get from source is, there is no rpm for OL8 . It is the same for OL7 and OL8 .

so finally it is :

# curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
#yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm 

As mentioned before. On RHEL 8 (and equivalent distros ) you use EL8 packages not EL7.
The correct CURL command would look like this

curl -o oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm

Select allOpen in new window

Tested and it downloads the correct EL8 package.

Regards,

    Tomas Helgi 

As mentioned before. On RHEL 8 (and equivalent distros ) you use EL8 packages not EL7.
The correct CURL command would look like this

good but I received information that EL8 package does not exists.

but tks anwya.

ok tks.

I trust you all.