Tuesday, August 22, 2006

Oracle 10gXE Starts Up Manually

After installation of Oracle 10gXe, there is a configuration file "oracle-xe" under /etc/sysconfig (FC5). It controls whether Oracle be loaded at system boot. If you want Oracle start up manually, you can follow the instructions below:
# cat /etc/sysconfig/oracle-xe
ORACLE_DBENABLED=false
LISTENER_PORT=1521
HTTP_PORT=8080
CONFIGURE_RUN=true

# /etc/init.d/oracle-xe enable
# /etc/init.d/oracle-xe start

When shutdown:
# /etc/init.d/oracle-xe stop
# /etc/init.d/oracle-xe disable

If you use GUI "Start Database", the Listener doesn't start up, so you have to load it manually.
# su - oracle
$ . oracle_env.sh
$ lsnrctl start

Now you can see that the port 1521 and 8080 are up, and you can manipulate the database by using browser and SQL*Net.