|
Oracle 10g Express Edition Quick Installation
Setup the necessary kernel pre-requisite settings.
vi /etc/sysctl.conf
#---
# Oracle 10g XE
kernel.sem = 250 32000 100 128
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.shmall = 2097152
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
#---
Install the Oracle Express Edition RPM from Oracle.
rpm -ivh oracle-xe-10.2.0.1-1.0.i386.rpm
Execute the script to configure the Oracle database.
Take note of the values you enter, if not the defaults.
/etc/init.d/oracle-xe configure
The quick and easy way to setup the environment variables.
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
cat $ORACLE_HOME/bin/oracle_env.sh >> /etc/profile
Setup the password for oracle, and optionally sudo access.
passwd oracle
oracle password: ********
vi /etc/sudoers
#---
oracle ALL=(ALL) ALL
#---
Modify the database to allow remote access, not just local.
$ sqlplus system
Enter password: ********
SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
PL/SQL procedure successfully completed.
Let's review basic procedures. Starting and stopping Oracle XE.
/etc/init.d/oracle-xe start
/etc/init.d/oracle-xe stop
Here's how to access the GUI, either locally or remotely.
http://localhost:8080/apex
http://hostname:8080/apex
Your Oracle Express Edition (XE) installation is ready for use.
| 
