[설치] Accel Linux 6.1 + oracle 8.0.5 Install Guide

#### Accel 6.1 Linux + Oracle.8.0.5 Install Guide ####

설치사양

cpu : intel PIII 450 MHz

ram : 512 M

os  : Accel 6.1

먼저 액셀리눅스 6.1을 설치한후 다음 패키지를 설치한다.

[root@hoonmart /root]# rpm -ivh tcl-8.0.5-20.i386.rpm

[root@hoonmart /root]# rpm -ivh compat-binutils-5.2-2.9.10.23.1.i386.rpm?

[root@hoonmart /root]# rpm -ivh compat-glibc-5.2-2.0.7.1.i386.rpm

[root@hoonmart /root]# rpm -ivh compat-egcs-5.2.-1.0.3a.1.i386.rpm

[root@hoonmart /root]# rpm -ivh compat-egcs-c++-5.2-1.0.3a.1.i386.rpm

[root@hoonmart /root]# rpm -ivh compat-libs-5.2-2.i386.rpm

다음에 root 권한에서 oracle 계정과 dba 그룹을 만든다.

[root@hoonmart /root]# group -g 5000 dba

[root@hoonmart /root]# adduser -g dba oracle (oracle password 지정)

오라클 홈디렉토리의 퍼미션을 755 로 풀어준다.

[root@hoonmart /root]# chmod 755 /home/oracle

오라클 CD를 넣고 다음 경로의 스크립트 파일을 root 권한에서 실행시킨다.

실행시키기 앞서 ORACLE_OWNER root 권한에서 지정해 준다.

아래 스크립트는 오라클 인스턴스 정보를 oratab 파일에 기록하는 작업이다.

[root@hoonmart /root]# mount -t iso9660 /dev/cdrom /mnt/cdrom

[root@hoonmart /root]# cd /mnt/cdrom/orainst

[root@hoonmart orainst]# export ORACLE_OWNER=oracle

[root@hoonmart orainst]# sh oratab.sh

——————————————————————

*************************************************************************

Following conditions should be met to run this script successfully.

1. Needs root permission to run this script.

2. Need to set ORACLE_OWNER enviornment variable to the user who

   installs oracle product.

3. This ORACLE_OWNER should be part of group “dba”.

If any of these conditions are not met, please re-run after satisfying

these conditions.

*************************************************************************

Is it OK to continue (Y/N)? [Y]: y

The ORACLE_OWNER is set as:  oracle

Are these settings correct (Y/N)? [Y]: y

Checking for “oracle” user id…

[root@hoonmart orainst]#

——————————————————————

oracle 계정에서 환경변수를 설정해 주어라.

먼저 오라클 계정으로 접속

[root@hoonmart /root]# su – oracle

[oracle@hoonmart oracle]$ vi .bash_profile

——————————————————————

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

# User specific environment and startup programs

# 사용자별 환경변수 및 시작 프로그램 설정

#

PATH=$PATH:$HOME/bin

BASE_ENV=$HOME/.bashrc

USERNAME=””

export USERNAME BASE_ENV PATH

umask   022

ORACLE_HOME=/home/oracle/app/oracle/product/8.0.5

ORACLE_BASE=/home/oracle

export ORACLE_BASE ORACLE_HOME

ORACLE_SID=ORA8

export ORACLE_SID

export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601;

ORACLE_TERM=386

export ORACLE_TERM

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

PATH=$PATH:$ORACLE_HOME/bin

export PATH

export ULIMIT=2113674

export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/classes111.zip

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdbc/lib

——————————————————————–

## 환경변수 적용

[oracle@hoonmart oracle]$ . .bash_profile  

오라클 라이브러리 패치파일 준비

[oracle@hoonmart oracle]$ mkdir orapatch

[oracle@hoonmart oracle]$ cd orapatch/

[oracle@hoonmart orapatch]$

다음 사이트에서 오라클 패치 파일을 다운 받는다.

http://technet.oracle.co.kr/product/linux/linux.html

lnxpatch.tgz

linux_80510patchset.tgz

glibcpatch.tgz

위 패치 작업은 리눅스 6.x 버젼에서 데이터베이스 생성시 발생하는 에러를

수정한 부분이므로 리눅스 6.x 버젼에 oracle805를 설치시 반드시 해야 한다.

### Oracle Documentation install 준비

오라클 설치시 Oracle Documentation install 부분에서 발생하는 에러를 방지

하기 위해 미리 두 디렉토리를 link 시켜 놓는다.

[oracle@hoonmart oracle]$ mkdir /home/oracle/doc

[oracle@hoonmart oracle]$ mkdir -p /home/oracle/app/oracle/product/8.0.5

[oracle@hoonmart oracle]$ ln -s /home/oracle/doc /home/oracle/app/oracle/product/8.0.5

### orainst 실행

[oracle@hoonmart oracle]$ cd /mnt/cdrom/orainst

[oracle@hoonmart orainst]$ ./orainst

### 오라클 인스톨 과정 ###

————————————————————————-

1. Custom Install 하도록 한다.

      -j-jjjjjjjjjjjjjjjjjjjjjjj Install Type jjjjjjjjjjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Select the installation method, either Default Install    q  q

      q q  or Custom Install:                                        q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   ( ) Default Install                                      q  q

      q q   (o) Custom Install                                       q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

2. 오라클 인스톨 환영 메세지 그냥 OK .

-jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj preamble.txt jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj^

q ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd q

