메뉴 건너뛰기

Korea Oracle User Group

Install/Configuration

12c R1 Install on Cent OS - Part 1 ( Preinstall )

Talros 2016.02.02 14:10 조회 수 : 526

1. Preinstall  Task

 

 1.1 OS 환경 확인

 

 오라클을 인스톨 하기 전에 현재 OS 의 버전 정보를 확인 합니다.

 

## OS 확인
[oracle@testora ~]$ cat /etc/redhat-release
CentOS release 6.7 (Final)
[oracle@testora ~]$ 

## 커널 확인
[oracle@testora ~]$ yum info installed kernel 
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: centos.mirror.cdnetworks.com
 * extras: centos.mirror.cdnetworks.com
 * updates: ftp.daumkakao.com
ol6_UEK_latest                                                                                                                                                                                  512/512
ol6_latest                                                                                                                                                                                  33094/33094
Installed Packages
Name        : kernel
Arch        : x86_64
Version     : 2.6.32
Release     : 573.el6
Size        : 126 M
Repo        : installed
From repo   : base
Summary     : The Linux kernel
URL         : http://www.kernel.org/
License     : GPLv2
Description : The kernel package contains the Linux kernel (vmlinuz), the core of any
            : Linux operating system.  The kernel handles the basic functions
            : of the operating system: memory allocation, process allocation, device
            : input and output, etc.

Name        : kernel
Arch        : x86_64
Version     : 2.6.32
Release     : 573.12.1.el6
Size        : 126 M
Repo        : installed
From repo   : updates
Summary     : The Linux kernel
URL         : http://www.kernel.org/
License     : GPLv2
Description : The kernel package contains the Linux kernel (vmlinuz), the core of any
            : Linux operating system.  The kernel handles the basic functions
            : of the operating system: memory allocation, process allocation, device
            : input and output, etc.

[oracle@testora ~]$ 

 

 1.2 Orachk 를 이용한 RPM 및 커널 설정 확인

 

  OS 에 필요한 환경 설정은 오라클 에서 제공 하는  orachk 라는 툴을 이용해 보겠습니다.

 

  orachk 에 대한 정보는 아래 오라클 블로그에서 확인이 가능 합니다.

  https://blogs.oracle.com/UPGRADE/entry/orachk_12_1_0_4

 

  최신 버전은 Document 1268927.2  이 문서에서 다운이 가능 합니다.

 

[oracle@testora orachk]$ ./orachk -a
This version of orachk was released on 05-Mar-2015 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report.


Do you want to continue running this version? [y/n][y]y
This computer is for [S]ingle instance database or part of a [C]luster to run RAC database [S|C] [C]:s
orachk did not find the inventory location on testora from environment.Does testora have Oracle software installed [y/n][n]?n         



Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

. . . . . . . . . 
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status                            
-------------------------------------------------------------------------------------------------------
Host Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name
-------------------------------------------------------------------------------------------------------
testora     No              No              No              No         No       No                 
-------------------------------------------------------------------------------------------------------


Copying plug-ins

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 

. . . . . . 


*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***


Collections and audit checks log file is 
/home/oracle/다운로드/orachk/orachk_testora_020116_175257/log/orachk.log



Checking for prompts in /home/oracle/.bash_profile on testora for oracle user...


=============================================================
                    Node name - testora                                
=============================================================

Collecting - CPU Information
Collecting - DiskMount Information
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - OS Packages
Collecting - Operating system release information and kernel version
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call





