Tuesday, February 16, 2016

Oracle 12c pre-requirements for RHEL 7.2

Requirements:-
Software Requirements
Ø  Linux software version:- this changes based on your requirement. i used.
·         Red Hat Enterprise Linux Server release 7.2 (Maipo) with kernel level
               3.10.0-327.el7.x86_64 and runlevel “N 5”.

Ø  SSH version:-
·         OpenSSH_6.6.1p1, OpenSSL 1.0.1e-fips

Ø  Note: - there is no Unbreakable RHEL (see Vikas/unix admins for any questions).

Ø  Display setting:-
·         current 2560 x 1024, maximum 2560 x 1024

Ø  Packages required for RHEL 7.2 :-
·         binutils-2.23.52.0.1-55.el7.x86_64
·         compat-libcap1-1.10-7.el7.x86_64
·         compat-libstdc++-33-3.2.3-72.el7.x86_64
·         gcc-4.8.5-4.el7.x86_64
·         gcc-c++-4.8.5-4.el7.x86_64
·         glibc-2.17-106.el7_2.1.i686
·         glibc-2.17-106.el7_2.1.x86_64
·         glibc-devel-2.17-106.el7_2.1.i686
·         glibc-devel-2.17-106.el7_2.1.x86_64
·         ksh-20120801-22.el7_1.3.x86_64
·         libaio-0.3.109-13.el7.i686
·         libaio-0.3.109-13.el7.x86_64
·         libaio-devel-0.3.109-13.el7.i686
·         libaio-devel-0.3.109-13.el7.x86_64
·         libgcc-4.8.5-4.el7.i686
·         libgcc-4.8.5-4.el7.x86_64
·         libgcc-4.8.5-4.el7.i686
·         libstdc++-4.8.5-4.el7.x86_64
·         libstdc++-devel-4.8.5-4.el7.i686
·         libstdc++-devel-4.8.5-4.el7.x86_64
·         libXi-1.7.4-2.el7.i686
·         libXi-1.7.4-2.el7.x86_64
·         libXtst-1.2.2-2.1.el7.i686
·         libXtst-1.2.2-2.1.el7.x86_64
·         make-3.82-21.el7.x86_64
·         sysstat-10.1.5-7.el7.x86_64

Ø  Kernel setting requirements:- 

Below are the minimum recommended Kernel parameters settings required for database software installation. We can go with higher values too. Modify the Kernel setting in /etc/sysctl.conf as follows.

·         semmsl                               250
·         semmns                              32000
·         semopm                              100
·         semmni                               128
·         shmall                                  40 percent of the size of physical memory in pages
              Check: -           kernel.sem                          250 32000 100 128

Ø  Note: If you are planning to  support multiple databases on this server,  then set this parameter to a value that is equal/more to the total amount of shared memory, in 4K pages, that the system can use at one time.

·         Shmmax                               Half the size of physical memory in bytes (See My Oracle Support            Note 567506.1)   ...... make sure you set this parameter based on the memory_max_target you want to use. if you are planning multiple db's on this serverthen it should be set equal/more to sum of all memory_target of all db's.
·         shmmni                                4096
·         panic_on_oops                   1
·         filemax                                 6815744
·         aio-max-nr                          1048576

Ø  Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures.

·         ip_local_port_range           Minimum: 9000
                                                                                      Maximum: 65500
·         rmem_default                     262144
·         rmem_max                          4194304
·         wmem_default                   262144
·         wmem_max                        1048576
                      Note:-  make  sure /dev/shm is set if you want to use oracle’s AMM(automatic memory management). this should be almost equal/more to the memory you want to use while installing the oracle software with AMM option.


Ø    Set shell limits for oracle user

a                     Add following setting to /etc/security/limits.conf

·         oracle soft nproc                  2047
·         oracle hard nproc                 16384
·         oracle soft nofile                   1024
·         oracle hard nofile                  65536
·         oracle soft stack                    10240
·         oracle hard stack                   10240
·          
Ø  Verify the latest version of PAM is loaded, then add or edit the following line in the /etc/pam.d/login file, if it does not exist:
·         session required pam_limits.so
           
               JDK “open jdk version ‘1.8.0_65’” is installed with this release. 
               
             Ø  Make sure the firewall is set ….Make sure the FIREWALL D (OS process) to be turned off.

         Ø No ASM libraries are required as we are using ASM with Raw devices(no ASM lib concept). if you plan to use/manage disks under ASM then please install latest ASM libraries.

  note:- All reference used are from Oracle forums/oracle support....


Hope this Doc Helps...................

No comments:

Post a Comment

PostgreSql: Useful Commands-

 1)   ************************* Users ***************************  -- List of users with roles assigned: SELECT usename AS role_name,   CASE...