q q————————————                                    ^ q

q qWELCOME TO THE NEW ORACLE INSTALLER!                                      q

q q————————————                                    q q

q qThe information in this file is provided in the following format:       q q

q qNewest information is provided at the top,older information is          q q

q qfurther down in the file.  Each major section is separated by a         q q

q qheading which documents the release number.                             q q

q q                                                                        q q

q q————————————                                    q q

q qOracle Installer 4.0.3.0                                                q q

q q————————————                                    q q

q qSIGNIFICANT CHANGES TO THE INSTALLER FOR THIS RELEASE                   q q

q q                                                                        q q

q q*** Add support for the “Customizable Dialog” in Motif                  v q

q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc q

q                                                                            q

q                                                                            q

q                                                                            q

q   (Back)                           (Cancel)                      (OK)      q

q                                                                            q

fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

3. 오라클 8 버젼 에 관련된 정보 그냥 OK .

-jjjjjjjjjjjjjjjjjjjjj /mnt/cdrom/orainst/README.FIRST jjjjjjjjjjjjjjjjjjjjjj^

q ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd q

q qVERSION=8.0.5.0.0                                                       ^ q

q q                                                                          q

q q    IMPORTANT ORACLE PARALLEL SERVER INSTALLATION NOTE.                   q

q q                                                                          q

q qFor the Sun SPARCcluster PDB installation of Oracle Parallel Server       q

q qyou must first install the support package for Oracle group Membership    q

q qServices. If this is not already done please exit the installer,and       q

q qfollow the directions in the <cdhome>/ops_patch/README file.            q q

q q                                                                        q q

q q    ORACLE8 RELEASE 8.0.5.0.0 IMPORTANT PRE-INSTALL INFORMATION         q q

q q                                                                        q q

q qThe following contains critical information that the customer needs to  q q

q qbe aware of prior to installing Oracle8 Release 8.0.5.0.0.              q q

q q                                                                        v q

q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc q

q                                                                            q

q                                                                            q

q                                                                            q

q   (Back)                           (Cancel)                      (OK)      q

q                                                                            q

fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

4. 인스톨 작업 선택 ( 처음으로 인스톨 하는거기 때문에 첫번째 선택 )

      -j-jjjjjjjjjjjjjjj Installation Activity Choice jjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Select the Installer activity:                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (o) Install, Upgrade, or De-Install Software             q  q

      q q   ( ) Create/Upgrade Database Objects                      q  q

      q q   ( ) Perform Administrative Tasks                         q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

5. 리눅스 6.x 버젼에서는 DB object 는 따로 설치 하여야 한다.

   그러므로  Install New Product – Do Not Create DB Objects  선택 .

      -j-jjjjjjjjjjjjjjjjjjj Installation Options jjjjjjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Select the Installer option:                              q  q

      q q  Note: there are two different Install New Product         q  q

      q q  options.                                                  q  q

      q q                                                            q  q

      q q                                                            q  q

      q q  ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  q  q

      q q  q Install New Product – Create DB Objects              q  q  q

      q q  q Install New Product – Do Not Create DB Objects       q  q  q

      q쾞  q ————————————————–   q  q  q

      q q  q Add/Upgrade Software                                 q  q  q

      q q  q Build Oracle8 Staging Area                           q  q  q

      q q  q Install Documentation Only                           q  q  q

      q q  q De-Install Software                                  q  q  q

      q q  q Migrate from ORACLE7 to ORACLE8                      q  q  q

      q q  fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

    

6. 오라클 디렉토리 구조 설정 (오라클 환경 변수에 지정된거야 똑같이 설정 )

   -jjjjjjjjjjjjjjjjjjjjjjj Environment Variables jjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Confirm, change, or enter values for the environment variables      q

   q  listed:                                                             q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q  ORACLE_BASE:    /home/oracle                                        q

   q                                                                      q

   q  ORACLE_HOME:    /home/oracle/app/oracle/product/8.0.5               q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

7. 오라클 log 파일 생성위치 지정 ( 그냥 OK )

   -jjjjjjjjjjjjjjjjjjjjjjjjj Logging and Status jjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Confirm (or Change) Log File Location:                              q

   q                                                                      q

   q  If current versions of these log files exist in these locations,    q

   q  they will be archived and reinitialized.  Select Help for more      q

   q  details.                                                            q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q  Installer Log:  acle/product/8.0.5/orainst/install.log              q

   q                                                                      q

   q  SQL Log:        /home/oracle/app/oracle/product/8.0.5/o             q

   q                                                                      q

   q  Makefile Log:   /home/oracle/app/oracle/product/8.0.5/o             q

   q                                                                      q

   q  OS Log:         /home/oracle/app/oracle/product/8.0.5/o             q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

8. 인스톨러 소스 위치 확인 ( CD-ROM 으로 설치 )

      -j-jjjjjjjjjjjjjjjjjjjjjj Install Source jjjjjjjjjjjjjjjjjjjjjjdjjd  

      q q                                                            q  q  

      q q  Select one of the following:                              q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   (o) Install from CD-ROM                                  q  q  

      q q   ( ) Install from Staging Area                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q  

      fjq                                                            qjjc  

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

