급하신 분은 보라색 글씨만 보시면 됩니다.
[# ] 표시 = root 계정으로 명령어 입력 / [$ ] 표시 = 사용자계정 (ex. oracle) 으로 명령어 입력
[:: ] 표시 = vi에디터 등에서 표시 이후의 내용을 타이핑하라는 의미입니다.
[# ] 표시 = root 계정으로 명령어 입력 / [$ ] 표시 = 사용자계정 (ex. oracle) 으로 명령어 입력
[:: ] 표시 = vi에디터 등에서 표시 이후의 내용을 타이핑하라는 의미입니다.
※ silent mode 로 설치시 주의 해야 할 점이 있다. 개인의 설치파일 경로에 따라 오류가 많이 발생하니, 염두에 두고 작업해야 한다.
필자는 아래와 같이 경로를 지정하여 설치를 진행하였다.
- 설치파일 : /home/oracle/install/
- 오라클 설치 시 홈 디렉토리 : /home/oracle/product/OraHome/
필자는 아래와 같이 경로를 지정하여 설치를 진행하였다.
- 설치파일 : /home/oracle/install/
- 오라클 설치 시 홈 디렉토리 : /home/oracle/product/OraHome/
1. 오라클 계정 및 그룹 생성
# groupadd –g 5000 dba
# useradd –g dba oracle
# passwd oracle
# useradd –g dba oracle
# passwd oracle
2. 공유메모리 확인 및 설정
# echo '2147483648' > /proc/sys/kernel/shmmax
→ 공유메모리 확인 echo 명령어는 출력해서 보여주는 명령어인데, echo '2147483648' 이렇게만 하면 재부팅시에는 적용이 되지 않으므로 이것을 /proc/sys/kernel/shmmax 이 파일안에 써놓겠다는 의미이다.
# vi /etc/rc.d/rc.local
echo '2147483648' > /proc/sys/kernel/shmmax → 재부팅 후에도 공유메모리를 2G설정해 주기위해서이다.
→ 공유메모리 확인 echo 명령어는 출력해서 보여주는 명령어인데, echo '2147483648' 이렇게만 하면 재부팅시에는 적용이 되지 않으므로 이것을 /proc/sys/kernel/shmmax 이 파일안에 써놓겠다는 의미이다.
# vi /etc/rc.d/rc.local
echo '2147483648' > /proc/sys/kernel/shmmax → 재부팅 후에도 공유메모리를 2G설정해 주기위해서이다.
3. 설치될 s/w log파일 저장위치를 지정해주는 oraInst.loc 파일 생성
# vi /etc/oraInst.loc
inventory_loc=/home/oracle/oraInventory
inst_group=dba
# chown -R oracle.dba /etc/oraInst.loc
inst_group=dba
# chown -R oracle.dba /etc/oraInst.loc
4. 설치 파일 복사 및 압축 해제
winSCP를 이용하여 오라클 설치 파일을 /home/oracle 밑에 복사해 놓는다. 그리고 압축을 해제한다.
5. rpm 설치
6. 소유권 설정
7. linux와 Oracle 의 자바 버전 맞추기 - root 계정으로 패치 실행 → p3006854 압축 푼 후 실행 할 것(unzip으로 압축 풀고 폴더로 가서 실행)
8. 오라클 계정의 .bash_profile 파일 설정 (경로 : /home/oracle)
winSCP를 이용하여 오라클 설치 파일을 /home/oracle 밑에 복사해 놓는다. 그리고 압축을 해제한다.
# cd /home/oracle/install/
# cpio -idmv < ship_9204_linux_disk1.cpio && cpio -idmv < ship_9204_linux_disk2.cpio && cpio -idmv < ship_9204_linux_disk3.cpio
# cpio -idmv < ship_9204_linux_disk1.cpio && cpio -idmv < ship_9204_linux_disk2.cpio && cpio -idmv < ship_9204_linux_disk3.cpio
5. rpm 설치
# cd /home/oracle/install/rpm/
# rpm -Uvh compat-libgcj-7.3-2.96.118.i386.rpm
# rpm -Uvh compat-libgcj-devel-7.3-2.96.118.i386.rpm
# rpm -Uvh nss_db-compat-2.2-20.i386.rpm ← 설치시 의존성 에러나는 경우 있음. 무시할 것
# rpm -Uvh compat-libgcj-7.3-2.96.118.i386.rpm
# rpm -Uvh compat-libgcj-devel-7.3-2.96.118.i386.rpm
# rpm -Uvh nss_db-compat-2.2-20.i386.rpm ← 설치시 의존성 에러나는 경우 있음. 무시할 것
6. 소유권 설정
# chown -R oracle.dba /home/oracle → /home/oracle디렉토리가 그룹 dba에 속하는 oracle로 소유자를 변경한다
7. linux와 Oracle 의 자바 버전 맞추기 - root 계정으로 패치 실행 → p3006854 압축 푼 후 실행 할 것(unzip으로 압축 풀고 폴더로 가서 실행)
# cd /home/oracle/install/patch
# unzip p3006854_9204_LINUX.zip
# cd 3006854
# chmod 755 rhel3_pre_install.sh → 실행권한이 없으므로 chmod 명령어를 이용하여 권한을 변경한다.
# sh rhel3_pre_install.sh → 패치작업, 쉘스크립트 실행한다.
# unzip p3006854_9204_LINUX.zip
# cd 3006854
# chmod 755 rhel3_pre_install.sh → 실행권한이 없으므로 chmod 명령어를 이용하여 권한을 변경한다.
# sh rhel3_pre_install.sh → 패치작업, 쉘스크립트 실행한다.
8. 오라클 계정의 .bash_profile 파일 설정 (경로 : /home/oracle)
# vi .bash_profile
export DISPLAY=localhost:0.0
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/OraHome
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=testdb
export ORACLE_TERM=xterm
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949
export LANG=ko_KR.eucKR
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/OraHome
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=testdb
export ORACLE_TERM=xterm
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949
export LANG=ko_KR.eucKR
9. enterprise.rsp 편집 - silent 모드 핵심 : OUI 설치 시 입력해 주는 항목을 미리 선언 해주고 silent모드로 인스톨
적용후 리눅스 재부팅. oracle 계정으로 로그인한다.
# vi /home/oracle/install/Disk1/response/enterprise.rsp
#Parameter: UNIX_GROUP_NAME
#Type: String
#Description: Unix group to be set for the inventory directory. Valid only in Unix platforms.
#Example : UNIX_GROUP_NAME = "install"
UNIX_GROUP_NAME="dba"
#Parameter: FROM_LOCATION
#Type: String
#Description: Complete path of the products.jar.
#Example : FROM_LOCATION = "../stage/products.jar"
FROM_LOCATION="/home/oracle/install/Disk1/stage/products.jar"
#Type: String
#Description: Unix group to be set for the inventory directory. Valid only in Unix platforms.
#Example : UNIX_GROUP_NAME = "install"
UNIX_GROUP_NAME="dba"
#Parameter: FROM_LOCATION
#Type: String
#Description: Complete path of the products.jar.
#Example : FROM_LOCATION = "../stage/products.jar"
FROM_LOCATION="/home/oracle/install/Disk1/stage/products.jar"
#Parameter: ORACLE_HOME
#Type: String
#Description: Complete Location of the Oracle Home.
#Example : ORACLE_HOME = "C:\OHOME1"
ORACLE_HOME="/home/oracle/product/OraHome"
#Type: String
#Description: Complete Location of the Oracle Home.
#Example : ORACLE_HOME = "C:\OHOME1"
ORACLE_HOME="/home/oracle/product/OraHome"
#Parameter: ORACLE_HOME_NAME
#Type: String
#Description: Oracle Home Name. Used in creating folders, services.
#Example : ORACLE_HOME_NAME = "OHOME1"
ORACLE_HOME_NAME="OraHome"
#Parameter: s_cfgtyperet
#Type: String
s_cfgtyperet="Software Only" → 설정을 해주면 엔진설치 완료후 Linux화면에 암호입력화면 안뜸.(Databse Configuration부분의 General Purpose로 설정이 되어있는 것을 Software Only로 바꿔주는 과정)
#Type: String
#Description: Oracle Home Name. Used in creating folders, services.
#Example : ORACLE_HOME_NAME = "OHOME1"
ORACLE_HOME_NAME="OraHome"
#Parameter: s_cfgtyperet
#Type: String
s_cfgtyperet="Software Only" → 설정을 해주면 엔진설치 완료후 Linux화면에 암호입력화면 안뜸.(Databse Configuration부분의 General Purpose로 설정이 되어있는 것을 Software Only로 바꿔주는 과정)
1. 설치 실행
$ cd /home/oracle/install/Disk1/
$ ./runInstaller -silent -responseFile /home/oracle/install/Disk1/response/enterprise.rsp
$ ./runInstaller -silent -responseFile /home/oracle/install/Disk1/response/enterprise.rsp
silent mode의 특징 상 rsp 파일에 미리 선언해 두었던 대로 설치가 된다.
1.1 설치 과정 확인하기
# tail -f /home/oracle/oraInventory/logs/install<tab>
아래는 사일런트 모드로 runInstaller 실행후 진행되는 상황 $ ./runInstaller -silent -responseFile /home/oracle/install/Disk1/response/enterprise.rsp
$ Initializing Java Virtual Machine from /tmp/OraInstall2011-12-21_10-05-16PM/jre/bin/java. Please wait...
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Warning: Cannot convert string "<Key>Escape,_Key_Cancel" to type VirtualBinding
Warning: Cannot convert string "<Key>Home,_Key_Begin" to type VirtualBinding
Warning: Cannot convert string "<Key>F1,_Key_Help" to type VirtualBinding
Warning: Cannot convert string "Shift<Key>F10,_Key_Menu" to type VirtualBinding
Warning: Cannot convert string "<Key>F10,Shift_Key_Menu" to type VirtualBinding
Warning: Cannot convert string "<Key>KP_Enter,_Key_Execute" to type VirtualBinding
Warning: Cannot convert string "Alt<Key>Return,Alt_Key_KP_Enter" to type VirtualBinding
Warning: Cannot convert string "<Key>Escape,_Key_Cancel" to type VirtualBinding
Warning: Cannot convert string "<Key>Home,_Key_Begin" to type VirtualBinding
Warning: Cannot convert string "<Key>F1,_Key_Help" to type VirtualBinding
Warning: Cannot convert string "Shift<Key>F10,_Key_Menu" to type VirtualBinding
Warning: Cannot convert string "<Key>F10,Shift_Key_Menu" to type VirtualBinding
Warning: Cannot convert string "<Key>KP_Enter,_Key_Execute" to type VirtualBinding
Warning: Cannot convert string "Alt<Key>Return,Alt_Key_KP_Enter" to type VirtualBinding
In Product Registration Page
In UNIX 그룹 이름 Page
In 클러스터 노드 선택 Page
In 파일 위치 Page
In 사용 가능한 제품 Page
In 설치 유형 Page
In 구성 요소 위치 Page
In Title Page
In Title Page
In 디렉토리 선택 Page
In Title Page
In 요약 Page
$ Initializing Java Virtual Machine from /tmp/OraInstall2011-12-21_10-05-16PM/jre/bin/java. Please wait...
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]
Warning: Cannot convert string "<Key>Escape,_Key_Cancel" to type VirtualBinding
Warning: Cannot convert string "<Key>Home,_Key_Begin" to type VirtualBinding
Warning: Cannot convert string "<Key>F1,_Key_Help" to type VirtualBinding
Warning: Cannot convert string "Shift<Key>F10,_Key_Menu" to type VirtualBinding
Warning: Cannot convert string "<Key>F10,Shift_Key_Menu" to type VirtualBinding
Warning: Cannot convert string "<Key>KP_Enter,_Key_Execute" to type VirtualBinding
Warning: Cannot convert string "Alt<Key>Return,Alt_Key_KP_Enter" to type VirtualBinding
Warning: Cannot convert string "<Key>Escape,_Key_Cancel" to type VirtualBinding
Warning: Cannot convert string "<Key>Home,_Key_Begin" to type VirtualBinding
Warning: Cannot convert string "<Key>F1,_Key_Help" to type VirtualBinding
Warning: Cannot convert string "Shift<Key>F10,_Key_Menu" to type VirtualBinding
Warning: Cannot convert string "<Key>F10,Shift_Key_Menu" to type VirtualBinding
Warning: Cannot convert string "<Key>KP_Enter,_Key_Execute" to type VirtualBinding
Warning: Cannot convert string "Alt<Key>Return,Alt_Key_KP_Enter" to type VirtualBinding
In Product Registration Page
In UNIX 그룹 이름 Page
In 클러스터 노드 선택 Page
In 파일 위치 Page
In 사용 가능한 제품 Page
In 설치 유형 Page
In 구성 요소 위치 Page
In Title Page
In Title Page
In 디렉토리 선택 Page
In Title Page
In 요약 Page
※ OS 환경설정 과정중 enterprise.rsp 수정시
#Parameter: s_cfgtyperet
#Type: String
s_cfgtyperet="Software Only"
부분을 추가해 주어야 OUI상태에서 위의 암호묻는 창이 뜨지 않는다.
#Parameter: s_cfgtyperet
#Type: String
s_cfgtyperet="Software Only"
부분을 추가해 주어야 OUI상태에서 위의 암호묻는 창이 뜨지 않는다.
2. 설치 잘 되었나 확인
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Dec 21 22:21:31 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Dec 21 22:21:31 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>
1. 엔진설치 완료후 패치 파일 압축 풀기
$ cd /home/oracle/install/patchset
$ unzip p4547809_92080_LINUX.zip
$ unzip p4547809_92080_LINUX.zip
2. root 계정으로 patchset.rsp 수정
# vi /home/oracle/install/patchset/Disk1/response/patchset.rsp
#-------------------------------------------------------------------------------
#Name : UNIX_GROUP_NAME
#Datatype : String
#Description: Unix group to be set for the inventory directory. Valid only in Unix platforms.
#Example: UNIX_GROUP_NAME = "install"
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME="dba"
#Name : UNIX_GROUP_NAME
#Datatype : String
#Description: Unix group to be set for the inventory directory. Valid only in Unix platforms.
#Example: UNIX_GROUP_NAME = "install"
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME="dba"
#-------------------------------------------------------------------------------
#Name : FROM_LOCATION
#Datatype : String
#Description: Complete path to the products.xml.
#Example: FROM_LOCATION = "../stage/products.xml"
#-------------------------------------------------------------------------------
FROM_LOCATION="/home/oracle/install/patchset/Disk1/stage/products.xml"
#Name : FROM_LOCATION
#Datatype : String
#Description: Complete path to the products.xml.
#Example: FROM_LOCATION = "../stage/products.xml"
#-------------------------------------------------------------------------------
FROM_LOCATION="/home/oracle/install/patchset/Disk1/stage/products.xml"
#-------------------------------------------------------------------------------
#Name : ORACLE_HOME
#Datatype : String
#Description: Complete path of the Oracle Home.
#Example: ORACLE_HOME = "C:\OHOME1"
#-------------------------------------------------------------------------------
ORACLE_HOME="/home/oracle/product/OraHome"
#Name : ORACLE_HOME
#Datatype : String
#Description: Complete path of the Oracle Home.
#Example: ORACLE_HOME = "C:\OHOME1"
#-------------------------------------------------------------------------------
ORACLE_HOME="/home/oracle/product/OraHome"
#-------------------------------------------------------------------------------
#Name : ORACLE_HOME_NAME
#Datatype : String
#Description: Oracle Home Name. Used in creating folders and services.
#Example: ORACLE_HOME_NAME = "OHOME1"
#-------------------------------------------------------------------------------
ORACLE_HOME_NAME="OraHome"
#Name : ORACLE_HOME_NAME
#Datatype : String
#Description: Oracle Home Name. Used in creating folders and services.
#Example: ORACLE_HOME_NAME = "OHOME1"
#-------------------------------------------------------------------------------
ORACLE_HOME_NAME="OraHome"
3. 설치
$ cd /home/oracle/install/patchset/Disk1/
$ ./runInstaller -silent -responseFile /home/oracle/install/patchset/Disk1/response/patchset.rsp
$ ./runInstaller -silent -responseFile /home/oracle/install/patchset/Disk1/response/patchset.rsp
아래는 사일런트 모드로 runInstaller 실행후 진행되는 상황
파일 복사 진행 중 (Wed Dec 21 23:42:07 KST 2011)
............................................................... 31% 완료되었습니다
................................................................ 62%완료되었습니다
................................................................ 94% 완료되었습니다
... 95% 완료되었습니다.복사 성공
링크 진행 중 (Wed Dec 21 23:44:34 KST 2011)
... 96% 완료되었습니다.
링크 성공
설정 진행 중 (Wed Dec 21 23:45:40 KST 2011)
... 98% 완료되었습니다.
설정 성공
설치 단계가 완료되었습니다.(Wed Dec 21 23:45:44 KST 2011)
경고:*** 경보: 설치를 완료하려면 구성 스크립트를 루트로 실행해야 합니다. 설치 완료 시 /home/oracle/product/OraHome/root.sh을(를) 루트 권한으로 실행하십시오. ***
설치를 완료하려면 구성 스크립트를 루트로 실행해야 합니다. 설치 완료 시 /home/oracle/product/OraHome/root.sh을(를) 루트 권한으로 실행하십시오.
Oracle 9iR2 Patch Set의 설치을(를) 성공했습니다.
자세한 내용은 /home/oracle/oraInventory/logs/silentInstall2011-12-21_11-41-50PM.log을(를) 확인하십시오.
LDAP Required Support Files Patch 9.2.0.8.0
Oracle Net Required Support Files Patch 9.2.0.8.0
Oracle9i Globalization Support Patch 9.2.0.8.0
Oracle Core Required Support Files Patch 9.2.0.8.0
Oracle Trace Required Support Files Patch 9.2.0.8.0
Precompiler Required Support Files Patch 9.2.0.8.0
RDBMS Required Support Files Patch 9.2.0.8.0
SSL Required Support Files Patch 9.2.0.8.0
XDK Required Support Files Patch 9.2.0.8.0
Oracle Database Utilities Patch 9.2.0.8.0
XML Parser for Java Patch 9.2.0.8.0
XML Parser for Oracle JVM Patch 9.2.0.8.0
Oracle Internet Directory Client Patch 9.2.0.8.0
Oracle Common Schema Demos Patch 9.2.0.8.0
Oracle Net Listener Patch 9.2.0.8.0
Database Verify Utility Patch 9.2.0.8.0
Utilities Common Files Patch 9.2.0.8.0
Oracle Net Patch 9.2.0.8.0
Oracle OLAP API Patch 9.2.0.8.0
Oracle Partitioning Patch 9.2.0.8.0
Oracle Net Manager Patch 9.2.0.8.0
PL/SQL Required Support Files Patch 9.2.0.8.0
Secure Socket Layer Patch 9.2.0.8.0
Oracle Database Demos Patch 9.2.0.8.0
Oracle JVM Patch 9.2.0.8.0
Oracle XML SQL Utility Patch 9.2.0.8.0
SQLJ Runtime Patch 9.2.0.8.0
XML 9.2.0.8.0
Oracle JDBC Thin Driver for JDK 1.2 Patch 9.2.0.8.0
Oracle Spatial Patch 9.2.0.8.0
Oracle Ultra Search Common Files Patch 9.2.0.8.0
Oracle Ultra Search Middle-Tier Patch 9.2.0.8.0
DBJAVA Required Support Files Patch 9.2.0.8.0
Oracle Java Tools Patch 9.2.0.8.0
Oracle JDBC Thin Driver for JDK 1.4 Patch 9.2.0.8.0
Oracle Ultra Search Server Patch 9.2.0.8.0
Oracle Call Interface (OCI) Patch 9.2.0.8.0
Oracle XML Developer's Kit Patch 9.2.0.10.0
Oracle interMedia Client Demos Patch 9.2.0.8.0
XML Parser for C++ Patch 9.2.0.8.0
XML Parser for C Patch 9.2.0.8.0
XML Parser for PL/SQL Patch 9.2.0.8.0
Assistant Common Files Patch 9.2.0.8.0
Oracle Internet Directory Client Common Files Patch 9.2.0.8.0
Installation Common Files Patch 9.2.0.8.0
SQL*Plus Required Support Files Patch 9.2.0.8.0
Oracle JDBC Thin Driver for JDK 1.1 Patch 9.2.0.8.0
Oracle Intelligent Agent Base Component Files Patch 9.2.0.8.0
Oracle Applications Extensions Patch 9.2.0.8.0
Oracle EMD Agent Extensions Patch 9.2.0.8.0
Data Management Services Common Files Patch 9.2.0.8.0
Oracle interMedia Audio 9.2.0.8.0
Oracle interMedia Image 9.2.0.8.0
Oracle interMedia Video 9.2.0.8.0
XML Class Generator for C++ 9.2.0.8.0
XML Class Generator for Java 9.2.0.8.0
XML Transx 9.2.0.8.0
XML Transviewer Beans 9.2.0.8.0
Oracle Data Mining Patch 9.2.0.8.0
Advanced Replication Patch 9.2.0.8.0
Character Set Migration Utility 9.2.0.8.0
Oracle eBusiness Management Extensions Patch 9.2.0.8.0
Oracle SQLJ Patch 9.2.0.8.0
Oracle Net Configuration Assistant Patch 9.2.0.8.0
XSQL Servlet 9.2.0.8.0
JDBC Common Files Patch 9.2.0.8.0
Oracle Forms Extensions Patch 9.2.0.8.0
Oracle HTTP Server Extensions Patch 9.2.0.8.0
Oracle Intelligent Agent Config Tool Patch 9.2.0.8.0
Oracle interMedia Java Client Patch 9.2.0.8.0
Oracle interMedia Java Media Framework Client Patch 9.2.0.8.0
Oracle interMedia Web Client Patch 9.2.0.8.0
Documentaion Required Support Files Patch 9.2.0.8.0
Platform Required Support Files Patch 9.2.0.8.0
Oracle Internet Directory Tools Patch 9.2.0.8.0
Patch of Modplsql 3.0.9.8.5f
PL/SQL Embedded Gateway Patch 9.2.0.8.0
Oracle Universal Installer 10.1.0.5.0
Oracle One-Off Patch Installer 10.1.0.5.0
Installer SDK Component 10.1.0.5.0
Java Runtime Environment 1.4.2.02.0
Oracle Java Core Patch 9.2.0.8.0
이미 설치됨 (108 제품)
iSQL*Plus 9.2.0.4.0
Oracle Text 9.2.0.4.0
Oracle interMedia Locator 9.2.0.4.0
Oracle JDBC Development Drivers 9.2.0.4.0
JDBC/OCI Common Files 9.2.0.4.0
Authentication and Encryption 9.2.0.4.0
Oracle Wallet Manager 9.2.0.4.0
Oracle interMedia Client Compatibility Files 9.2.0.4.0
Oracle interMedia Common Files 9.2.0.4.0
Oracle interMedia Java Advanced Imaging 9.2.0.4.0
Oracle OLAP 9.2.0.4.0
Oracle OLAP CWM Lite 9.2.0.4.0
Object Type Translator 9.2.0.4.0
Precompiler Common Files 9.2.0.4.0
Oracle9i 9.2.0.4.0
Advanced Queueing (AQ) API 9.2.0.4.0
Database SQL Scripts 9.2.0.4.0
Export/Import 9.2.0.4.0
Generic Connectivity Common Files 9.2.0.4.0
Generic Connectivity Using ODBC 9.2.0.4.0
Migration Utility 9.2.0.4.0
New Database ID 9.2.0.4.0
Oracle C++ Call Interface 9.2.0.4.0
Oracle Trace 9.2.0.4.0
PL/SQL 9.2.0.4.0
Recovery Manager 9.2.0.4.0
SQL*Loader 9.2.0.4.0
SQL*Plus 9.2.0.4.0
Agent Required Support Files 9.2.0.4.0
Oracle Client Required Support Files 9.2.0.4.0
LDAP Required Support Files 9.2.0.4.0
Oracle Net Required Support Files 9.2.0.4.0
Oracle9i Globalization Support 9.2.0.4.0
Oracle Core Required Support Files 9.2.0.4.0
Oracle Trace Required Support Files 9.2.0.4.0
Precompiler Required Support Files 9.2.0.4.0
RDBMS Required Support Files 9.2.0.4.0
SSL Required Support Files 9.2.0.4.0
XDK Required Support Files 9.2.0.4.0
Oracle Database Utilities 9.2.0.4.0
XML Parser for Java 9.2.0.4.0
XML Parser for Oracle JVM 9.2.0.4.0
Oracle Internet Directory Client 9.2.0.4.0
Oracle Common Schema Demos 9.2.0.4.0
Oracle Net Listener 9.2.0.4.0
Database Verify Utility 9.2.0.4.0
Utilities Common Files 9.2.0.4.0
Oracle Net 9.2.0.4.0
Oracle OLAP API 9.2.0.4.0
Oracle Partitioning 9.2.0.4.0
Oracle Net Manager 9.2.0.4.0
PL/SQL Required Support Files 9.2.0.4.0
Secure Socket Layer 9.2.0.4.0
Oracle Database Demos 9.2.0.4.0
Oracle JVM 9.2.0.4.0
Oracle XML SQL Utility 9.2.0.4.0
SQLJ Runtime 9.2.0.4.0
XML 9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.2 9.2.0.4.0
Oracle Spatial 9.2.0.4.0
Oracle Ultra Search Common Files 9.2.0.4.0
Oracle Ultra Search Middle-Tier 9.2.0.4.0
DBJAVA Required Support Files 9.2.0.4.0
Oracle Java Tools 9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.4 9.2.0.4.0
Oracle Ultra Search Server 9.2.0.4.0
Oracle Call Interface (OCI) 9.2.0.4.0
Oracle XML Developer's Kit 9.2.0.4.0
Oracle interMedia Client Demos 9.2.0.4.0
XML Parser for C++ 9.2.0.4.0
XML Parser for C 9.2.0.4.0
XML Parser for PL/SQL 9.2.0.4.0
Assistant Common Files 9.2.0.4.0
Oracle Internet Directory Client Common Files 9.2.0.4.0
Installation Common Files 9.2.0.4.0
SQL*Plus Required Support Files 9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.1 9.2.0.4.0
Oracle Intelligent Agent Base Component Files 9.2.0.4.0
Oracle Applications Extensions 9.2.0.4.0
Oracle EMD Agent Extensions 9.2.0.4.0
Data Management Services Common Files 9.2.0.4.0
Oracle interMedia Audio 9.2.0.4.0
Oracle interMedia Image 9.2.0.4.0
Oracle interMedia Video 9.2.0.4.0
XML Class Generator for C++ 9.2.0.4.0
XML Class Generator for Java 9.2.0.4.0
XML Transx 9.2.0.4.0
XML Transviewer Beans 9.2.0.4.0
Oracle Data Mining 9.2.0.4.0
Advanced Replication 9.2.0.4.0
Character Set Migration Utility 9.2.0.4.0
Oracle eBusiness Management Extensions 9.2.0.4.0
Oracle SQLJ 9.2.0.4.0
Oracle Net Configuration Assistant 9.2.0.4.0
XSQL Servlet 9.2.0.4.0
JDBC Common Files 9.2.0.4.0
Oracle Forms Extensions 9.2.0.1.0
Oracle HTTP Server Extensions 9.2.0.1.0
Oracle Intelligent Agent Config Tool 9.2.0.1.0
Oracle interMedia Java Client 9.2.0.1.0
Oracle interMedia Java Media Framework Client 9.2.0.1.0
Oracle interMedia Web Client 9.2.0.1.0
Documentaion Required Support Files 9.2.0.1.0
Platform Required Support Files 9.2.0.1.0
Oracle Internet Directory Tools 9.2.0.1.0
Oracle Mod PL/SQL Gateway 3.0.9.8.3b
PL/SQL Embedded Gateway 9.2.0.1.0
Sun JDK extensions 9.2.0.4.0
-----------------------------------------------------------------------------
Oracle Net Required Support Files Patch 9.2.0.8.0
Oracle9i Globalization Support Patch 9.2.0.8.0
Oracle Core Required Support Files Patch 9.2.0.8.0
Oracle Trace Required Support Files Patch 9.2.0.8.0
Precompiler Required Support Files Patch 9.2.0.8.0
RDBMS Required Support Files Patch 9.2.0.8.0
SSL Required Support Files Patch 9.2.0.8.0
XDK Required Support Files Patch 9.2.0.8.0
Oracle Database Utilities Patch 9.2.0.8.0
XML Parser for Java Patch 9.2.0.8.0
XML Parser for Oracle JVM Patch 9.2.0.8.0
Oracle Internet Directory Client Patch 9.2.0.8.0
Oracle Common Schema Demos Patch 9.2.0.8.0
Oracle Net Listener Patch 9.2.0.8.0
Database Verify Utility Patch 9.2.0.8.0
Utilities Common Files Patch 9.2.0.8.0
Oracle Net Patch 9.2.0.8.0
Oracle OLAP API Patch 9.2.0.8.0
Oracle Partitioning Patch 9.2.0.8.0
Oracle Net Manager Patch 9.2.0.8.0
PL/SQL Required Support Files Patch 9.2.0.8.0
Secure Socket Layer Patch 9.2.0.8.0
Oracle Database Demos Patch 9.2.0.8.0
Oracle JVM Patch 9.2.0.8.0
Oracle XML SQL Utility Patch 9.2.0.8.0
SQLJ Runtime Patch 9.2.0.8.0
XML 9.2.0.8.0
Oracle JDBC Thin Driver for JDK 1.2 Patch 9.2.0.8.0
Oracle Spatial Patch 9.2.0.8.0
Oracle Ultra Search Common Files Patch 9.2.0.8.0
Oracle Ultra Search Middle-Tier Patch 9.2.0.8.0
DBJAVA Required Support Files Patch 9.2.0.8.0
Oracle Java Tools Patch 9.2.0.8.0
Oracle JDBC Thin Driver for JDK 1.4 Patch 9.2.0.8.0
Oracle Ultra Search Server Patch 9.2.0.8.0
Oracle Call Interface (OCI) Patch 9.2.0.8.0
Oracle XML Developer's Kit Patch 9.2.0.10.0
Oracle interMedia Client Demos Patch 9.2.0.8.0
XML Parser for C++ Patch 9.2.0.8.0
XML Parser for C Patch 9.2.0.8.0
XML Parser for PL/SQL Patch 9.2.0.8.0
Assistant Common Files Patch 9.2.0.8.0
Oracle Internet Directory Client Common Files Patch 9.2.0.8.0
Installation Common Files Patch 9.2.0.8.0
SQL*Plus Required Support Files Patch 9.2.0.8.0
Oracle JDBC Thin Driver for JDK 1.1 Patch 9.2.0.8.0
Oracle Intelligent Agent Base Component Files Patch 9.2.0.8.0
Oracle Applications Extensions Patch 9.2.0.8.0
Oracle EMD Agent Extensions Patch 9.2.0.8.0
Data Management Services Common Files Patch 9.2.0.8.0
Oracle interMedia Audio 9.2.0.8.0
Oracle interMedia Image 9.2.0.8.0
Oracle interMedia Video 9.2.0.8.0
XML Class Generator for C++ 9.2.0.8.0
XML Class Generator for Java 9.2.0.8.0
XML Transx 9.2.0.8.0
XML Transviewer Beans 9.2.0.8.0
Oracle Data Mining Patch 9.2.0.8.0
Advanced Replication Patch 9.2.0.8.0
Character Set Migration Utility 9.2.0.8.0
Oracle eBusiness Management Extensions Patch 9.2.0.8.0
Oracle SQLJ Patch 9.2.0.8.0
Oracle Net Configuration Assistant Patch 9.2.0.8.0
XSQL Servlet 9.2.0.8.0
JDBC Common Files Patch 9.2.0.8.0
Oracle Forms Extensions Patch 9.2.0.8.0
Oracle HTTP Server Extensions Patch 9.2.0.8.0
Oracle Intelligent Agent Config Tool Patch 9.2.0.8.0
Oracle interMedia Java Client Patch 9.2.0.8.0
Oracle interMedia Java Media Framework Client Patch 9.2.0.8.0
Oracle interMedia Web Client Patch 9.2.0.8.0
Documentaion Required Support Files Patch 9.2.0.8.0
Platform Required Support Files Patch 9.2.0.8.0
Oracle Internet Directory Tools Patch 9.2.0.8.0
Patch of Modplsql 3.0.9.8.5f
PL/SQL Embedded Gateway Patch 9.2.0.8.0
Oracle Universal Installer 10.1.0.5.0
Oracle One-Off Patch Installer 10.1.0.5.0
Installer SDK Component 10.1.0.5.0
Java Runtime Environment 1.4.2.02.0
Oracle Java Core Patch 9.2.0.8.0
이미 설치됨 (108 제품)
iSQL*Plus 9.2.0.4.0
Oracle Text 9.2.0.4.0
Oracle interMedia Locator 9.2.0.4.0
Oracle JDBC Development Drivers 9.2.0.4.0
JDBC/OCI Common Files 9.2.0.4.0
Authentication and Encryption 9.2.0.4.0
Oracle Wallet Manager 9.2.0.4.0
Oracle interMedia Client Compatibility Files 9.2.0.4.0
Oracle interMedia Common Files 9.2.0.4.0
Oracle interMedia Java Advanced Imaging 9.2.0.4.0
Oracle OLAP 9.2.0.4.0
Oracle OLAP CWM Lite 9.2.0.4.0
Object Type Translator 9.2.0.4.0
Precompiler Common Files 9.2.0.4.0
Oracle9i 9.2.0.4.0
Advanced Queueing (AQ) API 9.2.0.4.0
Database SQL Scripts 9.2.0.4.0
Export/Import 9.2.0.4.0
Generic Connectivity Common Files 9.2.0.4.0
Generic Connectivity Using ODBC 9.2.0.4.0
Migration Utility 9.2.0.4.0
New Database ID 9.2.0.4.0
Oracle C++ Call Interface 9.2.0.4.0
Oracle Trace 9.2.0.4.0
PL/SQL 9.2.0.4.0
Recovery Manager 9.2.0.4.0
SQL*Loader 9.2.0.4.0
SQL*Plus 9.2.0.4.0
Agent Required Support Files 9.2.0.4.0
Oracle Client Required Support Files 9.2.0.4.0
LDAP Required Support Files 9.2.0.4.0
Oracle Net Required Support Files 9.2.0.4.0
Oracle9i Globalization Support 9.2.0.4.0
Oracle Core Required Support Files 9.2.0.4.0
Oracle Trace Required Support Files 9.2.0.4.0
Precompiler Required Support Files 9.2.0.4.0
RDBMS Required Support Files 9.2.0.4.0
SSL Required Support Files 9.2.0.4.0
XDK Required Support Files 9.2.0.4.0
Oracle Database Utilities 9.2.0.4.0
XML Parser for Java 9.2.0.4.0
XML Parser for Oracle JVM 9.2.0.4.0
Oracle Internet Directory Client 9.2.0.4.0
Oracle Common Schema Demos 9.2.0.4.0
Oracle Net Listener 9.2.0.4.0
Database Verify Utility 9.2.0.4.0
Utilities Common Files 9.2.0.4.0
Oracle Net 9.2.0.4.0
Oracle OLAP API 9.2.0.4.0
Oracle Partitioning 9.2.0.4.0
Oracle Net Manager 9.2.0.4.0
PL/SQL Required Support Files 9.2.0.4.0
Secure Socket Layer 9.2.0.4.0
Oracle Database Demos 9.2.0.4.0
Oracle JVM 9.2.0.4.0
Oracle XML SQL Utility 9.2.0.4.0
SQLJ Runtime 9.2.0.4.0
XML 9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.2 9.2.0.4.0
Oracle Spatial 9.2.0.4.0
Oracle Ultra Search Common Files 9.2.0.4.0
Oracle Ultra Search Middle-Tier 9.2.0.4.0
DBJAVA Required Support Files 9.2.0.4.0
Oracle Java Tools 9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.4 9.2.0.4.0
Oracle Ultra Search Server 9.2.0.4.0
Oracle Call Interface (OCI) 9.2.0.4.0
Oracle XML Developer's Kit 9.2.0.4.0
Oracle interMedia Client Demos 9.2.0.4.0
XML Parser for C++ 9.2.0.4.0
XML Parser for C 9.2.0.4.0
XML Parser for PL/SQL 9.2.0.4.0
Assistant Common Files 9.2.0.4.0
Oracle Internet Directory Client Common Files 9.2.0.4.0
Installation Common Files 9.2.0.4.0
SQL*Plus Required Support Files 9.2.0.4.0
Oracle JDBC Thin Driver for JDK 1.1 9.2.0.4.0
Oracle Intelligent Agent Base Component Files 9.2.0.4.0
Oracle Applications Extensions 9.2.0.4.0
Oracle EMD Agent Extensions 9.2.0.4.0
Data Management Services Common Files 9.2.0.4.0
Oracle interMedia Audio 9.2.0.4.0
Oracle interMedia Image 9.2.0.4.0
Oracle interMedia Video 9.2.0.4.0
XML Class Generator for C++ 9.2.0.4.0
XML Class Generator for Java 9.2.0.4.0
XML Transx 9.2.0.4.0
XML Transviewer Beans 9.2.0.4.0
Oracle Data Mining 9.2.0.4.0
Advanced Replication 9.2.0.4.0
Character Set Migration Utility 9.2.0.4.0
Oracle eBusiness Management Extensions 9.2.0.4.0
Oracle SQLJ 9.2.0.4.0
Oracle Net Configuration Assistant 9.2.0.4.0
XSQL Servlet 9.2.0.4.0
JDBC Common Files 9.2.0.4.0
Oracle Forms Extensions 9.2.0.1.0
Oracle HTTP Server Extensions 9.2.0.1.0
Oracle Intelligent Agent Config Tool 9.2.0.1.0
Oracle interMedia Java Client 9.2.0.1.0
Oracle interMedia Java Media Framework Client 9.2.0.1.0
Oracle interMedia Web Client 9.2.0.1.0
Documentaion Required Support Files 9.2.0.1.0
Platform Required Support Files 9.2.0.1.0
Oracle Internet Directory Tools 9.2.0.1.0
Oracle Mod PL/SQL Gateway 3.0.9.8.3b
PL/SQL Embedded Gateway 9.2.0.1.0
Sun JDK extensions 9.2.0.4.0
-----------------------------------------------------------------------------
파일 복사 진행 중 (Wed Dec 21 23:42:07 KST 2011)
............................................................... 31% 완료되었습니다
................................................................ 62%완료되었습니다
................................................................ 94% 완료되었습니다
... 95% 완료되었습니다.복사 성공
링크 진행 중 (Wed Dec 21 23:44:34 KST 2011)
... 96% 완료되었습니다.
링크 성공
설정 진행 중 (Wed Dec 21 23:45:40 KST 2011)
... 98% 완료되었습니다.
설정 성공
설치 단계가 완료되었습니다.(Wed Dec 21 23:45:44 KST 2011)
경고:*** 경보: 설치를 완료하려면 구성 스크립트를 루트로 실행해야 합니다. 설치 완료 시 /home/oracle/product/OraHome/root.sh을(를) 루트 권한으로 실행하십시오. ***
설치를 완료하려면 구성 스크립트를 루트로 실행해야 합니다. 설치 완료 시 /home/oracle/product/OraHome/root.sh을(를) 루트 권한으로 실행하십시오.
Oracle 9iR2 Patch Set의 설치을(를) 성공했습니다.
자세한 내용은 /home/oracle/oraInventory/logs/silentInstall2011-12-21_11-41-50PM.log을(를) 확인하십시오.
위와 같이 진행되지 않고 생각보다 짧게 진행되었다면, 패치가 안되었을 가능성이 높다.
재부팅후 다시 시도해 보자.
!! 재부팅을 하지 않을시 오류가 발생하는 경우가 있다. 엔진 설치 후 sqlplus가 실행되며 해당 프로세스가 실행된 상태에서 패치를 하려는 과정에서 일어나는 문제로 판단된다.
재부팅후 다시 시도해 보자.
!! 재부팅을 하지 않을시 오류가 발생하는 경우가 있다. 엔진 설치 후 sqlplus가 실행되며 해당 프로세스가 실행된 상태에서 패치를 하려는 과정에서 일어나는 문제로 판단된다.
4. 설치 완료되면 root계정으로 홈디렉토리 밑에 root.sh 실행
# /home/oracle/product/OraHome/root.sh → 엔터, y,y,y
Running Oracle9 root.sh script...
\nThe following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /home/oracle/product/OraHome
\nThe following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /home/oracle/product/OraHome
Enter the full pathname of the local bin directory: [/usr/local/bin]: (엔터)
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
\nCreating /etc/oratab file...
Adding entry to /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Adding entry to /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
5. 패치 잘 되었나 확인
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Wed Dec 21 23:53:28 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>
SQL*Plus: Release 9.2.0.8.0 - Production on Wed Dec 21 23:53:28 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>
OS 환경설정 → 엔진설치 → 엔진패치 → DB생성
1. dbca.rsp 파일 수정 → SID와 CHARACTERSET만 수정해주고 다른건 기본설정으로 둔다.
$ vi /home/oracle/install/Disk1/response/dbca.rsp
#-----------------------------------------------------------------------------
# Name : SID
# Datatype : String
# Description : System identifier (SID) of the database
# Valid values : Check Oracle9i Administrator's Guide
# Default value : <db_name> specified in GDBNAME
# Mandatory : No
#-----------------------------------------------------------------------------
SID = "testdb"
#-----------------------------------------------------------------------------
# Name : NATIONALCHARACTERSET
# Datatype : String
# Description : National Character set of the database
# Valid values : "UTF8" or "AL16UTF16". For details, check Oracle9i National Language Support Guide
# Default value : "AL16UTF16"
# Mandatory : No
#-----------------------------------------------------------------------------
NATIONALCHARACTERSET= "UTF8"
# Name : SID
# Datatype : String
# Description : System identifier (SID) of the database
# Valid values : Check Oracle9i Administrator's Guide
# Default value : <db_name> specified in GDBNAME
# Mandatory : No
#-----------------------------------------------------------------------------
SID = "testdb"
#-----------------------------------------------------------------------------
# Name : NATIONALCHARACTERSET
# Datatype : String
# Description : National Character set of the database
# Valid values : "UTF8" or "AL16UTF16". For details, check Oracle9i National Language Support Guide
# Default value : "AL16UTF16"
# Mandatory : No
#-----------------------------------------------------------------------------
NATIONALCHARACTERSET= "UTF8"
2. db생성
$ cd /home/oracle/product/OraHome/bin
$ ./dbca -silent -datafileJarLocation /home/oracle/product/OraHome/assistants/dbca/templates/ -responseFile /home/oracle/install/Disk1/response/dbca.rsp
$ ./dbca -silent -datafileJarLocation /home/oracle/product/OraHome/assistants/dbca/templates/ -responseFile /home/oracle/install/Disk1/response/dbca.rsp
3. 설치 잘 되었나 확인
$ sqlplus /nolog
> conn / as sysdba
Connected.
> conn / as sysdba
Connected.
> select status from v$instance;
STATUS
--------------
OPEN
SQL> STATUS
--------------
OPEN
'Oracle > Oracle - 설치' 카테고리의 다른 글
| 패치(Patch) 용어정리 및 DB 패치 방법 (0) | 2011.12.23 |
|---|---|
| Oracle 삭제하기 (0) | 2011.12.22 |
| RHEL4 - 9i 설치 _OUI (2) | 2011.12.21 |
| RHEL3 - 9i 설치 _OUI (0) | 2011.12.19 |
| RHEL3 - 8i 설치 _OUI (0) | 2011.12.17 |
