Package Details: oracle-xe 18.4.0.0.0-1

Git Clone URL: https://aur.archlinux.org/oracle-xe.git (read-only, click to copy)
Package Base: oracle-xe
Description: Oracle Database Express Edition
Upstream URL: https://www.oracle.com/database/
Keywords: database oracle
Licenses: custom
Submitter: The_Loko
Maintainer: DragonX256 (galaxy0419)
Last Packager: galaxy0419
Votes: 14
Popularity: 0.48
First Submitted: 2015-11-12 22:21 (UTC)
Last Updated: 2020-11-19 06:20 (UTC)

Pinned Comments

ArthurBorsboom commented on 2021-11-25 11:03 (UTC)

The previously reported error regarding the systemd service file is still present.

In

/usr/lib/systemd/system/oracle-xe.service

replace: ...exit;... with: ...exit...

Would you mind to fix this?

galaxy0419 commented on 2020-11-19 06:23 (UTC) (edited on 2020-11-25 13:25 (UTC) by galaxy0419)

Additional Notes:

  • After installing the package use the following command with root to set database password and create database:
su -s /bin/bash oracle -c '/opt/oracle/product/18c/dbhomeXE/bin/dbca -silent \
    -createDatabase -gdbName XE -templateName XE_Database.dbc -characterSet AL32UTF8 \
    -createAsContainerDatabase true -numberOfPDBs 1 -sid XE -pdbName XEPDB1 \
    -J-Doracle.assistants.dbca.validate.ConfigurationParams=false -emConfiguration DBEXPRESS \
    -emExpressPort 5500 -J-Doracle.assistants.dbca.validate.DBCredentials=false -sampleSchema true \
    -customScripts /opt/oracle/product/18c/dbhomeXE/assistants/dbca/postdb_creation.sql'
  • If you are having ORA-12547: TNS:lost contact error when logging into the database with sqlplus, use chmod -R u+s,g+s /opt/oracle/product/18c/dbhomeXE/bin/sqlplus command with root to give suid and guid permission.
  • Backup database files before removing the package.

Cheers

Latest Comments

GuessWhatBBQ commented on 2022-04-17 10:30 (UTC)

For anyone facing the [FATAL] Error while executing "/opt/oracle/product/18c/dbhomeXE/ord/im/admin/ordlib.sql". Refer to "/opt/oracle/cfgtoollogs/dbca/XE/ordlib0.log". You need to install libxcrypt-compat as the perl binary bundled with the rpm depends on legacy api functions for libcrypt.

user290399 commented on 2022-03-21 19:41 (UTC) (edited on 2022-03-21 19:42 (UTC) by user290399)

Hello. I had a problem executing the marked comment command to set database password and create database. It shows me the fatal error.

[FATAL] Error while executing "/opt/oracle/product/18c/dbhomeXE/ord/im/admin/ordlib.sql". Refer to "/opt/oracle/cfgtoollogs/dbca/XE/ordlib0.log" for more details. Error in Process: /opt/oracle/product/18c/dbhomeXE/perl/bin/perl

It refers me to the XE1.log for more details, but it only shows the installation process.

[ 2022-03-21 12:35:43.204 CST ] Prepare for db operation
DBCA_PROGRESS : 7%
[ 2022-03-21 12:35:43.253 CST ] Copying database files
DBCA_PROGRESS : 29%
[ 2022-03-21 12:36:34.782 CST ] Creating and starting Oracle instance
DBCA_PROGRESS : 30%
DBCA_PROGRESS : 31%
DBCA_PROGRESS : 34%
DBCA_PROGRESS : 38%
DBCA_PROGRESS : 41%
DBCA_PROGRESS : 43%
DBCA_PROGRESS : 100%
[ 2022-03-21 12:40:02.025 CST ] [FATAL] Error while executing "/opt/oracle/product/18c/dbhomeXE/ord/im/admin/ordlib.sql". Refer to "/opt/oracle/cfgtoollogs/dbca/XE/ordlib0.log" for more details. Error in Process: /opt/oracle/product/18c/dbhomeXE/perl/bin/perl
DBCA_PROGRESS : 29%
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 0%

