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.110540
First Submitted: 2015-11-12 22:21
Last Updated: 2016-03-08 12:37

Required by (0)

Sources (7)

Latest Comments

Scimmia commented on 2016-11-22 03:20

This should use bsdtar to extract the rpm, the same way makepkg does. No need for an extra makedep when all the rpmextact.sh script does is call bsdtar anyway.

kama commented on 2016-11-20 03:16

I have the same problem as jrborba. Can someone write a short howto?

jrborba commented on 2016-11-07 00:58

What kind of thing I need to do to run oracle-xe? My installation ends with no errors, but oracle-xe NEVER starts, even after run oracle_env.sh. Thanks in advance.

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!

All comments