!!!Fedora Core 6 Oracle Express Edition のインストール(メモ)
{{include_html banner_html, "!FedoraCora"}}
[Oracle XE]
Fedora Core 6 の Xen ゲストOSに、Oracle Database Express Edition をインストールする。

!パッケージのチェック

 # rpm -q glibc
 glibc-2.5-10.fc6
 # rpm -q libaio
 パッケージ libaio はインストールされていません。

::libaio をインストール

yum で検索する
 # yum search libaio
 Loading "installonlyn" plugin
 Setting up repositories
 Reading repository metadata in from local files
 
 libaio-devel.i386                         0.3.106-3.2            core            
 Matched from:
 libaio-devel
 
 libaio.i386                              0.3.106-3.2            core            
 Matched from:
 libaio
 The Linux-native asynchronous I/O facility ("async I/O", or "aio") has a
 richer API and capability set than the simple POSIX async I/O facility.
 This library, libaio, provides the Linux-native API for async I/O.
 The POSIX async I/O facility requires this library in order to provide
 kernel-accelerated async I/O capabilities, as do applications which
 require the Linux-native async I/O API.

yum でインストール

 # yum install libaio
 Loading "installonlyn" plugin
 Setting up Install Process
 Setting up repositories
 Reading repository metadata in from local files
 Parsing package install arguments
 　　　　　：
!Oracle XE のインストール

::インストール
 # rpm -ivh oracle_xe/oracle-xe-univ-10.2.0.1-1.0.i386.rpm 
 準備中...                ########################################### [100%]
 1:oracle-xe-univ         ########################################### [100%]
 Executing Post-install steps...
 You must run '/etc/init.d/oracle-xe configure' as the root user to 
 configure the database.

インストール完了
{{ref_image oracle.png}}

::設定
インストールが完了したら、以下を実行
ポート 8080は何かと都合がわるので、8090に変更し、ポートはデフォルト、起動時に実行はyesとする
 # /etc/init.d/oracle-xe configure
 
 Oracle Database 10g Express Edition Configuration
 -------------------------------------------------
 This will configure on-boot properties of Oracle Database 10g Express 
 Edition.  The following questions will determine whether the database should 
 be starting upon system boot, the ports it will use, and the passwords that 
 will be used for database accounts.  Press <Enter> to accept the defaults. 
 Ctrl-C will abort.
 
 Specify the HTTP port that will be used for Oracle Application Express [8080]:8090
 
 Specify a port that will be used for the database listener [1521]:
 
 Specify a password to be used for database accounts.  Note that the same
 password will be used for SYS and SYSTEM.  Oracle recommends the use of 
 different passwords for each database account.  This can be done after 
 initial configuration:
 Confirm the password:
 
 D o you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:y
 
 Starting Oracle Net Listener...Done
 Configuring Database...Done
 Starting Oracle Database 10g Express Edition Instance...Done
 Installation Completed Successfully.
 To access the Database Home Page go to "http://127.0.0.1:8090/apex"

管理ツール起動
{{ref_image oracle-2.png}}

::環境変数の設定
SQLPLUSで、パスが設定されたことを確認
 # cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin
 # . ./oracle_env.sh

 # sqlplus /nolog
 
 SQL*Plus: Release 10.2.0.1.0 - Production on 土 2月 10 09:26:20 2007
 
 Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
 SQL> 

SQLPLUS起動
{{ref_image oracle-3.png}}

::/etc/bashrcの最後に以下の行を追加
シェル起動毎に、環境変数が設定されるように。
 . /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh

----
{{include_html banner_html, "!Oracle"}}