DBA가 되고 싶은 병아리
ora10gr2x64_install_prerequire (아카이브) 본문
[root@ora10gr2x64 ~]# grep MemTotal /proc/meminfo
MemTotal: 1024916 kB
[root@ora10gr2x64 ~]# grep SwapTotal /proc/meminfo
SwapTotal: 2048276 kB
[root@ora10gr2x64 ~]# free
total used free shared buffers cached
Mem: 1024916 374928 649988 0 31420 187812
-/+ buffers/cache: 155696 869220
Swap: 2048276 0 2048276
[root@ora10gr2x64 ~]#
[root@ora10gr2x64 ~]#
[root@ora10gr2x64 ~]# df -k /tmp
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 101193496 3122600 92930500 4% /
[root@ora10gr2x64 ~]#
[root@ora10gr2x64 ~]#
[root@ora10gr2x64 ~]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/sda1 101193496 3122616 92930484 4% /
none 512456 0 512456 0% /dev/shm
[root@ora10gr2x64 ~]#
[root@ora10gr2x64 ~]# grep "model name" /proc/cpuinfo
model name : AMD Phenom(tm) II X4 925 Processor
model name : AMD Phenom(tm) II X4 925 Processor
model name : AMD Phenom(tm) II X4 925 Processor
model name : AMD Phenom(tm) II X4 925 Processor
[root@ora10gr2x64 ~]#
[root@ora10gr2x64 ~]# uname -a
Linux ora10gr2x64 2.6.9-89.0.0.0.1.ELsmp #1 SMP Tue May 19 05:31:20 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
[root@ora10gr2x64 ~]#
[root@ora10gr2x64 ~]# rpm -q binutils compat-db control-center gcc
gcc-c++ glibc glibc-common gnome-libs libstdc++
libstdc++-devel make pdksh sysstat xscreensaver
binutils-2.15.92.0.2-25
compat-db-4.1.25-9
compat-db-4.1.25-9
control-center-2.8.0-12.rhel4.5
gcc-3.4.6-11.0.1
gcc-c++-3.4.6-11.0.1
glibc-2.3.4-2.43
glibc-2.3.4-2.43
glibc-common-2.3.4-2.43
gnome-libs-1.4.1.2.90-44.2
libstdc++-3.4.6-11.0.1
libstdc++-3.4.6-11.0.1
libstdc++-devel-3.4.6-11.0.1
libstdc++-devel-3.4.6-11.0.1
make-3.80-7.EL4
pdksh-5.2.14-30.6
package sysstat is not installed
xscreensaver-4.18-5.rhel4.14.0.1
[root@ora10gr2x64 RPMS]# rpm -ivh sysstat-5.0.5-25.el4.x86_64.rpm
warning: sysstat-5.0.5-25.el4.x86_64.rpm: V3 DSA signature: NOKEY, key ID b38a8516
Preparing... ########################################### [100%]
1:sysstat ########################################### [100%]
[root@ora10gr2x64 RPMS]#
cat /proc/version
Linux version 2.6.9-89.0.0.0.1.ELsmp (mockbuild@ca-build10.us.oracle.com) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-11.0.1)) #1 SMP Tue May 19 05:31:20 EDT 2009
[root@ora10gr2x64 ~]# uname -r
2.6.9-89.0.0.0.1.ELsmp
[root@ora10gr2x64 ~]# cat /etc/nsswitch.conf | grep hosts
#hosts: db files ldap nis dns
hosts: files dns
[root@ora10gr2x64 ~]# vi /etc/hosts
192.168.10.100 ora10gr2x64 ora10gr2x64.test.com
127.0.0.1 localhost localhost.localdomain
[root@ora10gr2x64 ~]# groupadd oinstall
[root@ora10gr2x64 ~]# groupadd dba
[root@ora10gr2x64 ~]# adduser -g oinstall -G dba oracle
[root@ora10gr2x64 ~]# 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@ora10gr2x64 ~]#
[root@ora10gr2x64 ~]# id nobody
uid=99(nobody) gid=99(nobody) groups=99(nobody)
[root@ora10gr2x64 ~]# /sbin/sysctl -a | grep sem
kernel.sem = 250 32000 32 128
[root@ora10gr2x64 ~]# /sbin/sysctl -a | grep shm
vm.hugetlb_shm_group = 0
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 33554432
[root@ora10gr2x64 ~]# /sbin/sysctl -a | grep file-max
fs.file-max = 101208
[root@ora10gr2x64 ~]# /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 32768 61000
[root@ora10gr2x64 ~]# /sbin/sysctl -a | grep rmem_default
net.core.rmem_default = 135168
[root@ora10gr2x64 ~]# /sbin/sysctl -a | grep rmem_max
net.core.rmem_max = 135168
[root@ora10gr2x64 ~]# /sbin/sysctl -a | grep wmem_default
net.core.wmem_default = 135168
[root@ora10gr2x64 ~]# /sbin/sysctl -a | grep wmem_max
net.core.wmem_max = 135168
[root@ora10gr2x64 ~]#
[root@ora10gr2x64 ~]# 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
[root@ora10gr2x64 ~]# vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
[root@ora10gr2x64 ~]# vi /etc/pam.d/login
session required pam_limits.so
ot@ora10gr2x64 ~]# 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
[root@ora10gr2x64 ~]# mkdir -p /u01/app/oracle/oradata /u02/app/oracle/oradata/ /stage
[root@ora10gr2x64 ~]# chown -R oracle:oinstall /u01 /u02 /stage
[root@ora10gr2x64 ~]# chmod -R 770 /u01 /u02 /stage
[oracle@ora10gr2x64 ~]$ vi .bash_profile
ORACLE_BASE=/u01/app/oracle ; export ORACLE_BASE
rpm -qa -iVfl
rpm -q binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver
binutils-2.15.92.0.2-10.EL4
compat-db-4.1.25-9
control-center-2.8.0-12
gcc-3.4.3-9.EL4
gcc-c++-3.4.3-9.EL4
glibc-2.3.4-2
glibc-common-2.3.4-2
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-9.EL4
libstdc++-devel-3.4.3-9.EL4
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2