9. 인스톨 언어 설정 ( korean 으로 하도록 하자. )

      -j-jjjjjjjjjjjjjjjjjjjjjjjjjjj NLS jjjjjjjjjjjjjjjjjjjjjjjjjjjjdjjd  

      q q                                                            q  q  

      q q  Select the native language to be installed:               q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q  ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  q  q  

      q q  q Hungarian                                            q  q  q  

      q q  q Italian                                              q  q  q  

      q q  q Japanese                                             q  q  q  

      q q  q Korean                                                  q  q  

      q q  q Latin American Spanish                               q  q  q  

      q q  q Norwegian                                            q  q  q  

      q q  q Polish                                               q  q  q  

      q q  fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q  

      fjq                                                            qjjc  

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

10. 설치 종료후 다음 위치의 root.sh 를 root 계정으로 실행해라는 안내문.  

/home/oracle/app/oracle/product/8.0.5/orainst/root.sh.

      -j-jjjjjjjjjjjjjjjjjjjjjjj Information jjjjjjjjjjjjjjjjjjjjjjjjdjjd  

      q q                                                            q  q  

      q q  Post-installation steps that need to be run by root will  q  q  

      q q  be written to                                             q  q  

      q q  /home/oracle/app/oracle/product/8.0.5/orainst/root.sh.    q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q  

      q q                                                            q  q  

      q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

10. 설치할 프로그램을 선택 인스톨한다.

————————— Software Asset Manager —————————

q (From…)                                                                  q

q                                                                            q

q  Products available on /mnt/cdrom          Products installed on           q

q                                            /home/oracle/app/oracle/product q

q ——————————–           ——————————d q

q q   Client Software 8.0.5.0.0              q                             q q

q q   Net8 8.0.5.0.0             q (Install) q                             q q

q q – Net8 Protocol Adapters 8.0.q           q                             q q

q q     TCP/IP Protocol Adapter 8q (Remove)  q                             q q

q q   Oracle Intelligent Agent 8.q           q                             q q

q ——————————–           ——————————c q

q —Space—————————————————————–d q

q -Selected: No product selected                    Available: 203M        q q

q –                                                                        q q

q ————————————————————————-c q

q —Information———————————————————–d q

q q Select the product(s) you wish to install and choose the Install       ^ q

q q button, or insert another Oracle product disk and choose the From        q

q q button.                                                                v q

q ————————————————————————– q

q                                                                            q

q      (Help…)     (Options…)        (View Log…)        (Exit)         q

—————————————————————————–

11. 기존에 오라클 제품이 설치 되어져 있는지 확인하고 설치에 관련된 프로그램의

컴포넌트 사이의 의존성을 검사 한다. 그런후 Oracle DBA 권한을 부여할 그룹 지정.

      -j-jjjjjjjjjjjjjjjjjjjjjjjj DBA Group jjjjjjjjjjjjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Select group to act as DBA of the database:               q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (o) dba                                                  q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

OK ..

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd

      q                                                                 q

   -jjjjjjjjjjjjjjjjjjjjjjjjjjjj OSOPER Group jjjjjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Select the OSOPER group:                                            q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q  dba                                                                 q

   q —–                                                                q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      q                                                                 q

      q                                                                 q

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

dba 지정

12. 설치될 JDBC 드라이버의 버젼을 선택한다. (환경변수에 지정된 버젼 설치)

      -j-jjjjjjjjjjjjjjjjjj Choose JDBC Components jjjjjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Please select one or more of the following types of JDBC  q  q  

      q q  drivers to install.                                       q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   [ ] JDK 1.0 JDBC OCI Driver                              q  q  

      q q   [ ] JDK 1.0 JDBC Thin Driver                             q  q  

      q q   [X] JDK 1.1 JDBC OCI Driver                              q  q  

      q q   [X] JDK 1.1 JDBC Thin Driver                             q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

13 . Oracle Documentation 설치를 위한 경로 지정

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd

      q                                                                 q

   -jjjjjjjjjjjjjjjjjjjjjjjjjjjjj ORACLE_DOC jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Enter the pathname for your $ORACLE_DOC directory:                  q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q  /home/oracle/doc                                                    q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      q                                                                 q

      q                                                                 q

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

14. Document 포맷형식

      -j-jjjjjjjjjjjjjjjjjjj Documentation Format jjjjjjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Select one of the following formats for your Oracle8      q  q  

      q q  Server, Release 8.0.5 documentation:                      q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   (o) HTML                                                 q  q  

      q q   ( ) PDF                                                  q  q  

      q q   ( ) Both                                                 q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

그냥 default 로 선택

15. 패키지 인스톨 …

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd

      q                                                                 q

      q  Installing…                                         (Cancel) q  

      q                                                                 q  

      q  From: /mnt/cdrom                                               q  

      q                                                                 q  

      q  To:   /home/oracle/…/oracore/mesg/lrmko.msg                  q  

      q                                                                 q  

      q                     ORACLE Core Libraries                       q  

      q                                                                 q  

      q                                                                 q  

      q                                                                 q  

      q                                                                 q  

      q                                                                 q  

      q              Registering ORACLE Core Libraries…               q  

      q                                                                 q  

      q                                                                 q  

      q                                                                 q  

      q                                                                 q

      q                                                                 q

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

