Date Created: Sun 01-Mar-2009

Related Document Categories:

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

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

About Me

Steve Robinson has been working in IT for over 15 years and has provided solutions for many large-enterprise corporate companies across the world. Steve specialises in Java and Middleware consulting. Steve comes from both an administration and development background.

Before moving to JEE, Steve was an accomplished developer and consultant for both IBM Lotus Notes and Microsoft .NET Technologies.

Follow Steve as @stevencrobinson on twitter.

Read my books?

IBM WebSphere Application Server 8.0 Administration Guide

WebSphere Application Server 7.0 Administration Guide

Date Created: Sun 01-Mar-2009

Related Document Categories:

About Me

Read my books?

WebSphere Categories

Oracle WebLogic Categories

JBoss Categories

Other Categories