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

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?

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

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