Data collections completed. Checking best practices on testora.
--------------------------------------------------------------------------------------


 INFO =>    Oracle Data Pump Best practices.
 WARNING => Linux Swap Configuration does NOT meet Recommendation
 WARNING => physical memory is not sufficient
 WARNING => free physical memory is not at sufficient level on system
 INFO =>    Important Storage Minimum Requirements for Grid & Database Homes
 WARNING => net.core.wmem_default Is NOT Configured According to Recommendation
 WARNING => net.core.wmem_max Is NOT Configured According to Recommendation
 WARNING => net.core.rmem_default Is NOT Configured According to Recommendation
 WARNING => net.core.rmem_max is not configured according to recommendation
 WARNING => The number of async IO descriptors is too low (/proc/sys/fs/aio-max-nr)
 WARNING => Kernel Parameter SEMOPM Is Lower Than The Recommended Value
 WARNING => Shell limit soft nproc for DB is NOT configured according to recommendation
 WARNING => Shell limit hard nofile for DB is NOT configured according to recommendation
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    umask for RDBMS owner is not set to 0022
 WARNING => Package libaio-devel-0.3.107-10.el6-i686 is recommended but NOT installed
 WARNING => Package compat-libstdc++-33-3.2.3-69.el6-x86_64 is recommended but NOT installed
 WARNING => Package gcc-c++-4.4.4-13.el6-x86_64 is recommended but NOT installed
 WARNING => Package libstdc++-devel-4.4.4-13.el6-x86_64 is recommended but NOT installed
 WARNING => Package ksh-20100621-12.el6-x86_64 is recommended but NOT installed
 WARNING => Package compat-libcap1-1.10-1-x86_64 is recommended but NOT installed
 WARNING => Package glibc-devel-2.12-1.7.el6-i686 is recommended but NOT installed
 WARNING => Package glibc-devel-2.12-1.7.el6-x86_64 is recommended but NOT installed
 WARNING => Package compat-libstdc++-33-3.2.3-69.el6-i686 is recommended but NOT installed
 WARNING => Package libaio-devel-0.3.107-10.el6-x86_64 is recommended but NOT installed
 WARNING => Package libstdc++-devel-4.4.4-13.el6-i686 is recommended but NOT installed
 WARNING => Package gcc-4.4.4-13.el6-x86_64 is recommended but NOT installed
 INFO =>    Consider increasing the COREDUMPSIZE size

---------------------------------------------------------------------------------
 
Detailed report (html) - /home/oracle/다운로드/orachk/orachk_testora_020116_175257/orachk_testora_020116_175257.html


UPLOAD(if required) - /home/oracle/다운로드/orachk/orachk_testora_020116_175257.zip

 

orachk 를 이용해 현재 필요한 패키지 정보와 커널 셋팅 값에 대한 정보를 확인할 수 있습니다.

 

더 자세한 정보를 확인 하려면 제일 하단에 표시된 html 파일을 열어보면 확인이 가능 합니다.

 

리포트 파일은 첨부로 올리니 참조 하시면 됩니다.

 

1.3  커널 설정 및 RPM 설치

 

 CentOS 는 레드헷 커널 기반 이기 때문에 오라클 리눅스의 패키지를 사용해서 관련 설정을 해보도록 하겠습니다.

 

  Oracle Preinstall 패키지는 Oracle UEK 커널 기반이여서 관련 커널을 설치가 진행 되면서 기존 커널에 문제가 발생 하여 다시

 Cent OS 용으로 설치를 진행 했습니다.

 

 - 커널 셋팅 정보

Parameter Value File
semmsl

semmns

semopm

semmni

250

32000

100

128

/proc/sys/kernel/sem
shmall 40 percent of the size of physical memory in pages

Note: If the server supports multiple databases, or uses a large SGA, then set this parameter to a value that is equal to the total amount of shared memory, in 4K pages, that the system can use at one time.

/proc/sys/kernel/shmall
shmmax Half the size of physical memory in bytes

See My Oracle Support Note 567506.1 for additional information about configuring shmmax.

/proc/sys/kernel/shmmax
shmmni 4096 /proc/sys/kernel/shmmni
panic_on_oops 1 /proc/sys/kernel/panic_on_oops
file-max 6815744 /proc/sys/fs/file-max
aio-max-nr 1048576

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

/proc/sys/fs/aio-max-nr
ip_local_port_range Minimum: 9000

Maximum: 65500

See Setting UDP and TCP Kernel Parameters Manually

/proc/sys/net/ipv4/ip_local_port_range
rmem_default 262144 /proc/sys/net/core/rmem_default
rmem_max 4194304 /proc/sys/net/core/rmem_max
wmem_default 262144 /proc/sys/net/core/wmem_default
wmem_max 1048576 /proc/sys/net/core/wmem_max

 

 - 필요한 패키지 정보

  

binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (i686)
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (i686)
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (i686)
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6 (i686)
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6 (i686)
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (i686)
libXext-1.1 (x86_64)
libXext-1.1 (i686)
libXtst-1.0.99.2 (x86_64)
libXtst-1.0.99.2 (i686)
libX11-1.3 (x86_64)
libX11-1.3 (i686)
libXau-1.0.5 (x86_64)
libXau-1.0.5 (i686)
libxcb-1.5 (x86_64)
libxcb-1.5 (i686)
libXi-1.3 (x86_64)
libXi-1.3 (i686)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)

 

  1.3.1 Linux Kernel setting

 

oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    2047
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768
"/etc/security/limits.conf" 57L, 2022C written


#Oracl kernel parameter setting
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
~
"/etc/sysctl.conf" 47L, 1313C written

 

 

  1.3.2 Install Oracle preinstall package

 

# yum 에서 패키지 확인
[root@testora yum.repos.d]# yum list |grep oracle
kmod-oracleasm.x86_64                 2.0.8-6.el6_7            ol6_latest       
oracle-logos.noarch                   60.0.14-1.0.2.el6        ol6_latest       
oracle-rdbms-server-11gR2-preinstall.x86_64
oracle-rdbms-server-12cR1-preinstall.x86_64
oracleasm-support.x86_64              2.1.8-1.el6              ol6_latest       
oraclelinux-release.x86_64            6:6Server-7.0.6          ol6_latest       
oraclelinux-release-notes.x86_64      6Server-16.el6           ol6_latest       
[root@testora yum.repos.d]# 

# 패키지 인스톨
[root@testora yum.repos.d]# yum install oracle-rdbms-server-12cR1-preinstall.x86_64
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.mirror.cdnetworks.com
 * extras: centos.mirror.cdnetworks.com
 * updates: ftp.daumkakao.com
Resolving Dependencies
--> Running transaction check
---> Package oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-14.el6 will be installed
--> Processing Dependency: gcc for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Processing Dependency: kernel-uek for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Processing Dependency: ksh for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Processing Dependency: libaio-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Processing Dependency: glibc-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Processing Dependency: libstdc++-devel for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Processing Dependency: nfs-utils for package: oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64
--> Running transaction check
---> Package compat-libcap1.x86_64 0:1.10-1 will be installed
---> Package compat-libstdc++-33.x86_64 0:3.2.3-69.el6 will be installed
---> Package gcc.x86_64 0:4.4.7-16.el6 will be installed
--> Processing Dependency: libgomp = 4.4.7-16.el6 for package: gcc-4.4.7-16.el6.x86_64
--> Processing Dependency: cpp = 4.4.7-16.el6 for package: gcc-4.4.7-16.el6.x86_64
--> Processing Dependency: cloog-ppl >= 0.15 for package: gcc-4.4.7-16.el6.x86_64
--> Processing Dependency: libgomp.so.1()(64bit) for package: gcc-4.4.7-16.el6.x86_64
---> Package gcc-c++.x86_64 0:4.4.7-16.el6 will be installed
--> Processing Dependency: libmpfr.so.1()(64bit) for package: gcc-c++-4.4.7-16.el6.x86_64
---> Package glibc-devel.x86_64 0:2.12-1.166.el6_7.3 will be installed
--> Processing Dependency: glibc-headers = 2.12-1.166.el6_7.3 for package: glibc-devel-2.12-1.166.el6_7.3.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.12-1.166.el6_7.3.x86_64
---> Package kernel-uek.x86_64 0:2.6.39-400.264.13.el6uek will be installed
--> Processing Dependency: kernel-uek-firmware = 2.6.39-400.264.13.el6uek for package: kernel-uek-2.6.39-400.264.13.el6uek.x86_64
---> Package ksh.x86_64 0:20120801-28.el6_7.3 will be installed
---> Package libaio-devel.x86_64 0:0.3.107-10.el6 will be installed
---> Package libstdc++-devel.x86_64 0:4.4.7-16.el6 will be installed
---> Package nfs-utils.x86_64 1:1.2.3-64.el6 will be installed
--> Processing Dependency: nfs-utils-lib >= 1.1.0-3 for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: keyutils >= 1.4-4 for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: rpcbind for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: python-argparse for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: libtirpc for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: libgssglue.so.1(libgssapi_CITI_2)(64bit) for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: libgssglue for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: libevent for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: libtirpc.so.1()(64bit) for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: libnfsidmap.so.0()(64bit) for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: libgssglue.so.1()(64bit) for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Processing Dependency: libevent-1.4.so.2()(64bit) for package: 1:nfs-utils-1.2.3-64.el6.x86_64
--> Running transaction check
---> Package cloog-ppl.x86_64 0:0.15.7-1.2.el6 will be installed
--> Processing Dependency: libppl_c.so.2()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64
--> Processing Dependency: libppl.so.7()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64
---> Package cpp.x86_64 0:4.4.7-16.el6 will be installed
---> Package glibc-headers.x86_64 0:2.12-1.166.el6_7.3 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.12-1.166.el6_7.3.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.12-1.166.el6_7.3.x86_64
---> Package kernel-uek-firmware.noarch 0:2.6.39-400.264.13.el6uek will be installed
---> Package keyutils.x86_64 0:1.4-5.el6 will be installed
---> Package libevent.x86_64 0:1.4.13-4.el6 will be installed
---> Package libgomp.x86_64 0:4.4.7-16.el6 will be installed
---> Package libgssglue.x86_64 0:0.1-11.el6 will be installed
---> Package libtirpc.x86_64 0:0.2.1-10.el6 will be installed
---> Package mpfr.x86_64 0:2.4.1-6.el6 will be installed
---> Package nfs-utils-lib.x86_64 0:1.1.5-11.el6 will be installed
---> Package python-argparse.noarch 0:1.2.1-2.1.el6 will be installed
---> Package rpcbind.x86_64 0:0.2.0-11.el6_7 will be installed
--> Running transaction check
---> Package kernel-headers.x86_64 0:2.6.32-573.12.1.el6 will be installed
---> Package ppl.x86_64 0:0.10.2-11.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================================================
 Package                                                         Arch                              Version                                              Repository                                 Size
