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

Pinned Comments

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 Next › Last »

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

DragonX256 commented on 2020-11-18 10:21

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

galaxy0419 commented on 2020-11-18 09:31

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

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.

Anonymous comment on 2020-10-17 14:22

@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

@ArthurBorsboom Of course. Will fix that later.