oracle10g xe install & config - ubuntu

oracle10g xe install & config - ubuntu

 

------

oracle10g xe introduce

 

express edition, smaller than enterprise edition, take smaller disk & resource, suitable & enough for development & learn,

 

------

download

 

http://www.oracle.com/technetwork/database/express-edition/downloads/102xelinsoft-102048.html

 

for ubuntu download the xxx.dev

 

file size about 260Mb, install require about 1.6Gb,

 

------

install

 

refer to:

http://wiki.ubuntu.org.cn/index.php?title=Ubuntu%E4%B8%8AOracle10g%E5%AE%89%E8%A3%85%E6%8C%87%E5%8D%97&variant=zh-hans

 

steps:

* sudo dpkg -i xxx.dev

install oracle xe,

if error occor about libaio and libaio1,

then:

* apt-get -f install

fix the dependence

* sudo dpkg -i xxx.dev

retry install

* sudo /etc/init.d/oracle-xe configure

config:

port of Oracle Application Express, default to 8080,

port of database listener, default to 1521,

password for user sys and system,

whether start on boot,

* 

* config environments

vi /etc/profile.d/xxx.sh, add or modify lines:

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_HOME

export ORACLE_SID=XE

* 

* reboot

* 

* open http://127.0.0.1:8080/apex

login as sys,

* 

* ok

* 

 

XE instance:

a database with instance id = XE is created automaticly,

------

uninstall

 

refer to:

http://my.oschina.net/shootercn/blog/56035

 

steps:

* sudo dpkg -P oracle-xe-universal

* sudo rm -rf /usr/local/oracle

* sudo rm -rf /usr/lib/oracle

* 

* remove environments

vi /etc/profile.d/xxx.sh, remove oracle configs,

* 

 

------

start & stop

refer to :

http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/startup.htm

start:

* su - root

* su - oracle

* lsnrctl start

start the listener control

* sqlplus / as sysdba

login to sqlplus

* startup

start the database

* 

* ok

* 

stop:

* su - root

* su - oracle

* 

* sqlplus / as sysdba

login to sqlplus

* shutdown immediate

shutdown the database

* 

* lsnrctl stop

stop the listener control

* 

* ok

* 

------

/etc/init.d/oracle-xe

 

a script that control oracle start/restart/config,

 

format:

sudo /etc/init.d/oracle-xe option

 

options:

* restart

restart database

* status

print status

* enable

enable start boot

* disable

disable start boot

 

e.g.

sudo /etc/init.d/oracle-xe restart

restart the oracle database

sudo /etc/init.d/oracle-xe enable

start oracle database on boot

 

------