========================================================================================================================================================================================================
Installing:
 oracle-rdbms-server-12cR1-preinstall                            x86_64                            1.0-14.el6                                           ol6_latest                                 17 k
Installing for dependencies:
 cloog-ppl                                                       x86_64                            0.15.7-1.2.el6                                       base                                       93 k
 compat-libcap1                                                  x86_64                            1.10-1                                               base                                       17 k
 compat-libstdc++-33                                             x86_64                            3.2.3-69.el6                                         base                                      183 k
 cpp                                                             x86_64                            4.4.7-16.el6                                         base                                      3.7 M
 gcc                                                             x86_64                            4.4.7-16.el6                                         base                                       10 M
 gcc-c++                                                         x86_64                            4.4.7-16.el6                                         base                                      4.7 M
 glibc-devel                                                     x86_64                            2.12-1.166.el6_7.3                                   ol6_latest                                985 k
 glibc-headers                                                   x86_64                            2.12-1.166.el6_7.3                                   ol6_latest                                614 k
 kernel-headers                                                  x86_64                            2.6.32-573.12.1.el6                                  ol6_latest                                3.9 M
 kernel-uek                                                      x86_64                            2.6.39-400.264.13.el6uek                             ol6_UEK_latest                             28 M
 kernel-uek-firmware                                             noarch                            2.6.39-400.264.13.el6uek                             ol6_UEK_latest                            3.7 M
 keyutils                                                        x86_64                            1.4-5.el6                                            base                                       39 k
 ksh                                                             x86_64                            20120801-28.el6_7.3                                  ol6_latest                                760 k
 libaio-devel                                                    x86_64                            0.3.107-10.el6                                       base                                       13 k
 libevent                                                        x86_64                            1.4.13-4.el6                                         base                                       66 k
 libgomp                                                         x86_64                            4.4.7-16.el6                                         base                                      134 k
 libgssglue                                                      x86_64                            0.1-11.el6                                           base                                       23 k
 libstdc++-devel                                                 x86_64                            4.4.7-16.el6                                         base                                      1.6 M
 libtirpc                                                        x86_64                            0.2.1-10.el6                                         base                                       79 k
 mpfr                                                            x86_64                            2.4.1-6.el6                                          base                                      157 k
 nfs-utils                                                       x86_64                            1:1.2.3-64.el6                                       base                                      331 k
 nfs-utils-lib                                                   x86_64                            1.1.5-11.el6                                         base                                       68 k
 ppl                                                             x86_64                            0.10.2-11.el6                                        base                                      1.3 M
 python-argparse                                                 noarch                            1.2.1-2.1.el6                                        base                                       48 k
 rpcbind                                                         x86_64                            0.2.0-11.el6_7                                       ol6_latest                                 51 k

