UbuntuHelp:Oracle10gDapper
来自Ubuntu中文
 |
点击翻译: |
English |
请不要直接编辑翻译本页，本页将定期与来源同步。 |
目录
Oracle Express Edition 10g R2 / on Ubuntu Dapper 6.06 LTS
Oracle Express Edition 10g R2 is the small "free" version from Oracle (see http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html) and download the "oracle-xe-universal_10.2.0.1-0_i386.deb" Debian / Ubuntu package It's really easy to install under a fresh standard Drapper Server (6.06 LTS). You don't need to to create the usual oracle users or to modify the sysctr.conf file. This is all done by the package.
Requirements
Systems requirements
As usual, Oracle needs a lot of resources, with a minumum for the server of 512 MBytes of Ram and 1024 MBytes of Swap and 1.5 Gbytes of free disk space. This requirements are checked by the install package. As the amount of swap isn't the default value for a fresh install, be aware of that. A workaround for that is described in http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html
Needed libraries
Only one additional lib and one tool are needed:
- libaio1 - kernel aio access library
- bc - The GNU bc arbitrary precision calculator language
apt-get install libaio bc
Installation
Ok, now the really funny part for all guys who have already installed an Oracle server....
dpkg -i oracle-xe-universal_10.2.0.1-0_i386.deb
Configuration
You have to execute
/etc/init.d/oracle-xe configure
This script will ask you for the initial SYS and SYSTEM password, The TCP ports of the Oracle listener and Oracle Application Server. In most cases you should use the standard ports recommended by the script. Now for creating users / schema / ... you have a nice http interface to do it :
http://localhost:8080/apex/
No more need of java. If, like me, you install this Oracle database on a server without a graphic X server, you may need to use a SSH port forwarding
ssh -L 8080:localhost:8080 user@IP_of_your_server
Installing with apt-get
As an alternative method to install Oracle XE 10g in Ubuntu Dapper, Oracle made a repository so you can use apt-get instead of dpkg. Just add this line to /etc/apt/sources.list file:
deb http://oss.oracle.com/debian unstable main non-free
And run:
apt-get update
Note: you might need to run the following command if you get a GPG error:
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | apt-key add -
There are 3 packages to select from:
- oracle-xe - Oracle Database 10g Express Western European Edition
- oracle-xe-client - Oracle Client 10g Express Edition
- oracle-xe-universal - Oracle Database 10g Express Universal Edition
Disclamer
I make this install only on a 32 bit version of Ubuntu Server Dapper and Oracle.
See also
Oracle10g - general notes and important prerequisites for running Oracle on Ubuntu
