Oracle

From Wiki.voidnet.us

Jump to: navigation, search

[edit] Installing Oracle 10g Express on RHEL4

Installing Oracle 10g Express on RHEL4 is a fairly simple process.

1st download the RPM from Oracle. You may need to create an Oracle account.

 http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html

Ensure that you have at least 1024MB of Swap. If not, you can add more swap by following these steps:

 mkdir -p /root/.swap
 dd if=/dev/zero of=/root/.swap/swapfile bs=1024 count=524288
 mkswap /root/.swap/swapfile
 swapon /root/.swap/swapfile
 echo `/root/.swap/swapfile               swap                    swap    defaults        0 0` > /etc/fstab

Install the libaio package:

 up2date -i libaio

Install the Oracle RPM:

 rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm

Once the RPM has been installed (could take as long as 25 minutes depending on your hardware), you need to run the configuration script:

 /etc/init.d/oracle-xe configure

The default port settings for Application Express (apex) and the database listener are fine (8080 for apex, 1521 for the db listener). Set your password for the SYS and SYSTEM account and tell it to start at boot if you desire and then the configurator will do it's thing. By default, ApEx will be bound to localhost only. Using iptables pre-routing rules will not work either, you will have to log into the database using sqlplus as the SYSTEM user and tell ApEx that it needs to listen on the public interface. 1st we will export our environment variables and update ld.so.conf:

 # . /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
 # echo ‘/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib’ >> /etc/ld.so.conf
 # /sbin/ldconfig
 
 # sqlplus
 
 SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 27 12:38:39 2007
 Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 Enter user-name: SYSTEM
 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.
 
 SQL> exit
 Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

Now you can access the ApEx control panel through the public interface and have fun with your new Enterprise grade relational database.

Personal tools