`

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


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

 

------


 

 

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics