오라클 설치 tag - Voyager of Linux

Oracle 11gR2 설치 Silent Installation 방식이며 OFA(Optimal Flexible Architecture) 를 따른다. 환경 CentOS 6.8 64bit Memory 4GB Swap 8GB (Swap must be enabled double the size of RAM) Storage Size 50GB 호스트네임 변경

]# vi /etc/sysconfig/network
HOSTNAME=oraserv1.systemv.pe.kr
]# vi /etc/hosts
192.168.96.42		oraserv1.systemv.pe.kr		oraserv1
]# /etc/init.d/network restart

]# vi /etc/sysconfig/network

HOSTNAME=oraserv1.systemv.pe.kr

]# vi /etc/hosts

192.168.96.42 oraserv1.systemv.pe.kr oraserv1

]# /etc/init.d/network restart

Selinux 설정 변경

]# vi /etc/selinux/config
SELINUX=disable

1 2	]# vi /etc/selinux/config SELINUX=disable

Kernel 3.10 설치

]# rpm --import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org
]# rpm -Uvh http://www.elrepo.org/elrepo-release-6-6.el6.elrepo.noarch.rpm
]# sed -i "s/enabled=1/enabled=0/g" /etc/yum.repos.d/elrepo.repo
]# yum --enablerepo=elrepo-kernel install kernel-lt
]# sed -i "s/default=1/default=0/g" /boot/grub/grub.conf

]# rpm --import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org

]# rpm -Uvh http://www.elrepo.org/elrepo-release-6-6.el6.elrepo.noarch.rpm

]# sed -i "s/enabled=1/enabled=0/g" /etc/yum.repos.d/elrepo.repo

]# yum --enablerepo=elrepo-kernel install kernel-lt

]# sed -i "s/default=1/default=0/g" /boot/grub/grub.conf

설치 완료하고 나서 reboot. 계정생성

groupadd -g 500 oinstall
groupadd -g 501 dba
groupadd -g 502 oper

useradd -u 500 -g oinstall -G dba,oper oracle

groupadd -g 500 oinstall

groupadd -g 501 dba

groupadd -g 502 oper

useradd -u 500 -g oinstall -G dba,oper oracle

의존성 패키지 설치

]# yum install compat-libstdc++-33.x86_64 elfutils-libelf-devel.x86_64 elfutils-libelf-devel-static.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc-devel.x86_64 ksh.x86_64 libaio-devel.i686 libaio-devel.x86_64 libgomp.x86_64 libstdc++-devel.x86_64 sysstat.x86_64 unzip unixODBC.i686 unixODBC-devel.i686 unixODBC.x86_64 unixODBC-devel.x86_64
]# yum remove ksh
]# wget ftp://ftp.pbone.net/mirror/www.whiteboxlinux.org/whitebox/4/en/os/x86_64/WhiteBox/RPMS/pdksh-5.2.14-30.x86_64.rpm
]# yum localinstall pdksh-5.2.14-30.x86_64.rpm

]# yum install compat-libstdc++-33.x86_64 elfutils-libelf-devel.x86_64 elfutils-libelf-devel-static.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc-devel.x86_64 ksh.x86_64 libaio-devel.i686 libaio-devel.x86_64 libgomp.x86_64 libstdc++-devel.x86_64 sysstat.x86_64 unzip unixODBC.i686 unixODBC-devel.i686 unixODBC.x86_64 unixODBC-devel.x86_64

]# yum remove ksh

]# wget ftp://ftp.pbone.net/mirror/www.whiteboxlinux.org/whitebox/4/en/os/x86_64/WhiteBox/RPMS/pdksh-5.2.14-30.x86_64.rpm

]# yum localinstall pdksh-5.2.14-30.x86_64.rpm

OFA 디렉토리 생성

mkdir -p /u01/app/oracle/product/11.2.0/db_1
mkdir -p /u01/app/oraInventory
chown oracle:oinstall -R /u01

mkdir -p /u01/app/oracle/product/11.2.0/db_1

mkdir -p /u01/app/oraInventory

chown oracle:oinstall -R /u01

sysctl.conf

fs.aio-max-nr = 1048576
# It is recommended to have a minimum of 256 as value for every 4MB of RAM you have.
# So for 8GB RAM = 2048 * 4MB = 2048 * 256 = 524288
fs.file-max = 6815744
# It sets the maximum number of shared memory segments that server can handle.
# As Oracle recommends the value should be at least 4096,
# it says that we cannot find more than 4096 number of shared memory segments at any instance on the server.
# Note that SHMMNI value is in numbers.
#
# No change it should be 4096. It must be increased if you have more than at least one fourth (1024) Oracle Databases running on the server. Which we never recommend.
kernel.shmmni = 4096
# It defines the total amount of shared memory PAGES that can be used system-wide.
# It means that to the use all the physical memory this value should be less than or equal to total physical memory size.
# For DBA's, it means that sum of all SGA sizes on the server should be less than or equal to SHMALL value.
# Note that SHMALL value is a number of pages.
#
# If you want the maximum size of SGA on this server to be 5GB, then this parameter value should be 5*1024*1024*1024 = 5368709120 bytes. This, in turn, says that you should not have any database with more than 5GB of SGA. But you can have multiple databases with each 5GB of SGA or even less. This is the fact why Oracle recommends to have this value more than half of the memory to utilize it for SGA(s).
#
# By chance, if your SGA size is more than 5GB say it is 7GB then 2 shared memory areas will be allocated to SGA with one of 5GB and two of 2GB sizes, which doesn's perform well.
kernel.shmmax = 2147483648

