Page 1 of 1

Installing Oracle XE on Porteus

Posted: 27 Nov 2017, 17:34
by jpagan
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

Installing Oracle XE on Porteus

Posted: 28 Nov 2017, 00:11
by brokenman
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.

Installing Oracle XE on Porteus

Posted: 28 Nov 2017, 10:25
by burdi01
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

Installing Oracle XE on Porteus

Posted: 29 Nov 2017, 18:16
by jpagan
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

Installing Oracle XE on Porteus

Posted: 27 Apr 2018, 15:19
by jpagan
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.

Installing Oracle XE on Porteus

Posted: 27 Apr 2018, 18:40
by Ed_P
Thank you for the update jpagan. Especially enjoy happy endings. :good: