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

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

버전 1 다음 »

 

 

 

 

 

 

 

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

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

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

[root@rac1 ~]# uname -r
4.1.12-37.4.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.44.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-17.el6.x86_64

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

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

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

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

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

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

[root@rac1 ~]# rpm -q libstdc++-devel-*
libstdc++-devel-4.4.7-17.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.3-1.el6.x86_64

[root@rac1 ~]# rpm -q libXtst-*
libXtst-1.2.2-2.1.el6.x86_64

[root@rac1 ~]# rpm -q libX11-*
libX11-1.6.3-2.el6.x86_64

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

[root@rac1 ~]# rpm -q libxcb-*
libxcb-1.11-2.el6.x86_64

[root@rac1 ~]# rpm -q libXi-*
libXi-1.7.4-1.el6.x86_64

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

[root@rac1 ~]# rpm -q sysstat-*
sysstat-9.0.4-31.el6.x86_64

 

vi /etc/hosts
### Public
10.0.1.101 ora12cr1

 

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
grid    hard  nofile   65536
grid    soft  nproc    2047

 

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

 

# 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,asmadmin,asmdba,vboxsf oracle
useradd -g oinstall -G dba,asmdba,asmoper,asmadmin,vboxsf grid
passwd oracle
passwd grid
[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,asmadmin,asmdba,vboxsf oracle
[root@rac1 ~]# useradd -g oinstall -G dba,asmdba,asmoper,asmadmin,vboxsf grid

[root@rac1 ~]# passwd oracle
oracle 사용자의 비밀 번호 변경 중
새  암호:
잘못된 암호: 사전에 있는 단어를 기반으로 합니다  
잘못된 암호: 너무 간단함
새  암호 재입력:
passwd: 모든 인증 토큰이 성공적으로 업데이트 되었습니다.
 
[root@rac1 ~]# passwd grid
grid 사용자의 비밀 번호 변경 중
새  암호:
잘못된 암호: 사전에 있는 단어를 기반으로 합니다  
잘못된 암호: 너무 간단함
새  암호 재입력:
passwd: 모든 인증 토큰이 성공적으로 업데이트 되었습니다.

 

mkdir -p /u01/app/oracle/product
chown -R grid:oinstall /u01
chmod -R 770 /u01

 

grid 유저 : vi .bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export EDITOR=vi
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=$GRID_HOME
export ORACLE_SID=+ASM
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$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
export PS1='[\u@$ORACLE_SID \W]$ '

 

oracle 유저 : vi .bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export EDITOR=vi
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=orcl
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
export PS1='[\u@$ORACLE_SID \W]$ '

 

  • 레이블 없음