16. 인스톨 완료. 종료후 root 계정으로 root.sh 실행 메세지.

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd

      q-jjjjjjjjjjjjjjj Installer Actions Completed jjjjjjjjjjjjjjjjd   q

      qq                                                            ql) q

      qq  The requested action has been performed for selected      q   q

      qq  products.                                                 q   q

      qq                                                            q   q

      qq  Certain product setup actions need to be performed by     q   q

      qq  the ‘root’ user after successful installation.  Upon      q   q

      qq  completion of installation, please log in as ‘root’ and   q   q

      qq  run the root.sh script.                                   q   q

      qq                                                            q   q

      qq  Select (Help) for more details on what you can do next.   q   q

      qq  Select (OK) to continue.                                  q   q

      qq                                                            q   q

      qq                                                            q   q

      qq                                                            q   q

      qq                                                            q   q

      qq                                                            q   q

      qq   (Help…)                         (Cancel)         (OK)  q   q

      qq                                                            q   q

      ffjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjcjjjc

17 . EXIT 로 나온다.

-jjjjjjjjjjjjjjjjjjjjjjjjjj Software Asset Manager jjjjjjjjjjjjjjjjjjjjjjjjjjd

q (From…)                                                                  q

q                                                                            q

q  Products available on                     Products installed on           q

q  /home/oracle/app/oracle/product/          /home/oracle/app/oracle/product q

q ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd           ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjd q

q q   Oracle Intelligent Agent 8.q           q   <Database Startup> Load Fi  q

q q   Oracle On-Line Text Viewer q (Install) q   Client Software 8.0.5.0.0 q q

q q   Oracle Unix Installer 4.0.3q           q   Common documentation resouq q

q q   Oracle8 JDBC Drivers 8.0.5.  (Remove)  q   Net8 8.0.5.0.0            q q

q q   Oracle8 Standard (RDBMS) 8.q           q   ORACLE Common Agent Librarq q

q f jjjjjjjjjjjjjjjjjjjjjjjjjjjjjc           f jjjjjjjjjjjjjjjjjjjjjjjjjjjjc q

q ejjSpacejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd q

q qSelected: 145M in 1 product (dependancies        Available: 3855M       q q

q qare not included. See IG for details.)                                  q q

q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc q

q ejjInformationjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd q

q q Brings up file browser to aid selection of PRD file.                   ^ q

q q                                                                          q

q q                                                                        v q

q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc q

q                                                                            q

q      (Help…)     (Options…)        (View Log…)        (Exit)         q

q                                                                            q

fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

yes 선택.

-jjjjjjjjjjjjjjjjjjjjjjjjjj Software Asset Manager jjjjjjjjjjjjjjjjjjjjjjjjjjd

q (From…)                                                                  q

q                                                                            q

q  Products available on                     Products installed on           q

q  /home/oracle/app/oracle/product/          /home/oracle/app/oracle/product q

q ejjjjjjj-jjjjjjjjjjjjjjjjjjjj Confirmation jjjjjjjjjjjjjjjjjjjjdjjjjjjjjjd q

q q   Oracq                                                      q> Load Fi  q

q q   Oracq  Are you sure you want to exit the Oracle            q.0.5.0.0 q q

q q   Oracq  Installer?                                          qion resouq q

q q   Oracq                                                      q         q q

q q   Oracq                                                      qnt Librarq q

q f jjjjjjq                                                      qjjjjjjjjjc q

q ejjSpaceq                                                      qjjjjjjjjjd q

q qSelecteq                                                      q5M       q q

q qare notq   (No)                                        (Yes)  q         q q

q fjjjjjjjq                                                      qjjjjjjjjjc q

q ejjInforfjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjcjjjjjjjjjd q

q q                                                                        ^ q

q q                                                                          q

q q                                                                        v q

q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc q

q                                                                            q

q      (Help…)     (Options…)        (View Log…)        (Exit)         q

q                                                                            q

fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

18. glibcpatch 패치

[oracle@hoonmart oracle]$ cd orapatch

[oracle@hoonmart orapatch]$ ./glibcpatch.sh

19. DB object 생성

[oracle@hoonmart orapatch]$ cd /mnt/cdrom/orainst/

[oracle@hoonmart orainst]$ ./orainst

20. Custom Install 선택

      -j-jjjjjjjjjjjjjjjjjjjjjjj Install Type jjjjjjjjjjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Select the installation method, either Default Install    q  q

      q q  or Custom Install:                                        q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   ( ) Default Install                                      q  q

      q q   (o) Custom Install                                       q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

21. 2번 과 3번 과 동일한 과정을 거친후 Create/Upgrade Database Objects 선택함.

      -j-jjjjjjjjjjjjjjj Installation Activity Choice jjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Select the Installer activity:                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   ( ) Install, Upgrade, or De-Install Software             q  q

      q q   (o) Create/Upgrade Database Objects                      q  q

      q q   ( ) Perform Administrative Tasks                         q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

22. DB가 생성되어 있지 않기 때문에 첫번째 항목을 선택하여 DB 생성.

      -j-jjjjjjjjjjjjjjjjjjjjj Database Options jjjjjjjjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Select the database action:                               q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (o) Create Database Objects                              q  q

      q q   ( ) Upgrade Database Objects                             q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

23. 오라클 경로 지정

   -jjjjjjjjjjjjjjjjjjjjjjj Environment Variables jjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Confirm, change, or enter the values of the environment variables   q

   q  listed:                                                             q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q  ORACLE_BASE:    /home/oracle                                        q

   q                                                                      q

   q  ORACLE_HOME:    /home/oracle/app/oracle/product/8.0.5               q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

