RAC_ASM설치 ( OEL5 + ORACLE 11g )
6. DB생성
- 재부팅하고 oracle계정으로 로그인후 dbca 시작
[oracle@rac1 ~]$ dbca |
- DB생성 확인
[oracle@rac1 database]$ crs_stat -t
|
| [RAC] OEL5 + Oracle 11g + RAC_ASM (engine 설치 및 ASM 구성) (636) | 2016.03.18 |
|---|---|
| [RAC] OEL5 + Oracle 11g + RAC_ASM (grid 설치) (613) | 2016.03.18 |
| [RAC] OEL5 + Oracle 11g + RAC_ASM (VMware, node1,2설정) (638) | 2016.03.18 |
| [Single] RHEL5 + ORACLE 11g(11.2.0.1) 설치(OUI) (618) | 2016.03.17 |
| [Single] RHEL4 + ORACLE 10g 설치(Silent) (607) | 2016.03.17 |
RAC_ASM설치 ( OEL5 + ORACLE 11g )
4. 11g Engine 설치
- grid 설치 완료후 재부팅하고 oracle계정으로 로그인.
- engine 설치 시작
[oracle@rac1 ~]$ cd database [oracle@rac1 database]$ ./runInstaller
|
- node1,2에서 각각 스크립트 실행
[oracle@rac1 ~]$ su - [oracle@rac1 ~]# /app/oracle/11g/db/root.sh |
- Engine설치완료
5. ASM 구성
- ASM configuration assistant 실행
[oracle@rac1 ~]$ asmca |
- 상태확인
[oracle@rac1 database]$ crs_tat -t
|
| [RAC] OEL5 + Oracle 11g + RAC_ASM (DB생성 및 TEST) (609) | 2016.03.18 |
|---|---|
| [RAC] OEL5 + Oracle 11g + RAC_ASM (grid 설치) (613) | 2016.03.18 |
| [RAC] OEL5 + Oracle 11g + RAC_ASM (VMware, node1,2설정) (638) | 2016.03.18 |
| [Single] RHEL5 + ORACLE 11g(11.2.0.1) 설치(OUI) (618) | 2016.03.17 |
| [Single] RHEL4 + ORACLE 10g 설치(Silent) (607) | 2016.03.17 |
RAC_ASM설치 ( OEL5 + ORACLE 11g )
3. grid 설치
- grid 설치 시작
[oracle@rac1 ~]$ cd grid [oracle@rac1 grid]$ ./runInstaller
|
- node1,2에서 각각 패키지 설치
[oracle@rac1 ~]$ su - [oracle@rac1 ~]# cd /media/Oracle\ Linux\ Server\ dvd\ 20110119/Server/ [oracle@rac1 Server]# rpm -ivh libaio-devel-0.3.106-5.i386.rpm 경고: libaio-devel-0.3.106-5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 준비 중... ########################################### [100%] 1:libaio-devel ########################################### [100%]
[root@rac1 Server]# |
- 다시 확인
- 모두 무시 체크
- 스크립트 실행 (순서 잘지켜야함)
[root@rac1 Server]# /app/oraInventory/orainstRoot.sh ..완료 [root@rac2 Server]# /app/oraInventory/orainstRoot.sh ..완료 [root@rac1 Server]# /app/11g/grid/root.sh .....succeeded. [root@rac2 Server]# /app/11g/grid/root.sh .....succeeded. |
- grid 설치완료
( 당황하지않고 확인)
- 상태확인
[oracle@rac1 grid]$ crs_stat -t
|
- GSD(global service daemon) 가동
[oracle@rac1 grid]$ srvctl enable nodeapps -g [oracle@rac1 grid]$ srvctl start nodeapps [oracle@rac1 grid]$ ocr check
|
- crs_stat 확인
[oracle@rac1 grid]$ crs_stat -t
|
| [RAC] OEL5 + Oracle 11g + RAC_ASM (DB생성 및 TEST) (609) | 2016.03.18 |
|---|---|
| [RAC] OEL5 + Oracle 11g + RAC_ASM (engine 설치 및 ASM 구성) (636) | 2016.03.18 |
| [RAC] OEL5 + Oracle 11g + RAC_ASM (VMware, node1,2설정) (638) | 2016.03.18 |
| [Single] RHEL5 + ORACLE 11g(11.2.0.1) 설치(OUI) (618) | 2016.03.17 |
| [Single] RHEL4 + ORACLE 10g 설치(Silent) (607) | 2016.03.17 |
RAC_ASM설치 ( OEL5 + ORACLE 11g )
1. VMware 설정 및 리눅스 설치
VMware (rac1) 설정
- virtual machine name: rac1
- RAM: 1500MB
- HDD: 30GB
- Disk file name: rac1.vmdk
- 불필요한 하드웨어 삭제 : Edit virtual machine settings -> Floppy, USB controller, Sound card, Printer 삭제
- Add Hard ware type : Network Adapter 추가
- Network Adaptor type: Host-only
- Add Hard ware type : HDD추가
- virtual disk type: SCSI
- Mode: Independent - persistent
-disk size/ Allocate all disk space now / single file
- Disk file name
Advanced setting
- Virtual device node :SCSI 1:0
- Mode: Independent - persistent
- 이렇게 각각 총 6개 HDD 추가.
ocr_vote01 1G SCSI 1:0
ocr_vote02 1G SCSI 1:1
ocr_vote03 1G SCSI 1:2
asm01 5G SCSI 1:3
asm02 5G SCSI 1:4
asm03 5G SCSI 1:5
- rac1 폴더의 rac1.vmx 파일 메모장으로 열고 내용 추가.
disk.locking = "FALSE"
diskLib.dataCacheMaxSize = "0"
scsi1.sharedBus = "virtual"
scsi1:0.deviceType = "disk"
scsi1:1.deviceType = "disk"
scsi1:2.deviceType = "disk"
scsi1:3.deviceType = "disk"
scsi1:4.deviceType = "disk"
scsi1:5.deviceType = "disk"
OEL5 설치
- Partition (/sda만)
/ 7000
/boot 100
/var 1000
swap 3000
/home 8000
/app 나머지
- Network devices : eth0, eth1 모두 Active
- Hostname : rac1
- 패키지 설치 : 사용자정의 ( 개발도구 모두 선택, 서버 모두 체크해제, 시스템툴 선택)
- 시스템도구 -> 오른쪽 하단에 optional pakage선택
ocfs2-2.6.18-238.el5-1.4.6.-2.el5.i686
2. node 설정
node_1 (rac1) 설정
- 주소확인
ifconfig : ip, netmask 주소확인
eth0 ip - 172.16.133.131
eth1 ip - 172.16.23.130
netmask - 255.255.255.0
netstat -nr : gateway 172.16.133.2
- 주소바꾸기
rac1 rac2
eth0 (NAT) = public 172.16.133.100 172.16.133.200
eth1 (host) = private 172.16.23.111 172.16.23.222
eth0 (NAT) = vip 172.16.133.10 172.16.133.20
gw 172.16.133.2 (eth1은 gw설정 안함)
dns 168.126.63.1
- vi /etc/hosts 내용추가
[root@rac1 ~]# vi /etc/hosts # public 172.16.133.100 rac1 172.16.133.200 rac2 # private 172.16.23.111 rac1-priv 172.16.23.222 rac2-priv # vip 172.16.133.10 rac1-vip 172.16.133.20 rac2-vip 172.16.133.30 rac-scan |
- 리눅스 부팅 후 불필요한 서비스 OFF
[root@rac1 ~]# chkconfig --level 123456 xinetd off [root@rac1 ~]# chkconfig --level 123456 sendmail off [root@rac1 ~]# chkconfig --level 123456 cups off [root@rac1 ~]# chkconfig --level 123456 cups-config-daemon off [root@rac1 ~]# chkconfig --level 123456 smartd off [root@rac1 ~]# chkconfig --level 123456 isdn off [root@rac1 ~]# chkconfig --level 123456 iptables off |
[root@rac1 ~]# groupadd -g 5000 dba [root@rac1 ~]# groupadd -g 5001 oinstall [root@rac1 ~]# useradd -g oinstall -G dba oracle [root@rac1 ~]# [root@rac1 ~]# passwd oracle |
- winscp로 설치파일옮기고, 설치파일 압축해제 및 권한변경
[oracle@rac1 ~]# cd /home/oracle [root@rac1 oracle]# unzip p10098816_112020_LINUX_1of7.zip && unzip p10098816_112020_LINUX_2of7.zip && unzip p10098816_112020_LINUX_3of7.zip [root@rac1 oracle]# chown -R oracle.oinstall /home/oracle |
- vi /etc/sysctl.conf 내용 추가
[oracle@rac1 ~]# vi /etc/sysctl.conf kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.wmem_max = 1048576 net.core.rmem_default = 4194304 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 fs.file-max = 6815744 fs.aio-max-nr = 1048576 |
- vi /etc/security/limits.conf 내용 추가
[oracle@rac1 ~]# vi /etc/security/limits.conf grid soft nproc 2047 grid hard nproc 16384 grid soft nofile 1024 grid hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 |
- vi /etc/pam.d/login 내용 추가
[oracle@rac1 ~]# vi /etc/pam.d/login session required pam_limits.so |
- vi /etc/modprobe.conf 내용 추가
[oracle@rac1 ~]# vi /etc/modprobe.conf options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180 |
- modprobe
[root@rac1 ~]# modprobe -v hangcheck-timer insmod /lib/modules/2.6.18-238.el5/kernel/drivers/char/hangcheck-timer.ko hangcheck_tick=30 hangcheck_margin=180 |
- vi /etc/rc.local 내용추가
[oracle@rac1 ~]# vi /etc/rc.local /sbin/modprobe hangcheck-timer rdate -s 203.248.240.140 |
- vi /etc/sysconfig/ntpd (options= -x 추가 )
[oracle@rac1 ~]# vi /etc/sysconfig/ntpd -x
|
- ntpd 재시작
[root@rac1 ~]# service ntpd restart ntpd를 종료중: [ 실패 ] ntpd: 시간서버와 동기화함: [ OK ] ntpd (을)를 시작 중: [ OK ] [root@rac1 ~]# chkconfig --level 123456 ntpd on [root@rac1 ~]# [root@rac1 ~]# chown -R oracle.oinstall /app [root@rac1 ~]# chmod -R 755 /app |
- vi .bash_profile (root) 내용추가
[root@rac1 ~]# vi .bash_profile export GRID_HOME=/app/11g/grid export PATH=$PATH:$HOME/bin:$GRID_HOME/bin |
- vi /home/oracle/.bash_profile 내용추가
[root@rac1 ~]# vi /home/oracle/.bash_profile export EDITOR=vi export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=rac1 export ORACLE_UNQNAME=racdb export ORACLE_BASE=/app/oracle export ORACLE_HOME=$ORACLE_BASE/11g/db export GRID_HOME=/app/11g/grid export ORACLE_SID=racdb1 export ORACLE_TERM=xterm export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib |
- 파티션 분할 (sdb,sdc,sdd,sdf,sdg)
[root@rac1 ~]# fdisk /dev/sdb Command (m for help): n Command action e extended p primary partition (1-4) p Partition number (1-4): 1 First cylinder (1-130, default 1): Using default value 1 Last cylinder or +size or +sizeM or +sizeK (1-130, default 130): Using default value 130 Command (m for help): w The partition table has been altered! Calling ioctl() to re-read partition table. Syncing disks. [root@rac1 ~]# |
- ASM환경설정
[root@rac1 ~]# oracleasm configure -I Configuring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. The current values will be shown in brackets ('[]'). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort. Default user to own the driver interface []: oracle Default group to own the driver interface []: oinstall Start Oracle ASM library driver on boot (y/n) [n]: y Scan for Oracle ASM disks on boot (y/n) [y]: y The next two configuration options take substrings to match device names. The substring "sd" (without the quotes), for example, matches "sda", "sdb", etc. You may enter more than one substring pattern, separated by spaces. The special string "none" (again, without the quotes) will clear the value. Device order to scan for ASM disks []: Devices to exclude from scanning []: Writing Oracle ASM library driver configuration: done [root@rac1 ~]# |
- 마운트 포인트 생성
[root@rac1 ~]# oracleasm init Creating /dev/oracleasm mount point: /dev/oracleasm Loading module "oracleasm": oracleasm Mounting ASMlib driver filesystem: /dev/oracleasm |
- 공유디스크 생성 (/dev/oracleasm 밑에 생성됨)
[root@rac1 ~]# oracleasm createdisk ocr_vote01 /dev/sdb1 Writing disk header: done Instantiating disk: done [root@rac1 ~]# oracleasm createdisk ocr_vote02 /dev/sdc1 Writing disk header: done Instantiating disk: done [root@rac1 ~]# oracleasm createdisk ocr_vote03 /dev/sdd1 Writing disk header: done Instantiating disk: done [root@rac1 ~]# oracleasm createdisk asm01 /dev/sde1 Writing disk header: done Instantiating disk: done [root@rac1 ~]# oracleasm createdisk asm02 /dev/sdf1 Writing disk header: done Instantiating disk: done [root@rac1 ~]# oracleasm createdisk asm03 /dev/sdg1 Writing disk header: done Instantiating disk: done [root@rac1 ~]# |
- 생성 리스트 확인하고 시스템 종료
[root@rac1 ~]# oracleasm scandisks Reloading disk partitions: done Cleaning any stale ASM disks... Scanning system for ASM disks... [root@rac1 ~]# oracleasm listdisks ASM01 ASM02 ASM03 OCR_VOTE01 OCR_VOTE02 OCR_VOTE03 [root@rac1 ~]# chown -R oracle.oinstall /dev/oracleasm [root@rac1 ~]# [root@rac1 ~]# init 0 |
node_2 설정
- rac1 폴더의 vmdk, vmx 파일을 rac2 폴더로 복사한후 rac2로 이름변경
- rac2.vmx파일 메모장으로 열고 rac1을 rac2로 모두 수정
- VMware에서 rac2.vmx 불러온후 i copied it.
- 주소바꾸기 : 앞에 node1에서 지정했던 주소로 바꿔줌 (#neat) , eth0,2.bak은 비활성화후 삭제
rac1 rac2
eth0 (NAT) = public 172.16.133.100 172.16.133.200
eth1 (host) = private 172.16.23.111 172.16.23.222
eth0 (NAT) = vip 172.16.133.10 172.16.133.20
gw 172.16.133.2 (eth1은 gw설정 안함)
dns 168.12
- vi /home/oracle/.bash_profile (rac1 -> rac2 로 수정)
[root@rac2 ~]# vi /home/oracle/.bash_profile export EDITOR=vi export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=rac2 export ORACLE_UNQNAME=racdb export ORACLE_BASE=/app/oracle export ORACLE_HOME=$ORACLE_BASE/11g/db export GRID_HOME=/app/11g/grid export ORACLE_SID=racdb2 export ORACLE_TERM=xterm export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib |
- node1에서 rpm설치후 node2에도 rpm파일전송하고 설치
[root@rac1 ~]# cd /home/oracle/grid/ [root@rac1 grid]# cd rpm/ [root@rac1 rpm]# [root@rac1 rpm]# export CVUQDISK_GRP=dba [root@rac1 rpm]# rpm -ivh cvuqdisk-1.0.9-1.rpm 준비중: ########################################### [100%] 1:cvuqdisk ########################################### [100%] [root@rac1 rpm]# scp cvuqdisk-1.0.9-1.rpm rac2:~/ The authenticity of host 'rac2 (172.16.133.200)' can't be established. RSA key fingerprint is 18:e2:c7:0b:4e:bd:7e:98:7b:7a:f8:b1:7e:2a:11:e2. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added 'rac2,172.16.133.200' (RSA) to the list of known hosts. root@rac2's password: cvuqdisk-1.0.9-1.rpm 100% 8233 8.0KB/s 00:00 [root@rac2 ~]# export CVUQDISK_GRP=dba [root@rac2 ~]# rpm -ivh cvuqdisk-1.0.9-1.rpm 준비중‘... ########################################### [100%] 1:cvuqdisk ########################################### [100%] [root@rac2 ~]# |
| [RAC] OEL5 + Oracle 11g + RAC_ASM (engine 설치 및 ASM 구성) (636) | 2016.03.18 |
|---|---|
| [RAC] OEL5 + Oracle 11g + RAC_ASM (grid 설치) (613) | 2016.03.18 |
| [Single] RHEL5 + ORACLE 11g(11.2.0.1) 설치(OUI) (618) | 2016.03.17 |
| [Single] RHEL4 + ORACLE 10g 설치(Silent) (607) | 2016.03.17 |
| [Single] RHEL4 + ORACLE 10g(10.2.0.1) > (10.2.0.4) 설치(OUI) (456) | 2016.03.17 |
Install ORACLE 11g on RHEL5
● Engine 생성전
- oracle 계정생성
[root@server114 root]# groupadd –g 5000 dba [root@server114 root]# useradd –g dba oracle [root@server114 root]# passwd oracle |
- winscp 파일전송
linux_11gR2_database_1of2.zip /home/oracle linux_11gR2_database_2of2.zip /home/oracle |
- 메모리, 디스크권장사항 확인하기
[root@server114 ~]# grep SwapTotal /proc/meminfo SwapTotal: 2048248 kB [root@server114 ~]# free total used free shared buffers cached Mem: 1035200 510560 524640 0 24468 384800 // 최소한의 메모리 1GB -/+ buffers/cache: 101292 933908 Swap: 2048248 0 2048248 // swap : 메모리의 1.5배~2배 [root@server114 ~]# df -h /tmp Filesystem Size Used Avail Use% Mounted on /dev/sda3 4.8G 2.9G 1.7G 65% / // tmp 디렉토리 1 GB 이상 되야함 |
- 필수 패키지 권장사항 확인하기(아래의 패키지 중 하나라도 설치되어 있지 않다면 꼭 찾아서 설치하고 다음으로 진행.)
binutils-2.17.50.0.6 compat-libstdc++-33-3.2.3 elfutils-libelf-0.125 elfutils-libelf-devel-0.125 elfutils-libelf-devel-static-0.125 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-24 glibc-common-2.5 glibc-devel-2.5 glibc-headers-2.5 kernel-headers-2.6.18 ksh-20060214 libaio-0.3.106 libaio-devel-0.3.106 libgcc-4.1.2 libgomp-4.1.2 libstdc++-4.1.2 libstdc++-devel-4.1.2 make-3.81 numactl-devel-0.9.8.i386 sysstat-7.0.2 unixODBC-32bit-2.2.11 unixODBC-devel-2.2.11 [root@server114 Server]# pwd /media/RHEL_5.3 i386 DVD/Server
[root@server114 Server]# [root@localhost Server]# rpm -qa | grep binutils-2.17.50.0.6 binutils-2.17.50.0.6-14.el5 [root@localhost Server]# rpm -qa | grep compat-libstdc++-33-3.2.3 compat-libstdc++-33-3.2.3-61 [root@localhost Server]# rpm -qa | grep elfutils-libelf elfutils-libelf-devel-static-0.137-3.el5 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-0.137-3.el5 [root@localhost Server]# rpm -qa | grep gcc-4.1.2 libgcc-4.1.2-50.el5 gcc-4.1.2-50.el5 [root@localhost Server]# rpm -qa | grep gcc-c++-4.1.2 gcc-c++-4.1.2-50.el5 [root@localhost Server]# rpm -qa |grep glibc-2.5 glibc-2.5-58 [root@localhost Server]# rpm -qa | grep glibc-common glibc-common-2.5-58 [root@localhost Server]# rpm -qa | grep glibc-devel glibc-devel-2.5-58 [root@localhost Server]# rpm -qa | grep glibc-headers glibc-headers-2.5-58 compat-glibc-headers-2.3.4-2.26 [root@localhost Server]# rpm -qa | grep kernel-headers-2.6.18 kernel-headers-2.6.18-238.el5 [root@localhost Server]# rpm -qa | grep ksh ksh-20100202-1.el5_5.1 [root@localhost Server]# rpm -qa | grep libaio libaio-0.3.106-5 [root@localhost Server]# rpm -qa | grep libaio-devel [root@server114 Server]# rpm -Uvh libaio-devel-0.3.106-3.2.i386.rpm warning: libaio-devel-0.3.106-3.2.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186 Preparing... ########################################### [100%]
1:libaio-devel ########################################### [100%] [root@server114 Server]# rpm -qa | grep libgcc-4.1.2 libgcc-4.1.2-44.el5 [root@server114 Server]# rpm -qa | grep libgomp libgomp-4.3.2-7.el5 [root@server114 Server]# rpm -qa | grep libstdc++ compat-libstdc++-296-2.96-138 libstdc++-devel-4.1.2-44.el5 compat-libstdc++-33-3.2.3-61 libstdc++-4.1.2-44.el5 [root@server114 Server]# rpm -qa | grep make-3.81 make-3.81-3.el5 [root@server114 Server]# rpm -qa | grep numactl-devel [root@server114 Server]# rpm -Uvh numactl-devel-0.9.8-7.el5.i386.rpm warning: numactl-devel-0.9.8-7.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186 Preparing... ########################################### [100%] 1:numactl-devel ########################################### [100%] [root@server114 Server]# [root@server114 Server]# [root@server114 Server]# rpm -qa | grep sysstat-7.0.2 [root@server114 Server]# rpm -ivh sysstat-7.0.2-3.el5.i386.rpm warning: sysstat-7.0.2-3.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186 Preparing... ########################################### [100%] 1:sysstat ########################################### [100%] [root@server114 Server]# rpm -qa | grep unixODBC-32bit-2.2.11 [root@server114 Server]# rpm -ivh unixODBC-* warning: unixODBC-2.2.11-7.1.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186 Preparing... ########################################### [100%] 1:unixODBC ########################################### [ 33%] 2:unixODBC-devel ########################################### [ 67%] 3:unixODBC-kde ########################################### [100%]
[root@server114 Server]# |
- 설치에 필요한 그룹과 사용자 생성 및 수정
[root@localhost Server]# groupadd oinstall
[root@localhost Server]# groupadd oper [root@localhost Server]# usermod -g oinstall -G dba,oper oracle |
- 설치할 사용자의 Resource Limit 값을 확인하고 수정
[root@localhost ~]# vi /etc/security/limits.conf
Oracle soft nproc 2047 Oracle hard nproc 16384 Oracle soft nofile 1024 oracle hard nofile 65536
oracle soft stack 10240 |
- 커널파라미터 설정하기
[root@localhost ~]# vi /etc/sysctl.conf ( 아래 내용 추가 후 저장. 공백, 대소문자 주의) fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586 [root@localhost ~]# sysctl –p // 위 설정값을 적용 |
- oracle 사용자의 환경설정
[root@localhost ~]# vi /home/oracle/.bash_profile
export EDITOR=vi export ORACLE_BASE=/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11g export ORACLE_SID=testdb export LANG=ko_KR.eucKR export ORACLE_TERM=xterm export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949 export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export PATH=$PATH:$ORACLE_HOME/bin
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib [root@server114 Server]# vi /etc/pam.d/login session required pam_limits.so |
- oracle 설치 파일 압축 풀기
[oracle@localhost oracle]# pwd /home/oracle [root@localhost oracle]# ls -l -rw-r--r-- 1 oracle dba 1285396902 Jun 2 2010 linux_11gR2_database_1of2.zip -rw-r--r-- 1 oracle dba 995359177 Jun 2 2010 linux_11gR2_database_2of2.zip
[root@localhost oracle]# unzip linux_11gR2_database_1of2.zip && unzip linux_11gR2_database_2of2.zip
[root@localhost oracle]# chown -R oracle.dba /home/oracle
[root@localhost oracle]# chown -R oracle.dba /app
|
- RHEL4 로그아웃 후 오라클계정으로 로그인.
● Engine(11.2.0.1) 생성
- 새터미널열어서 runInstaller 실행.
[root@server114 oracle]$ cd database [root@server114 database]$ ./runInstaller |
OUI
1. security updates - 체크해제 - next
2. 경고창 - yes
3. install database software only
4. single instance database installation
5. Korean 추가
6 .Enterprise Edition 을 선택한 후 select Options 클릭
8. Oracle Base 와 Oracle Home 디렉토리 설정 (환경설정파일 설정대로 되어 있음)
9. oracle inventory 디렉터리설정
10.관리그룹지정 - 기본값
11. 선행체크사항 점검 - 오른쪽 상단에 ∨ ignore all
12. 요약
13. 엔진설치 진행
14. 루트로 스크립트 실행
15. 설치종료
- 설치 확인
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 13 10:23:32 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
|
● DB생성 (DBCA) : DataBase Configuration Assistant
- 터미널에서 dbca 치면 database configuration assistant 시작
[oracle@server114 oracle]$ dbca |
1. DBCA 시작
2. 수행하고자 하는 작업 선택 - create a database - next
3. DB생성할 템플리트선택 - general purpose - next
4 DB ID - testdb
5. Enterprise Manager 체크해제
6. 계정암호 설정
7. 암호 복잡하게 하라는 경고 - yes
8. 데이터베이스 파일 저장방식 - file system (기본값) - file location variables 버튼눌러 정보확인
9.정보확인
10. Flash Recovery area 지정 - 기본값
11. Sample schema 체크 (연습용 계정을 의미)
12. Memory: SGA 와 PGA 로 사용될 메모리 값 설정 - 기본값 - 세번째 탭(sizing) 이동
13. character set 설정 - 세번째옵션 - KO16MSWIN949 선택
14 위의 화면에서 All initialization Parameters 버튼을 누르면 현재까지 설정되어 있는 주요 파라미터들을 볼수있음
15. 요약
16. create databse
17.확인
18. DB생성시작
19. 생성완료
[oracle@server114 oracle]$ $ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 25 02:09:09 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning option SQL> select status from v$instance; STATUS ---------------- OPEN SQL>  |
| [RAC] OEL5 + Oracle 11g + RAC_ASM (grid 설치) (613) | 2016.03.18 |
|---|---|
| [RAC] OEL5 + Oracle 11g + RAC_ASM (VMware, node1,2설정) (638) | 2016.03.18 |
| [Single] RHEL4 + ORACLE 10g 설치(Silent) (607) | 2016.03.17 |
| [Single] RHEL4 + ORACLE 10g(10.2.0.1) > (10.2.0.4) 설치(OUI) (456) | 2016.03.17 |
| [Single] RHEL3 + ORACLE 9i R2 설치(Silent) (431) | 2016.03.17 |
Install ORACLE 10g on RHEL4
● Engine 생성전
- oracle 계정생성
[root@server114 root]# groupadd –g 5000 dba [root@server114 root]# useradd –g dba oracle [root@server114 root]# passwd oracle |
- winscp 이용해 필요한 설치파일 전송 (window: oracle 10g 설치파일---> linux: /home/oracle 로 전송)
patch patchset /hom/oracle 10201_database_linux32.zip
|
- /etc/sysctl.conf 커널설정하기 (대소문자구분, 공백주의)
[root@server114 root]# vi /etc/sysctl.conf // 기존 내용에 아래의 내용 추가. // 푸티에서 작성시 오른쪽 하단의 글자가 깨져있으면 유니코드전환 후 작성해야함. kernel.shmmax=536870912 kernel.sem=250 32000 100 128 fs.file-max=65536 |
- /etc/security/limits.conf 커널설정하기
[root@server114 root]# vi /etc/security/limits.conf //기존 내용에 아래의 내용 추가. oracle10g soft nproc 2047 |
- /etc/pam.d/login 커널설정하기
[root@server114 root]# vi /etc/pam.d/login //기존 내용에 아래의 내용 추가. session required pam_limits.so |
- RPM설치 ( 설치 CD 3번 연결 후 )
[root@server114 root]# umount /media/cdrecoder [root@server114 root]# mount /media/cdrecoder // CD새로 인식 [root@server114 root]# cd /media/cdrecoder/RedHat/RPMS [root@server114 RPMS]# rpm -ivh libaio-devel-0.3.105-2.i386.rpm 경고: libaio-devel-0.3.105-2.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e 준비 중... ########################################### [100%] 1:libaio-devel ########################################### [100%] [root@server114 RPMS]# cd /home/oracle/patch/ [root@server114 patch]# unzip p4198954_40_LINUX.zip Archive: p4198954_40_LINUX.zip inflating: compat-libcwait-2.1-1.i386.rpm inflating: compat-oracle-rhel4-1.0-5.i386.rpm inflating: README.txt [root@server114 patch]# rpm -ivh compat-libcwait-2.1-1.i386.rpm 준비 중... ########################################### [100%] 1:compat-libcwait ########################################### [100%] [root@server114 patch]# rpm -ivh compat-oracle-rhel4-1.0-5.i386.rpm 준비 중... ########################################### [100%] 1:compat-oracle-rhel4 ###################################### [100%] |
- .bash_profile 환경설정 (oracle 계정)
[root@server114 patch]# su - oracle [oracle@server114 ~]$ vi .bash_profile // 기존 내용에 아래내용 추가 export EDITOR=vi export LD_ASSUME_KERNEL=2.4.19 export ORACLE_BASE=/home/oracle
|
- oracle10g 파일 압축풀기 (root로 작업)
[oracle@server114 ~]$ su - [root@server114 root]# cd /home/oracle [root@server114 oracle]# unzip 10201_database_linux32.zip [root@server114 oracle]# chown -R oracle.dba /home/oracle |
- oraInst.loc 파일생성 (log파일 저장위치를 지정)
[root@server114 oracle]# vi /etc/oraInst.loc inventory_loc=/home/oracle/oraInventory inst_group=dba [root@server114 oracle]# chown -R oracle.dba /etc/oraInst.loc |
- response 파일(enterprise.rsp) 내용수정
[root@server114 oracle]# vi /home/oracle/database/response/enterprise.rsp // 아래의 내용 찾아서 수정 UNIX_GROUP_NAME="dba" ORACLE_HOME="/home/oracle/product/10g" ORACLE_HOME_NAME="OUIHome" COMPONENT_LANGUAGES={"en,ko"} INSTALL_TYPE="EE" n_configurationOption="3" |
- RHEL4 로그아웃 후 오라클계정으로 로그인.
● Engine(10.2.0.1) 생성
- 엔진설치 디렉토리로 이동후 silent 옵션으로 runInstaller 실행
[oracle@server114 oracle]$ cd /home/oracle/database [oracle@server114 Disk1]$ ./runInstaller -silent -responseFile /home/oracle/database/response/enterprise.rsp |
- 엔진 설치완료 후 root로 스크립트 실행
위의 화면이 뜨면 엔진설치 성공. [oracle@server114 database]$ su - Password: [root@server114 ~]# [root@server114 ~]# /home/oracle/product/10g/root.sh Running Oracle10 root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /home/oracle/product/10g Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. |
- 설치 확인
[oracle@server114 database]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 26 15:50:59 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL>
|
- 패치파일 디렉토리로 이동후 압축해제
[oracle@server114 ~]$ cd /home/oracle/patchset [oracle@server114 patchset]$ unzip p6810189_10204_Linux-x86.zip |
- response 파일(patchset.rsp) 내용수정
[oracle@server114 patchset]$ cd /home/oracle/patchset/Disk1/response/ [oracle@server114 response]$ ll 합계 16 -rwxr-xr-x 1 oracle dba 15971 8월 20 2006 patchset.rsp [oracle@server114 response]$ vi patchset.rsp UNIX_GROUP_NAME="dba" FROM_LOCATION="../stage/products.xml" ORACLE_HOME="/home/oracle/product/10g" ORACLE_HOME_NAME="OUIHome" COMPONENT_LANGUAGES={"en,ko"} |
- 엔진 패치
[oracle@server114 response]$ cd /home/oracle/patchset/Disk1 [oracle@server114 Disk1]$ ./runInstaller -silent -responseFile /home/oracle/patchset/Disk1/response/patchset.rsp |
- 패치완료 (새로 putty창 열고 root로 스크립트 실행 )
login as: root root@172.16.133.129's password: Last login: Thu Feb 26 15:20:39 2015 from 172.16.133.1 [root@server114 ~]# /home/oracle/product/10g/root.sh Running Oracle10 root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /home/oracle/product/10g Enter the full pathname of the local bin directory: [/usr/local/bin]: The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ... The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. [root@server114 ~]# |
- 패치확인 (다시 oracle계정으로 로그인한 putty창으로 돌아와서 )
[oracle@server114 Disk1]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 26 16:16:31 2015 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL>
|
● DB생성 (DBCA) : DataBase Configuration Assistant
- response 파일(dbca.rsp) 내용수정
[oracle@server114 Disk1]$ cd /home/oracle/database/response/ [oracle@server114 response]$ [oracle@server114 response]$ vi dbca.rsp GDBNAME="testdb" SID="testdb" TEMPLATENAME="/home/oracle/product/10g/assistants/dbca/templates/New_Database.dbt" CHATACTERSET="KO16MSWIN949" NATIONALCHARACTERSET="UTF8" |
- DBCA 실행
[oracle@server114 response]$cd /home/oracle/product/10g/bin [oracle@server114 bin]$ ./dbca -silent -responseFile /home/oracle/database/response/dbca.rsp
|
[oracle@server114 bin]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Fri Feb 27 16:54:58 2015 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
|
| [RAC] OEL5 + Oracle 11g + RAC_ASM (VMware, node1,2설정) (638) | 2016.03.18 |
|---|---|
| [Single] RHEL5 + ORACLE 11g(11.2.0.1) 설치(OUI) (618) | 2016.03.17 |
| [Single] RHEL4 + ORACLE 10g(10.2.0.1) > (10.2.0.4) 설치(OUI) (456) | 2016.03.17 |
| [Single] RHEL3 + ORACLE 9i R2 설치(Silent) (431) | 2016.03.17 |
| [Single] RHEL3 + ORACLE 9i(9.2.0.4) > (9.2.0.7) > (9.2.0.8) 설치(OUI) (11) | 2016.03.17 |
Install ORACLE 10g on RHEL4
● Engine 생성전
- oracle 계정생성
[root@server114 root]# groupadd –g 5000 dba [root@server114 root]# useradd –g dba oracle [root@server114 root]# passwd oracle |
- winscp 이용해 필요한 설치파일 전송 (window: oracle 10g 설치파일---> linux: /home/oracle 로 전송)
patch patchset /hom/oracle 10201_database_linux32.zip
|
- /etc/sysctl.conf 커널설정하기 (대소문자구분, 공백주의)
[root@server114 root]# vi /etc/sysctl.conf // 기존 내용에 아래의 내용 추가. // 푸티에서 작성시 오른쪽 하단의 글자가 깨져있으면 유니코드전환 후 작성해야함. kernel.shmmax=536870912 kernel.sem=250 32000 100 128 fs.file-max=65536 |
- /etc/security/limits.conf 커널설정하기
[root@server114 root]# vi /etc/security/limits.conf //기존 내용에 아래의 내용 추가. oracle10g soft nproc 2047 |
- /etc/pam.d/login 커널설정하기
[root@server114 root]# vi /etc/pam.d/login //기존 내용에 아래의 내용 추가. session required pam_limits.so |
- RPM설치 ( 설치 CD 3번 연결 후 )
[root@server114 root]# umount /media/cdrecoder [root@server114 root]# mount /media/cdrecoder // CD새로 인식
[root@server114 root]# cd /media/cdrecoder/RedHat/RPMS [root@server114 RPMS]# rpm -ivh libaio-devel-0.3.105-2.i386.rpm 경고: libaio-devel-0.3.105-2.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e 준비 중... ########################################### [100%] 1:libaio-devel ########################################### [100%] [root@server114 RPMS]# cd /home/oracle/patch/ [root@server114 patch]# unzip p4198954_40_LINUX.zip Archive: p4198954_40_LINUX.zip inflating: compat-libcwait-2.1-1.i386.rpm inflating: compat-oracle-rhel4-1.0-5.i386.rpm inflating: README.txt [root@server114 patch]# rpm -ivh compat-libcwait-2.1-1.i386.rpm 준비 중... ########################################### [100%] 1:compat-libcwait ########################################### [100%] [root@server114 patch]# rpm -ivh compat-oracle-rhel4-1.0-5.i386.rpm 준비 중... ########################################### [100%] 1:compat-oracle-rhel4 ###################################### [100%] |
- .bash_profile 환경설정 (oracle 계정)
[root@server114 patch]# su - oracle [oracle@server114 ~]$ vi .bash_profile // 기존 내용에 아래내용 추가 export EDITOR=vi export LD_ASSUME_KERNEL=2.4.19 export ORACLE_BASE=/home/oracle
|
- oracle10g 파일 압축풀기 (root로 작업)
[oracle@server114 ~]$ su - [root@server114 root]# cd /home/oracle [root@server114 oracle]# unzip 10201_database_linux32.zip [root@server114 oracle]# chown -R oracle.dba /home/oracle |
- RHEL4 로그아웃 후 오라클계정으로 로그인.
●Engine(10.2.0.1) 생성
- 새터미널열어서 runInstaller 실행.
[root@server114 oracle]$ cd database [root@server114 database]$ ./runInstaller |
OUI
1.설치방식선택 - 고급설치 - 다음
2. 인벤토리 디렉토리에 대한 전체경로 입력 - 다음
3. 설치유형 선택 - Enterprise Edition - 다음
4. 홈 세부 정보 지정 - 다음
5. 제품별 필요 조건 검사 
6. 상태항목에서 실행되지 않음 체크 하고 다음 
6. 구성 옵션 선택 - 데이터베이스 소프트웨어만 설치
7. 요약 - 설치
8. 설치 
9. 터미널 열고 루트계정으로 스크립트 실행 
# /home/oracle/oraInventory/oraInstRoot.sh
# /home/oracle/product/10g/root.sh
10. 설치종료 - 종료 
●Engine (10.2.0.4) 패치
- 엔진설치 확인 후 패치실행
[oracle@server114 ~]$ [oracle@server114 ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 17 10:24:03 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> exit [oracle@server114 ~]$ [oracle@server114 ~]$ cd /home/oracle/patchset [oracle@server114 patchset]$ ls p4679769_10201_LINUX.zip p8202632_10205_LINUX.zip p6810189_10204_Linux-x86.zip [oracle@server114 patchset]$ unzip p6810189_10204_Linux-x86.zip ..... [oracle@server114 patchset]$ ls [oracle@server114 patchset]$ cd Disk1 [oracle@server114 Disk1]$ ./runInstaller |
1. 시작
2. 제품별 필요 조건 검사 - 상태: 성공함 확인 후 - 다음 
3. 오라클 구성 매니져 등록 - 활성화체크 해제 - 다음 
4. 요약 - 설치 
5. 설치시작
6. 루트로 스크립트 실행. 
# /home/oracle/product/10g/root.sh -> Enter -> y,y,y
7. 패치설치 종료
● DB생성 (DBCA) : DataBase Configuration Assistant
- 터미널에서 dbca 치면 database configuration assistant 시작
[oracle@server114 oracle]$ dbca |
1.시작
2.수행하고자 하는 작업 선택 - 데이터베이스 생성
3. 생설할 템플리트 선택 - 범용 - 다음
4. 데이터베이스 ID - testdb
5. 관리옵션 - Enterprise Manager 사용해 데이터베이스 구성 체크해제 - 다음 
6. 데이터베이스 인증서 - 모든계정에 동일한 암호사용 : 암호설정후 - 다음
7.저장영역옵션 - 파일시스템 - 다음
8. 데이터베이스 파일위치 - 템플리트에서 데이터베이스 파일위치 사용 - 다음
9. 복구구성 - 플래시 복구 영역 지정 체크 - 다음
10. 데이터베이스내용 - 샘플스키마 체크 - 다음
11. 초기화 매개변수 - 기본
12. 데이터베이스 저장영역 - 다음
13. 생성옵션 - 데이터베이스 생성 - 완료
14. 확인
15. 데이터베이스 생성 시작
16. 생성완료 - 종료
- DB생성(10.2.0.4) 확인
[oracle@server114 oracle]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Tue Feb 17 12:44:15 2015 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ....... SQL> select status from v$instance; STATUS -------------------------------- OPEN SQL>
|
| [Single] RHEL5 + ORACLE 11g(11.2.0.1) 설치(OUI) (618) | 2016.03.17 |
|---|---|
| [Single] RHEL4 + ORACLE 10g 설치(Silent) (607) | 2016.03.17 |
| [Single] RHEL3 + ORACLE 9i R2 설치(Silent) (431) | 2016.03.17 |
| [Single] RHEL3 + ORACLE 9i(9.2.0.4) > (9.2.0.7) > (9.2.0.8) 설치(OUI) (11) | 2016.03.17 |
| [Single] RHEL3 + ORACLE 8i(8.1.7.0) 설치(OUI) (9) | 2016.03.17 |
Install ORACLE 9i R2 on RHEL3
192.168.15.114
255.255.0.0
192.168.0.1
168.126.63.1
● Engine 생성전
- oracle 계정생성
[root@server114 root]# groupadd –g 5000 dba [root@server114 root]# useradd –g dba oracle [root@server114 root]# passwd oracle |
- winscp 이용해 필요한 설치파일 전송 (window: oracle9i install---> linux: /home/oracle 로 전송)
|
- 공유메모리 확인
[root@server114 root]# echo '2147483648' > /proc/sys/kernel/shmmax [root@server114 root]# vi /etc/rc.d/rc.local <- 공유메모리확인 내용 등록함. #!/bin/sh # # This script will be executed *after* all the other init scripts. # You can put your own initialization stuff in here if you don't # want to do the full Sys V style init stuff. touch /var/lock/subsys/local echo ‘2147483648’ > /proc/sys/kernel/shmmax |
- ship_9204_linux_disk 압축풀기
[root@server114 oracle]# cd /home/oracle/install [root@server114 install]# ll 합계 1570140 drwxr-xr-x 2 root root 4096 2월 17 15:52 font drwxr-xr-x 2 root root 4096 2월 17 15:52 patch drwxr-xr-x 2 root root 4096 2월 17 15:54 patchset drwxr-xr-x 2 root root 4096 2월 17 15:55 rpm -rw-r--r-- 1 root root 659577856 3월 25 2004 ship_9204_linux_disk1.cpio -rw-r--r-- 1 root root 646914048 3월 25 2004 ship_9204_linux_disk2.cpio -rw-r--r-- 1 root root 299722752 3월 25 2004 ship_9204_linux_disk3.cpio [root@server114 install]# [root@server114 install]# cpio -idmv < ship_9204_linux_disk1.cpio && cpio -idmv < ship_9204_linux_disk2.cpio && cpio -idmv < ship_9204_linux_disk3.cpio |
- RPM 설치 (rpm -Uvh compat-libgc*.rpm 하면 자동으로 순서대로 설치해줌)
[root@server114 font]# cd /home/oracle/install/rpm [root@server114 rpm]# rpm -Uvh compat-libgc* 경고: compat-libgcj-7.3-2.96.118.i386.rpm: V3 DSA signature: NOKEY, key ID db42a 60e 준비 중... ########################################### [100%] 1:compat-libgcj ########################################### [ 50%] 2:compat-libgcj-devel ########################################### [100%]
|
- 오라클 계정의 .bash_profile 파일설정. (기존파일에 아래내용을 추가)
[root@server114 rpm]# chown -R oracle.dba /home/oracle [root@server114 rpm]# su - oracle [oracle@server114 oracle]$ vi .bash_profile export DISPLAY=localhost:0.0 export ORACLE_BASE=/home/oracle export ORACLE_HOME=$ORACLE_BASE/product/9.2 export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH export ORACLE_OWNER=oracle export ORACLE_SID=testdb export ORACLE_TERM=xterm export LD_ASSUME_KERNEL=2.4.1 export THREADS_FLAG=native export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949 export LANG=ko_KR.eucKR
|
- bash_profile 수정완료후 root계정으로 su - 해서 9204 압축풀고 패치실행
[root@server114 root]# [root@server114 root]# cd /home/oracle/install/patch [root@server114 patch]# ls 9i_opatch_p6880880_101000_LINUX.zip p3238244_9204_LINUX.zip p3006854_9204_LINUX.zip register97.hwp [root@server114 patch]# unzip p3006854_9204_LINUX.zip Archive: p3006854_9204_LINUX.zip creating: 3006854/ inflating: 3006854/rhel3_pre_install.sh inflating: 3006854/README.txt [root@server114 patch]# ls 3006854 p3006854_9204_LINUX.zip register97.hwp 9i_opatch_p6880880_101000_LINUX.zip p3238244_9204_LINUX.zip [root@server114 patch]# cd 3006854 [root@server114 3006854]# ls README.txt rhel3_pre_install.sh [root@server114 3006854]# sh rhel3_pre_install.sh Applying patch... Ensuring permissions are correctly set... Done. Patch successfully applied |
- oraInst.loc 파일생성 (설치될 s/w log파일 저장위치를 지정)
[root@server114 oracle]# vi /etc/oraInst.loc inventory_loc=/home/oracle/oraInventory inst_group=dba [root@server114 oracle]# chown -R oracle.dba /etc/oraInst.loc |
- response 파일(enterprise.rsp) 내용수정
[root@server114 oracle]# vi /home/oracle/install/Disk1/response/enterprise.rsp // 아래의 내용 찾아서 수정 UNIX_GROUP_NAME="dba" ORACLE_HOME="/home/oracle/product/9.2" ORACLE_HOME_NAME="OUIHome" COMPONENT_LANGUAGES={"en,ko"} INSTALL_TYPE="EE" s_cfgtyperet="Software Only"
* Enterprise.rsp 파일을 수정해도 되고 아래와 같이 옵션을 다 적어서 실행해도 똑같음
Ex) ./runInstaller -silent -force -debug FROM_LOCATION="/home/oracle/Disk1/stage/products.jar" ORACLE_HOME= "/home/oracle/Disk1/OraHome" ORACLE_HOME_NAME="OraHome" TOPLEVEL_COMPONENT= '{"oracle.server","9.2.0.4.0"}' INSTALL_TYPE="EE" |
● Engine (9.2.0.4) 생성 - Silent mode
- 오라클계정으로 다시 로그인 한후 ./runInstaller 실행
- 엔진설치 디렉토리로 이동후 silent 옵션으로 runInstaller 실행
[oracle@server114 oracle]$ cd /home/oracle/install/Disk1 [oracle@server114 Disk1]$ ./runInstaller -silent -responseFile /home/oracle/install/Disk1/response/enterprise.rsp |
- 엔진 설치시작
위의 화면이 뜨면 엔진설치 성공. |
- 설치 확인
[oracle@server114 Disk1]$ sqlplus /nolog SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 25 17:48:23 2015 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> |
● Engine (9.2.0.8) 패치
- 패치파일 디렉토리로 이동후 압축해제
[oracle@server114 Disk1]$ cd /home/oracle/install/patchset [oracle@server114 patchset]$ unzip p4547809_92080_LINUX.zip |
- response 파일(patchset.rsp) 내용수정
[oracle@server114 patchset]$ cd /home/oracle/install/patchset/Disk1/response/ [oracle@server114 response]$ ll 합계 16 -rwxr-xr-x 1 oracle dba 15971 8월 20 2006 patchset.rsp [oracle@server114 response]$ vi patchset.rsp UNIX_GROUP_NAME="dba" FROM_LOCATION="/home/oracle/install/patchset/Disk1/stage/products.xml" ORACLE_HOME="/home/oracle/product/9.2" ORACLE_HOME_NAME="OUIHome"
|
- 엔진 패치
[oracle@server114 response]$ cd /home/oracle/install/patchset/Disk1 [oracle@server114 Disk1]$ ./runInstaller -silent -responseFile /home/oracle/install/patchset/Disk1/response/patchset.rsp |
- 패치완료 -> root로 스크립트 실행
[oracle@server114 Disk1]$ su - Password: [root@server114 root]# /home/oracle/product/9.2/root.sh Running Oracle9 root.sh script... \nThe following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /home/oracle/product/9.2 Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... \nCreating /etc/oratab file... Adding entry to /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. [root@server114 root]# |
- 리스너구성(netca) 실행
login as: oracle oracle@192.168.15.114's password: [oracle@server114 oracle]$ cd /home/oracle/product/9.2/bin [oracle@server114 bin]$ [oracle@server114 bin]$ ./netca /silent /responseFile /home/oracle/install/Disk1/response/netca.rsp 명령줄 인수 분석: 매개변수 "silent" = true 매개변수 "responsefile" = /home/oracle/install/Disk1/response/netca.rsp 명령줄 인수 분석을 완료했습니다. Oracle Net Service 구성: 프로파일 구성이 완료되었습니다. Oracle Net 리스너 시작: 실행 중인 리스너 제어: /home/oracle/product/9.2/bin/lsnrctl start LISTENER 리스너 제어가 완료되었습니다. 리스너가 성공적으로 시작되었습니다. 리스너 구성이 완료되었습니다. 기본 로컬 이름 지정 구성을 완료했습니다. Oracle Net Service 구성을 성공했습니다. 종료 코드는 다음과 같습니다. 0 // 종료코드가 0이면 리스너가 정상적으로 구성됨 |
● DB생성 (DBCA) : DataBase Configuration Assistant
- response 파일(dbca.rsp) 내용수정
[oracle@server114 bin]$ cd /home/oracle/install/Disk1/response/ [oracle@server114 response]$ [oracle@server114 response]$ vi dbca.rsp CREATE_TYPE="createDatabase" GDBNAME="testdb" SID="testdb" TEMPLATENAME="New Database" CHATACTERSET="KO16MSWIN949" NATIONALCHARACTERSET="UTF8" |
- DBCA 실행
[oracle@server114 response]$cd /home/oracle/product/9.2/bin [oracle@server114 bin]$ ./dbca -silent -responseFile /home/oracle/install/Disk1/response/dbca.rsp
|
- 생성확인
[oracle@server114 bin]$ sqlplus /nolog SQL*Plus: Release 9.2.0.8.0 - Production on Wed Feb 25 20:10:05 2015 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> conn /as sysdba Connected. SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production PL/SQL Release 9.2.0.8.0 - Production CORE 9.2.0.8.0 Production TNS for Linux: Version 9.2.0.8.0 - Production NLSRTL Version 9.2.0.8.0 - Production SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> conn /as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 235999648 bytes Fixed Size 450976 bytes Variable Size 201326592 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> select status from v$instance; STATUS ------------ OPEN SQL> |
| [Single] RHEL5 + ORACLE 11g(11.2.0.1) 설치(OUI) (618) | 2016.03.17 |
|---|---|
| [Single] RHEL4 + ORACLE 10g 설치(Silent) (607) | 2016.03.17 |
| [Single] RHEL4 + ORACLE 10g(10.2.0.1) > (10.2.0.4) 설치(OUI) (456) | 2016.03.17 |
| [Single] RHEL3 + ORACLE 9i(9.2.0.4) > (9.2.0.7) > (9.2.0.8) 설치(OUI) (11) | 2016.03.17 |
| [Single] RHEL3 + ORACLE 8i(8.1.7.0) 설치(OUI) (9) | 2016.03.17 |
