[설치] 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 의 인스톨 셋팅이 완료되어집니다.
![[관리][튜닝] 오라클 인스턴스 튜닝 ( instence tunning )](http://nblog.syszone.co.kr/wp-content/themes/hueman/assets/front/img/thumb-medium-empty.png)
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.