#  It defines the total amount of shared memory PAGES that can be used system-wide. It means that to the use all the physical memory this value should be less than or equal to total physical memory size. For DBA's, it means that sum of all SGA sizes on the server should be less than or equal to SHMALL value. Note that SHMALL value is a number of pages.
# By default the page size on Linux is 4KB. The total size of RAM is 8GB. Let us leave at least 1GB of RAM for Linux kernel to run, with which consider 7GB can be used for Oracle Databases. Now value of SHMALL can be:
#
# (7*1024*1024)KB/4KB = 1835008
kernel.shmall = 95325

kernel.sem = 250 32000 100 128

# This parameter defines the range of port numbers that system can use for programs which want to connect to the server without a specific port number.
#
# Now, it makes sense if you have come across somebody advising you not to use port numbers for listener beyond 9000. Also, just look back to documents on OEM installation, Oracle uses and advises all the default port numbers less than 9000.
net.ipv4.ip_local_port_range = 9000 65500

# This parameter defines the default  and maximum RECEIVE socket memory through TCP.
net.core.rmem_default = 262144
net.core.rmem_max = 4194304

# This parameter defines the default  and maximum SEND socket memory through TCP.
net.core.wmem_default = 262144
net.core.wmem_max = 1048586

fs.aio-max-nr = 1048576

# It is recommended to have a minimum of 256 as value for every 4MB of RAM you have.

# So for 8GB RAM = 2048 * 4MB = 2048 * 256 = 524288

fs.file-max = 6815744

# It sets the maximum number of shared memory segments that server can handle.

# As Oracle recommends the value should be at least 4096,

# it says that we cannot find more than 4096 number of shared memory segments at any instance on the server.

# Note that SHMMNI value is in numbers.

# No change it should be 4096. It must be increased if you have more than at least one fourth (1024) Oracle Databases running on the server. Which we never recommend.

kernel.shmmni = 4096

# It defines the total amount of shared memory PAGES that can be used system-wide.

# It means that to the use all the physical memory this value should be less than or equal to total physical memory size.

# For DBA's, it means that sum of all SGA sizes on the server should be less than or equal to SHMALL value.

# Note that SHMALL value is a number of pages.

# If you want the maximum size of SGA on this server to be 5GB, then this parameter value should be 5*1024*1024*1024 = 5368709120 bytes. This, in turn, says that you should not have any database with more than 5GB of SGA. But you can have multiple databases with each 5GB of SGA or even less. This is the fact why Oracle recommends to have this value more than half of the memory to utilize it for SGA(s).

# By chance, if your SGA size is more than 5GB say it is 7GB then 2 shared memory areas will be allocated to SGA with one of 5GB and two of 2GB sizes, which doesn's perform well.

kernel.shmmax = 2147483648

# It defines the total amount of shared memory PAGES that can be used system-wide. It means that to the use all the physical memory this value should be less than or equal to total physical memory size. For DBA's, it means that sum of all SGA sizes on the server should be less than or equal to SHMALL value. Note that SHMALL value is a number of pages.

# By default the page size on Linux is 4KB. The total size of RAM is 8GB. Let us leave at least 1GB of RAM for Linux kernel to run, with which consider 7GB can be used for Oracle Databases. Now value of SHMALL can be:

# (7*1024*1024)KB/4KB = 1835008

kernel.shmall = 95325

kernel.sem = 250 32000 100 128

# This parameter defines the range of port numbers that system can use for programs which want to connect to the server without a specific port number.

# Now, it makes sense if you have come across somebody advising you not to use port numbers for listener beyond 9000. Also, just look back to documents on OEM installation, Oracle uses and advises all the default port numbers less than 9000.

net.ipv4.ip_local_port_range = 9000 65500

# This parameter defines the default and maximum RECEIVE socket memory through TCP.

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

# This parameter defines the default and maximum SEND socket memory through TCP.

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

/etc/security/limits.conf

# http://www.tecmint.com/setting-up-prerequisites-for-oracle-12c-installation/
oracle          soft    nofile  1024
oracle          hard    nofile  65536
oracle          soft    nproc   2047
oracle          hard    nproc   16384
oracle          soft    stack   10240
oracle          hard    stack   32768

# http://www.tecmint.com/setting-up-prerequisites-for-oracle-12c-installation/

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.d/90-nproc.conf

*          -    nproc     16384
root       soft    nproc     unlimited

1 2	* - nproc 16384 root soft nproc unlimited

/etc/pam.d/login

session required pam_limits.so

1	session required pam_limits.so

/etc/oraInst.loc

]# vim /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory
inst_group=oinstall

]# chown oracle:oinstall /etc/oraInst.loc
]# chmod 664 /etc/oraInst.loc

]# vim /etc/oraInst.loc

inventory_loc=/u01/app/oraInventory

inst_group=oinstall

]# chown oracle:oinstall /etc/oraInst.loc

]# chmod 664 /etc/oraInst.loc

oracle 계정으로 로그인 한후에 Oracle 11gR2 바이너리 설치 […]