galaxy0419 commented on 2022-01-03 16:08 (UTC)

Okay, it seems 21c has a lot of breaking changes that prevents the database running on "unsupported" distributions. I have a WIP PKGBUILD on my github and I currently stuck at OS Authentication error. Any help would be appreciated :)

galaxy0419 commented on 2021-12-05 05:15 (UTC) (edited on 2021-12-05 05:16 (UTC) by galaxy0419)

@ArthurBorsboom Thanks for the suggestions. I'm currently working on porting the 21c version. I'll include the fixes in the next release. I've pinned your comments in case anyone want to fix themselves :)

ArthurBorsboom commented on 2021-11-25 11:03 (UTC)

The previously reported error regarding the systemd service file is still present.

In

/usr/lib/systemd/system/oracle-xe.service

replace: ...exit;... with: ...exit...

Would you mind to fix this?

ArthurBorsboom commented on 2021-05-22 13:52 (UTC)

Another issue with the oracle-xe.service file seems to be the listener which is started by the service file, but not stopped.

If the service is stopped and then started, the following systemd warning is presented.

oracle-xe.service: Found left-over process 1235 (tnslsnr) in control group while starting unit. Ignoring.
This usually indicates unclean termination of a previous run, or service implementation deficiencies.

Looking at the systemd specification, there exists an ExecStopPost.

https://www.freedesktop.org/software/systemd/man/systemd.service.html

Using this would be the counterpart of the ExecStartPre which is used to start the listener.

Would you mind to look into this as well?

ArthurBorsboom commented on 2021-05-22 13:41 (UTC)

The ExecStart and ExecStop commands in the oracle-xe.service file contain an error.

The semi-colon at the end of the command 'exit' should be removed, since the command exit is not a SQL query. It results in the following (non problematic) error visible by systemctl status oracle-xe.

ERROR at line 2:
ORA-00933: SQL command not properly ended

galaxy0419 commented on 2020-12-01 09:10 (UTC)

@ayams02 Please refer to the pinned comment. Execute the command to create a database. All the script functions are now integrated to systemd service file and install script.

ayams02 commented on 2020-12-01 01:38 (UTC) (edited on 2020-12-01 01:39 (UTC) by ayams02)

hello, after installing i got this > oracle-xe-18c configure

> zsh: command not found: oracle-xe-18c. Also running your pinned comment resulting /bin/bash: oracle: No such file or directory

galaxy0419 commented on 2020-11-25 13:13 (UTC) (edited on 2020-11-25 13:25 (UTC) by galaxy0419)

@aKrRaC Try login oracle account using su -l oracle with root and login database again. If you really want to use other accounts with sqlplus, give installation folder suid and guid permission using chmod -R u+s,g+s /opt/oracle/product/18c/dbhomeXE/bin/sqlplus and restart oracle service but this might have some security issues. Rolling back to previous PKGBUILD can be achieved using git checkout HEAD~1 after cloning.

aKrRaC commented on 2020-11-23 17:18 (UTC)

After installing and configuring oracle xe, I'm unable to login into SYSTEM, SYSDBA with the passwords provided during the configuration. It shows an error "ORA-12547: TNS:lost contact". Please help! I have been using your package for the last one month and did not face any issue with the previous version (the one before the 19-11-2020 update). If possible can you provide me the git clone link of the previous version.

Keep up the great work. It was a nightmare for me installing oracle xe 18c until I found out about this package. Your work helped me a lot. Thanks

galaxy0419 commented on 2020-11-19 06:23 (UTC) (edited on 2020-11-25 13:25 (UTC) by galaxy0419)

Additional Notes:

  • After installing the package use the following command with root to set database password and create database:
