Package Details: oracle-xe 11.2.0_1.0-4

Git Clone URL: https://aur.archlinux.org/oracle-xe.git (read-only)
Package Base: oracle-xe
Description: a non free DBMS
Upstream URL: http://www.oracle.com/
Keywords: oracle
Licenses: custom
Conflicts: oracle-xe
Provides: oracle-xe
Submitter: The_Loko
Maintainer: yesuu
Last Packager: The_Loko
Votes: 6
Popularity: 0.397374
First Submitted: 2015-11-12 22:21
Last Updated: 2016-03-08 12:37

Required by (0)

Sources (7)

Latest Comments

wget commented on 2016-08-20 14:38

@The_Loko: Also, I was the guys who wrote a PKGBUILD for oracle-xe when it was not readded to the AUR with Git but I gave up on that project. It was not working properly as I had issues with the listener. I didn't get we had to use a sticky bit ;-)

In my version, I patched the oracle-xe file to avoid requiring net-tools and rely only on ss instead of netstat. If you want my patch, here it is:

# Avoid the old net-tools dependency and use the ss command from iproute2 instead
sed -i 's#`netstat -n --tcp --listen | $GREP :$LINE | $AWK -F: '\''{print $4}'\'' | $SED '\''s/ //g'\''`#$(ss -nl "( sport = :$LINE )" | awk -F: '\''{print $4}'\'' | sed '\''/^$/d'\'')#g' \
"./u01/app/oracle/product/${pkgver%%_*}/xe/config/scripts/oracle-xe"

wget commented on 2016-08-20 14:33

Modifying tnsnames.ora (/usr/lib/oracle/product/11.2.0/xe/network/admin/tnsnames.ora
) to have database links with Oracle does not work (and therefore database links fail to be set up properly).

I assume the environment variable (TNS_ADMIN) must be set to /usr/lib/oracle/product/11.2.0/xe/network/admin/. But I don't know how it could be sourced (or actually if it will be sourced at all) by oracle-xe.

Maybe adding this to the oracle_env.sh and oracle_env.csh should help.

@The_Loko, could you fix this issue?

kearnmachine commented on 2016-08-09 10:10

Just do not use yaourt. It works with the way described here: https://wiki.archlinux.org/index.php/Arch_User_Repository#Installing_packages

sahbi commented on 2016-08-01 18:14

I guess there is something to change in the PKGBUILD once the rpm has been manually downloaded from Oracle web site. I tried to replace source=('manual://download/file/from/oracle/page/oracle-xe-11.2.0-1.0.x86_64.rpm.zip' by source=('/path/to/my/downloaded/file' but it does not seem to work. Any idea?
Thanks!

The_Loko commented on 2016-03-09 12:10

I hadn't pay attention before, but yes, it seems that the configuration is corrupted after updating the package.
I have been looking the documentation but I don't know how to solve this. Maybe creating a backup using the backup scripts included and restoring it later?

itti commented on 2016-03-09 08:42

Have you ever tried updating with a pre-existing package install? Twice in a row now the package upgrade destroyed my existing installation and database. I think it overwrites files that should not be overwritten. (e.g. listener configuration etc.)

The_Loko commented on 2016-03-08 12:38

Didn't notice, it's fixed now.
Thanks!

kkl2401 commented on 2016-03-06 10:01

In oracle_env.sh: shouldn't it be
export PATH=$PATH:$ORACLE_HOME/bin
instead of
export PATH=$ORACLE_HOME/bin:$PATH
?
Since Oracle bundles for example zip and unzip binaries, they are used instead of the system ones.