[Oracle] 10G RPM install - oracle 10G XE

--------------------------------------------------------------------------------
◆ 계정 생성
--------------------------------------------------------------------------------
[root@localhost root]# groupadd dba
[root@localhost root]# groupadd oinstall
[root@localhost root]# useradd -g oinstall -G dba oracle
[root@localhost root]# passwd oracle




--------------------------------------------------------------------------------
◆ 디렉토리 생성
--------------------------------------------------------------------------------
[root@localhost root]# mkdir -p /opt/ora9/product/9.2
[root@localhost root]# mkdir /var/opt/oracle
[root@localhost root]# chown oracle.dba /var/opt/oracle
[root@localhost root]# chown -R oracle.dba /opt/ora9




--------------------------------------------------------------------------------
◆ 필수 RPM 파일 확인 및 설치
--------------------------------------------------------------------------------
gcc-3.2.2-5
cpp-3.2.2-5
glibc-devel-2.3.2-11.9
binutils-2.13.90.0.18-9
compat-gcc-7.3-2.96.118.i386.rpm
compat-libgcj-7.3-2.96.118.i386.rpm
compat-libgcj-devel-7.3-2.96.118.i386.rpm
nss_db-compat-2.2-20.i386.rpm

설치되어 있지 않다면 http://rpmfind.net 에서 해당 rpm을 다운 받아 설치한다.
rpm -Uvh (package_name)




--------------------------------------------------------------------------------
◆ Maximum Share Memory Size의 증가
--------------------------------------------------------------------------------
/etc/sysctl.conf 를 vi로 열고 다음을 추가한다.

kernel.shmmax = 1073741824
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000

/etc/security/limits.conf 에는 다음을 추가한다.

oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384

저장하고 재부팅.




--------------------------------------------------------------------------------
◆ SWAP 메모리 1024kb 설정
--------------------------------------------------------------------------------

<추가>
..]# dd if=/dev/dba8 of=/swap bs=1024 count=65535
..]# mkswap /swap
..]# swapon /swap

<제거>
..]# swapoff /swap
..]# rm /swap


libaio-0.3.105-2.i386.rpm 설치

yum install libaio
rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
/etc/init.d/oracle-xe configure



--------------------------------------------------------------------------------
◆ SWAP 메모리 1024kb 설정
--------------------------------------------------------------------------------



Log on to your computer with root permissions.
Go to the following Web site:
http://www.oracle.com/technology/products/database/xe

Click Free Download and follow the instructions to select and download the Linux version of Oracle Database XE Server.
Run one the following Oracle Database XE executables to either install or upgrade Oracle Database XE server:
For Linux operating systems that use Debian:

Universal character set: oracle-xe-universal_10.2.0.1-1.0_i386.deb
Western European character set: oracle-xe_10.2.0.1-1.0_i386.deb

For all other supported Linux operating systems:

Universal character set: oracle-xe-univ-10.2.0.1-1.0.i386.rpm
Western European character set: oracle-xe-10.2.0.1-1.0.i386.rpm

For example, if you downloaded the oracle-xe-universal_10.2.0.1-1.0_i386.deb executable into a directory called downloads, you would enter the following command:

$ dpkg -i downloads/oracle-xe-universal_10.2.0.1-1.0_i386.deb

If you downloaded the oracle-xe-univ-10.2.0.1-1.0.i386.rpm executable, you would enter this command:

$ rpm -ivh downloads/oracle-xe-univ-10.2.0.1-1.0.i386.rpm

The installation displays a status of its progress.
When prompted, run the following command:

$ /etc/init.d/oracle-xe configure

Enter the following configuration information:
A valid HTTP port for the Oracle Database XE graphical user interface (the default is 8080)
A valid port for the Oracle database listener (the default is 1521)
A password for the SYS and SYSTEM administrative user accounts
Whether you want the database to start automatically when the computer starts
If you enter Yes, then the database starts immediately
If you need to change the configuration settings, then you can do so by running the following command:

$ /etc/init.d/oracle-xe configure

To start the database manually, run this command:

$ /etc/init.d/oracle-xe start

To stop the database manually, use the following command:

$ /etc/init.d/oracle-xe stop






To perform a silent installation of Oracle Database XE Server, you need to create a response file and a wrapper shell script to perform the silent installation. The silent installation response file handles the configuration information

To perform a silent installation:

After downloading the installation executable (described under "Procedure for Installing Oracle Database XE Server"), create a response file that contains settings for the following values:

A valid HTTP port numeric value, so that you can connect to the Oracle Database XE graphical user interface

A valid listener numeric port value, so that you can connect to the Oracle Database XE database

A password value for the SYS and SYSTEM administrative user accounts

The SYS and SYSTEM password value again, to confirm it

Yes (y) or no (n), to specify whether you want to start Oracle Database XE automatically when the computer starts

List only the values themselves, in the order shown as follows. For example:

8080
1521
44gh992
44gh992
y

Create a wrapper shell script to perform the silent installation.

It should contain commands similar to the following:

#!/bin/bash

rpm -ivh /downloads/oracle-xe-univ-10.2.0.1-1.0.i386 > /xe_logs/XEsilentinstall.log

/etc/init.d/oracle-xe configure < /downloads/responsefile >> /xe_logs/XEsilentinstall.log

Run the wrapper script.

For details of the installation, see the XEsilentinstall.log file.

After you complete the silent installation, set the Oracle Database XE Server environment variables, which is described next.