可能是安装oracle-xe的好方法

在debian上安装oracle 10g express
若是要安装oracle10G，可能要麻烦些，但若是安装oracle 10g express的话，那就很简单：
1、修改/etc/apt/source.list，添加oracle的源：
deb unstable main non-free
2、进行更新和安装
aptitude update
aptitude install oracle-xe-universal
3、进行初始的密码设置
/etc/init.d/oracle-xe configure
若服务器无GUI，可以这样远程管理
ssh -L 8080:localhost:8080 user@IP_of_your_server
firefox



Install Oracle 10g Express Edition on Debian

Oracle Database Express Edition Installation Guide

10g Release 2 (10.2) for Linux



下载 Oracle Database 10g Express Edition for Linux x86

- Available for Debian, Mandriva, Novell, Red Hat and Ubuntu

文件 Oracle Database 10g Express Edition (Universal)

oracle-xe-universal_10.2.0.1-1.0_i386.deb (262,440,214 bytes) (cksum 3404538446) *Debian package

安装 debian:/home/huihoo/database/oracle# dpkg -i oracle-xe-universal_10.2.0.1-1.0_i3 86.deb

(Reading database ... 76128 files and directories currently installed.)

Unpacking oracle-xe-universal (from oracle-xe-universal_10.2.0.1-1.0_i386.deb) . ..

This system does not meet the minimum requirements for swap space. Based on

the amount of physical memory available on the system, Oracle Database 10g

Express Edition requires 1006 MB of swap space. This system has 818 MB

of swap space. Configure more swap space on the system and retry the installati on.

dpkg: error processing oracle-xe-universal_10.2.0.1-1.0_i386.deb (--install):

subprocess pre-installation script returned error exit status 1

Errors were encountered while processing:

oracle-xe-universal_10.2.0.1-1.0_i386.deb

Create 1GB swap file if needed.

dd if=/dev/zero of=/tmp/tmpswap bs=1k count=1024000
chmod 600 /tmp/tmpswap

/sbin/mkswap /tmp/tmpswap


su
# /sbin/swapon -v /tmp/tmpswap


若要卸出,可运行
swapoff /tmp/tmpswap

rm /tmp/tmpswap


再次安装

debian:/home/huihoo/database/oracle# dpkg -i oracle-xe-universal_10.2.0.1-1.0_i3 86.deb

dpkg: dependency problems prevent configuration of oracle-xe-universal:

oracle-xe-universal depends on libaio (>= 0.3.96) | libaio1 (>= 0.3.96); however:

Package libaio is not installed.

Package libaio1 is not installed.

dpkg: error processing oracle-xe-universal (--install):

dependency problems - leaving unconfigured

Errors were encountered while processing:

oracle-xe-universal

安装 package libaio libaio1
从 获得libaio debian package

如:
# dpkg -i libaio_0.3.104-1_i386.deb


接着
# dpkg -i oracle-xe-universal_10.2.0.1-1.0_i3 86.deb

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

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

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


这时可看见后台启动了很多oracle 进程
oracle 7357 0.0 1.8 224664 9664 ? Ss 06:25 0:00 xe_pmon_XE

oracle 7359 0.0 1.6 224048 8300 ? Ss 06:25 0:00 xe_psp0_XE

oracle 7361 0.0 4.4 224048 23084 ? Ss 06:25 0:00 xe_mman_XE

oracle 7363 0.0 2.1 226116 11248 ? Ss 06:25 0:00 xe_dbw0_XE

oracle 7365 0.0 2.4 239608 12508 ? Ss 06:25 0:00 xe_lgwr_XE

oracle 7367 0.0 2.6 224108 13764 ? Ss 06:25 0:00 xe_ckpt_XE

oracle 7369 0.0 8.1 224648 42268 ? Ss 06:25 0:00 xe_smon_XE

oracle 7371 0.0 2.6 224108 13896 ? Ss 06:25 0:00 xe_reco_XE

oracle 7373 0.0 4.1 225716 21332 ? Ss 06:25 0:00 xe_cjq0_XE

oracle 7375 0.0 7.9 226864 40820 ? Ss 06:25 0:00 xe_mmon_XE

oracle 7377 0.0 2.0 224052 10560 ? Ss 06:25 0:00 xe_mmnl_XE

oracle 7379 0.0 1.6 224712 8280 ? Ss 06:25 0:00 xe_d000_XE

oracle 7381 0.0 1.5 224668 8036 ? Ss 06:25 0:00 xe_s000_XE

oracle 7383 0.0 1.5 224668 8040 ? Ss 06:25 0:00 xe_s001_XE

oracle 7385 0.0 1.5 224668 8044 ? Ss 06:25 0:00 xe_s002_XE

oracle 7387 0.0 1.5 224668 8048 ? Ss 06:25 0:00 xe_s003_XE

oracle 7414 0.0 2.5 224108 13000 ? Ss 06:25 0:00 xe_qmnc_XE

oracle 7424 0.0 1.7 224076 8784 ? Ss 06:25 0:00 xe_q000_XE

oracle 7426 0.0 2.0 224076 10596 ? Ss 06:25 0:00 xe_q001_XE



apex

设置环境变量
#cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

# source oracle_env.csh (for C or tcsh shell)


或
# ./oracle_env.sh (for Bourne, Bash, or Korn shell)


Making Oracle Database XE Server Available to Remote Clients

1 Click the Application menu (on Gnome) or the K menu (on KDE), then point to Oracle Database 10g Express Edition, and then Go To Database Home Page.

2 In the Database Login page, log in as SYSTEM, enter the password, and then click Login.

3 In the Oracle Database XE home page, click Administration.

4 Under Tasks, click Manage HTTP Access.

5 Under Manage HTTP Access, select Available from local server and remove clients.

6 Click Apply Changes.
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

bin/sqlplus system

Enter password:


ERROR: ORA-12162: TNS:net service name is incorrectly specified

./sqlplus system@localhost
[编辑]
参考资料
Getting Started Guide -
Oracle Database Express Edition 10g Release 2 (10.2) - http://www.oracle.com/technology/xe/documentation
来源：