Saturday, November 19, 2005

Oracle 10g express on debian 3.1

Yeah baby - I FINALLY got Oracle 10g express to work on my debian dist. I
had to change quite a few lines in oracle-xe (mostly to do with missing chkconfig on my debian system and some paths) and creating a directory which is NOT std. debian (/etc/sysconfig) and using alien to create a .deb package and finally by using dpkg to install the lot.
Well acutally I installed it twice before it worked, first I simply used alien to install the downloaded RPM package from Oracle.com, then making the above changes and repacking the RPM to .deb, and finally installing the .deb using dpkg.
Then there were NO errors displayed and I am able to browse to http://localhost:8080/htmldb to see admin webapp... Ofcoz this is NOT for a production stable system, but still, it seems to work perfectly...

10 Comments:

Anonymous roy@verrips.org said...

I tried to get Oracle XE 10G to work on my Sarge box, but gave up ... Is the deb you recompiled available for private viewing?

Thank

Yours

Roy

30/11/05 16:09  
Blogger lborupj said...

Hi Roy,

I tried to send you an email, but it bounced, so here goes:

Its not public available, but I might consider putting it on a FTP server for you. However I did really nothing special.. just used alien to convert the RPM (although I did feed alien quite a few options).. You have to create a etc/sysconfig folder before you install the lot, and remember to say NO to installing as a service using chkconfig for obvious reasons. Then it installed with a hazzle and I did write my own init script to put /etc/init.d/ to start/stop the service.

1/12/05 13:49  
Blogger lborupj said...

yikes.. typo "it installed WITHOUT..."

1/12/05 13:51  
Anonymous mazzer@biquad.com.br said...

Hello, i make de .deb package and i have installed the oracle without any error message. My system have the running process: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit
But i not having access to the web administration page on port 8080.
Its necessary to add some thing in the inetd.conf? No firewall rules is present.
And please send the start/stop scripts that you have make to me, if possible. And sorry about my english.
Thanks

2/12/05 18:44  
Blogger lborupj said...

Hi,

Its not necessary to add anything to your inetd.conf as the Oracle service is NOT intended for inetd. But you do however want to put an init script into /etc/init.d and perhaps a softlink to this script in your rc"runlevel".d dir if you want the service to start when that runlevel is reached. When you have the TNS listener up and running you should be able to use sqlplus to execute the startdb.sql script found in $ORACLE_HOME/install/scripts (as far as I remember). Take a look at the oracle-xe script in same folder, to see how you call sqlplus with the correct options and the .sql file. I might consider putting my init script up here...

3/12/05 19:45  
Blogger lborupj said...

Here goes - my init script, but as you might discover not all functions are implemented. Only start is currently working :-)


#!/bin/bash
#

export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_SID=XE
export PATH=$PATH:$ORACLE_HOME/bin
ORA_OWNR="oraclexe"

case "$1" in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
su $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl start" > /dev/null 2>&1
su $ORA_OWNR -c "$ORACLE_HOME/bin/sqlplus -s /nolog @$ORACLE_HOME/config/scripts/startdb.sql" > /dev/null 2>&1
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
echo "Now WHY would you shut it down? NOT IMPLEMENTED (yet)"
;;
reload|restart)
echo "NOPE - NOT IMPLEMENTED EITHER (yet)
;;
*)
echo "Usage: `basename $0` start|stop|restart|reload"
exit 1
esac
exit 0

7/12/05 08:35  
Anonymous Daniel said...

Hello, its me again.
The listener is ok and running, but the sqlplus return the folowing error message. The google says nothing about that.

ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes

My system has 768MB with about 430MB free Ram and 2GB free swap.

Do you know how can i icrease that shared pool memory?

Marry Christmas
Thank you

Daniel.

21/12/05 19:43  
Blogger lborupj said...

Hi Daniel,

I think this might be a Oracle <-> Kernel problem although my findings suggest its "simply" a matter of changing your .ora file.

Which kernel version are you using? I'm using a 2.6.11 as far as I remember. Im actually using my debian as dom0 in a Xen setup running multiple suse 9.x instances atop of my debian so my kernel is compiled as a Xen dom0 "image"..

From a quick and sporadic search I did on Google I found the following hints for you.

http://ora-00371.ora-code.com/msg/31470.html
http://www.orafaq.com/parms/parm1319.htm

21/12/05 20:29  
Anonymous Daniel said...

Ok, its working now.
I set up some configuration files, and i make a re-install of oracle.
Now its running ok.

Thank you very much by the help!

21/12/05 21:29  
Anonymous Anonymous said...

Enjoyed the blog - properties tenerife. A new site has been launched with plenty of bargain holidays to choose from. Bookmark http://www.bargainplace.co.uk not just for bargain holidays but for flights and transport to and from airports plus travel insurance deals and holiday clothes.

15/2/07 01:43  

Post a Comment

<< Home