Installing Oracle XE on Porteus

Technical issues/questions of an intermediate or advanced nature.
Post Reply
jpagan
White ninja
White ninja
Posts: 11
Joined: 10 Feb 2016, 23:05
Distribution: Ubuntu
Location: Texas

Installing Oracle XE on Porteus

Post#1 by jpagan » 27 Nov 2017, 17:34

Hello all,

I want to run Oracle XE database on Porteus. However, I am not an expert so to me this is a bit challenging. I am hoping I can get some help here. I did some research on my own and I found a few things to get me started but I reached a stopping point.

I found a Slackbuild at the address below. Can I use this to install Oracle XE on Porteus? How?

https://slackbuilds.org/repository/14.2 ... oracle-xe/

Thanks in advance

JP

User avatar
brokenman
Site Admin
Site Admin
Posts: 5849
Joined: 27 Dec 2010, 03:50
Distribution: Porteus v3.2rcX all desktops
Location: Brazil
Contact:

Installing Oracle XE on Porteus

Post#2 by brokenman » 28 Nov 2017, 00:11

Yes. You will need an oracle account to download the package.
Then you will need to activate the 05_devel module which can be foound on our servers.
Then you can download the files at the link you provide and build the package from source.
Then you can convert the resulting slackware package into a porteus module.

If you can at least provide the oracle package we can try to build it for you.
How do i become super user?
Wear your underpants on the outside and put on a cape.

burdi01
Black ninja
Black ninja
Posts: 72
Joined: 18 Aug 2013, 12:09
Distribution: Slackware, Xubuntu
Location: The Netherlands

Installing Oracle XE on Porteus

Post#3 by burdi01 » 28 Nov 2017, 10:25

If you can at least provide the oracle package we can try to build it for you.
Would not that amount to re-distributing the package? For as far as I am aware Oracle does not allow that.
:D

jpagan
White ninja
White ninja
Posts: 11
Joined: 10 Feb 2016, 23:05
Distribution: Ubuntu
Location: Texas

Installing Oracle XE on Porteus

Post#4 by jpagan » 29 Nov 2017, 18:16

Thanks for the offer to build the module for me. I did not want to burden anybody with doing something I think would benefit me to learn. Plus, I was also concerned about the re-distribution issue. With that said...

I am up to the point where I need to build the package. So I run the script "doinst.sh", but I get an error. The contents of the script and the error are below. The slack build does have a file called "10-oracle.xe.conf.new" which I copied to /etc/sysctl.d, but I get the same error regardless of me copying the file to that directory or not. Any ideas?

Code: Select all

VERSION="11.2.0"

config() {
  NEW="$1"
  OLD="$(dirname $NEW)/$(basename $NEW .new)"
  if [ ! -r $OLD ]; then
    mv $NEW $OLD
  elif [ "$(cat $OLD | md5sum)" = "$(cat $NEW | md5sum)" ]; then
    rm $NEW
  fi
}

config etc/sysctl.d/10-oracle.xe.conf.new

if [ -x /usr/bin/update-desktop-database ]; then
  /usr/bin/update-desktop-database -q usr/share/applications >/dev/null 2>&1
fi

if ! grep /u01/app/oracle/product/${VERSION}/xe/lib etc/ld.so.conf 1> /dev/null 2> /dev/null ; then
  echo "/u01/app/oracle/product/${VERSION}/xe/lib" >> etc/ld.so.conf
fi

if [ -x /sbin/ldconfig ]; then
  /sbin/ldconfig 2> /dev/null
fi


# from rpm oracle scripts
availphymem=`cat /proc/meminfo | grep '^MemTotal' | awk '{print $2}'`
availphymem=`echo $availphymem / 1024 | bc`
memory_target=`echo 0.40 \* $availphymem | bc | sed "s/\..*//"`

if [ $memory_target -gt 1024 ];
then
  memory_target=`echo 1024 \* 1048576 | bc`
else
  memory_target=`echo $memory_target \* 1048576 | bc`
fi

sed -i "s/%memory_target%/$memory_target/g" u01/app/oracle/product/${VERSION}/xe/config/scripts/init.ora
sed -i "s/%memory_target%/$memory_target/g" u01/app/oracle/product/${VERSION}/xe/config/scripts/initXETemp.ora
root@porteus:/tmp/oracle-xe# ./doinst.sh
mv: cannot stat 'etc/sysctl.d/10-oracle.xe.conf.new': No such file or directory
./doinst.sh: line 20: etc/ld.so.conf: No such file or directory
sed: can't read u01/app/oracle/product/11.2.0/xe/config/scripts/init.ora: No such file or directory
sed: can't read u01/app/oracle/product/11.2.0/xe/config/scripts/initXETemp.ora: No such file or directory

jpagan
White ninja
White ninja
Posts: 11
Joined: 10 Feb 2016, 23:05
Distribution: Ubuntu
Location: Texas

Installing Oracle XE on Porteus

Post#5 by jpagan » 27 Apr 2018, 15:19

Sorry to revive this old thread. But I was able to resolve this issue so I wanted to share in case somebody else needs the information...

I figured out what I was doing wrong. All I had to do is make oracle-xe.SlackBuild executable and then execute it. This will build the Slackware module. From there all I had to do was convert it to a Porteus module and I was done. So now I have a Porteus module for Oracle XE 11.

User avatar
Ed_P
Contributor
Contributor
Posts: 3887
Joined: 06 Feb 2013, 22:12
Distribution: 4.0 Cinnamon 64-bit ISO
Location: Western NY, USA

Installing Oracle XE on Porteus

Post#6 by Ed_P » 27 Apr 2018, 18:40

Thank you for the update jpagan. Especially enjoy happy endings. :good:
Ed

Post Reply