24. 오라클 log file 경로 지정

   -jjjjjjjjjjjjjjjjjjjjjjjjj Logging and Status jjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Confirm (or Change) Log File Location:                              q

   q                                                                      q

   q  If current versions of these log files exist in these locations,    q

   q  they will be archived and reinitialized.  Select Help for more      q

   q  details.                                                            q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q  Installer Log:  /home/oracle/app/oracle/product/8.0.5/o             q

   q                                                                      q

   q  SQL Log:        /home/oracle/app/oracle/product/8.0.5/o             q

   q                                                                      q

   q  Makefile Log:   /home/oracle/app/oracle/product/8.0.5/o             q

   q                                                                      q

   q  OS Log:         /home/oracle/app/oracle/product/8.0.5/o             q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

25. Oracle SID 값 입력 ( 환경변수에 이미 지정하였기 때문에 그냥 OK.)

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  

      q                                                                 q  

   -jjjjjjjjjjjjjjjjjjjjjjjjjjjjj ORACLE_SID jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Enter your ORACLE_SID:                                              q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q  ORA8                                                                q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      q                                                                 q  

      q                                                                 q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

26. 기타 프로그램은 모두 설치 하였으므로 Oracle8 Standard (RDBMS) 8.0.5 만 선택.

————————— Software Asset Manager —————————

q (From…)                                                                  q

q                                                                            q

q  Products available on /mnt/cdrom          Products installed on           q

q                                            /home/oracle/app/oracle/product q

q ——————————–           ——————————d q

q q   Client Software 8.0.5.0.0              q                             q q

q q   Net8 8.0.5.0.0             q (Install) q                             q q

q q – Net8 Protocol Adapters 8.0.q           q                             q q

q q     TCP/IP Protocol Adapter 8q (Remove)  q                             q q

q q   Oracle Intelligent Agent 8.q           q                             q q

q ——————————–           ——————————c q

q —Space—————————————————————–d q

q -Selected: No product selected                    Available: 203M        q q

q –                                                                        q q

q ————————————————————————-c q

q —Information———————————————————–d q

q q Select the product(s) you wish to install and choose the Install       ^ q

q q button, or insert another Oracle product disk and choose the From        q

q q button.                                                                v q

q ————————————————————————– q

q                                                                            q

q      (Help…)     (Options…)        (View Log…)        (Exit)         q

—————————————————————————–

27. 두번째 항목인 Create Product DB Object 을 선택하고 OK.

      -j-jjjjjjjjjjjjjjjjjjjjj Database Action jjjjjjjjjjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Select one of the following actions for Oracle Server     q  q

      q q  Manager:                                                  q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   ( ) Do Not Perform any DB Actions                        q  q

      q q   (o) Create Product DB Objects                            q  q

      q q   ( ) Upgrade Existing Product DB Objects                  q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

28. 파일시스템 형식으로 테이터베이스를 구성하므로 첫번째 선택 OK.

      -j-jjjjjjjjjjjjj Create DB Objects: Storage Type jjjjjjjjjjjjjjdjjd

      q q                                                            q  q

      q q  Choose storage type for database:                         q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (o) Filesystem-Based Database                            q  q

      q q   ( ) Raw Device-Based Database                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q                                                            q  q

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q

      fjq                                                            qjjc

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

29. 컨트롤 파일을 세군데로 분산 배치하기 위한 설정 yes 선택

   -jjjjjjjjj Create DB Objects (F/S): Control File Distribution jjjjjjjjjd

   q                                                                      q

   q  Distribute control files over three mount points?                   q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)        (Back)          (Cancel)        (No)      (Yes)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

29. 데이터베이스 마운트 포인트 입력

   -jjjjjjjjjjjjjjjjjjjjjjj Database Mount Points jjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Enter 3 database mount points                                       q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q  Point 1:        /home/oracle/data1                                  q

   q                                                                      q

   q  Point 2:        /home/oracle/data2                                  q

   q                                                                      q

   q  Point 3:        /home/oracle/data3                                  q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

30. 데이터 베이스 생성시 캐릭터 셋을 지정하는 부분. 한글 사용을 위해서는

KO16KSC5601을 지정.

      -j-jjjjjjjjjjjjjjjjjjjjjj Character Set jjjjjjjjjjjjjjjjjjjjjjjdjjd  

      q q                                                            q  q  

      q q  Select the character set for creating this database.  If  q  q  

      q q  your desired character set is not listed, select          q  q  

      q q  (Others..) and enter the character set manually.          q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q  ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  q  q  

      q q  q EE8ISO8859P2                                         q  q  q  

      q q  q EL8DEC                                               q  q  q  

      q q  q JA16EUC                                                 q  q  

      q q  q KO16KSC5601                                          q  q  q  

      q q  q RU8PC855                                             q  q  q  

      q q  q US7ASCII                                             q  q  q  

      q q  q WE8DEC                                               q  q  q  

      q q  fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q  

      fjq                                                            qjjc  

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

31. 두번째로 지정할수 있는 캐릭터 셋이다. KO16KSC5601 선택된 채로 두고 OK

      -j-jjjjjjjjjjjjjjjjjj National Character Set jjjjjjjjjjjjjjjjjjdjjd  

      q q                                                            q  q  

      q q  Select the national character set for this database.      q  q  

      q q  The default value is the character set specified for      q  q  

      q q  database creation. If your desired character set is not   q  q  

      q q  listed, select (Others..) and enter the character set     q  q  

      q q                                                            q  q  

      q q  ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  q  q  

      q q  q EE8ISO8859P2                                         q  q  q  

      q q  q EL8DEC                                               q  q  q  

      q q  q JA16EUC                                              q  q  q  

      q q  q JA16EUCFIXED                                            q  q  

      q q  q JA16SJISFIXED                                        q  q  q  

      q q  q JA16DBCSFIXED                                        q  q  q  

      q q  q KO16KSC5601                                          q  q  q  

      q q  fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q  

      fjq                                                            qjjc  

        fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