Transaction Summary
========================================================================================================================================================================================================
Install      26 Package(s)

Total download size: 61 M
Installed size: 183 M
Is this ok [y/N]: y
Downloading Packages:
(1/26): cloog-ppl-0.15.7-1.2.el6.x86_64.rpm                                                                                                                                      |  93 kB     00:00     
(2/26): compat-libcap1-1.10-1.x86_64.rpm                                                                                                                                         |  17 kB     00:00     
(3/26): compat-libstdc++-33-3.2.3-69.el6.x86_64.rpm                                                                                                                              | 183 kB     00:00     
(4/26): cpp-4.4.7-16.el6.x86_64.rpm                                                                                                                                              | 3.7 MB     00:00     
(5/26): gcc-4.4.7-16.el6.x86_64.rpm                                                                                                                                              |  10 MB     00:01     
(6/26): gcc-c++-4.4.7-16.el6.x86_64.rpm                                                                                                                                          | 4.7 MB     00:00     
(7/26): glibc-devel-2.12-1.166.el6_7.3.x86_64.rpm                                                                                                                                | 985 kB     00:01     
(8/26): glibc-headers-2.12-1.166.el6_7.3.x86_64.rpm                                                                                                                              | 614 kB     00:00     
(9/26): kernel-headers-2.6.32-573.12.1.el6.x86_64.rpm                                                                                                                            | 3.9 MB     00:02     
(10/26): kernel-uek-2.6.39-400.264.13.el6uek.x86_64.rpm                                                                                                                          |  28 MB     00:23     
(11/26): kernel-uek-firmware-2.6.39-400.264.13.el6uek.noarch.rpm                                                                                                                 | 3.7 MB     00:03     
(12/26): keyutils-1.4-5.el6.x86_64.rpm                                                                                                                                           |  39 kB     00:00     
(13/26): ksh-20120801-28.el6_7.3.x86_64.rpm                                                                                                                                      | 760 kB     00:00     
(14/26): libaio-devel-0.3.107-10.el6.x86_64.rpm                                                                                                                                  |  13 kB     00:00     
(15/26): libevent-1.4.13-4.el6.x86_64.rpm                                                                                                                                        |  66 kB     00:00     
(16/26): libgomp-4.4.7-16.el6.x86_64.rpm                                                                                                                                         | 134 kB     00:00     
(17/26): libgssglue-0.1-11.el6.x86_64.rpm                                                                                                                                        |  23 kB     00:00     
(18/26): libstdc++-devel-4.4.7-16.el6.x86_64.rpm                                                                                                                                 | 1.6 MB     00:00     
(19/26): libtirpc-0.2.1-10.el6.x86_64.rpm                                                                                                                                        |  79 kB     00:00     
(20/26): mpfr-2.4.1-6.el6.x86_64.rpm                                                                                                                                             | 157 kB     00:00     
(21/26): nfs-utils-1.2.3-64.el6.x86_64.rpm                                                                                                                                       | 331 kB     00:00     
(22/26): nfs-utils-lib-1.1.5-11.el6.x86_64.rpm                                                                                                                                   |  68 kB     00:00     
(23/26): oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64.rpm                                                                                                              |  17 kB     00:00     
(24/26): ppl-0.10.2-11.el6.x86_64.rpm                                                                                                                                            | 1.3 MB     00:00     
(25/26): python-argparse-1.2.1-2.1.el6.noarch.rpm                                                                                                                                |  48 kB     00:00     
(26/26): rpcbind-0.2.0-11.el6_7.x86_64.rpm                                                                                                                                       |  51 kB     00:00     
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                   1.5 MB/s |  61 MB     00:40     
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Importing GPG key 0xEC551F03:
 Userid: "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
 From  : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libgssglue-0.1-11.el6.x86_64                                                                                                                                                        1/26 
  Installing : libtirpc-0.2.1-10.el6.x86_64                                                                                                                                                        2/26 
  Installing : libstdc++-devel-4.4.7-16.el6.x86_64                                                                                                                                                 3/26 
  Installing : mpfr-2.4.1-6.el6.x86_64                                                                                                                                                             4/26 
  Installing : cpp-4.4.7-16.el6.x86_64                                                                                                                                                             5/26 
  Installing : rpcbind-0.2.0-11.el6_7.x86_64                                                                                                                                                       6/26 
  Installing : python-argparse-1.2.1-2.1.el6.noarch                                                                                                                                                7/26 
  Installing : ppl-0.10.2-11.el6.x86_64                                                                                                                                                            8/26 
  Installing : cloog-ppl-0.15.7-1.2.el6.x86_64                                                                                                                                                     9/26 
  Installing : keyutils-1.4-5.el6.x86_64                                                                                                                                                          10/26 
  Installing : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                                                                                            11/26 
  Installing : libevent-1.4.13-4.el6.x86_64                                                                                                                                                       12/26 
  Installing : nfs-utils-lib-1.1.5-11.el6.x86_64                                                                                                                                                  13/26 
  Installing : 1:nfs-utils-1.2.3-64.el6.x86_64                                                                                                                                                    14/26 
  Installing : ksh-20120801-28.el6_7.3.x86_64                                                                                                                                                     15/26 
  Installing : compat-libcap1-1.10-1.x86_64                                                                                                                                                       16/26 
  Installing : kernel-uek-firmware-2.6.39-400.264.13.el6uek.noarch                                                                                                                                17/26 
  Installing : kernel-uek-2.6.39-400.264.13.el6uek.x86_64                                                                                                                                         18/26 
  Installing : kernel-headers-2.6.32-573.12.1.el6.x86_64                                                                                                                                          19/26 
  Installing : glibc-headers-2.12-1.166.el6_7.3.x86_64                                                                                                                                            20/26 
  Installing : glibc-devel-2.12-1.166.el6_7.3.x86_64                                                                                                                                              21/26 
  Installing : libaio-devel-0.3.107-10.el6.x86_64                                                                                                                                                 22/26 
  Installing : libgomp-4.4.7-16.el6.x86_64                                                                                                                                                        23/26 
  Installing : gcc-4.4.7-16.el6.x86_64                                                                                                                                                            24/26 
  Installing : gcc-c++-4.4.7-16.el6.x86_64                                                                                                                                                        25/26 
  Installing : oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64                                                                                                                             26/26 

