Date Created: Sun 01-Mar-2009

Related Document Categories:

Get my WebSphere Application Server course here >> http://www.themiddlewareshop.com/products/


Installing Oracle XE for Linux in CentOS 5

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

oracle-xe-10.2.0.1-1.0.i386.rpm (221,136,869 bytes) (cksum 2319822646) *RPM package

Using win scp upload the oracle XE rpm downloaded from Oracle

Login as root or sudo to root

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

error: Failed dependencies:
libaio >= 0.3.96 is needed by oracle-xe-10.2.0.1-1.0.i386

yum install libaio

You can now run the rpm and once Oracle is installed run:

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

[root@s15337574 oracle_install]# rpm -ivh oracle-xe-10.2.0.1-1.0.i386.rpm
Preparing... ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing Post-install steps...

/var/tmp/rpm-tmp.54953: line 37: bc: command not found
/var/tmp/rpm-tmp.54953: line 38: bc: command not found
/var/tmp/rpm-tmp.54953: line 39: bc: command not found
/var/tmp/rpm-tmp.54953: line 40: bc: command not found
/var/tmp/rpm-tmp.54953: line 41: bc: command not found
/var/tmp/rpm-tmp.54953: line 42: bc: command not found
/var/tmp/rpm-tmp.54953: line 43: bc: command not found
/var/tmp/rpm-tmp.54953: line 44: bc: command not found
/var/tmp/rpm-tmp.54953: line 45: test: !=: unary operator expected
/var/tmp/rpm-tmp.54953: line 50: bc: command not found
/var/tmp/rpm-tmp.54953: line 51: test: !=: unary operator expected
/var/tmp/rpm-tmp.54953: line 56: bc: command not found
You must run '/etc/init.d/oracle-xe configure' as the root user to
configure the database.




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

Basically I ran:

yum install bc

Then re-installed the Oracle rpm as directed above.

Preparing... ########################################### [100%]
1:oracle-xe ########################################### [100%]
Executing Post-install steps...

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


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


[root@s15337574 oracle_install]# /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 <Enter> 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:
Password can't be null. Enter password:
Confirm the 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://127.0.0.1:8080/apex"

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


Note:

After you install Oracle Database XE Server, its graphical user interface is only available from the local server, not remotely. To fix this you need to install firefox and configure via local host.

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts

you can see that there is a script called: ./DatabaseHomePage.sh

By running this script you can get firefox to launch automatically the Oracle XE home page














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

Background and research commands:

Oracle is installed to: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle

To start XE

/etc/init.d/oracle-xe start

To stop XE

/etc/init.d/oracle-xe stop

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

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

Installed Oracle Client:


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

yum groupinstall "GNOME Desktop Environment""

yum install yum-utils

yumdownloader nautilus-sendto

rpm -Uvh --nodeps nautilus-sendto-0.7-5.fc6.x86_64.rpm


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


export PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:$PATH
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server


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

*Command Line:
SQLPLUS /NOLOG
*At the SQL Command Line prompt, enter the following command:
CONNECT SYSTEM/password
*EXEC DBMS_XDB.SETHTTPPORT(8087);



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


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



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


yum remove xulrunner-1.9.0.6-1.el5

yum install firefox, for some reason I couldn't get firefox to connect to oracle so I tried installing Gnome so I would look at the administration of Linux using X Windows.


rpm -e oracle-xe-10.2.0.1-1.0.i386

Get my WebSphere Application Server course here >> http://www.themiddlewareshop.com/products/

Steve Robinson - IBM Champion 2013

About Me

Steve Robinson has been working in IT for over 20 years and has provided solutions for many large-enterprise corporate companies across the world. Steve specialises in Java and Middleware.

In January 2013, I was awarded the prestigous 'IBM Champion' accolade.


  • Linked In
  • Twitter
  • About Me
  • My Blog
  • Contact Me

Read my books?

IBM WebSphere Application Server 8.0 Administration Guide

IBM WebSphere Application Server 8.0 Administration Guide

WebSphere Application Server 7.0 Administration Guide

WebSphere Application Server 7.0 Administration Guide

WebSphere Categories

Other Categories