bofm / docker-oracle12c Goto Github PK

View Code? Open in Web Editor NEW

69.0 14.0 70.0 53 KB

Docker image for Oracle Database 12c

License: MIT License

Shell 60.44% Makefile 39.56%

docker database oracle-database oracle

docker-oracle12c's Introduction

Goals

Provide an easy way to build a lightweight Docker image for Oracle Database.
Just run a database and skip the complexities of installation and configuration.

Features

docker run creates and starts up a new database or the existing database, if it is already created.
docker logs shows all the logs prefixed with log source (in the style of syslog).
Uses trap to handle signals and shutdown gracefully.
Data and logs are stored in /data so that -v /data could be used.
Total memory used by Oracle instance (MEMORY_TARGET) is set depending on --shm-size parameter.
rlwrap can be installed by running bash /tmp/install/install_rlwrap.sh (+ 50 MB on disk).

Build

Optional: if you are using Vagrant, you can use this Vagrantfile for your build environment.

download linuxamd64_12102_database_1of2.zip and linuxamd64_12102_database_2of2.zip from oracle.com and extract the archives to current directory.
Execute the following lines in bash and wait ~15 minutes:

git clone https://github.com/bofm/docker-oracle12c.git
cd docker-oracle12c
make all

Usage

Note: In the following examples oracle_database is the name of the container.

Create or run database and listener

Daemon mode

# Create and start
docker run -d --shm-size 1GB --name oracle_database -p 1521:1521 -v /data bofm/oracle12c
# Stop
docker stop -t 120 oracle_database
# Start again
docker start oracle_database

Important: Always stop with -t, otherwise Docker will kill the database instance, if it doesn't shut down in 10 seconds.

Foreground mode

# Start
docker run -it --shm-size 1GB --name oracle_database -p 1521:1521 -v /data bofm/oracle12c
# `ctrl+c` (SIGINT) to stop

Create a gzipped tar archive suitable for docker load (an archive of the image with a created database and without volumes)

It is recommended to use large (>=20GB, the default is 10GB) Docker base volume size, for which Vagrant with Vagrantfile can be used.

# Build everything and save the created image to a file.
#   This will echo something like this:
#     Image saved to: /some/path/docker_img_oracle_database_created_YYYY-MM-DD.tgz
make all docker-save

# The saved image can be loaded from the file
# The image will be loaded with tag bofm/oracle12c:created
docker load < docker_img_oracle_database_created_YYYY-MM-DD.tgz

# Run the image in the new container
# Daemon
docker run -d --shm-size 1GB --name oracle_database -p 1521:1521 bofm/oracle12c:created
# Foreground
docker run -it --shm-size 1GB --name oracle_database -p 1521:1521 bofm/oracle12c:created

Logs

# Check all the logs in one place
docker logs oracle_database

# Check alert log
docker logs oracle_database | grep alertlog:

# Check listener log
docker logs oracle_database | grep listener:

SQL*Plus, RMAN or any other program

# Bash
# as root
docker exec -it -u root oracle_database bash
# as oracle
docker exec -it oracle_database bash

# Run sqlplus in the running container
docker exec -it oracle_database sqlplus / as sysdba

# Run rman in the running container
docker exec -it oracle_database rman target /

# Run sqlplus in a separate container and
# connect to the database in the linked container
docker run -it --rm --link oracle_database:oradb bofm/oracle12c sqlplus sys/sys@oradb/ORCL as sysdba

Start listener only (not sure if anybody needs it :) )

docker run -d --name listener -p 1521:1521 bofm/oracle12c listener
# Or link it to the running container
docker run -d --name listener -p 1521:1521 --link <database_container> bofm/oracle12c listener

Compatibility

Tested on Docker 1.12

Limitations and Bugs

--shm-size option is required to mount /dev/shm to use Oracle's automatic memory management.
Oracle Database doesn't work with Docker ZFS storage driver by default. Check this issue for the workaround.
Database options and sample schemas installation through DBCA is a mystery. In this repo dbca is run with -sampleSchema true and db_template.dbt contains this line <option name="SAMPLE_SCHEMA" value="true"/>, but nothing happens, the database is always created without sample schemas. Well, that's Oracle Database after 30+ years of development.