gzip: stdout: No space left on device
E: dracut: creation of /boot/initramfs-2.6.39-400.264.13.el6uek.x86_64.img failed
mkinitrd failed
warning: %posttrans(kernel-uek-2.6.39-400.264.13.el6uek.x86_64) scriptlet failed, exit status 1
Non-fatal POSTTRANS scriptlet failure in rpm package kernel-uek-2.6.39-400.264.13.el6uek.x86_64
  Verifying  : libgomp-4.4.7-16.el6.x86_64                                                                                                                                                         1/26 
  Verifying  : gcc-c++-4.4.7-16.el6.x86_64                                                                                                                                                         2/26 
  Verifying  : libaio-devel-0.3.107-10.el6.x86_64                                                                                                                                                  3/26 
  Verifying  : kernel-headers-2.6.32-573.12.1.el6.x86_64                                                                                                                                           4/26 
  Verifying  : kernel-uek-2.6.39-400.264.13.el6uek.x86_64                                                                                                                                          5/26 
  Verifying  : kernel-uek-firmware-2.6.39-400.264.13.el6uek.noarch                                                                                                                                 6/26 
  Verifying  : compat-libcap1-1.10-1.x86_64                                                                                                                                                        7/26 
  Verifying  : ksh-20120801-28.el6_7.3.x86_64                                                                                                                                                      8/26 
  Verifying  : libevent-1.4.13-4.el6.x86_64                                                                                                                                                        9/26 
  Verifying  : nfs-utils-lib-1.1.5-11.el6.x86_64                                                                                                                                                  10/26 
  Verifying  : mpfr-2.4.1-6.el6.x86_64                                                                                                                                                            11/26 
  Verifying  : compat-libstdc++-33-3.2.3-69.el6.x86_64                                                                                                                                            12/26 
  Verifying  : cpp-4.4.7-16.el6.x86_64                                                                                                                                                            13/26 
  Verifying  : cloog-ppl-0.15.7-1.2.el6.x86_64                                                                                                                                                    14/26 
  Verifying  : gcc-4.4.7-16.el6.x86_64                                                                                                                                                            15/26 
  Verifying  : keyutils-1.4-5.el6.x86_64                                                                                                                                                          16/26 
  Verifying  : 1:nfs-utils-1.2.3-64.el6.x86_64                                                                                                                                                    17/26 
  Verifying  : oracle-rdbms-server-12cR1-preinstall-1.0-14.el6.x86_64                                                                                                                             18/26 
  Verifying  : libstdc++-devel-4.4.7-16.el6.x86_64                                                                                                                                                19/26 
  Verifying  : ppl-0.10.2-11.el6.x86_64                                                                                                                                                           20/26 
  Verifying  : python-argparse-1.2.1-2.1.el6.noarch                                                                                                                                               21/26 
  Verifying  : glibc-devel-2.12-1.166.el6_7.3.x86_64                                                                                                                                              22/26 
  Verifying  : rpcbind-0.2.0-11.el6_7.x86_64                                                                                                                                                      23/26 
  Verifying  : glibc-headers-2.12-1.166.el6_7.3.x86_64                                                                                                                                            24/26 
  Verifying  : libtirpc-0.2.1-10.el6.x86_64                                                                                                                                                       25/26 
  Verifying  : libgssglue-0.1-11.el6.x86_64                                                                                                                                                       26/26 

