:: 작업장

<Oracle 설치 준비>

터미널창을 연뒤에 진행.

앞에 프롬프트를 지우기위해 notepad에 복사하여 alt + h를 이용하여 지우면 편함.

1.설치 Software 준비

[root@edydr1p1 ~]# cd /mnt/hgfs/Share

[root@edydr1p1 share]# cp *.zip /stage/

[root@edydr1p1 share]# cp RPM/* /stage/

[root@edydr1p1 share]# cd /stage

[root@edydr1p1 stage]# unzip linux.x64_11gR2_grid_infra.zip

[root@edydr1p1 stage]# unzip linux.x64_11gR2_database_1of2.zip

[root@edydr1p1 stage]# unzip linux.x64_11gR2_database_2of2.zip

[root@edydr1p1 stage]# rm -f linux.x64_11gR2_database*

[root@edydr1p1 stage]# rm -f linux.x64_11gR2_grid_infra.zip

위의 명령어를 입력

2. VM세팅 클릭

3. 하드웨어 - cd - Use ISO image - 브라우져 클릭하여 ISO 변경

4. cd/media/En +tab키 /server/ 엔터  (tab 키를 누르면 자동으로 찾아줍니다)

- ls 명령어를 치면 파일들이 있는 것을 확인 할 수있습니다.

5. 필요 패키지 설치 및 기본 설정 구성

다음 명령어 입력.

[root@edydr1p1 ~]# rpm -Uvh binutils-2.*

[root@edydr1p1 ~]# rpm -Uvh compat-libstdc++-33*

[root@edydr1p1 ~]# rpm -Uvh compat-libstdc++-33*.i386.rpm

[root@edydr1p1 ~]# rpm -Uvh elfutils-libelf*

[root@edydr1p1 ~]# rpm -Uvh gcc-4.*

[root@edydr1p1 ~]# rpm -Uvh gcc-c++-4.*

[root@edydr1p1 ~]# rpm -Uvh glibc-2.*

[root@edydr1p1 ~]# rpm -Uvh glibc-common-2.*

[root@edydr1p1 ~]# rpm -Uvh glibc-devel-2.*

[root@edydr1p1 ~]# rpm -Uvh glibc-headers-2.*

[root@edydr1p1 ~]# rpm -Uvh ksh*

[root@edydr1p1 ~]# rpm -Uvh libaio-0.*

[root@edydr1p1 ~]# rpm -Uvh libaio-devel-0.*

[root@edydr1p1 ~]# rpm -Uvh libgomp-4.*

[root@edydr1p1 ~]# rpm -Uvh libgcc-4.*

[root@edydr1p1 ~]# rpm -Uvh libstdc++-4.*

[root@edydr1p1 ~]# rpm -Uvh libstdc++-devel-4.*

[root@edydr1p1 ~]# rpm -Uvh make-3.*

[root@edydr1p1 ~]# rpm -Uvh sysstat-7.*

[root@edydr1p1 ~]# rpm -Uvh unixODBC-2.*

[root@edydr1p1 ~]# rpm -Uvh unixODBC-devel-2.*

[root@edydr1p1 ~]# rpm -Uvh numactl-devel-*

[root@edydr1p1 ~]# rpm -Uvh unixODBC-2.2.11-7.1.i386.rpm

6. 인터넷에서 필요한 부분 자동 다운로드 하기 위함 (굳이 안해도 된다고 하셨음)

[root@edydr1p1 ~]# cd /etc/yum.repos.d