32. SYSTEM 패스 워드 입력 (기본값 manager)

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  

      q                                                                 q  

      q  Analyzing Dependencies…                                      q  

   -jjjjjjjjjjjjjjjjjjjjjjjjjj SYSTEM Password jjjjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Enter the password for the ‘SYSTEM’ ORACLE userid:                  q

   q  (For security reasons, your input will not be echoed. After you     q

   q  type in the password, you will be prompted to re-enter the          q

   q  password for confirmation.)                                         q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      q                                                                 q  

      q                                                                 q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

재확인 ..

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  

      q                                                                 q  

      q  Analyzing Dependencies…                                      q  

   -jjjjjjjjjjjjjjjjjjjjjjjjjj SYSTEM Password jjjjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Please enter the password for the ‘SYSTEM’ ORACLE userid again to   q

   q  confirm:                                                            q

   q  (Your input will not be echoed.)                                    q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      q                                                                 q  

      q                                                                 q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

33. SYS 패스워드 입력 (기본값 change_on_install)

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  

      q                                                                 q  

      q  Analyzing Dependencies…                                      q  

   -jjjjjjjjjjjjjjjjjjjjjjjjjjjj SYS Password jjjjjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Please enter the password for the ‘SYS’ ORACLE userid:              q

   q  (For security reasons, your input will not be echoed. After you     q

   q  type in the password, you will be prompted to re-enter the          q

   q  password for confirmation.)                                         q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      q                                                                 q  

      q                                                                 q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

재확인 …

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  

      q                                                                 q  

      q  Analyzing Dependencies…                                      q  

   -jjjjjjjjjjjjjjjjjjjjjjjjjjjj SYS Password jjjjjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Please enter the password again to confirm:                         q

   q  (Your input will not be echoed.)                                    q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      q                                                                 q  

      q                                                                 q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

34. 내부(dba)이용자를 위한 패스워드 지정. 여기서 yes 를 선택하면 svrmgrl 에서

connect internal 접속시 패스워드를 물어보게 된다. (난 그냥 NO 로 한다.)

   -jjjjjjjjjjjjjjjjjjjjjjjjjjjj dba password jjjjjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Do you want to set the passwords for the internal users (dba and    q

   q  operator)?                                                          q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)        (Back)          (Cancel)        (No)      (Yes)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

35. SQL*Net 를 위한 TNS Listener 의 패스워드 부여

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  

      q                                                                 q  

      q  Analyzing Dependencies…                                      q  

   -jjjjjjjjjjjjjjjjjjjjjjj TNS Listener Password jjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Enter the password for the TNS listener: (For security reasons,     q

   q  your input will not be echoed.  After you type in the password,     q

   q  you will be prompted to re-enter the password for confirmation.)    q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      q                                                                 q  

      q                                                                 q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

재확인…

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd  

      q                                                                 q  

      q  Analyzing Dependencies…                                      q  

   -jjjjjjjjjjjjjjjjjjjjjjj TNS Listener Password jjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Please enter the password again to confirm:                         q

   q  (Your input will not be echoed.)                                    q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)           (Back)              (Cancel)            (OK)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      q                                                                 q  

      q                                                                 q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

36. MTS(Multi-Threaded Server)  를 이용하기 위한 설정. 메모리양이 적거나

오래걸리는 트랜잭션이 거의 없는 어플리케이션을 운영하는 시스템에 효율적.

   -jjjjjjjjjjjjj Configure MTS and start SQL*Net listener? jjjjjjjjjjjjjjd

   q                                                                      q

   q  Would you like MTS (Multi-Threaded Server) configured and the       q

   q  SQL*Net listener automatically started?                             q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)        (Back)          (Cancel)        (No)      (Yes)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

37. 컨트롤 파일의 생성될 위치와 파일명,기타 데이터베이스와 관련된 파일들의

위치와 크기등을 보여 준다.

   -jjjjjjjjjjjj Create DB Objects(F/S): Control File Locator jjjjjjjjjjjjd

   q                                                                      q

   q  Do you want to use the following files as control files?            q

   q  /home/oracle/data1/oradata/ORA8/control01.ctl                       q

   q  /home/oracle/data2/oradata/ORA8/control02.ctl                       q

   q  /home/oracle/data3/oradata/ORA8/control03.ctl                       q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)        (Back)          (Cancel)        (No)      (Yes)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

      -j-jjjjjjjjjjjjjjjjjjjjjjj DB Defaults jjjjjjjjjjjjjjjjjjjjjjjjdjjd  

      q q                                                            q  q  

      q q  The following are the default file names and sizes that   q  q  

      q q  will be used to create the new database.  Select (OK) to  q  q  

      q q  continue to the next screen of defaults files:            q  q  

      q q  PASSWORD(1 entry):                                        q  q  

      q q  /home/oracle/app/oracle/product/8.0.5/dbs/orapwORA8       q  q  

      q q  SYSTEM(80M):                                              q  q  

      q q  /home/oracle/data1/oradata/ORA8/system01.dbf              q  q  

      q q  LOG1(500k):                                               q  q  

      q q  /home/oracle/data1/oradata/ORA8/redoORA801.log            q  q  

      q q  LOG2(500k):                                               q  q  

      q q  /home/oracle/data2/oradata/ORA8/redoORA802.log            q  q  

      q q  LOG3(500k):                                               q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q  

      q q                                                            q  q  

      q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

      -j-jjjjjjjjjjjjjjjjjjjjjjj DB Defaults jjjjjjjjjjjjjjjjjjjjjjjjdjjd  

      q q                                                            q  q  

      q q  Default file names and sizes continued.  Select (Back)    q  q  

      q q  to see the previous screen of defaults.  Select (OK) to   q  q  

      q q  continue:                                                 q  q  

      q q  ROLLBACK(15M): /home/oracle/data1/oradata/ORA8/rbs01.dbf  q  q  

      q q  TEMP(1M): /home/oracle/data1/oradata/ORA8/temp01.dbf      q  q  

      q q  USERS(1M): /home/oracle/data1/oradata/ORA8/users01.dbf    q  q  

      q q  TOOLS(25M): /home/oracle/data1/oradata/ORA8/tools01.dbf   q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q                                                            q  q  

      q q   (Help…)        (Back)           (Cancel)         (OK)  q  q  

      q q                                                            q  q  

      q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  q  

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc  