Installed:
  oracle-rdbms-server-12cR1-preinstall.x86_64 0:1.0-14.el6                                                                                                                                              

Dependency Installed:
  cloog-ppl.x86_64 0:0.15.7-1.2.el6              compat-libcap1.x86_64 0:1.10-1                  compat-libstdc++-33.x86_64 0:3.2.3-69.el6                cpp.x86_64 0:4.4.7-16.el6                   
  gcc.x86_64 0:4.4.7-16.el6                      gcc-c++.x86_64 0:4.4.7-16.el6                   glibc-devel.x86_64 0:2.12-1.166.el6_7.3                  glibc-headers.x86_64 0:2.12-1.166.el6_7.3   
  kernel-headers.x86_64 0:2.6.32-573.12.1.el6    kernel-uek.x86_64 0:2.6.39-400.264.13.el6uek    kernel-uek-firmware.noarch 0:2.6.39-400.264.13.el6uek    keyutils.x86_64 0:1.4-5.el6                 
  ksh.x86_64 0:20120801-28.el6_7.3               libaio-devel.x86_64 0:0.3.107-10.el6            libevent.x86_64 0:1.4.13-4.el6                           libgomp.x86_64 0:4.4.7-16.el6               
  libgssglue.x86_64 0:0.1-11.el6                 libstdc++-devel.x86_64 0:4.4.7-16.el6           libtirpc.x86_64 0:0.2.1-10.el6                           mpfr.x86_64 0:2.4.1-6.el6                   
  nfs-utils.x86_64 1:1.2.3-64.el6                nfs-utils-lib.x86_64 0:1.1.5-11.el6             ppl.x86_64 0:0.10.2-11.el6                               python-argparse.noarch 0:1.2.1-2.1.el6      
  rpcbind.x86_64 0:0.2.0-11.el6_7               

Complete!
[root@testora yum.repos.d]# 

# 추가로 오라클 ASM 설치를 위해 드리이버도 설치 했습니다.
[root@testora yum.repos.d]# yum install oracleasm-support.x86_64
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.mirror.cdnetworks.com
 * extras: centos.mirror.cdnetworks.com
 * updates: ftp.daumkakao.com
Resolving Dependencies
--> Running transaction check
---> Package oracleasm-support.x86_64 0:2.1.8-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================================================
 Package                                               Arch                                       Version                                          Repository                                      Size
========================================================================================================================================================================================================
Installing:
 oracleasm-support                                     x86_64                                     2.1.8-1.el6                                      ol6_latest                                      73 k

Transaction Summary
========================================================================================================================================================================================================
Install       1 Package(s)

Total download size: 73 k
Installed size: 216 k
Is this ok [y/N]: y
Downloading Packages:
oracleasm-support-2.1.8-1.el6.x86_64.rpm                                                                                                                                         |  73 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : oracleasm-support-2.1.8-1.el6.x86_64                                                                                                                                                 1/1 
  Verifying  : oracleasm-support-2.1.8-1.el6.x86_64                                                                                                                                                 1/1 