[root@edydr1p1 yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo

[root@edydr1p1 yum.repos.d]# yum install oracle-validated

위의 명령어 입력

이하 문장은 결과창으로써 Y를 입력하며 진행

Total download size: 43 M

Is this ok [y/N]: y    

...

Importing GPG key 0x1E5E0159 "Oracle OSS group (Open Source Software group)

<build@oss.oracle.com>" from http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5

Is this ok [y/N]: y

[root@edydr1p1 yum.repos.d]# yum install unixODBC

Total download size: 290 k

Is this ok [y/N]: y

...

Installed:

unixODBC.i386 0:2.2.11-10.el5

Complete!

/*****************   VI 편집기 기본적인 명령어     **********************/

7. 호스트 수정

vi /etc/hosts 입력

================================================================

# Do not remove the following line, or various programs

# that require network functionality will fail.

192.168.100.100 edydr1p0.us.oracle.com edydr1p0

127.0.0.1 edydr1p0.us.oracle.com edydr1p0 localhost.localdomain localhost

아이피 주소와 edydr1p0 수정

8. vi /etc/sysctl.conf 편집

vi /etc/sysctl.conf 들어가서 가장 아래에  추가

# for Oracle Database 11gR2

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 4294967295

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 = 1048576

9. vi /etc/security/limits.conf 편집

vi /etc/security/limits.conf 들어가서 가장 아래에 추가

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 4096

oracle hard nofile 65536

oracle soft stack 10240

10. Oracle User 생성

[root@edydr1p1 ~]# userdel oracle

[root@edydr1p1 ~]# groupdel oinstall

[root@edydr1p1 ~]# groupdel dba

[root@edydr1p1 ~]# groupdel oper

[root@edydr1p1 ~]# rm -rf /home/oracle

[root@edydr1p1 ~]# groupadd oinstall

[root@edydr1p1 ~]# groupadd dba

[root@edydr1p1 ~]# groupadd oper

[root@edydr1p1 ~]# useradd -g oinstall -G dba,oper oracle

Creating mailbox file: File exists

[root@edydr1p1 ~]# passwd oracle

Changing password for user oracle.

New UNIX password: oracle

BAD PASSWORD: it is based on a dictionary word

Retype new UNIX password: oracle

passwd: all authentication tokens updated successfully.

/////////****************  설명  ****************//////////

userdel oracle           //이미 있으면 지우라는 명령어

groupdel oinstall         //이미 있으면 지우라는 명령어

groupdel dba              //이미 있으면 지우라는 명령어

groupdel oper            //이미 있으면 지우라는 명령어 

rm -rf /home/oracle    //해당 유저의 홈디렉토리 지우라는 명령어

groupadd oinstall

groupadd dba

groupadd oper

useradd -g oinstall -G dba,oper oracle 

//오라클이란 유져를 기본 그룹 oinstall dba와 oper란 그룹에도 포함시키는 명령어

Creating mailbox file: File exists

[root@edydr1p1 ~]# passwd oracle                //패스워드 설정

Changing password for user oracle.              // 이것도 오라클 입력

10. vi /home/oracle/.bash_profile

가장 아래에 추가

# Oracle Settings

export PS1="[\u@\h-\`echo \$ORACLE_SID\` \W]$ "

export LANG=C

export ORACLE_BASE=/u01/app/oracle

export PATH=/usr/java/jdk1.6.0_18/bin:$PATH

11. 다음 명령 수행

[root@edydr1p1 ~]# chown oracle:oinstall /home/oracle/.bash_profile

12.필요 디렉토리 생성 및 권한 부여

[root@edydr1p1 ~]# mkdir -p /u01/app/oracle

[root@edydr1p1 ~]# chown -R oracle:oinstall /u01

[root@edydr1p1 ~]# chmod -R 775 /u01

[root@edydr1p1 ~]# mkdir /stage   /* 스테이지 이미 만들었으니 안해도됨 */

[root@edydr1p1 ~]# chown -R oracle:oinstall /stage

13.추가 구성

mv /etc/ntp.conf /etc/ntp.conf.org

후 cd /stage

14. ASM Library 및 추가 패키지 설치

[root@edydr1p1 stage]# rpm -Uvh flash-plugin-11.2.202.235-release.x86_64.rpm

//플래쉬 설치

[root@edydr1p1 stage]# rm -f flash-plugin-11.2.202.235-release.x86_64.rpm //플래쉬 설치 후 설치파일 제거.

15. asm디스크를 만들기 위한 ASM Library 및 추가 패키지 설치

 (설치 설명 pdf 와 순서가 바뀌었습니다.)

입력:

[root@edydr1p1 stage]# rpm -Uvh oracleasm-support-2.1.7-1.el5.x86_64.rpm

결과:

Preparing... ########################################### [100%]

1:oracleasm-support ########################################### [100%]

입력:

[root@edydr1p1 stage]# rpm -Uvh oracleasm-2.6.18-92.el5-2.0.5-1.el5.x86_64.rpm

결과:

Preparing... ########################################### [100%]

1:oracleasm-2.6.18-92.el5########################################### [100%]

입력:

[root@edydr1p1 stage]# rpm -Uvh oracleasmlib-2.0.4-1.el5.x86_64.rpm 

결과:

Preparing... ########################################### [100%]

1:oracleasmlib ########################################### [100%]

입력:

[root@edydr1p1 stage]# rm -rf oracleasm*

[root@edydr1p1 stage]# chmod 755 jdk-6u18-linux-x64.bin

[root@edydr1p1 stage]# mkdir /usr/java

[root@edydr1p1 stage]# cd /usr/java/

[root@edydr1p1 java]# mv /stage/jdk-6u18-linux-x64.bin . 

// .의 의미는 현재 있는곳으로 옮기자는 것 입니다.

[root@edydr1p1 java]# ./jdk-6u18-linux-x64.bin

[root@edydr1p1 java]# rm -f jdk-6u18-linux-x64.bin

Do you agree to the above license terms? [yes or no]

yes   // yes 입력

Press Enter to continue.....

Done.

[root@edydr1p1 java]# rm -f jdk-6u18-linux-x64.bin

16.ASM Disk 준비

[root@edydr1p1 ~]# mkdir -p /u01/asmdisks

[root@edydr1p1 ~]# chown -R oracle:oinstall /u01/asmdisks

[root@edydr1p1 ~]# chmod 666 /u01/asmdisks

[root@edydr1p1 ~]# cd /u01/asmdisks

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_01 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_02 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_03 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_04 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_05 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_06 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_07 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_08 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_09 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_10 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_11 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_12 bs=1024k count=2304

[root@edydr1p1 asmdisks]# dd if=/dev/zero of=_file_disk_13 bs=1024k count=2304

[root@edydr1p1 asmdisks]# chmod 666 _file_disk*

- 입력

[root@edydr1p1 asmdisks]# vi /etc/modprobe.conf

options loop max_loop=32     //가장 아래에 추가

- 아래의 명령어 입력

[root@edydr1p1 ~]# losetup /dev/loop1 /u01/asmdisks/_file_disk_01

[root@edydr1p1 ~]# losetup /dev/loop2 /u01/asmdisks/_file_disk_02

[root@edydr1p1 ~]# losetup /dev/loop3 /u01/asmdisks/_file_disk_03

[root@edydr1p1 ~]# losetup /dev/loop4 /u01/asmdisks/_file_disk_04

[root@edydr1p1 ~]# losetup /dev/loop5 /u01/asmdisks/_file_disk_05

[root@edydr1p1 ~]# losetup /dev/loop6 /u01/asmdisks/_file_disk_06

[root@edydr1p1 ~]# losetup /dev/loop7 /u01/asmdisks/_file_disk_07

[root@edydr1p1 ~]# losetup /dev/loop8 /u01/asmdisks/_file_disk_08

[root@edydr1p1 ~]# losetup /dev/loop9 /u01/asmdisks/_file_disk_09

[root@edydr1p1 ~]# losetup /dev/loop10 /u01/asmdisks/_file_disk_10

[root@edydr1p1 ~]# losetup /dev/loop11 /u01/asmdisks/_file_disk_11

[root@edydr1p1 ~]# losetup /dev/loop12 /u01/asmdisks/_file_disk_12

[root@edydr1p1 ~]# losetup /dev/loop13 /u01/asmdisks/_file_disk_13

[root@edydr1p1 ~]# ln -s /dev/loop1 /dev/xvdb

[root@edydr1p1 ~]# ln -s /dev/loop2 /dev/xvdc

[root@edydr1p1 ~]# ln -s /dev/loop3 /dev/xvdd

[root@edydr1p1 ~]# ln -s /dev/loop4 /dev/xvde

[root@edydr1p1 ~]# ln -s /dev/loop5 /dev/xvdf

[root@edydr1p1 ~]# ln -s /dev/loop6 /dev/xvdg

[root@edydr1p1 ~]# ln -s /dev/loop7 /dev/xvdh

[root@edydr1p1 ~]# ln -s /dev/loop8 /dev/xvdi

[root@edydr1p1 ~]# ln -s /dev/loop9 /dev/xvdj

[root@edydr1p1 ~]# ln -s /dev/loop10 /dev/xvdk

[root@edydr1p1 ~]# ln -s /dev/loop11 /dev/xvdl

[root@edydr1p1 ~]# ln -s /dev/loop12 /dev/xvdm

[root@edydr1p1 ~]# ln -s /dev/loop13 /dev/xvdn

[root@edydr1p1 ~]# chmod 666 /dev/loop1

[root@edydr1p1 ~]# chmod 666 /dev/loop2

[root@edydr1p1 ~]# chmod 666 /dev/loop3

[root@edydr1p1 ~]# chmod 666 /dev/loop4

[root@edydr1p1 ~]# chmod 666 /dev/loop5

[root@edydr1p1 ~]# chmod 666 /dev/loop6

[root@edydr1p1 ~]# chmod 666 /dev/loop7

[root@edydr1p1 ~]# chmod 666 /dev/loop8

[root@edydr1p1 ~]# chmod 666 /dev/loop9

[root@edydr1p1 ~]# chmod 666 /dev/loop10

[root@edydr1p1 ~]# chmod 666 /dev/loop11

[root@edydr1p1 ~]# chmod 666 /dev/loop12

[root@edydr1p1 ~]# chmod 666 /dev/loop13

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop1

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop2

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop3

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop4

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop5

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop6

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop7

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop8

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop9

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop10

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop11

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop12

[root@edydr1p1 ~]# chown oracle:oinstall /dev/loop13

- VI 편집

[root@edydr1p1 ~]# vi /etc/rc5.d/S91ora_start

-  가장 아래에 밑의 내용 추가

#!/bin/bash

#

# description: Start Oracle ASM Disk after reboots

su - root -c '/sbin/modprobe loop'

su - root -c 'losetup /dev/loop1 /u01/asmdisks/_file_disk_01'

su - root -c 'losetup /dev/loop2 /u01/asmdisks/_file_disk_02'

su - root -c 'losetup /dev/loop3 /u01/asmdisks/_file_disk_03'

su - root -c 'losetup /dev/loop4 /u01/asmdisks/_file_disk_04'

su - root -c 'losetup /dev/loop5 /u01/asmdisks/_file_disk_05'

su - root -c 'losetup /dev/loop6 /u01/asmdisks/_file_disk_06'

su - root -c 'losetup /dev/loop7 /u01/asmdisks/_file_disk_07'

su - root -c 'losetup /dev/loop8 /u01/asmdisks/_file_disk_08'

su - root -c 'losetup /dev/loop9 /u01/asmdisks/_file_disk_09'

su - root -c 'losetup /dev/loop10 /u01/asmdisks/_file_disk_10'

su - root -c 'losetup /dev/loop11 /u01/asmdisks/_file_disk_11'

su - root -c 'losetup /dev/loop12 /u01/asmdisks/_file_disk_12'

su - root -c 'losetup /dev/loop13 /u01/asmdisks/_file_disk_13'

su - root -c 'ln -s /dev/loop1 /dev/xvdb'

su - root -c 'ln -s /dev/loop2 /dev/xvdc'

su - root -c 'ln -s /dev/loop3 /dev/xvdd'

su - root -c 'ln -s /dev/loop4 /dev/xvde'

su - root -c 'ln -s /dev/loop5 /dev/xvdf'

su - root -c 'ln -s /dev/loop6 /dev/xvdg'

su - root -c 'ln -s /dev/loop7 /dev/xvdh'

su - root -c 'ln -s /dev/loop8 /dev/xvdi'

su - root -c 'ln -s /dev/loop9 /dev/xvdj'

su - root -c 'ln -s /dev/loop10 /dev/xvdk'

su - root -c 'ln -s /dev/loop11 /dev/xvdl'

su - root -c 'ln -s /dev/loop12 /dev/xvdm'

su - root -c 'ln -s /dev/loop13 /dev/xvdn'

su - root -c 'chmod 666 /dev/loop1'

su - root -c 'chmod 666 /dev/loop2'

su - root -c 'chmod 666 /dev/loop3'

su - root -c 'chmod 666 /dev/loop4'

su - root -c 'chmod 666 /dev/loop5'

su - root -c 'chmod 666 /dev/loop6'

su - root -c 'chmod 666 /dev/loop7'

su - root -c 'chmod 666 /dev/loop8'

su - root -c 'chmod 666 /dev/loop9'

su - root -c 'chmod 666 /dev/loop10'

su - root -c 'chmod 666 /dev/loop11'

su - root -c 'chmod 666 /dev/loop12'

su - root -c 'chmod 666 /dev/loop13'

su - root -c 'chown oracle:oinstall /dev/loop1'

su - root -c 'chown oracle:oinstall /dev/loop2'

su - root -c 'chown oracle:oinstall /dev/loop3'

su - root -c 'chown oracle:oinstall /dev/loop4'

su - root -c 'chown oracle:oinstall /dev/loop5'

su - root -c 'chown oracle:oinstall /dev/loop6'

su - root -c 'chown oracle:oinstall /dev/loop7'

su - root -c 'chown oracle:oinstall /dev/loop8'

su - root -c 'chown oracle:oinstall /dev/loop9'

su - root -c 'chown oracle:oinstall /dev/loop10'

su - root -c 'chown oracle:oinstall /dev/loop11'

su - root -c 'chown oracle:oinstall /dev/loop12'

su - root -c 'chown oracle:oinstall /dev/loop13'

su - root -c 'oracleasm scandisks'

편집기 닫습니다

- 입력:

[root@edydr1p1 ~]# chmod 777 /etc/rc5.d/S91ora_start

root@edydr1p1 ~]# reboot // reboot 명령어 실행하여 재부팅