38. 이전화면에서 고칠것이 없는지 마지막으로 확인.

   -jjjjjjjjjjjjjjjjjjjjjjjjjj Default Database jjjjjjjjjjjjjjjjjjjjjjjjjjd

   q                                                                      q

   q  Select (Yes) to accept the default file names and sizes shown on    q

   q  the previous screens.  Select (No) to specify new values.  Select   q

   q  (Back) to view the previous screens.                                q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q                                                                      q

   q   (Help…)        (Back)          (Cancel)        (No)      (Yes)   q

   q                                                                      q

   fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

39. 데이터베이스 생성..(다소 시간이 걸린다. )

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd

      q                                                                 q

      q  Installing…                                         (Cancel) q

      q                                                                 q

      q  From: /home/oracle/app/oracle/product/8.0.5                    q

      q                                                                 q

      q  To:   /home/oracle/app/oracle/product/8.0.5                    q

      q                                                                 q

      q                    Oracle8 Standard (RDBMS)                     q

      q                                                                 q

      q                                                                 q

      q                                                                 q

      q                                                                 q

      q                                                                 q

      q       Creating database ORA8’s catalogs and files (this         q

      q                       will take a while)                        q

      q                                                                 q

      q                                                                 q

      q                                                                 q

      q                                                                 q

      fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

40. 데이터베이스 생성완료 (종료후 root.sh 실행 – root 계정으로)

      -jjjjjjjjjjjjjjjjjjjjjjjjjjjj Oracle jjjjjjjjjjjjjjjjjjjjjjjjjjjjjd

      q-jjjjjjjjjjjjjjj Installer Actions Completed jjjjjjjjjjjjjjjjd   q

      qq                                                            ql) q

      qq  The requested action has been performed for selected      q   q

      qq  products.                                                 q   q

      qq                                                            q   q

      qq  Certain product setup actions need to be performed by     q   q

      qq  the ‘root’ user after successful installation.  Upon      q   q

      qq  completion of installation, please log in as ‘root’ and   q   q

      qq  run the root.sh script.                                   q   q

      qq                                                            q   q

      qq  Select (Help) for more details on what you can do next.   q   q

      qq  Select (OK) to continue.                                  q   q

      qq                                                            q   q

      qq                                                            q   q

      qq                                                            q   q

      qq                                                            q   q

      qq                                                            q   q

      qq   (Help…)                         (Cancel)         (OK)  q   q

      qq                                                            q   q

      ffjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjcjjjc

41. EXIT 로 빠져 나간다.

-jjjjjjjjjjjjjjjjjjjjjjjjjj Software Asset Manager jjjjjjjjjjjjjjjjjjjjjjjjjjd

q (From…)                                                                  q

q                                                                            q

q  Products available on                     Products installed on           q

q  /home/oracle/app/oracle/product/          /home/oracle/app/oracle/product q

q ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd           ejjjjjjjjjjjjjjjjjjjjjjjjjjjjjd q

q q   Oracle Intelligent Agent 8.q           q   <Database Startup> Load Fi  q

q q   Oracle On-Line Text Viewer q (Install) q   Client Software 8.0.5.0.0 q q

q q   Oracle Unix Installer 4.0.3q           q   Common documentation resouq q

q q   Oracle8 JDBC Drivers 8.0.5.  (Remove)  q   Net8 8.0.5.0.0            q q

q q   Oracle8 Standard (RDBMS) 8.q           q   ORACLE Common Agent Librarq q

q f jjjjjjjjjjjjjjjjjjjjjjjjjjjjjc           f jjjjjjjjjjjjjjjjjjjjjjjjjjjjc q

q ejjSpacejjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd q

q qSelected: 145M in 1 product (dependancies        Available: 3855M       q q

q qare not included. See IG for details.)                                  q q

q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc q

q ejjInformationjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjd q

q q Brings up file browser to aid selection of PRD file.                   ^ q

q q                                                                          q

q q                                                                        v q

q fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc q

q                                                                            q

q      (Help…)     (Options…)        (View Log…)        (Exit)         q

q                                                                            q

q                                                                            q

fjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjc

42. root 계정으로 root.sh 실행

#### 주의 : 여기서 root 의 환경변수(.bash_profile)에 oracle의 환경변수값이적용