License

This repo - MIT License.
Oracle Database software - see Database Licensing Information.

TODO

create new databases faster
use spfile?
EM DBconsole
Archivelog mode option?
syslog-ng or rsyslog, maybe?

docker-oracle12c's People

Contributors

Stargazers

Watchers

docker-oracle12c's Issues

do we need to orainstRoot.sh and root.sh script or it is automatic

getting below mentioned error message when i try to execute

root@ubuntu:~# docker exec -it oracle_database gosu oracle sqlplus / as sysdba
error: failed switching to "oracle": operation not permitted

DB Auto-Shutdown after a short period

Good day.

I've created an docker image using your instructions.
But something strange occurs.
After a short period after the start (about 10 minutes) the DB is going to power-off state.
But DB do it normally. Looks like something says to shutdown and DB is going to do it.
The docker container is still alive at that time.

My command to start

docker run -d --name oracle_database \
--shm-size 4GB \
-p 18081:8080 -p 11521:1521 \
bofm/oracle12c

Some logs from the command docker logs oracle_database | grep alertlog:

alertlog: Tue Jan 10 11:47:08 2017
alertlog: UNDO_SEG_CRT: Could not find usn tail
alertlog: Completed: create rollback segment SYSTEM tablespace SYSTEM
alertlog: storage (initial 50K next 50K)
alertlog: Tue Jan 10 11:47:08 2017
alertlog: db_recovery_file_dest_size of 5265 MB is 0.00% used. This is a
alertlog: user-specified limit on the amount of space that will be used by this
alertlog: database for recovery-related files, and does not reflect the amount of
alertlog: space available in the underlying filesystem or ASM diskgroup.
alertlog: Tue Jan 10 11:47:08 2017
alertlog: Caching undo dictionary info: used hint for object index=0
alertlog: Caching undo dictionary info: used hint for object index=1
alertlog: Caching undo dictionary info: used hint for object index=2
alertlog: Caching undo dictionary info: used hint for object index=3
alertlog: Caching undo dictionary info: used hint for object index=4
alertlog: Undo initialization finished serial:0 start:597758716 end:597758716 diff:0 ms (0.0 seconds)
alertlog: alter tablespace system force logging
alertlog: Completed: alter tablespace system force logging
alertlog: processing ?/rdbms/admin/dsqlddl.bsq
alertlog: processing ?/rdbms/admin/dmanage.bsq
alertlog: CREATE TABLESPACE sysaux DATAFILE  '/data/oracle/oradata/ORCL/sysaux01.dbf' SIZE 550M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
alertlog: 
alertlog: EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
alertlog: Completed: CREATE TABLESPACE sysaux DATAFILE  '/data/oracle/oradata/ORCL/sysaux01.dbf' SIZE 550M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
alertlog: 
alertlog: EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
alertlog: alter tablespace system default compress for all operations
alertlog: Completed: alter tablespace system default compress for all operations
alertlog: alter tablespace sysaux default compress for all operations
alertlog: Completed: alter tablespace sysaux default compress for all operations
alertlog: processing ?/rdbms/admin/dplsql.bsq
alertlog: processing ?/rdbms/admin/dtxnspc.bsq
alertlog: CREATE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE   '/data/oracle/oradata/ORCL/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
alertlog: 
alertlog: [202] Successfully onlined Undo Tablespace 2.
alertlog: Completed: CREATE SMALLFILE UNDO TABLESPACE UNDOTBS1 DATAFILE   '/data/oracle/oradata/ORCL/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
alertlog: 
alertlog: CREATE SMALLFILE TEMPORARY TABLESPACE TEMP TEMPFILE  '/data/oracle/oradata/ORCL/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
alertlog: 
alertlog: Completed: CREATE SMALLFILE TEMPORARY TABLESPACE TEMP TEMPFILE  '/data/oracle/oradata/ORCL/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
alertlog: 
alertlog: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
alertlog: Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
alertlog: ALTER DATABASE DEFAULT TABLESPACE SYSTEM
alertlog: Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM
alertlog: processing ?/rdbms/admin/dfmap.bsq
alertlog: processing ?/rdbms/admin/denv.bsq
alertlog: processing ?/rdbms/admin/drac.bsq
alertlog: processing ?/rdbms/admin/dsec.bsq
alertlog: processing ?/rdbms/admin/doptim.bsq
alertlog: processing ?/rdbms/admin/dobj.bsq
alertlog: processing ?/rdbms/admin/djava.bsq
alertlog: processing ?/rdbms/admin/dpart.bsq
alertlog: processing ?/rdbms/admin/drep.bsq
alertlog: processing ?/rdbms/admin/daw.bsq
alertlog: processing ?/rdbms/admin/dsummgt.bsq
alertlog: processing ?/rdbms/admin/dtools.bsq
alertlog: processing ?/rdbms/admin/dexttab.bsq
alertlog: processing ?/rdbms/admin/ddm.bsq
alertlog: processing ?/rdbms/admin/dlmnr.bsq
alertlog: processing ?/rdbms/admin/ddst.bsq
alertlog: processing ?/rdbms/admin/dfba.bsq
alertlog: processing ?/rdbms/admin/dpstdy.bsq
alertlog: processing ?/rdbms/admin/drupg.bsq
alertlog: processing ?/rdbms/admin/dtlog.bsq
alertlog: Tue Jan 10 11:47:13 2017
alertlog: SMON: enabling tx recovery
alertlog: Starting background process SMCO
alertlog: Tue Jan 10 11:47:13 2017
alertlog: SMCO started with pid=7, OS id=218
alertlog: Tue Jan 10 11:47:14 2017
alertlog: Successfully created internal service SYS$BACKGROUND at open
alertlog: Successfully created internal service SYS$USERS at open
alertlog: replication_dependency_tracking turned off (no async multimaster replication found)
alertlog: Starting background process AQPC
alertlog: Tue Jan 10 11:47:14 2017
alertlog: AQPC started with pid=31, OS id=226
alertlog: Completed: CREATE DATABASE "ORCL"
alertlog: MAXINSTANCES 8
alertlog: MAXLOGHISTORY 1
alertlog: MAXLOGFILES 16
alertlog: MAXLOGMEMBERS 3
alertlog: MAXDATAFILES 100
alertlog: DATAFILE '/data/oracle/oradata/ORCL/system01.dbf' SIZE 700M REUSE AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
alertlog: EXTENT MANAGEMENT LOCAL
alertlog: SYSAUX DATAFILE '/data/oracle/oradata/ORCL/sysaux01.dbf' SIZE 550M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
alertlog: SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/data/oracle/oradata/ORCL/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
alertlog: SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE  '/data/oracle/oradata/ORCL/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED
alertlog: CHARACTER SET AL32UTF8
alertlog: NATIONAL CHARACTER SET AL16UTF16
alertlog: LOGFILE GROUP 1 ('/data/oracle/oradata/ORCL/redo01.log') SIZE 100M,
alertlog: GROUP 2 ('/data/oracle/oradata/ORCL/redo02.log') SIZE 100M,
alertlog: GROUP 3 ('/data/oracle/oradata/ORCL/redo03.log') SIZE 100M
alertlog: USER SYS IDENTIFIED BY  USER SYSTEM IDENTIFIED BY
alertlog: Tue Jan 10 11:47:14 2017
alertlog: CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  '/data/oracle/oradata/ORCL/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL  SEGMENT SPACE MANAGEMENT  AUTO
alertlog: Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  '/data/oracle/oradata/ORCL/users01.dbf' SIZE 5M REUSE AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL  SEGMENT SPACE MANAGEMENT  AUTO
alertlog: ALTER DATABASE DEFAULT TABLESPACE "USERS"
alertlog: Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
alertlog: Tue Jan 10 11:47:35 2017
alertlog: Thread 1 advanced to log sequence 2 (LGWR switch)
alertlog: Current log# 2 seq# 2 mem# 0: /data/oracle/oradata/ORCL/redo02.log
alertlog: Tue Jan 10 11:48:26 2017
alertlog: Thread 1 advanced to log sequence 3 (LGWR switch)
alertlog: Current log# 3 seq# 3 mem# 0: /data/oracle/oradata/ORCL/redo03.log
alertlog: Tue Jan 10 11:48:56 2017
alertlog: Thread 1 cannot allocate new log, sequence 4
alertlog: Checkpoint not complete
alertlog: Current log# 3 seq# 3 mem# 0: /data/oracle/oradata/ORCL/redo03.log
alertlog: Tue Jan 10 11:48:59 2017
alertlog: Thread 1 advanced to log sequence 4 (LGWR switch)
alertlog: Current log# 1 seq# 4 mem# 0: /data/oracle/oradata/ORCL/redo01.log
alertlog: Tue Jan 10 11:49:17 2017
alertlog: Create Relation IPS_PACKAGE_UNPACK_HISTORY
alertlog: Tue Jan 10 11:49:42 2017
alertlog: Thread 1 advanced to log sequence 5 (LGWR switch)
alertlog: Current log# 2 seq# 5 mem# 0: /data/oracle/oradata/ORCL/redo02.log
alertlog: Tue Jan 10 11:49:54 2017
alertlog: Thread 1 cannot allocate new log, sequence 6
alertlog: Checkpoint not complete
alertlog: Current log# 2 seq# 5 mem# 0: /data/oracle/oradata/ORCL/redo02.log
alertlog: Tue Jan 10 11:49:57 2017
alertlog: Thread 1 advanced to log sequence 6 (LGWR switch)
alertlog: Current log# 3 seq# 6 mem# 0: /data/oracle/oradata/ORCL/redo03.log
alertlog: Tue Jan 10 11:50:24 2017
alertlog: Thread 1 cannot allocate new log, sequence 7
alertlog: Checkpoint not complete
alertlog: Current log# 3 seq# 6 mem# 0: /data/oracle/oradata/ORCL/redo03.log
alertlog: Tue Jan 10 11:50:29 2017
alertlog: Thread 1 advanced to log sequence 7 (LGWR switch)
alertlog: Current log# 1 seq# 7 mem# 0: /data/oracle/oradata/ORCL/redo01.log
alertlog: Tue Jan 10 11:51:50 2017
alertlog: Thread 1 cannot allocate new log, sequence 8
alertlog: Checkpoint not complete
alertlog: Current log# 1 seq# 7 mem# 0: /data/oracle/oradata/ORCL/redo01.log
alertlog: Tue Jan 10 11:51:53 2017
alertlog: Thread 1 advanced to log sequence 8 (LGWR switch)
alertlog: Current log# 2 seq# 8 mem# 0: /data/oracle/oradata/ORCL/redo02.log
alertlog: Tue Jan 10 11:52:57 2017
alertlog: Thread 1 cannot allocate new log, sequence 9
alertlog: Checkpoint not complete
alertlog: Current log# 2 seq# 8 mem# 0: /data/oracle/oradata/ORCL/redo02.log
alertlog: Tue Jan 10 11:53:00 2017
alertlog: Thread 1 advanced to log sequence 9 (LGWR switch)
alertlog: Current log# 3 seq# 9 mem# 0: /data/oracle/oradata/ORCL/redo03.log
alertlog: Tue Jan 10 11:53:12 2017
alertlog: Resize operation completed for file# 3, old size 204800K, new size 215040K
alertlog: Tue Jan 10 11:53:45 2017
alertlog: Shared IO Pool defaulting to 128MB. Trying to get it from Buffer Cache for process 236.
alertlog: Resize operation completed for file# 3, old size 215040K, new size 225280K
alertlog: Resize operation completed for file# 3, old size 225280K, new size 235520K
alertlog: Tue Jan 10 11:53:54 2017
alertlog: Thread 1 cannot allocate new log, sequence 10
alertlog: Checkpoint not complete
alertlog: Current log# 3 seq# 9 mem# 0: /data/oracle/oradata/ORCL/redo03.log
alertlog: Tue Jan 10 11:53:57 2017
alertlog: Thread 1 advanced to log sequence 10 (LGWR switch)
alertlog: Current log# 1 seq# 10 mem# 0: /data/oracle/oradata/ORCL/redo01.log
alertlog: Tue Jan 10 11:54:03 2017
alertlog: ALTER SYSTEM SET db_securefile='NEVER' SCOPE=MEMORY;
alertlog: Tue Jan 10 11:54:03 2017
alertlog: ALTER SYSTEM SET db_securefile='PREFERRED' SCOPE=MEMORY;
alertlog: Tue Jan 10 11:54:04 2017
alertlog: Resize operation completed for file# 3, old size 235520K, new size 245760K
alertlog: Tue Jan 10 11:54:04 2017
alertlog: Resize operation completed for file# 4, old size 5120K, new size 15360K
alertlog: Resize operation completed for file# 4, old size 15360K, new size 25600K
alertlog: Resize operation completed for file# 4, old size 25600K, new size 35840K
alertlog: Resize operation completed for file# 4, old size 35840K, new size 46080K
alertlog: Resize operation completed for file# 4, old size 46080K, new size 56320K
alertlog: Resize operation completed for file# 4, old size 56320K, new size 66560K
alertlog: Resize operation completed for file# 4, old size 66560K, new size 76800K
alertlog: Resize operation completed for file# 4, old size 76800K, new size 87040K
alertlog: Resize operation completed for file# 4, old size 87040K, new size 97280K
alertlog: Resize operation completed for file# 4, old size 97280K, new size 107520K
alertlog: Resize operation completed for file# 4, old size 107520K, new size 117760K
alertlog: Resize operation completed for file# 4, old size 117760K, new size 128000K
alertlog: Resize operation completed for file# 4, old size 128000K, new size 138240K
alertlog: Resize operation completed for file# 4, old size 138240K, new size 148480K
alertlog: Resize operation completed for file# 4, old size 148480K, new size 158720K
alertlog: Resize operation completed for file# 4, old size 158720K, new size 168960K
alertlog: Resize operation completed for file# 4, old size 168960K, new size 179200K
alertlog: Resize operation completed for file# 4, old size 179200K, new size 189440K
alertlog: Resize operation completed for file# 4, old size 189440K, new size 199680K
alertlog: Resize operation completed for file# 4, old size 199680K, new size 209920K
alertlog: Resize operation completed for file# 4, old size 209920K, new size 220160K
alertlog: Resize operation completed for file# 4, old size 220160K, new size 230400K
alertlog: Tue Jan 10 11:54:15 2017
alertlog: Resize operation completed for file# 3, old size 245760K, new size 256000K
alertlog: Tue Jan 10 11:54:16 2017
alertlog: Buffer Cache Full DB Caching mode changing from FULL CACHING ENABLED to FULL CACHING DISABLED
alertlog: Full DB Caching disabled: DEFAULT_CACHE_SIZE should be at least 19 MBs bigger than current size.
alertlog: Tue Jan 10 11:54:16 2017
alertlog: Resize operation completed for file# 4, old size 230400K, new size 240640K
alertlog: Tue Jan 10 11:54:24 2017
alertlog: 
alertlog: XDB installed.
alertlog: 
alertlog: XDB initialized.
alertlog: Tue Jan 10 11:54:32 2017
alertlog: Resize operation completed for file# 3, old size 256000K, new size 266240K
alertlog: Tue Jan 10 11:54:33 2017
alertlog: Thread 1 cannot allocate new log, sequence 11
alertlog: Checkpoint not complete
alertlog: Current log# 1 seq# 10 mem# 0: /data/oracle/oradata/ORCL/redo01.log
alertlog: Tue Jan 10 11:54:34 2017
alertlog: Thread 1 advanced to log sequence 11 (LGWR switch)
alertlog: Current log# 2 seq# 11 mem# 0: /data/oracle/oradata/ORCL/redo02.log
alertlog: TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P181 (42744) VALUES LESS THAN (TO_DATE(' 2017-01-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
alertlog: Tue Jan 10 11:55:20 2017
alertlog: Resize operation completed for file# 3, old size 266240K, new size 276480K
alertlog: Tue Jan 10 11:55:34 2017
alertlog: Resize operation completed for file# 3, old size 276480K, new size 286720K
alertlog: Tue Jan 10 11:55:45 2017
alertlog: Resize operation completed for file# 3, old size 286720K, new size 296960K
alertlog: Tue Jan 10 11:55:45 2017
alertlog: Thread 1 cannot allocate new log, sequence 12
alertlog: Checkpoint not complete
alertlog: Current log# 2 seq# 11 mem# 0: /data/oracle/oradata/ORCL/redo02.log
alertlog: Tue Jan 10 11:55:48 2017
alertlog: Thread 1 advanced to log sequence 12 (LGWR switch)
alertlog: Current log# 3 seq# 12 mem# 0: /data/oracle/oradata/ORCL/redo03.log
alertlog: TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P201 (42744) VALUES LESS THAN (TO_DATE(' 2017-01-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
alertlog: Tue Jan 10 11:56:00 2017
alertlog: Resize operation completed for file# 3, old size 296960K, new size 307200K
alertlog: SERVER COMPONENT id=CATPROC: timestamp=2017-01-10 11:56:00
alertlog: Tue Jan 10 11:56:18 2017
alertlog: Resize operation completed for file# 3, old size 307200K, new size 317440K
alertlog: Tue Jan 10 11:56:22 2017
alertlog: SERVER COMPONENT id=UTLRP_BGN: timestamp=2017-01-10 11:56:22
alertlog: SERVER COMPONENT id=UTLRP_END: timestamp=2017-01-10 11:56:27
alertlog: Shutting down instance (immediate)
alertlog: Stopping background process SMCO
alertlog: Shutting down instance: further logons disabled
alertlog: Stopping background process MMNL
alertlog: Stopping background process MMON
alertlog: License high water mark = 2
alertlog: Tue Jan 10 11:56:34 2017
alertlog: All dispatchers and shared servers shutdown
alertlog: ALTER DATABASE CLOSE NORMAL
alertlog: Tue Jan 10 11:56:36 2017
alertlog: SMON: disabling tx recovery
alertlog: Tue Jan 10 11:56:36 2017
alertlog: Stopping Emon pool
alertlog: Stopping Emon pool
alertlog: Tue Jan 10 11:56:36 2017
alertlog: SMON: disabling cache recovery
alertlog: Shutting down archive processes
alertlog: Archiving is disabled
alertlog: Tue Jan 10 11:56:36 2017
alertlog: Thread 1 closed at log sequence 12
alertlog: Successful close of redo thread 1
alertlog: Completed: ALTER DATABASE CLOSE NORMAL
alertlog: ALTER DATABASE DISMOUNT
alertlog: Shutting down archive processes
alertlog: Archiving is disabled
alertlog: Completed: ALTER DATABASE DISMOUNT
alertlog: Tue Jan 10 11:56:37 2017
alertlog: ARCH: Archival disabled due to shutdown: 1089
alertlog: Shutting down archive processes
alertlog: Archiving is disabled
alertlog: ARCH: Archival disabled due to shutdown: 1089
alertlog: Shutting down archive processes
alertlog: Archiving is disabled
alertlog: Tue Jan 10 11:56:39 2017
alertlog: Stopping background process VKTM
alertlog: Tue Jan 10 11:56:46 2017
alertlog: Instance shutdown complete

Username and password?

Hi,

I was able to run your oracle database, however I am not sure what is the username, password, database and SID name for this image? I use the one with the tag "preinstall".

Thanks

Unable to change password for oracle user

I need to change the password for oracle user. I log into root user, run the passwd procedure to change password, it says it is successfully updated, but if I try to log into oracle user, it gives me error, like it wasn't changed at all.
I use this image for our developers, it is by far, the best for our needs. If I could change the password it would be perfect.
I assume it is possible by rewriting some line in the build script, but I don't know where to look.
Anyway, great work, thank you!

Error to install /bin/bash: ./runInstaller: No such file or directory

enio_oliveira@homeworkte:~/Documents/docker-oracle12c$ make all
Installing Oracle Database software...
c3be46c2902c bofm/oracle12c:preinstall "/tmp/install/install" 8 minutes ago Exited (127) 8 minutes ago oracle_install
oracle_install
/bin/bash: ./runInstaller: No such file or directory
Makefile:50: recipe for target 'install' failed
make: *** [install] Error 127

I1m getting this error when i execute the command line "make all"

Error running the container MEMORY_TARGET not supported on this system

When running the container, there is an error:

MEMORY_TARGET not supported on this system

and the containers exits. My info:

Containers: 0
 Running: 0
 Paused: 0
 Stopped: 0
Images: 257
Server Version: 1.11.1
Storage Driver: devicemapper
 Pool Name: docker-253:1-2495626-pool
 Pool Blocksize: 65.54 kB
 Base Device Size: 10.74 GB
 Backing Filesystem: ext4
 Data file: /dev/loop0
 Metadata file: /dev/loop1
 Data Space Used: 11.57 GB
 Data Space Total: 107.4 GB
 Data Space Available: 17.74 GB
 Metadata Space Used: 11.38 MB
 Metadata Space Total: 2.147 GB
 Metadata Space Available: 2.136 GB
 Udev Sync Supported: true
 Deferred Removal Enabled: false
 Deferred Deletion Enabled: false
 Deferred Deleted Device Count: 0
 Data loop file: /var/lib/docker/devicemapper/devicemapper/data
 Metadata loop file: /var/lib/docker/devicemapper/devicemapper/metadata
 Library Version: 1.02.109 (2015-09-22)
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins: 
 Volume: local
 Network: bridge null host
Kernel Version: 4.4.9-300.fc23.x86_64
Operating System: Fedora 23 (Workstation Edition)
OSType: linux
Architecture: x86_64
CPUs: 4
Total Memory: 7.704 GiB
Name: gali7
ID: 5SH4:FMHV:JZ6W:AKLM:QBAS:LU7R:DHNI:KTFW:TZGX:HQBR:5SY4:JNZO
Docker Root Dir: /var/lib/docker
Debug mode (client): false
Debug mode (server): false
Registry: https://index.docker.io/v1/

dbca_log: ORA-00845: MEMORY_TARGET not supported on this system

创建完bofm/oracle以后，执行如下：
docker run -t -i --shm-size 2GB borm/oracle
在创建oracle时，发现执行错误：
dbca_log: ORA-00845: MEMORY_TARGET not supported on this system

exec failed: permission denied

After make all

root@hadoop:/exch/docker-oracle12c-master# make run
error: exec failed: permission denied

root@hadoop:/exch/docker-oracle12c-master# make run-priv
docker run -it --rm -v /data --privileged --name oracle bofm/oracle12c bash --shm
Mounting /dev/shm...
error: exec failed: permission denied
Makefile:49: recipe for target 'run-priv' failed
make: *** [run-priv] Error 1

unable to run with zfs storage driver

Hello

your image does not work based on docker with zfs storage driver
I think its a bug in docker/zfs (read on), but I want to keep you noticed, and perhaps you have some ideas for workarounds. I'll try to file an issue on docker...

ubuntu 16.04 with zfs
docker 1.11.2
https://docs.docker.com/engine/userguide/storagedriver/zfs-driver/
(setup of zfs fs is a bit simpler with new ubuntu now.)

both "make test" and "test3" (means with and without a volume) fails on both listener and on dbca execution. See the erros below.
I also tried to run the image with "-u root", and I noticed,that the error on the listener went away, however, dbca is not allowed to run as root user.
--privileged also did not help.

Also mind that when I try to create such files manually (as oracle user) things work fine, so I think oracle does some special things during opening the files.

regarding volumes:
(1) no -v : fails (implies zfs)
(2) -v /data: fails (implieds zfs)
(3) -v /some_non_zfs:/data: works
(4) -v /some_zfs:/data: fails

So, it seems that docker/zfs integration has a problem with access control setup (remember the -u root above, where the listener startup is successful)

Greetings, Gerhard.

listener: [AutoCreate Relation]: following error encountered and ignored:
listener: DIA-48316: relation [ADR_CONTROL] unavailable or cannot be created
listener: DIA-48210: Relation Not Found
listener: DIA-48166: error with opening ADR block file because file does not exist [/app/oracle/diag/tnslsnr/bc9000c85096/listener/metadata/ADR_CONTROL.ams] [0]
listener: DIA-48122: error with opening the ADR block file [/app/oracle/diag/tnslsnr/bc9000c85096/listener/metadata/ADR_CONTROL.ams] [0]
listener: DIA-27040: Message 27040 not found; product=RDBMS; facility=DIA
listener: Linux-x86_64 Error: 22: Invalid argument
listener: Additional information: 2
...

dbca_log: Creating and starting Oracle instance
dbca_log: DBCA_PROGRESS : 2%
dbca_log: DBCA_PROGRESS : 3%
dbca_log: DBCA_PROGRESS : 5%
dbca_log: ORA-01501: CREATE DATABASE failed
dbca_log: ORA-00200: control file could not be created
dbca_log: ORA-00202: control file: '/data/oracle/oradata/ORCL/control01.ctl'
dbca_log: ORA-27040: file create error, unable to create file

Apex Support, Windows, Persistent DB?

Hello,

quite new to Docker and I have some Questions/issues here.

I want to use this image on a windows mashine with an APEX application deployed into it. So first I need to install Apex into the image which I kinda don't know how.

Is it possible to Take the Image, put it on Windows, start it and have a persistent database? What happens if Windows will be shutdown without stopping the image before? Is it possible to add Apex 5 to the image?

manifest for bofm/oracle12c:installed not found

Sending build context to Docker daemon 22.02kB
Step 1/13 : FROM bofm/oracle12c:installed
manifest for bofm/oracle12c:installed not found
******* FAILED 4 times

And failed again and again.

/bin/bash: ./runInstaller: No such file or directory

Im using osx.
after running make full.
Here is the error.
Successfully built 258d8fe419a1 Installing Oracle Database software... 8543679cbee2 bofm/oracle12c:preinstall "/tmp/install/install" 4 minutes ago Exited (127) 2 minutes ago aa_oracle_zz_install aa_oracle_zz_install /bin/bash: ./runInstaller: No such file or directory make: *** [install] Error 127

Can you tell me how to change the port of the database?

Because I want to run two container in docker to test .

make: *** [install] Error 127 /bin/bash: ./runInstaller: No such file or directory

I get this error when I run make

$ make all
\033[32mInstalling Oracle Database software...\033[0m
Unable to find image 'bofm/oracle12c:preinstall' locally
preinstall: Pulling from bofm/oracle12c
a3ed95caeb02: Pull complete
4164c8cc49b7: Pull complete
6a54cbaa2f35: Pull complete
a8482cde7cad: Pull complete
80fd503b7647: Pull complete
cf214770b793: Pull complete
0d5d1e8a3a13: Pull complete
d62732ebc72a: Pull complete
07354f4227e1: Pull complete
bab3fa98616c: Pull complete
Digest: sha256:7e8043881e932f40e0b5c916faa5dda121186bc93d653969ff216e46e37a2aa5
Status: Downloaded newer image for bofm/oracle12c:preinstall
/bin/bash: ./runInstaller: No such file or directory
make: *** [install] Error 127

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.