From a6b415ee320284c29165992a1d74d79ee5f3d190 Mon Sep 17 00:00:00 2001 From: Andrew Clemons Date: Mon, 28 Feb 2022 22:23:56 +1300 Subject: system/oracle-xe: Removed (old version, not available for download). Please resubmit with an update for 18c XE or 21c XE if needed. These are both freely available for download. See OracleDatabase/SingleInstance/dockerfiles/21.3.0/Dockerfile.xe at https://github.com/oracle/docker-images.git. Signed-off-by: Andrew Clemons Signed-off-by: Willy Sudiarto Raharjo --- system/oracle-xe/10-oracle.xe.conf.new | 8 -- system/oracle-xe/README | 14 --- system/oracle-xe/README.Slackware | 52 ----------- system/oracle-xe/doinst.sh | 41 --------- system/oracle-xe/oracle-xe.SlackBuild | 160 --------------------------------- system/oracle-xe/oracle-xe.info | 10 --- system/oracle-xe/slack-desc | 19 ---- 7 files changed, 304 deletions(-) delete mode 100644 system/oracle-xe/10-oracle.xe.conf.new delete mode 100644 system/oracle-xe/README delete mode 100644 system/oracle-xe/README.Slackware delete mode 100644 system/oracle-xe/doinst.sh delete mode 100644 system/oracle-xe/oracle-xe.SlackBuild delete mode 100644 system/oracle-xe/oracle-xe.info delete mode 100644 system/oracle-xe/slack-desc (limited to 'system') diff --git a/system/oracle-xe/10-oracle.xe.conf.new b/system/oracle-xe/10-oracle.xe.conf.new deleted file mode 100644 index 1d9dd0d8e6..0000000000 --- a/system/oracle-xe/10-oracle.xe.conf.new +++ /dev/null @@ -1,8 +0,0 @@ -kernel.sem=250 32000 100 128 -kernel.shmmax=4294967295 -kernel.shmmni=4096 -kernel.shmall=2097152 -fs.file-max=6815744 -net.ipv4.ip_local_port_range=9000 65000 -vm.swappiness=40 - diff --git a/system/oracle-xe/README b/system/oracle-xe/README deleted file mode 100644 index d5100304df..0000000000 --- a/system/oracle-xe/README +++ /dev/null @@ -1,14 +0,0 @@ -Oracle Database 11g Express Edition (Oracle Database XE) - -Oracle Database Express Edition is an entry-level, -small-footprint database based on the Oracle Database 11g -Release 2 code base. It's free to develop, deploy, and -distribute; fast to download; and simple to administer. - -You need accept license before download oracle-xe and -you have to use a web browser to download it. - -Oracle-XE is only available for 64 bits systems. - -See README.Slackware for setup, configuration and usage -hints. diff --git a/system/oracle-xe/README.Slackware b/system/oracle-xe/README.Slackware deleted file mode 100644 index f1067059e0..0000000000 --- a/system/oracle-xe/README.Slackware +++ /dev/null @@ -1,52 +0,0 @@ -The installation process needs a user and a group previuosly -configured, *oracle* for the user and *dba* for the group. - -You must be run the following commands: - -# groupadd -g 329 dba -# useradd -d /u01/app/oracle -s /bin/bash -u 329 -g 329 oracle - -Oracle recomend some system requirements in kernel parameters, -acording to oracle-xe installation guide at: -https://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#BABJFAIA - -This slackbuild provides an sysctl configurations at -/etc/sysctl.d/10-oracle.xe.conf; you only need restart or run: - -# sysctl --system - -After installing you must configure the database: - -# /etc/rc.d/rc.oracle-xe configure - -Some environment variables need to be configured or exported before -you start to use Oracle; by default all variables is configured with -"en_US.UTF-8" but you can change to your locale preferences at: - -/etc/profile.d/oracle-env.sh - -And you can load with: - -# source /etc/profile.d/oracle-env.sh - -or logout and login for load all environment variables. - -To start and stop the database at boot/shutdown, make sure -/etc/rc.d/rc.oracle-xe is executable and update the following files: - -/etc/rc.d/rc.local -================== -# Startup oracle-xe -if [ -x /etc/rc.d/rc.oracle-xe ]; then - /etc/rc.d/rc.oracle-xe start -fi - -/etc/rc.d/rc.local_shutdown -=========================== -# Stop oracle-xe -if [ -x /etc/rc.d/rc.oracle-xe ]; then - /etc/rc.d/rc.oracle-xe stop -fi - -You can read more detailed instructions at: -https://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm diff --git a/system/oracle-xe/doinst.sh b/system/oracle-xe/doinst.sh deleted file mode 100644 index 563eeec10e..0000000000 --- a/system/oracle-xe/doinst.sh +++ /dev/null @@ -1,41 +0,0 @@ -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 diff --git a/system/oracle-xe/oracle-xe.SlackBuild b/system/oracle-xe/oracle-xe.SlackBuild deleted file mode 100644 index 0dafc63117..0000000000 --- a/system/oracle-xe/oracle-xe.SlackBuild +++ /dev/null @@ -1,160 +0,0 @@ -#!/bin/bash - -# Slackware build script for oracle-xe - -# Copyright 2015 Dhaby Xiloj -# All rights reserved. -# -# Some ideas has taked from -# https://github.com/aclemons/slackbuilds/tree/master/system/oracle-xe-11g -# Andrew Clemons, Wellingtong, New Zeland -# -# Redistribution and use of this script, with or without modification, is -# permitted provided that the following conditions are met: -# -# 1. Redistributions of this script must retain the above copyright -# notice, this list of conditions and the following disclaimer. -# -# THIS SOFTWARE IS PROVIDED BY THE AUTHOR "AS IS" AND ANY EXPRESS OR IMPLIED -# WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF -# MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO -# EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, -# SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, -# PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; -# OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, -# WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR -# OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF -# ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. - -cd $(dirname $0) ; CWD=$(pwd) - -PRGNAM=oracle-xe -VERSION=${VERSION:-11.2.0} -RELEASE=${RELEASE:-1.0} -BUILD=${BUILD:-1} -TAG=${TAG:-_SBo} -PKGTYPE=${PKGTYPE:-tgz} - -if [ -z "$ARCH" ]; then - case "$( uname -m )" in - x86_64) ARCH=x86_64 ;; - *) echo "The package for $(uname -m) architecture is not available."; exit 1;; - esac -fi - -# If the variable PRINT_PACKAGE_NAME is set, then this script will report what -# the name of the created package would be, and then exit. This information -# could be useful to other scripts. -if [ ! -z "${PRINT_PACKAGE_NAME}" ]; then - echo "$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.$PKGTYPE" - exit 0 -fi - -TMP=${TMP:-/tmp/SBo} -PKG=$TMP/package-$PRGNAM -OUTPUT=${OUTPUT:-/tmp} - -RPMNAME="${PRGNAM}-${VERSION}-${RELEASE}.x86_64.rpm" -ZIPNAME="${RPMNAME}.zip" - -set -e - -# Check if oracle group and user exist -if [ "$(grep ^oracle /etc/passwd)" = "" -o "$(grep ^dba /etc/group)" = "" ] ; then - cat << EOF -You must have apropiate user and group for oracle-xe. - Example: - # groupadd -g 329 dba - # useradd -d /u01/app/oracle -s /bin/bash -u 329 -g 329 oracle -EOF - exit 1 -fi - -rm -rf $PKG -mkdir -p $TMP $PKG $OUTPUT -cd $TMP -rm -rvf $PRGNAM-$VERSION - -mkdir $PRGNAM-$VERSION -cd $PRGNAM-$VERSION -unzip $CWD/$ZIPNAME -cd Disk1 -rpm2cpio < $RPMNAME | cpio -imdv - -chown -R root:root . -find -L . \ - \( -perm 777 -o -perm 775 -o -perm 750 -o -perm 711 -o -perm 555 \ - -o -perm 511 \) -exec chmod 755 {} \; -o \ - \( -perm 666 -o -perm 664 -o -perm 640 -o -perm 600 -o -perm 444 \ - -o -perm 440 -o -perm 400 \) -exec chmod 644 {} \; - -# moving everything to proper place -mv u01 usr $PKG -mkdir -p $PKG/etc/rc.d -mv etc/init.d/oracle-xe $PKG/etc/rc.d/rc.oracle-xe -chmod 644 $PKG/etc/rc.d/rc.oracle-xe -sed -i 's#/etc/init.d/oracle-xe#/etc/rc.d/rc.oracle-xe#g' $PKG/etc/rc.d/rc.oracle-xe - -mkdir -p $PKG/etc/sysctl.d/ -cp $CWD/10-oracle.xe.conf.new $PKG/etc/sysctl.d/ - -# copy environment files -mkdir -p $PKG/etc/profile.d -cp $PKG/u01/app/oracle/product/${VERSION}/xe/bin/oracle_env.sh \ - $PKG/etc/profile.d/oracle-env.sh - echo "export TNS_ADMIN=\$ORACLE_HOME/network/admin" >> $PKG/etc/profile.d/oracle-env.sh - -cp $PKG/u01/app/oracle/product/${VERSION}/xe/bin/oracle_env.csh \ - $PKG/etc/profile.d/oracle-env.csh - echo "setenv TNS_ADMIN \$ORACLE_HOME/network/admin" >> $PKG/etc/profile.d/oracle-env.csh - -# add oracle jdbc driver to classpath -mkdir -p $PKG/etc/profile.d/ -cat << EOF > $PKG/etc/profile.d/oracle-jdbc-env.csh -#!/bin/csh -setenv CLASSPATH \$CLASSPATH:\$ORACLE_HOME/jdbc/lib/ojdbc6.jar -EOF - -cat << EOF > $PKG/etc/profile.d/oracle-jdbc-env.sh -#!/bin/sh -export CLASSPATH=\$CLASSPATH:\$ORACLE_HOME/jdbc/lib/ojdbc6.jar -EOF - -chmod 755 $PKG/etc/profile.d/* - - -# Remove -lipgo and -lsvml from sysliblist as they were not shipped in 11.2XE -sed -i "s/-lipgo //" $PKG/u01/app/oracle/product/11.2.0/xe/lib/sysliblist -sed -i "s/ -lsvml//" $PKG/u01/app/oracle/product/11.2.0/xe/lib/sysliblist - -# fix bad konsole param -sed -i "s/konsole -T /konsole -p tabtitle=/" \ - $PKG/u01/app/oracle/product/11.2.0/xe/config/scripts/runsqlplus.sh - -# creating empty dirs for proper oracle configuration -mkdir -p $PKG/u01/app/oracle/product/${VERSION}/xe/config/log -mkdir -p $PKG/u01/app/oracle/product/${VERSION}/xe/rdbms/{audiot,log} -mkdir -p $PKG/u01/app/oracle/product/${VERSION}/xe/network/{trace,log} - -# Make symbolic links for some libs -( - cd $PKG/u01/app/oracle/product/${VERSION}/xe/lib - ln -s libagtsh.so.1.0 libagtsh.so - ln -s libclntsh.so.11.1 libclntsh.so - ln -s libocci.so.11.1 libocci.so -) - -# set appropriate permissions for oracle -chown -R oracle:dba $PKG/u01 -chmod 755 $PKG/u01/app/oracle/product/${VERSION}/xe/config/scripts/*.sh - -mkdir -p $PKG/usr/doc/$PRGNAM-$VERSION -mv $PKG/usr/share/doc/oracle_xe/* $PKG/usr/doc/$PRGNAM-$VERSION -cat $CWD/$PRGNAM.SlackBuild > $PKG/usr/doc/$PRGNAM-$VERSION/$PRGNAM.SlackBuild - -mkdir -p $PKG/install -cat $CWD/slack-desc > $PKG/install/slack-desc -cat $CWD/doinst.sh > $PKG/install/doinst.sh - -cd $PKG -/sbin/makepkg -l y -c n $OUTPUT/$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.$PKGTYPE diff --git a/system/oracle-xe/oracle-xe.info b/system/oracle-xe/oracle-xe.info deleted file mode 100644 index 43a659d691..0000000000 --- a/system/oracle-xe/oracle-xe.info +++ /dev/null @@ -1,10 +0,0 @@ -PRGNAM="oracle-xe" -VERSION="11.2.0" -HOMEPAGE="http://www.oracle.com/technetwork/database/database-technologies/express-edition/overview/index.html" -DOWNLOAD="UNSUPPORTED" -MD5SUM="" -DOWNLOAD_x86_64="http://download.oracle.com/otn/linux/oracle11g/xe/oracle-xe-11.2.0-1.0.x86_64.rpm.zip" -MD5SUM_x86_64="dd7881a55569d890241f11cd0eeb7d48" -REQUIRES="" -MAINTAINER="DhabyX" -EMAIL="slack.dhabyx@gmail.com" diff --git a/system/oracle-xe/slack-desc b/system/oracle-xe/slack-desc deleted file mode 100644 index 428ace3b07..0000000000 --- a/system/oracle-xe/slack-desc +++ /dev/null @@ -1,19 +0,0 @@ -# HOW TO EDIT THIS FILE: -# The "handy ruler" below makes it easier to edit a package description. -# Line up the first '|' above the ':' following the base package name, and -# the '|' on the right side marks the last column you can put a character in. -# You must make exactly 11 lines for the formatting to be correct. It's also -# customary to leave one space after the ':' except on otherwise blank lines. - - |-----handy-ruler------------------------------------------------------| -oracle-xe: oracle-xe (Oracle Database Express Edition) -oracle-xe: -oracle-xe: Oracle Database 11g Express Edition (Oracle Database XE) is an -oracle-xe: entry-level, small-footprint database based on the Oracle Database -oracle-xe: 11g Release 2 code base. It's free to develop, deploy, and -oracle-xe: distribute; fast to download; and simple to administer. -oracle-xe: -oracle-xe: -oracle-xe: -oracle-xe: -oracle-xe: -- cgit v1.2.3