Oracle Express Edition (XE) database installation

Oracle installation

1. Download Oracle 10g Express Edition free version (oracle-xe-univ-10.2.0.1-1.0.i386.rpm).

Oracle docs are available at http://www.oracle.com/pls/xe102/homepage

2. Set Tuning Parameters

Edit vi /etc/sysctl.conf and add the following tuning parameters

--------------------------------------------------

# Parameters for Oracle 10g XE database

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.shmall = 268435456

# SEMMSL, SEMMNS, SEMOPM, and SEMMNI

kernel.sem=250 32000 100 128

fs.file-max=65536

net.ipv4.ip_local_port_range=1024 65000

--------------------------------------------------

3. Installation

Copy oracle rpm to /opt/software/oracle-10g-express-universal

Login as root

#cd /opt/software/oracle-10g-express-universal

[root@bvaiiwq01 oracle-10g-express-universal]# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm

Preparing... ########################################### [100%]

1:oracle-xe-univ ########################################### [100%]

Executing Post-install steps...

You must run '/etc/init.d/oracle-xe configure' as the root user to

configure the database.

[root@bvaiiwq01 oracle-10g-express-universal]# /etc/init.d/oracle-xe configure

Oracle Database 10g Express Edition Configuration

-------------------------------------------------

This will configure on-boot properties of Oracle Database 10g Express

Edition. The following questions will determine whether the database should

be starting upon system boot, the ports it will use, and the passwords that

will be used for database accounts. Press to accept the defaults.

Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same

password will be used for SYS and SYSTEM. Oracle recommends the use of

different passwords for each database account. This can be done after

initial configuration:

Confirm the password: oracle (or any password)

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:y

Starting Oracle Net Listener...Done

Configuring Database...Done

Starting Oracle Database 10g Express Edition Instance...Done

Installation Completed Successfully.

To access the Database Home Page go to "http://{ip_address}:8080/apex"

4. Set Oracle environment parameters

cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

. ./oracle_env.sh

5. Start the database

[root@bvaiiwq01 oracle-10g-express-universal]# /etc/init.d/oracle-xe start

Starting Oracle Database 10g Express Edition Instance.

6. Perform this step for providing remote web access console

[root@bvaiiwq01 client]# sqlplus system

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 8 19:13:20 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter password:

Connected to:

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

PL/SQL procedure successfully completed.

7. Access the database web console

To access the Database Home Page go to "http://{ip_address}:8080/apex"

user: system password: oracle (password set during install)

user:sysdba password: oracle (password set during install)