Installed:
  oracleasm-support.x86_64 0:2.1.8-1.el6                                                                                                                                                                

Complete!
[root@testora yum.repos.d]#

 

 1.3.3 설정 다시 체크

 

[oracle@testora orachk]$ ./orachk -a
This version of orachk was released on 05-Mar-2015 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report.


Do you want to continue running this version? [y/n][y]y
This computer is for [S]ingle instance database or part of a [C]luster to run RAC database [S|C] [C]:S
orachk did not find the inventory location on testora from environment.Does testora have Oracle software installed [y/n][n]?n    



Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

. . . . . . . . . 
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status                            
-------------------------------------------------------------------------------------------------------
Host Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name
-------------------------------------------------------------------------------------------------------
testora     No              No              No              No         No       No                 
-------------------------------------------------------------------------------------------------------


Copying plug-ins

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 

. . . . . . 


*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***


Collections and audit checks log file is 
/home/oracle/다운로드/orachk/orachk_testora_020216_132336/log/orachk.log



Checking for prompts in /home/oracle/.bash_profile on testora for oracle user...


=============================================================
                    Node name - testora                                
=============================================================

Collecting - CPU Information
Collecting - DiskMount Information
Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - Memory Information
Collecting - OS Packages
Collecting - Operating system release information and kernel version
Collecting - Table of file system defaults
Collecting - number of semaphore operations per semop system call





Data collections completed. Checking best practices on testora.
--------------------------------------------------------------------------------------


 INFO =>    Oracle Data Pump Best practices.
 WARNING => Linux Swap Configuration does NOT meet Recommendation
 WARNING => physical memory is not sufficient
 INFO =>    Important Storage Minimum Requirements for Grid & Database Homes
 WARNING => Shell limit soft nproc for DB is NOT configured according to recommendation
 WARNING => Shell limit hard nofile for DB is NOT configured according to recommendation
 WARNING => OSWatcher is not running as is recommended.
 INFO =>    umask for RDBMS owner is not set to 0022
 INFO =>    Consider increasing the COREDUMPSIZE size

---------------------------------------------------------------------------------
 
Detailed report (html) - /home/oracle/다운로드/orachk/orachk_testora_020216_132336/orachk_testora_020216_132336.html


UPLOAD(if required) - /home/oracle/다운로드/orachk/orachk_testora_020216_132336.zip

 


 

 1.3.4  빠진 부분 직접 설정 변경

 

 

root@testora ~]# vi /etc/security/limits.conf

# /etc/security/limits.conf
#
#Each line describes a limit for a user in the form:
#
#<domain>        <type>  <item>  <value>
#
#Where:
#<domain> can be:
#        - a user name
#        - a group name, with @group syntax
#        - the wildcard *, for default entry
#        - the wildcard %, can be also used with %group syntax,
#                 for maxlogin limit
#
#<type> can have the two values:
#        - "soft" for enforcing the soft limits
#        - "hard" for enforcing hard limits
#
#<item> can be one of the following:
#        - core - limits the core file size (KB)
#        - data - max data size (KB)
#        - fsize - maximum filesize (KB)
#        - memlock - max locked-in-memory address space (KB)
#        - nofile - max number of open file descriptors
#        - rss - max resident set size (KB)
#        - stack - max stack size (KB)
#        - cpu - max CPU time (MIN)
#        - nproc - max number of processes
#        - as - address space limit (KB)
#        - maxlogins - max number of logins for this user
#        - maxsyslogins - max number of logins on the system
#        - priority - the priority to run user process with
#        - locks - max number of file locks the user can hold
#        - sigpending - max number of pending signals
#        - msgqueue - max memory used by POSIX message queues (bytes)
#        - nice - max nice priority allowed to raise to values: [-20, 19]
#        - rtprio - max realtime priority
#
#<domain>      <type>  <item>         <value>
#

#*               soft    core            0
#*               hard    rss             10000
#@student        hard    nproc           20
#@faculty        soft    nproc           20
#@faculty        hard    nproc           50
#ftp             hard    nproc           0
#@student        -       maxlogins       4

oracle hard nofile 4096
oracle soft nproc 1024

"/etc/security/limits.conf" 54L, 1884C written


## insert profile in umask value

umask 022
 

 

 

위로