Arch Linux User Repository

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

@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.

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

@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.

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

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

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

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

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.

@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

@ArthurBorsboom Of course. Will fix that later.