su -s /bin/bash oracle -c '/opt/oracle/product/18c/dbhomeXE/bin/dbca -silent \
    -createDatabase -gdbName XE -templateName XE_Database.dbc -characterSet AL32UTF8 \
    -createAsContainerDatabase true -numberOfPDBs 1 -sid XE -pdbName XEPDB1 \
    -J-Doracle.assistants.dbca.validate.ConfigurationParams=false -emConfiguration DBEXPRESS \
    -emExpressPort 5500 -J-Doracle.assistants.dbca.validate.DBCredentials=false -sampleSchema true \
    -customScripts /opt/oracle/product/18c/dbhomeXE/assistants/dbca/postdb_creation.sql'
  • If you are having ORA-12547: TNS:lost contact error when logging into the database with sqlplus, use chmod -R u+s,g+s /opt/oracle/product/18c/dbhomeXE/bin/sqlplus command with root to give suid and guid permission.
  • Backup database files before removing the package.

Cheers

DragonX256 commented on 2020-11-18 10:21 (UTC)

@galaxy0419 updated URL in package and added you as co-maintainer

galaxy0419 commented on 2020-11-18 09:31 (UTC) (edited on 2020-11-18 09:38 (UTC) by galaxy0419)

Hi @DragonX256,

Thanks for the package. There are several things can be improved:
1. oracle-xe-18c.ld.so.conf is not required
2. oracle-xe-18c, oracle_env.csh, oracle_env.sh can be intergrated into service file and install script
3. There is no need to download the package manually, use https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm instead

I'm happy to be the maintainer if you do not have the time.

Cheers

mbw commented on 2020-11-04 08:44 (UTC)

Thanks for this package. One question though:

After installing, invoking the configuration script via oracle-xe-18c configure initially fails for me, since the hostname cannot be resolved. Even though trying this a second seems to succeed, the listener won't start.

I was able to get this to work by hardcoding my local ip into /etc/hosts, i.e. via adding a line

192.168.x.x myhostname

Is there a better approach that avoids this step? The local ip is subject to change or may not exist at all if I am not in a network, after all.

commented on 2020-10-17 14:22 (UTC)

@DragonX256 I have questions 1. after installing this package, it automatically create a user named oracle on my login manager..how to prevent this from happening? your previous package 11g did not do this. 2. when uninstalling, I got error [SEVERE] Database or a listener exists. To delete the database and the listener run '/etc/init.d/oracle-xe-18c delete' as root. error: command failed to execute correctly

BTW great package..keep it up

DragonX256 commented on 2020-09-29 15:46 (UTC)

@ArthurBorsboom Of course. Will fix that later.

ArthurBorsboom commented on 2020-09-29 14:29 (UTC)

I believe it is not necessary to login at Oracle to download the XE edition. If I am correct, it used to be necessary, however it seems it can be downloaded directly.

https://www.oracle.com/database/technologies/xe-downloads.html

https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm

ArthurBorsboom commented on 2020-09-27 18:50 (UTC)

I am not an experienced package builder, but maybe it would have been a better to rename the existing package oracle-xe to oracle-xe-11g, assuming that is possible. I sometimes receive a question from the package manager to replace package X with package Y.

Once the rename would be completed then a new package oracle-xe could have been created.

Ah well, next time better. :)

Regardless of this, thanks for your efforts. That is appreciated.

DragonX256 commented on 2020-09-27 16:31 (UTC)

@ArthurBorsboom I guess. Never had previous version before. Tried to install it several years ago, but it didn't worked.

ArthurBorsboom commented on 2020-09-27 16:02 (UTC)

@DragonX256

The package manager performs an upgrade, however in reality it is not an upgrade but a new install.

Is that correct?

DragonX256 commented on 2020-09-27 15:43 (UTC)

@ArthurBorsboom There's old https://aur.archlinux.org/packages/oracle-xe-11g package. You can use it. And script lies in /etc/rc.d, just because of changes, accepted from @julius.tzm

ArthurBorsboom commented on 2020-09-27 15:28 (UTC)

After upgrading to 18c the service does not start anymore. The systemd service status gives

Sep 27 17:25:38 pb450 systemd[1]: Starting Oracle XE...
Sep 27 17:25:38 pb450 oracle-xe-18c[34450]: The Oracle Database is not configured. You must run '/etc/init.d/oracle-xe-18c configure' as the root user to configure the datab>
Sep 27 17:25:38 pb450 systemd[1]: Finished Oracle XE.

However, the script does not exist in that location. Besides that, what happened to the existing (11g) databases? :S

