Installing Oracle 9i on Red Hat Linux 9

操作系统 LINUX REDHAT 9.0

一、
安装J2SDK
下载2sdk-1_4_2_09-linux-i586.bin
用root用户执行下面命令改变其权限
chmod 755 j2sdk-1_4_2_09-linux-i586.bin
解压
./j2sdk-1_4_2_09-linux-i586.bin
将解压后的文件放入usr目录中
mkdir /usr/java
mv /home/zhulx/soft/j2sdk1.4.2_09 /usr/java
输入命令java -version

java version "1.3.1"
jdkgcj 0.2.3 (http://www.arklinux.org/projects/jdkgcj)
gcj (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
如果出现上面提示则说明你及其中已经安装了jdkgcj，这个程序会与SUN JDK冲突所以我吧他卸载了
用rpm -q -a |grep jdkgcj命令查看具体的版本名称后执行下面命令卸载jdkgcj
rpm -e jdkgcj-0.2.3-5

为JDK修改环境变量文件

vi /etc/profile
进入编辑界面，再最后添加下列命令
#-------------------j2sdk-----------------------------
JAVA_HOME=/usr/java/j2sdk1.4.2_09
export JAVA_HOME
PATH=$PATH:$JAVA_HOME/bin
export PATH
CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/jre/lib/rt.jar
export CLASSPATH
#-----------------------------------------------------

执行source /etc/profile 重新加载环境变量
输入java -version 如果出现下列提示则说明安装完成
java version "1.4.2_09"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_09-b05)
Java HotSpot(TM) Client VM (build 1.4.2_09-b05, mixed mode)
[zhulx@localhost src]$

三、
安装ORACLE
ORACLE安装前的依赖要求：
gcc
cpp
glibc-devel
compat-libstdc++
glibc-kernheaders
binutils
可以使用命令来查看是否已安装了这些包
rpm -q gcc cpp compat-libstdc++ glibc-devel glibc-kernheaders binutils

下载下列文件
ship_9204_linux_disk1.cpio.gz
ship_9204_linux_disk2.cpio.gz
ship_9204_linux_disk3.cpio.gz
使用下列命令进行解压
zcat lnx_920_disk1.cpio.gz | cpio –idmv
zcat lnx_920_disk2.cpio.gz | cpio –idmv
zcat lnx_920_disk3.cpio.gz | cpio –idmv
解压出三个目录
Disk1 Disk2 Disk3

设置内存参数
vi /etc/sysctl.conf
加入下列参数，测试机512MB内存，可以根据具体情况修改这个数值
#-------------install oracle setup,memory is 512MB------------
kernel.shmmax=4294967295
#-------------------------------------------------------------
执行source /etc/sysctl.conf 重新加载环境变量
接下来按照ORACLE的要求为ORACLE创建用户和组以及安装目录，以root用户依次执行下列命令并设置oracle用户的口令
groupadd dba
groupadd oinstall
useradd -g oinstall -G dba oracle
passwd oracle （输入口令）

mkdir /opt/oracle
mkdir /opt/oracle/product
mkdir /opt/oracle/product/9204
chown -R oracle.oinstall /opt/oracle
mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chmod 755 /var/opt/oracle

以oracle用户登陆
编辑环境变量
vi .bash_profile
加入
#--------oracle setup------
export PATH LD_ASSUME_KERNEL=2.4.1
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/9204
export ORACLE_SID=OEMSID 
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
##(2)
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
##(3)  LD_LIBRARY_PATH
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin
CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export PATH  CLASSPATH
unset USERNAME
export DISPLAY=192.168.200.32:0.0
# ---- fix font cn bug  -----
export JAVA_FONTS=/usr/share/fonts/zh_CN/TrueType
#---------------------------
上文件中的DISPLAY参数指定的是安装图形界面的输出位置。这里指定一个IP
执行source .bash_profile重新加载环境变量

将解压好的ORACLE安装程序移动到oracle目录下
mv Disk1 /home/oracle/
mv Disk2 /home/oracle/
mv Disk3 /home/oracle/
./runInstaller
开始安装

Global Database Name= OEMREP

SID = OEMSID

Database Chracter Set= Simplified Chinese ZHS16GBK

中间要求以root执行一个命令，结果如下
[root@TestLinux /]# /opt/oracle/product/9204/root.sh
Running Oracle9 root.sh script...
/nThe following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /opt/oracle/product/9204

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 ...

/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.
设定ORACLE管理员口令
SYS : dba   (可根据实际情况修改)
SYSTEM :  sysdba  (可根据实际情况修改)

安装完成提示信息
The following information is available in:
/opt/oracle/product/9204/Apache/Apache/setupinfo.txt
-----------------------------------------
The HTTP Server can be accessed using the following URLs:

Non SSL Mode:
http://TestLinux:7777

SSL mode (executed at install time):
http://TestLinux:7778
https://TestLinux:4443

以root用户登陆删除/tmp目录下的临时文件
rm -rf /tmp/OraInstall*

以oracle用户登录
复制初始化配置文件
cp /opt/oracle/admin/OEMREP/pfile/initOEMSID.ora.* ${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora

执行下列命令启动数据库服务
oracle$ sqlplus /nolog
SQL> connect / as sysdba
SQL> startup

执行下列命令启动监听服务
lsnrctl start

配置启动服务
创建oracle服务启动教本
vi /etc/rc.d/init.d/oracle
加入下列内容
#!/bin/sh
#-------------------------- start ------------------------------
OPT_=$1

case "$OPT_" in
start)
        /bin/echo "$0 : (start)"
        #
        # Your service startup command goes here.
        #
        su - oracle -c "/opt/oracle/product/9204/bin/lsnrctl start"
        su - oracle -c "/opt/oracle/product/9204/bin/dbstart"

        # NOTE: Must exit with zero unless error is severe.
        chmod 1777 /tmp
        #chown sys:oracle /tmp
        exit 0
        ;;
stop)
        /bin/echo "$0 : (stop)"
        #
        # Your service shutdown command goes here.
        #
        su - oracle -c "/opt/oracle/product/9204/bin/lsnrctl stop"
        su - oracle -c "/opt/oracle/product/9204/bin/dbshut"

        # NOTE: Must exit with zero unless error is severe.
        exit 0
        ;;
*)  /bin/echo ''
        /bin/echo "Usage: $0 [start|stop]"
        /bin/echo "       Invalid argument ==> /"${OPT_}/""
        /bin/echo ''
        exit 0
        ;;
esac
#---------------------------- end --------------------------------
创建启动项文件连接
ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc3.d/S99oracle
ln -s /etc/rc.d/init.d/oracle /etc/rc.d/rc0.d/K01oracle

修改/etc/oratab文件
vi /etc/oratab
将
OEMSID:/opt/oracle/product/9204:N
改为
OEMSID:/opt/oracle/product/9204:Y

到目前位置ORACLE已经可以在RED HAT LINUX 9上面正常使用了。