runOracle.sh failed

[sarkiva]

docker run -d -p 32118:1521 -p 35518:5500 --name=oracle-xe oracle-xe:18c

Unfortunately DB configuration does not work. The container starts, but orapwd fails, probably because of the symbolic links referencing themselves under /opt/oracle/oradata/dbconfig/XE

/opt/oracle/oradata/dbconfig/XE/orapwXE can not be found.

Database does not exists, configuring Configuring Oracle Listener. Listener configuration succeeded. Configuring Oracle Database XE. [WARNING] [DBT-09251] The listener configuration is not selected for the database. EM DB Express URL will not be accessible. CAUSE: The database should be registered with a listener in order to access the EM DB Express URL. ACTION: Select a listener to be registered or created with the database. Enter SYS user password:

---

Enter SYSTEM user password:

---

Enter PDBADMIN User Password:

---

Prepare for db operation 7% complete Copying database files 29% complete 100% complete [FATAL] Error in Process: /opt/oracle/product/18c/dbhomeXE/bin/orapwd

Enter password for SYS:

OPW-00001: Unable to open password-file 7% complete 0% complete Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.

Database configuration failed. Check logs under '/opt/oracle/cfgtoollogs/dbca'. The Oracle base remains unchanged with value /opt/oracle Enabling XDB for external access

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Feb 5 16:14:16 2019 Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connected to an idle instance.

SQL> BEGIN dbms_xdb_config.setlistenerlocalaccess(false); END;

ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0

SQL> BEGIN dbms_xdb_config.setglobalportenabled(true); END;

ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0

SQL> Disconnected sed: can't read /opt/oracle/product/18c/dbhomeXE/network/admin/listener.oraF: No such file or directory sed: can't read /opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora: No such file or directory The following output is now a tail of the alert.log: tail: cannot open '/opt/oracle/diag/rdbms///trace/alert*.log' for reading: No such file or directory tail: no files remaining

bash-4.2# cd /opt/oracle/oradata/dbconfig/XE/ bash-4.2# pwd /opt/oracle/oradata/dbconfig/XE bash-4.2# ls -la total 12 drwxr-xr-x. 2 root root 4096 Feb 5 16:14 . drwxr-xr-x. 3 root root 4096 Feb 5 16:10 .. lrwxrwxrwx. 1 root root 44 Feb 5 16:10 listener.ora -> /opt/oracle/oradata/dbconfig/XE/listener.ora lrwxrwxrwx. 1 root root 39 Feb 5 16:10 orapwXE -> /opt/oracle/oradata/dbconfig/XE/orapwXE -rw-r--r--. 1 root root 779 Feb 5 16:14 oratab lrwxrwxrwx. 1 root root 44 Feb 5 16:10 spfileXE.ora -> /opt/oracle/oradata/dbconfig/XE/spfileXE.ora lrwxrwxrwx. 1 root root 42 Feb 5 16:10 sqlnet.ora -> /opt/oracle/oradata/dbconfig/XE/sqlnet.ora lrwxrwxrwx. 1 root root 44 Feb 5 16:10 tnsnames.ora -> /opt/oracle/oradata/dbconfig/XE/tnsnames.ora

CentOS Linux release 7.5.1804 (Core)

docker version Client: Version: 18.09.1 API version: 1.39 Go version: go1.10.6 Git commit: 4c52b90 Built: Wed Jan 9 19:35:01 2019 OS/Arch: linux/amd64 Experimental: false

Server: Docker Engine - Community Engine: Version: 18.09.1 API version: 1.39 (minimum version 1.12) Go version: go1.10.6 Git commit: 4c52b90 Built: Wed Jan 9 19:06:30 2019 OS/Arch: linux/amd64 Experimental: false

oracle-database-xe-18c-1.0-1.x86_64.rpm

[fuzziebrain]

@sarkiva

1. Were there any errors during the build?
2. Did you change any other environment variables?
3. Is SELinux in enforcing mode?

[femarschall]

I had the same issue. I fixed it by generating a new orapwXE file:

• $ /opt/oracle/product/18c/dbhomeXE/bin/orapwd file=/opt/oracle/product/18c/dbhomeXE/dbs/orapwXE password=oracle ENTRIES=30 FORCE=Y IGNORECASE=Y format=12

maybe this could be placed on the script scripts/runOracle.sh instead of this line:

• mv $ORACLE_HOME/dbs/orapw$ORACLE_SID $ORACLE_BASE/oradata/dbconfig/$ORACLE_SID/

[femarschall]

just one more note, after that fix I also had problem with spfileXE.ora so I placed this file on /opt/oracle/product/18c/dbhomeXE/dbs:

• spfileXE.ora.txt

Later on to startup the database as Standalone (not pluggable), instead of running "/etc/init.d/oracle-xe-18c configure", I customized the db setup with DBCA:

• dbca -silent -createDatabase -templateName XE_Database.dbc -gdbName XE -sid XE -createAsContainerDatabase false -emConfiguration NONE -datafileDestination /opt/oracle/oradata/ -storageType FS -characterSet AL32UTF8 -totalMemory 2048