본문
1. Oracle 9i 설치 시 준비물
■ VMware
■ WinSCP
■ Red Hat Enterprise Linux 3
■ Oracle 9i
- ship_9204_linux_disk1.cpio
- ship_9204_linux_disk2.cpio
- ship_9204_linux_disk3.cpio
- p3006854_9204_LINUX.zip (패치)
- baekmuk-ttf-2.1.tar.gz (폰트파일)
- p4163445_92070_LINUX.zip (패치)
- p4547809_92080_LINUX.zip (패치)
2. RHEL3에 Oracle 9i 설치하기
2-1) 엔진 설치
> Oracle 계정 생성
[root@server117 root]# groupadd dba
[root@server117 root]# useradd -g dba oracle
[root@server117 root]# passwd oracle
Changing password for user oracle.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfilly.
[로그인] >> [비밀번호] : Oracle 계정 패스워드 입력 >> 확인 >>
(install 폴더)
- ship_9204_linux_disk1.cpio
- ship_9204_linux_disk2.cpio
- ship_9204_linux_disk3.cpio
- p3006854_9204_LINUX.zip (패치)
- baekmuk-ttf-2.1.tar.gz (폰트파일)
- p4163445_92070_LINUX.zip (패치)
- p4547809_92080_LINUX.zip (패치)
[root@server117 root]# echo ‘2147483648’ > /proc/sys/kernel/shmmax
[root@server117 root]# vi /etc/rc.d/rc.local
echo ‘2147483648’ > /proc/sys/kernel/shmmax
[root@server117 root]# sysctl –p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmmax = 2147483648
[root@server117 install]# cpio -idmv < ship_9204_linux_disk1.cpio
[root@server117 install]# cpio -idmv < ship_9204_linux_disk2.cpio
[root@server117 install]# cpio -idmv < ship_9204_linux_disk3.cpio
> 폰트 설정
[root@server117 install]# cd /home/oracle/install/font/
[root@server117 font]# tar zxvf baekmuk-ttf-2.1.tar.gz
[root@server117 font]# cp*.ttf
/home/oracle/install/Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/fonts/
[root@server117 font]# cp fonts.dir /home/oracle/install/Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/fonts/
( Overwrite 여부 y )
[root@server117 font]# cp font.properties.ko /home/oracle/install/Disk1/stage/Components/oracle.swd.jre/1.3.1.0.0/1/DataFiles/Expanded/jre/linux/lib/
> 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
# chown -R oracle.dba /home/oracle
# su - oracle
$ vi .bash_profile
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=testdb
export ORACLE_TERM=xterm
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949
export LANG=ko_KR.eucKR
: wq
# cd /home/oracle/install/patch
# unzip p3006854_9204_LINUX.zip
# cd 3006854
# sh rhel3_pre_install.sh
$ cd install/Disk1
$ ./runinstaller
다음 >>
확인 >>
Oracle 계정의 그룹인 dba 입력 >>
$ su -
Password:
# /tmp/oraInstRoot.sh
▶ 이름 : OUIHome ▶ 경로 : /home/oracle/product/9.2 입력 >>
$ su -
Password:
# /home/oracle/product/9.2/root.sh
[/usr/local/bin] : [Enter]
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on ··
3-2) 엔진 패치 (9.2.0.4.0 → 9.2.0.7.0)
$ unzip p4163445_92070_LINUX.zip
$ ./runInstaller
$ LANG=c
$ ./runInstaller
▶ Name : OUIHome ▶ Path : /home/oracle/product/9.2 >> Next >>
$ su -
Password:
# /home/oracle/product/9.2/root.sh
(Overwrite y 3번)
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.7.0 - Production on ···
3-3) DB 생성
$ dbca
testdb 입력(.bash_profile에 입력한···) >> 다음 >>
Password 입력 >> 종료 >>
$ sqlplus /nolog
SQL> conn / as sysdba
Connected.
SQL> select status from v$instance;
STATUS
--------
OPEN
3-4) DB 생성 후 엔진 패치 (9.2.0.7.0 → 9.2.0.8.0)
SQL> conn / as sysdba
Connected.
SQL>Shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
$ unzip p4547809_92080_LINUX.zip
$ cd /home/oracle/install/patchset/Disk1/
$ LANG=C
$ ./runInstaller
$ su -
Password:
# /home/oracle/product/9.2/root.sh
(Overwrite y 3번)
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on ···
SQL> conn / as sysdba
SQL> startup
> 각 각 설치버전 확인 - 하위 버전(9.2.0.4.0)임을 확인 할 수 있다
SQL> col COMP_NAME for a30
SQL> select comp_name, version, status from dba_registry;
SQL> shutdown
SQL> startup migrate
SQL> @?/rdbms/admin/catpatch.sql
> 설치버전 다시 확인
SQL> col COMP_NAME for a30
SQL> select comp_name, version, status from dba_registry;
> DB 상태 확인
SQL> select status from v$instance;
STATUS
-----------
OPEN
'Oracle_Install > Linux + Single' 카테고리의 다른 글
RHEL 3 + Oracle 8i 설치 (엔진, DB생성) (2) | 2014.10.17 |
---|