maksymbilenko / docker-oracle-ee-11g

🐳 Dockerfile of Oracle Database Enterprise Edition 11g Release 2

Oracle Enterprise Edition 11g Release 2

Oracle Enterprise Edition 11g Release 2 on Oracle Linux

This Dockerfile is a trusted build of Docker Registry.

Installation

docker pull sath89/oracle-ee-11g

Run with 8080 and 1521 ports opened:

docker run -d -p 8080:8080 -p 1521:1521 sath89/oracle-ee-11g

Run with data on host and reuse it:

docker run -d -p 8080:8080 -p 1521:1521 -v /my/oracle/data:/u01/app/oracle sath89/oracle-ee-11g

Run with Custom DBCA_TOTAL_MEMORY (in Mb):

docker run -d -p 8080:8080 -p 1521:1521 -v /my/oracle/data:/u01/app/oracle -e DBCA_TOTAL_MEMORY=1024 sath89/oracle-11g

Connect database with following setting:

hostname: localhost
port: 1521
sid: EE
service name: EE.oracle.docker
username: system
password: oracle

To connect using sqlplus:

sqlplus system/oracle@//localhost:1521/EE.oracle.docker

Password for SYS & SYSTEM:

oracle

Apex install up to v 5.*

docker run -it --rm --volumes-from ${DB_CONTAINER_NAME} --link ${DB_CONTAINER_NAME}:oracle-database -e PASS=YourSYSPASS quay.io/maksymbilenko/docker-oracle-apex install

Details could be found here: https://github.com/MaksymBilenko/docker-oracle-apex

Connect to Oracle Enterprise Management console with following settings:

http://localhost:8080/em
user: sys
password: oracle
connect as sysdba: true

By Default web management console is enabled. To disable add env variable:

docker run -d -e WEB_CONSOLE=false -p 1521:1521 -v /my/oracle/data:/u01/app/oracle sath89/oracle-11g
#You can Enable/Disable it on any time

Start with additional init scripts or dumps:

docker run -d -p 1521:1521 -v /my/oracle/data:/u01/app/oracle -v /my/oracle/init/SCRIPTSorSQL:docker-entrypoint-initdb.d sath89/oracle-11g

By default Import from docker-entrypoint-initdb.d enabled only if you are initializing database(1st run). If you need to run import at any case - add -e IMPORT_FROM_VOLUME=true In case of using DMP imports dump file should be named like ${IMPORT_SCHEME_NAME}.dmp User credentials for imports are ${IMPORT_SCHEME_NAME}/${IMPORT_SCHEME_NAME}

If you have an issue with database init like DBCA operation failed, please reffer to this issue

TODO LIST

• Web management console HTTPS port
• Add functionality to run custom scripts on startup, for example User creation
• Add Parameter that would setup processes amount for database (Currently by default processes=300)
• Spike with clustering support
• Spike with DB migration from 11g

In case of any issues please post it here.

docker-oracle-ee-11g's Issues

charset

Hi, how to specify a character set? I tried to use parameter -e NLS_LANG=AMERICAN_AMERICA.ZHS16GBK or -e CHARACTER_SET=AMERICAN_AMERICA.ZHS16GBK, but it is not ok.

EM is not starting

http://localhost:8080/em gives 404.
When tried execute
# su oracle -c "emctl start"
"Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name."

http://localhost:8080/ shows files.

About Oracle container restart failure

73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/EE/EE.log" for further details.
Starting web management console

PL/SQL procedure successfully completed.

Starting import from '/docker-entrypoint-initdb.d':
found file /docker-entrypoint-initdb.d//docker-entrypoint-initdb.d/*
[IMPORT] /entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

Import finished

Database ready to use. Enjoy! ;)
Database closed.
Database dismounted.
ORACLE instance shut down.
Preparing oracle installer.
Running root scripts.
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to dba.
The execution of the script is complete.
Check /u01/app/oracle/product/11.2.0/EE/install/root_684094e44f92_2018-09-20_01-35-19.log for the output of root script
found files in /u01/app/oracle/oradata Using them instead of initial database
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/EE/dbs/initEE.ora'
Starting web management console
BEGIN DBMS_XDB.sethttpport(8080); END;

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

Starting import from '/docker-entrypoint-initdb.d':
found file /docker-entrypoint-initdb.d//docker-entrypoint-initdb.d/*
[IMPORT] /entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

Import finished

Database ready to use. Enjoy! ;)

insufficient shm-object space

I have a problem working with geometries
For example when I execute this sql
SELECT SDO_GEOMETRY('POINT(497311 4678860)', 25831) FROM dual;
I get this error
Bulk load of method java/lang/reflect/Field. failed; insufficient shm-object space

I found some possible solutions, one of them is related about /etc/fstab file, but there isn't a fstab file in the container.

My run docker command is:

docker run -d -p 8080:8080 -p 1521:1521 --name dockerDB -v OracleDBData:/u01/app/oracle -e DBCA_TOTAL_MEMORY=8024 --shm-size 8g sath89/oracle-ee-11g

SQL> SELECT SDO_GEOMETRY('POINT(497311 4678860)', 25831) FROM dual;
SELECT SDO_GEOMETRY('POINT(497311 4678860)', 25831) FROM dual
*
ERROR at line 1:
ORA-29516: Aurora assertion failure: Assertion failure at joez.c:3311
Bulk load of method java/lang/Object. failed; insufficient shm-object
space
ORA-06512: at "MDSYS.SDO_UTIL", line 187
ORA-06512: at "MDSYS.SDO_GEOMETRY", line 76
ORA-06512: at line 1

sath89/oracle-ee-11g-base has been removed from DockerHub

Today I realised that sath89/oracle-ee-11g-base is not available at Docker Hub anymore, I believe the link was https://hub.docker.com/r/sath89/oracle-ee-11g-base/ which is not found currently.

use the volumes first time, then error!

oracle-ee:
image: sath89/oracle-ee-11g
environment:
- DBCA_TOTAL_MEMORY=1024
volumes:
- c:/Users/witer/Documents/db/a2:/u01/app/oracle
#- c:/Intel/aaa223:/docker-entrypoint-initdb.d

- c:/Intel/:/u01/app/oracle/oradata

ports:
- "8080:8080"
- "1521:1521"

i docker-compose it up, and then :

Check /u01/app/oracle/product/11.2.0/EE/install/root_a240d3c75b24_2017-09-04_10-41-34.log for the output of root script
found files in /u01/app/oracle/oradata Using them instead of initial database
ORA-01078: failure in processing system parameters

not exist anymore in docker hub

php connect oracle ee 11g

using codeigniter v3 php framework
with xe, simply declare hostname

'hostname' => '192.168.100.5:1521/xe',

switch to ee must put the whole string in oci_connect as hostname

'hostname' => '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.5)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = EE.oracle.docker) (SID = EE)))',