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: 13
Popularity: 0.080169
First Submitted: 2015-11-12 22:21
Last Updated: 2020-11-19 06:20

Pinned Comments

ArthurBorsboom commented on 2021-11-25 11:03

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

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

1 2 3 4 5 Next › Last »

galaxy0419 commented on 2022-01-03 16:08

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

@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

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

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

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

@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

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

@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

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

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