이 페이지의 이전 버전을 보고 있습니다. 현재 버전 보기.

현재와 비교 페이지 이력 보기

« 이전 버전 7 다음 »

 

 

 

 

 

 

 

cat /etc/oracle-release
cat /etc/redhat-release
lsb_release -id
uname -r
[root@rac1 ~]# cat /etc/oracle-release
Oracle Linux Server release 6.5


[root@rac1 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.5 (Santiago)


[root@rac1 ~]# lsb_release -id
Distributor ID:	OracleServer
Description:	Oracle Linux Server release 6.5


[root@rac1 ~]# uname -r
3.8.13-16.2.1.el6uek.x86_64
rpm -q binutils-*
rpm -q compat-libcap1-*
rpm -q compat-libstdc++-33-*
rpm -q gcc-*
rpm -q gcc-c++-*
rpm -q glibc-*
rpm -q glibc-devel-*
rpm -q ksh
rpm -q libgcc-*
rpm -q libstdc++-*
rpm -q libstdc++-devel-*
rpm -q libaio-*
rpm -q libaio-devel-*
rpm -q libXext-*
rpm -q libXtst-*
rpm -q libX11-*
rpm -q libXau-*
rpm -q libxcb-*
rpm -q libXi-*
rpm -q make-*
rpm -q sysstat-*
[root@rac1 ~]# rpm -q binutils-*
binutils-2.20.51.0.2-5.36.el6.x86_64


[root@rac1 ~]# rpm -q compat-libcap1-*
compat-libcap1-1.10-1.x86_64


[root@rac1 ~]# rpm -q compat-libstdc++-33-*
compat-libstdc++-33-3.2.3-69.el6.x86_64


[root@rac1 ~]# rpm -q gcc-*
gcc-4.4.7-4.el6.x86_64


[root@rac1 ~]# rpm -q gcc-c++-*
gcc-c++-4.4.7-4.el6.x86_64


[root@rac1 ~]# rpm -q glibc-*
glibc-2.12-1.132.el6.x86_64
glibc-2.12-1.132.el6.i686


[root@rac1 ~]# rpm -q glibc-devel-*
glibc-devel-2.12-1.132.el6.x86_64


[root@rac1 ~]# rpm -q ksh
ksh-20120801-10.el6.x86_64


[root@rac1 ~]# rpm -q libgcc-*
libgcc-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.i686


[root@rac1 ~]# rpm -q libstdc++-*
libstdc++-4.4.7-4.el6.x86_64


[root@rac1 ~]# rpm -q libstdc++-devel-*
libstdc++-devel-4.4.7-4.el6.x86_64


[root@rac1 ~]# rpm -q libaio-*
libaio-0.3.107-10.el6.x86_64


[root@rac1 ~]# rpm -q libaio-devel-*
libaio-devel-0.3.107-10.el6.x86_64


[root@rac1 ~]# rpm -q libXext-*
libXext-1.3.1-2.el6.x86_64


[root@rac1 ~]# rpm -q libXtst-*
libXtst-1.2.1-2.el6.x86_64


[root@rac1 ~]# rpm -q libX11-*
libX11-1.5.0-4.el6.x86_64


[root@rac1 ~]# rpm -q libXau-*
libXau-1.0.6-4.el6.x86_64


[root@rac1 ~]# rpm -q libxcb-*
libxcb-1.8.1-1.el6.x86_64


[root@rac1 ~]# rpm -q libXi-*
libXi-1.6.1-3.el6.x86_64


[root@rac1 ~]# rpm -q make-*
make-3.81-20.el6.x86_64


[root@rac1 ~]# rpm -q sysstat-*
sysstat-9.0.4-22.el6.x86_64
vi /etc/hosts
### Public
10.0.1.101 rac1
10.0.1.102 rac2
### Private
10.0.5.101 rac1-priv
10.0.5.102 rac2-priv
### Virtual
10.0.1.111 rac1-vip
10.0.1.112 rac2-vip
### SCAN
10.0.1.120 rac-scan
vi /etc/sysctl.conf
kernel.sem    = 250   32000   100   128
kernel.shmmni = 4096
fs.file-max   = 6815744
net.ipv4.ip_local_port_range = 9000   65535
net.core.rmem_default = 262144
net.core.rmem_max     = 4194304
net.core.wmem_default = 262144
net.core.wmem_max     = 1048576
fs.aio-max-nr         = 1048576 
vi /etc/security/limits.conf
oracle  hard  nofile   65536
oracle  hard  nproc    16384
oracle  soft  nproc    2047
oracle  hard  memlock  4572857
service dnsmasq start
chkconfig dnsmasq on
chkconfig --level 123456 xinetd off
chkconfig --level 123456 cups off
chkconfig --level 123456 smartd off
chkconfig --level 123456 iptables off
chkconfig --level 123456 ip6tables off
chkconfig --level 123456 bluetooth off
mv /etc/sysconfig/ntpd /etc/sysconfig/ntpd.original
mv /etc/ntp /etc/ntp.original
mv /etc/ntp.conf /etc/ntp.conf.original
vi /etc/sysconfig/selinux
SELINUX=permissive
vi /etc/security/limits.d/90-nproc.conf
# Change this
*          soft    nproc    1024

# To this
* 		   - 	   nproc    16384
# groupadd oinstall
# groupadd dba
groupadd oper
groupadd backupdba
groupadd dgdba
groupadd kmdba
groupadd asmdba
groupadd asmoper
groupadd asmadmin
 
usermod -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,asmoper,asmadmin,vboxsf oracle
passwd oracle
[root@rac1 ~]# groupadd oper
[root@rac1 ~]# groupadd backupdba
[root@rac1 ~]# groupadd dgdba
[root@rac1 ~]# groupadd kmdba
[root@rac1 ~]# groupadd asmdba
[root@rac1 ~]# groupadd asmoper
[root@rac1 ~]# groupadd asmadmin

[root@rac1 ~]# usermod -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,asmoper,asmadmin,vboxsf oracle

[root@rac1 ~]# passwd oracle
oracle 사용자의 비밀 번호 변경 중
새  암호:
잘못된 암호: 사전에 있는 단어를 기반으로 합니다  
잘못된 암호: 너무 간단함
새  암호 재입력:
passwd: 모든 인증 토큰이 성공적으로 업데이트 되었습니다.
mkdir /u01
chown -R oracle:oinstall /u01
vi .bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export EDITOR=vi
export ORACLE_HOSTNAME=rac1     # rac2 => 2번 노드
export ORACLE_UNQNAME=racdb
export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/12.1.0/grid
export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=racdb1     # racdb2 => 2번 노드
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GRID_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export NLS_LANG=AMERICAN_KOREA.AL32UTF8
vi .db_env
export ORACLE_SID=racdb1     # racdb2 => 2번 노드
export ORACLE_HOME=$DB_HOME
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GRID_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
vi .grid_env
export ORACLE_SID=+ASM1     # +ASM2 => 2번 노드
export ORACLE_HOME=$GRID_HOME
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GRID_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
vi .bashrc
alias grid_env='. ~/.grid_env'
alias db_env='. ~/.db_env'
alias ss='sqlplus / as sysdba'
alias ltr='ls -ltr'
  • 레이블 없음