Raknos13 commented on 2020-07-28 08:10 (UTC)

Gives an error while validating md5sums ==> ERROR: One or more files did not pass the validity check!

julius.tzm commented on 2020-03-27 20:35 (UTC)

Hi @ll,

I have just created PKGBUILD file for the 18c version of Oracle Express Edition:

https://github.com/JuliusTZM/oracle-xe-18c_arch.git

Cheers!

jeyhunn commented on 2019-01-04 18:40 (UTC)

Hi @RonaldMcDaddy, please update oracle-xe. New version is available.

BootyBlaster commented on 2018-09-30 17:27 (UTC)

@ArthurBorsboom from the ArchWiki:

Note: The group base-devel is assumed to be already installed when building with makepkg. Members of this group should not be included in makedepends array.

https://www.archlinux.org/groups/x86_64/base-devel/

fakeroot is a package that is in the group base-devel, therefore it shouldn't be a build dependency.

ArthurBorsboom commented on 2018-06-28 08:45 (UTC)

Missing build dependency:

fakeroot

tuannt39 commented on 2018-04-05 02:36 (UTC) (edited on 2018-04-05 02:39 (UTC) by tuannt39)

thank @MoroS

==> Validating source files with md5sums... oracle-xe-11.2.0-1.0.x86_64.rpm.zip ... NOT FOUND

Download: Oracle Database Express Edition 11g Release 2

http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

-> Copy file "oracle-xe-11.2.0-1.0.x86_64.rpm.zip" to "/tmp/yaourt-tmp-your_user_name/aur-oracle-xe"

==> Restart building oracle-xe ? [y/N]

DONE!

MoroS commented on 2018-01-08 10:35 (UTC)

Just a quick note for people using Yaourt. When installing oracle-xe run it first, so it installs all dependencies and created the temporary build/package directory, which is: /tmp/yaourt-tmp-your_user_name.

At this point Yaourt will fail complaining that there's no zip file (the one downloaded manually) and will ask to try running the build again. Pause here (don't exit Yaourt) and place the manually downloaded file in the /tmp/yaourt-tmp-your_user_name/aur-oracle-xe (should exist at this point).

Finally return to Yaourt and tell it to restart the build. It won't clean the .zip file placed in the temporary directory and will proceed with the installation normally. :)

commented on 2017-01-21 21:06 (UTC)

I have the same issue like @jrborba and @kama. I debugged /etc/rc.d/oracle-xe script and it fails when $ORACLE_HOME/config/scripts/XE.sh is executed. After a few seconds something wrong is happening (when executing startup command from CloneRmanRestore.sql script) and script returns: Configuring database... ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-12547: TNS:lost contact and so on.

alonhar commented on 2017-01-21 20:44 (UTC)

The installation ends without any error, I run oracle-xe configure.. now what I have problem with the control file and some configuration, If I write inside sqlplus / as sysdba SQL > stratup it start with errors that it dont find the control file. someone knows where is this file?? Thanks

dartzon commented on 2017-01-21 20:24 (UTC)

Just git clone this package and download oracle-xe-11.2.0-1.0.x86_64.rpm.zip from Oracle's website, then put the zip file into the package's folder and run makepkg -si

syaorandroid commented on 2016-12-14 17:23 (UTC)

@sahbi you should copy and paste the file in /tmp/yaourt-tmp-<user>\aur-oracle-xe. But now i have another erros, like: Write failed. Can anybody help?

syaorandroid commented on 2016-12-14 16:43 (UTC) (edited on 2016-12-14 16:44 (UTC) by syaorandroid)

I have the same problem as sahbi, does anybody knows what to do?

Scimmia commented on 2016-11-22 03:20 (UTC)

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 (UTC)

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

jrborba commented on 2016-11-07 00:58 (UTC)

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 (UTC)

@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 (UTC)

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 (UTC)

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 (UTC)

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 (UTC) (edited on 2016-03-09 12:11 (UTC) by The_Loko)

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 (UTC)

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 (UTC)

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

kkl2401 commented on 2016-03-06 10:01 (UTC)

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.