오라클을 인스톨 하기 전에 현재 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 파일을 열어보면 확인이 가능 합니다.
리포트 파일은 첨부로 올리니 참조 하시면 됩니다.
CentOS 는 레드헷 커널 기반 이기 때문에 오라클 리눅스의 패키지를 사용해서 관련 설정을 해보도록 하겠습니다.
Oracle Preinstall 패키지는 Oracle UEK 커널 기반이여서 관련 커널을 설치가 진행 되면서 기존 커널에 문제가 발생 하여 다시
Cent OS 용으로 설치를 진행 했습니다.
- 커널 셋팅 정보
| Parameter | Value | File |
|---|---|---|
semmsl
|
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 |
/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 |
/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
