DBA가 되고 싶은 병아리
ol5up5x64_oracle10g_prerequirements (아카이브) 본문
[root@ora10R2t Server]# rpm -ivh kernel-headers-2.6.18-194.el5.x86_64.rpm
warning: kernel-headers-2.6.18-194.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
package kernel-headers-2.6.18-194.el5.x86_64 is already installed
[root@ora10R2t Server]#
rpm -q gcc-c++-4.1.2-48.el5.x86_64
gcc-4.1.2-48.el5.x86_64
libstdc++-devel-4.1.2-48.el5.i386
libstdc++-devel-4.1.2-48.el5.x86_64
glibc-headers-2.5-49.x86_64
glibc-devel-2.5-49.x86_64
glibc-devel-2.5-49.i386
glibc-2.5-49.i686
glibc-2.5-49.x86_64
libgomp-4.4.0-6.el5.i386
libgomp-4.4.0-6.el5.x86_64
package gcc-c++-4.1.2-48.el5.x86_64 is not installed
package gcc-4.1.2-48.el5.x86_64 is not installed
package libstdc++-devel-4.1.2-48.el5.i386 is not installed
package libstdc++-devel-4.1.2-48.el5.x86_64 is not installed
glibc-headers-2.5-49
glibc-devel-2.5-49
package glibc-devel-2.5-49.i386 is not installed
glibc-2.5-49
glibc-2.5-49
package libgomp-4.4.0-6.el5.i386 is not installed
package libgomp-4.4.0-6.el5.x86_64 is not installed
[root@ora10R2t Server]#
rpm -ivh gcc-c++-4.1.2-48.el5.x86_64.rpm \
gcc-4.1.2-48.el5.x86_64.rpm
libstdc++-devel-4.1.2-48.el5.i386.rpm
libstdc++-devel-4.1.2-48.el5.x86_64.rpm
glibc-devel-2.5-49.i386.rpm
libgomp-4.4.0-6.el5.i386.rpm
libgomp-4.4.0-6.el5.x86_64.rpm
warning: gcc-c++-4.1.2-48.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:libgomp ########################################### [ 14%]
2:glibc-devel ########################################### [ 29%]
3:libstdc++-devel ########################################### [ 43%]
4:libstdc++-devel ########################################### [ 57%]
5:libgomp ########################################### [ 71%]
6:gcc ########################################### [ 86%]
7:gcc-c++ ########################################### [100%]
rpm -ivh compat-db-4.2.52-5.1.i386.rpm
compat-db-4.2.52-5.1.x86_64.rpm
libXp-1.0.0-8.1.el5.i386.rpm
libXp-1.0.0-8.1.el5.x86_64.rpm
warning: compat-db-4.2.52-5.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:libXp ########################################### [ 25%]
2:compat-db ########################################### [ 50%]
3:compat-db ########################################### [ 75%]
4:libXp ########################################### [100%]
rpm -ivh sysstat-7.0.2-3.el5.x86_64.rpm
warning: sysstat-7.0.2-3.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:sysstat ########################################### [100%]
#
===========================================================================
semmsl, semmns, semopm, and semmni
/sbin/sysctl -a | grep sem
This command displays the value of the semaphore parameters in the order listed.
shmall, shmmax, and shmmni
/sbin/sysctl -a | grep shm
This command displays the details of the shared memory segment sizes.
file-max
/sbin/sysctl -a | grep file-max
This command displays the maximum number of file handles.
ip_local_port_range
/sbin/sysctl -a | grep ip_local_port_range
This command displays a range of port numbers.
rmem_default
/sbin/sysctl -a | grep rmem_default
rmem_max
/sbin/sysctl -a | grep rmem_max
wmem_default
/sbin/sysctl -a | grep wmem_default
wmem_max
/sbin/sysctl -a | grep wmem_max
[root@ora10R2t Server]# /sbin/sysctl -a | grep sem
kernel.sem = 250 32000 32 128
[root@ora10R2t Server]#
[root@ora10R2t Server]#
[root@ora10R2t Server]# /sbin/sysctl -a | grep shm
vm.hugetlb_shm_group = 0
kernel.shmmni = 4096
kernel.shmall = 4294967296
kernel.shmmax = 68719476736
[root@ora10R2t Server]# /sbin/sysctl -a | grep file-max
fs.file-max = 101048
[root@ora10R2t Server]# /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 32768 61000
[root@ora10R2t Server]# /sbin/sysctl -a | grep rmem_default
net.core.rmem_default = 129024
[root@ora10R2t Server]# /sbin/sysctl -a | grep rmem_max
net.core.rmem_max = 131071
[root@ora10R2t Server]# /sbin/sysctl -a | grep wmem_default
net.core.wmem_default = 129024
[root@ora10R2t Server]# /sbin/sysctl -a | grep wmem_max
net.core.wmem_max = 131071
[root@ora10R2t Server]#
vi /etc/sysctl.conf
#kernel.shmall = 2097152
#kernel.shmmax = 2147483648
#kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
#fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@ora10R2t Server]#
mkdir -p /stage /u01/app/oracle /u02
chown -R oracle:oinstall /stage /u01 /u02
cd /
ls -l
...
drwxr-xr-x 2 oracle oinstall 4096 Jan 7 18:16 stage
drwxr-xr-x 11 root root 0 Jan 7 16:30 sys
drwxr-xr-x 3 root root 4096 Jan 8 2011 tftpboot
drwxrwxrwt 12 root root 4096 Jan 7 17:46 tmp
drwxr-xr-x 3 oracle oinstall 4096 Jan 7 18:16 u01
drwxr-xr-x 2 oracle oinstall 4096 Jan 7 18:16 u02
...
vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
vi /etc/pam.d/login
session required pam_limits.so
vi /etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ];then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH
export PATH
su - oracle
$ vi .bash_profile
For ORACLE SW and DB Server
umask 022
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
export ORACLE_BASE ORACLE_HOME PATH
TMP=/tmp
TMPDIR=/tmp
#TNS_ADMIN=/u01/app/oracle/product/10.2.0/db_1/network/admin
#JAVA_HOME=$ORACLE_HOME/jdk
LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib:$ORACLE_HOME/jdk/jre/lib/i386
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdk/jre/lib/i386/server
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib
export LD_LIBRARY_PATH
#EDITOR=vi
#export TMP TMPDIR TNS_ADMIN JAVA_HOME LD_LIBRARY_PATH EDITOR
#ORACLE_SID=orcl
#NLS_LANG=AMERICAN_AMERICA.AL32UTF8
NLS_LANG=KOREAN_KOREA.AL32UTF8
#export ORACLE_SID NLS_LANG
reboot
- Unzip the file:
$ gunzip 10201_database_linux_x86_64.cpio.gz
- Extract the file:
$ cpio -idmv < 10201_database_linux_x86_64.cpio
이 내용은 RedHat, OL 5 에 Oracle Database 10g Release 2
설치시에 수행합니다.이전 버젼의 리눅스 (예, RedHat 4, OL 4 등)에 설치할 때는
수행할 필요가 없습니다.
Step1)/stage/database/install/oraparam.ini 파일 편집
[oracle@ora10R2t install]$ cd /stage/database/install
[oracle@ora10R2t install]$
[oracle@ora10R2t install]$
[oracle@ora10R2t install]$ ls
addLangs.sh images oneclick.properties oraparamsilent.ini response
addNode.sh lsnodes oraparam.ini resource unzip
[oracle@ora10R2t install]$
[oracle@ora10R2t install]$ vi oraparam.ini
--기존 내용
[Certified Versions]
Linux=redhat-3,SuSE-9,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2
맨마지막에 ,redhat-5 추가
-- 편집후 내용
[Certified Versions]
Linux=redhat-3,SuSE-9,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2,redhat-5
Step 2) /stage/database/stage/prereq/db/refhost.xml 파일 편집
$ vi /stage/database/stage/prereq/db/refhost.xml
아래로 스크롤해서
++++++ add the new redhat-5 bit in here
Find the code where the redhat 4 checking ends and the SUSE 9 checking starts
$ cd /stage/database
./runInstaller -ignoreSysPrereqs