17. 강사님이 올린 파일 다시 다운로드

cd /stage

cd /mnt/hgfs/share/oracleasm-2.6. 18-164

rpm - uvh oracleasm-2.6.18-164.

cd /dev

ls xvd*          //입력하여 13개나오는지 확인.

18.ASM Disk 생성

[root@edydr1p1 ~]# 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 []: dba

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

Writing Oracle ASM library driver configuration: done

[root@edydr1p1 ~]# oracleasm exit

[root@edydr1p1 ~]# oracleasm init

Creating /dev/oracleasm mount point: /dev/oracleasm

Loading module "oracleasm": oracleasm

Mounting ASMlib driver filesystem: /dev/oracleasm

[root@edydr1p1 ~]# oracleasm status

Checking if ASM is loaded: yes

Checking if /dev/oracleasm is mounted: yes

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK01 /dev/xvdb

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK02 /dev/xvdc

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK03 /dev/xvdd

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK04 /dev/xvde

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK05 /dev/xvdf

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK06 /dev/xvdg

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK07 /dev/xvdh

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK08 /dev/xvdi

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK09 /dev/xvdj

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK10 /dev/xvdk

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK11 /dev/xvdl

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK12 /dev/xvdm

[root@edydr1p1 ~]# oracleasm createdisk ASMDISK13 /dev/xvdn

[root@edydr1p1 ~]# oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks...

Scanning system for ASM disks...

[root@edydr1p1 ~]# oracleasm listdisks

ASMDISK1

ASMDISK2

...

[root@edydr1p1 ~]# reboot

oracleasm listdisks       //명령어로 13개있는지 확인