오라클 스터디

솔라리스 설치는 앞에 OUI설치법 참고

Oracle 설치 준비

putty랑 연동하기

#vi /etc/ssh/sshd_config

 132 - PerminRootLogin yes

#svcs ssh

#svcadm disable ssh

#svcadm enable ssh

/etc/system 파일 설정

forceload:sys/shmsys 
forceload:sys/semsys 
set shmsys:shminfo_shmmax=4294967295 
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256

set semsys:seminfo_semvmx=32767

그룹과 오라클 계정 생성

#groupadd -g 5000 dba

#groupadd -g 5001 oinstall

#groupadd -g 5002 oper

#useradd -g oinstall -G dba,oper -s /bin/ksh -d /export/home/oracle -m oracle

cd 들어가서 필요 패키지 설치

# cd /cdrom//sol_10_508_x86/Solaris_10/Product/ 

# mkdir /export/home/oracle//package 

# cp -rp ./SUNWi1cs /export/home/oracle/package/ 

# cp -rp ./SUNWi15cs /export/home/oracle/package/ 

# pkgadd -d /export/home/oracle/package/  

vi /export/home/oracle/.profile

export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10g
export ORACLE_SID=testdb
export ORACLE_OWNER=oracle
export  PATH=$PATH:$ORACLE_HOME/bin
export LANG=ko_KR.UTF-8
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export TMP=/tmp

export TMPDIR=/tmp

.profile 적용하기위해 재부팅

오라클 계정으로 winscp를 이용해서 설치파일 /export/home/oracle 로 옮겨줌

unzip 10202_database_solx86.zip

cd database

오라클 계정 로그인

rsp파일 설정

cd /export/home/oracle/database/response

vi enterprise.rsp 

cd ../

./runInstaller -silent -responseFile /export/home/oracle/database/response/enterprise.rsp

sqlplus /nolog로 확인

DB생성하기

response 파일 설정

cd /export/home/oracle/database/response

vi dbca.rsp

dbca -silent -templateName General_Purpose.dbc \

-responseFile /export/home/oracle/response/dbca.rsp

설치 완료후 sqlplus / as sysdba

select status from v$instance;

10.2.0.4 패치

cd patchset

unzip p6810189_10204_Linux-x86.zip

vi /home/oracle/patchset/Disk1/response/patchset.rsp

cd /Disk1

./runInstaller -silent - \ responseFile /home/oracle/patchset/Disk1/response/patchset.rsp

설치를 하면 아래와 같이 스크립트 입력하라고 나옴

루트 계정 터미널창 열어서 /home/oracle/product/10g/root.sh 입력

DB생성

vi /home/oracle/database/response/dbca.rsp

cd /home/oracle/product/10g/bin

./dbca -silent -responseFile /home/oracle/database/response/dbca.rsp

설치 완료

sqlplus / as sysdba

sql > select status from v$instance; 로 확인

10.2.0.5 패치를 위해 DB를 Shutdown 해준다.

sqlplus / as sysdba

sql > shutdown

10.2.0.4 패치를 위해 풀어놓은 Disk1과 README.html 파일을 지워줌

cd patchset

rm -rf Disk1/ README.html

unzip -p8202632_10205_LINUX.zip
cd Disk1

vi /home/oracle/patchset/Disk1/response/patchset.rsp

cd Disk1

./runInstaller -silent - \ responseFile /home/oracle/patchset/Disk1/response/patchset.rsp

루트계정 터미널창 열어서 /home/oracle/product/10g/root.sh 입력

패치후 Post Upgrade

sqlplus / as sysdba

startup upgrade

sql >select status from v$instance;

@?/rdbms/admin/catupgrd.sql 입력해주면 엔진에 맞는 DB버전으로 패치적용

sql> shutdown

sql> startup

@?/rdbms/admin/utlrp.sql 명령어로 Invalid PL/SQL package 를 compile

sql> sqlplus / as sysdba

sql> select status from v$instance;

groupadd -g 5000 dba

useradd -g dba oracle

passwd oracle

vi /etc/oraInst.loc

inventory_loc=/home/oracle/oraInventory

inst_group=dba

chown -R oracle.dba /etc/oraInst.loc

vi /etc/sysctl.conf

kernel.shmmax=536870912

kernel.shmmni=4096

kernel.shmall=2097152

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

vi /etc/security/limits.conf

oracle10g soft nproc 2047

oracle10g hard nproc 16384

oracle10g soft nofile 1024

oracle10g hard nofile 65536

vi /etc/pam.d/login

session    required    pam_limits.so

sysctl -p

root 계정에서 rpm설치를 위해 cd3을 넣어줌

cd /media/cdrecoder/RedHat/RPMS

아래와 같이 설치 성공하고 루트계정 터미널을 열어서 /home/oracle/product/10g/root.sh 입력

sqlplus /nolog 버전확인

그룹 및 계정 생성

groupadd –g 5000 dba

useradd –g dba oracle

passwd oracle