되도록 해준다. (오라클 환경변수를 root 환경변수에 추가..)

[root@hoonmart /root]# cd /home/oracle/app/oracle/product/8.0.5/orainst/

[root@hoonmart orainst]# sh root.sh

—————————————————————————–

Running Oracle8 root.sh script…

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /home/oracle/app/oracle/product/8.0.5

    ORACLE_SID=   ORA8

Are these settings correct (Y/N)? [Y]: y

Enter the full pathname of the local bin directory [/usr/lbin]: /usr/bin

Checking for “oracle” user id…

ORACLE_HOME does not match the home directory for oracle.

Okay to continue? [N]: y

Leaving common section of Oracle8 root.sh.

[root@hoonmart orainst]#

오라클 프로세서 확인

[root@hoonmart orainst]# ps aux | grep ORA8

oracle   14522  0.0  0.5 20296 2672 ?        S       16:41   0:00 ora_pmon_ORA8

oracle   14524  0.1  0.5 20096 3096 ?        S       16:41   0:02 ora_dbw0_ORA8

oracle   14526  0.2  0.4 20012 2552 ?        S       16:41   0:03 ora_lgwr_ORA8

oracle   14528  0.0  0.4 20024 2580 ?        S       16:41   0:00 ora_ckpt_ORA8

oracle   14530  0.0  0.8 20024 4464 ?        S       16:41   0:00 ora_smon_ORA8

oracle   14532  0.0  0.8 20040 4508 ?        S       16:41   0:00 ora_reco_ORA8

oracle   14534  0.0  0.3 19836 2040 ?        S       16:41   0:00 ora_s000_ORA8

oracle   14536  0.0  0.4 19936 2176 ?        S       16:41   0:00 ora_d000_ORA8

이상으로 오라클 설치가 완료 되었습니다. 설치후 몇가지 작업을 해 주어야 합니다.

다시 오라클 계정으로 돌아와서 다음 위치에서 svrmgrl 접속

[oracle@hoonmart oracle]$ cd app/oracle/product/8.0.5/sqlplus/admin

[oracle@hoonmart admin]$ svrmgrl

Oracle Server Manager Release 3.0.5.0.0 – Production

(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.

Oracle8 Release 8.0.5.0.0 – Production

PL/SQL Release 8.0.5.0.0 – Production

VRMGR> connect system/manager

Connected.

SVRMGR>

## pupbld.sql 실행한다.

SVRMGR> @pupbld.sql     ## 에러무시

## 일반 계정사용자 생성 ##

SVRMGR> create user hoonmart identified by hoon224

     2> default tablespace users

     3> temporary tablespace temp

     4> quota unlimited on users

     5> quota unlimited on temp;

Statement processed.

SVRMGR> grant connect, resource to hoonmart;

Statement processed.

SVRMGR> quit

Server Manager complete.

[oracle@hoonmart admin]$

### Listener 설정 ###

[oracle@hoonmart oracle]$ cd app/oracle/product/8.0.5/network/admin/

[oracle@hoonmart admin]$ vi listener.ora

———————————————————————

LISTENER =

  (ADDRESS_LIST =

        (ADDRESS= (PROTOCOL= IPC)(KEY= <oracle_sid>))

        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))

        (ADDRESS= (PROTOCOL= TCP)(Host= hoonmart.hoonmart.co.kr)(Port= 1521))

  )

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME= hoonmart.hoonmart.co.kr.)

      (ORACLE_HOME= /home/oracle/app/oracle/product/8.0.5)

      (SID_NAME = <oracle_sid>)

    )

    (SID_DESC =

      (SID_NAME = extproc)

      (ORACLE_HOME = /home/oracle/app/oracle/product/8.0.5)

      (PROGRAM = extproc)

    )

  )

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

———————————————————————

<oracle_sid> 를 오라클 환경변수에 지정된 SID 값으로 변환시켜준다.

[oracle@hoonmart admin]$ vi tnsnames.ora

——————————————————————–

extproc_connection_data =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = IPC)(KEY = <oracle_sid>))

    (CONNECT_DATA = (SID = extproc))

  )

<oracle_sid> =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL= TCP)(Host= hoonmart.hoonmart.co.kr)(Port= 1521))

    (CONNECT_DATA = (SID = <oracle_sid>))

  )

<oracle_sid>_BEQ =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /home/oracle/app/oracle/product/8.0.5)

               (argv0 = oracle<oracle_sid>)

               (args = ‘(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))’)

               (envs = ‘ORACLE_HOME=/home/oracle/app/oracle/product/8.0.5,ORACLE_SID=<oracle_sid>’)

    )

  )

—————————————————————-

<oracle_sid> 를 오라클 환경변수에 지정된 SID 값으로 변환시켜준?

## 리스너를 시작 시킨다 ##

[oracle@hoonmart admin]$ lsnrctl start

이로써 레드햇 6.1 기반에서 오라클 8.0.5 의 인스톨 셋팅이 완료되어집니다.

서진우

슈퍼컴퓨팅 전문 기업 클루닉스/ 상무(기술이사)/ 정보시스템감리사/ 시스존 블로그 운영자

You may also like...

1 Response

  1. cami halısı 말해보세요:

    Hi, just required you to know I he added your site to my Google bookmarks due to your layout. But seriously, I believe your internet site has 1 in the freshest theme I??ve came across.

페이스북/트위트/구글 계정으로 댓글 가능합니다.