@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.
Search Criteria
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: | |
Submitter: | The_Loko |
Maintainer: | DragonX256 (galaxy0419) |
Last Packager: | galaxy0419 |
Votes: | 11 |
Popularity: | 0.24 |
First Submitted: | 2015-11-12 22:21 |
Last Updated: | 2020-11-19 06:20 |
Dependencies (5)
Required by (0)
Sources (5)
galaxy0419 commented on 2020-12-01 09:10
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, usechmod -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.
Pinned Comments
galaxy0419 commented on 2020-11-19 06:23
Additional Notes:
ORA-12547: TNS:lost contact
error when logging into the database with sqlplus, usechmod -R u+s,g+s /opt/oracle/product/18c/dbhomeXE/bin/sqlplus
command with root to give suid and guid permission.Cheers