Debian Sarge 上安装Oracle 10g

核心提示： # ln -s /usr/bin/rpm /bin/rpm# ln -s /usr/bin/basename /bin/basename# ln -s /etc /etc/rc.d模拟redhat-3进行安装，新建一个文件/etc/redhat-release,写入以下内容：Red Hat

# ln -s /usr/bin/rpm /bin/rpm

# ln -s /usr/bin/basename /bin/basename

# ln -s /etc /etc/rc.d

模拟redhat-3进行安装，新建一个文件/etc/redhat-release,写入以下内容：

Red Hat Enterprise Linux AS release 3 (Taroon)

二、开始安装

你可以从http://mirrors.cn99.com上下载oracle 10g,按以下方法进行解压：

$ gunzip ship.db.cpio.gz

$ cpio -idmv < ship.db.cpio

这样会生成一个Disk1目录，进入Disk1目录。

切换到oracle用户，设置环境变量：

$ xhost +

$ su - oralce

$ export ORACLE_BASE=/opt/oracle

$ export ORACLE_SID=oralin#你可以自己命名sid

确保此时环境中没有ORACLE_HOME 和TNS_ADMIN

$ unset ORACLE_HOME

$ unset TNS_ADMIN

可以将这些写进.bash_profile

export ORACLE_BASE=/opt/oracle

export ORACLE_SID=oralin

unset ORACLE_HOME

unset TNS_ADMIN

umask 022

执行

$ ./runInstaller

我选择标准安装，安装大约30多分钟。安装过程截图，参见 http://www.linuxsir.org/bbs/showthread.php?s=&threadid=140617

三、安装后

1.Oracle 管理工具

Ultra Search URL:

http://debian:5620/ultrasearch

Ultra Search 管理工具 URL:

http://debian:5620/ultrasearch/admin

iSQL*Plus URL:

http://debian:5560/isqlplus

Enteprise Manager 10g Database Control URL:

http://debian:5500/em

2.oracle启动脚本/etc/init.d/oracle

#!/bin/bash
#
# Run-level Startup script for the Oracle Instance and Listener
#
# chkconfig: 345 91 19
# description: Startup/Shutdown Oracle listener and instance
ORA_HOME="/opt/oracle/product/10.1.0/db_1"
ORA_OWNR="oracle"
# if the executables do not exist -- display error
if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]
then
echo "Oracle startup: cannot start"
exit 1
fi
# depending on parameter -- startup, shutdown, restart
# of the instance and listener or usage display
case "" in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNR -c $ORA_HOME/bin/dbstart
#Optional : for isqlplus only
su - $ORA_OWNR -c "$ORA_HOME/bin/isqlplusctl start"
#Optional : for Enterprise Manager software only
su - $ORA_OWNR -c "$ORA_HOME/bin/emctl start dbconsole"
touch /var/lock/oracle
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
#Optional : for isqlplus only
su - $ORA_OWNR -c "$ORA_HOME/bin/isqlplusctl stop"
#Optional : for Enterprise Manager software only
su - $ORA_OWNR -c "$ORA_HOME/bin/emctl stop dbconsole"
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNR -c $ORA_HOME/bin/dbshut
rm -f /var/lock/oracle
echo "OK"
;;
reload|restart)
stop
start
;;
*)
echo "Usage: start|stop|restart|reload"
exit 1
esac
exit 0

可以通过/etc/init.d/oracle start来启动oracle.