Code Monkey home page Code Monkey logo

oracle-11g's Introduction

Image for running Oracle Database 11g Standard/Enterprise. Due to oracle license restrictions image is not contain database itself and will install it on first run from external directory.

This image for development use only

Usage

Download database installation files from Oracle site and unpack them to install_folder. Run container and it will install oracle and create database:

docker run --privileged --name oracle11g -p 1521:1521 -v <install_folder>:/install jaspeen/oracle-11g

Then you can commit this container to have installed and configured oracle database:

docker commit oracle11g oracle11g-installed

Database located in /opt/oracle folder

OS users:

  • root/install
  • oracle/install

DB users:

  • SYS/oracle

Optionally you can map dpdump folder to easy upload dumps:

docker run --privileged --name oracle11g -p 1521:1521 -v <install_folder>:/install -v <local_dpdump>:/opt/oracle/dpdump jaspeen/oracle-11g

To execute impdp/expdp just use docker exec command:

docker exec -it oracle11g impdp ..

oracle-11g's People

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

oracle-11g's Issues

Startup of the container crashes without error

When starting the container the installation of the db crashes:
Checking Temp space: must be greater than 80 MB. Actual 44933 MB Passed
Checking swap space: must be greater than 150 MB. Actual 984 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-11-08_07-55-27PM. Please wait ...

And then thats it, it jumps back to the console. The docker container is also not running anymore

Permission denied

Database is not installed. Installing...
Installing Oracle Database 11g
bash: /install/database/runInstaller: Permission denied

can't find java or environment setting

I can connect with sqldevelopper, but can not access to java
CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED ...

ORA-29516: รฉchec d'assertion Aurora : Assertion failure at joez.c:3311 Bulk load of method java/lang/Object.<init> failed; insufficient shm-object space 29516. 00000 - "Aurora assertion failure: %s" *Cause: An internal error occurred in the Aurora module.

Change characterset

Hello, we are testing oracle in docker, and this image is perfect for same test. Now we need change the character set AL32UTF8 to WE8ISO8859P9 because we have a Turkish database.
Can you help us? because we tried change it with CSSCAN, and altering directly, but ever was wrong.

We tried put in file profile too
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P9
export NLS_CHARACTERSET=WE8ISO8859P9
export NLS_NCHAR_CHARACTERSET=AL16UTF16

and run the built but it isnt run.

thanks for your help.

Best regards

Image errorn on run

Hello,

I have the next error message ๐Ÿ‘ Database is not installed. Installing...
Installation files not found. Unzip installation files into mounted(/install) folder

the docker file is on /install folder and also on /install/database I have the sources
The assets folder is also on /install folder.

Please help.

Best regards,
Daniela

For new branch

Could you create a new branch for Oralce database version 11.2.0.1? I use the version, so I want to merge the version code into it. Thank you!

[FATAL] [INS-10105] The given response file /assets/db_install.rsp is not valid. Docker build is failing

Hello,

I was been testing the image in test environment, its been failing with the response file error. Any known issue of fix for this ?

docker run --privileged --name oracle11g -p 1521:1521 -v /root/docker-images/OracleDatabase/dockerfiles/11.2.0.2:/install jaspeen/oracle-11g

Database is not installed. Installing...
Installing Oracle Database 11g
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 9919 MB Passed
Checking swap space: must be greater than 150 MB. Actual 10239 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-12-06_08-25-17PM. Please wait ...[FATAL] [INS-10105] The given response file /assets/db_install.rsp is not valid.
CAUSE: Syntactically incorrect response file. Either unexpected variables are specified or expected variables are not specified in the response file.
ACTION: Refer the latest product specific response file template
SUMMARY:
- cvc-complex-type.2.4.a: Invalid content was found starting with element 'oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification'. One of '{"":oracle.install.responseFileVersion, "":oracle.install.option, "":SELECTED_LANGUAGES, "":INVENTORY_LOCATION, "":UNIX_GROUP_NAME, "":oracle.install.db.InstallEdition, "":ORACLE_HOME, "":oracle.install.db.CLUSTER_NODES, "":oracle.install.db.isRACOneInstall, "":oracle.install.db.racOneServiceName, "":oracle.install.db.DBA_GROUP, "":oracle.install.db.OPER_GROUP, "":oracle.install.db.EEOptionsSelection, "":oracle.install.db.optionalComponents, "":oracle.install.db.config.starterdb.type, "":oracle.install.db.config.starterdb.SID, "":oracle.install.db.config.starterdb.globalDBName, "":oracle.install.db.config.starterdb.characterSet, "":oracle.install.db.config.starterdb.memoryLimit, "":oracle.install.db.config.starterdb.enableSecuritySettings, "":oracle.install.db.config.starterdb.storageType, "":oracle.install.db.config.starterdb.fileSystemStorage.dataLocation, "":oracle.install.db.config.starterdb.password.ALL, "":oracle.install.db.config.starterdb.password.SYS, "":oracle.install.db.config.starterdb.password.DBSNMP, "":oracle.install.db.config.starterdb.password.SYSMAN, "":oracle.install.db.config.starterdb.password.SYSTEM, "":oracle.install.db.config.starterdb.control, "":oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL, "":oracle.install.db.config.starterdb.automatedBackup.enable, "":oracle.install.db.config.starterdb.automatedBackup.osuid, "":oracle.install.db.config.starterdb.automatedBackup.ospwd, "":SECURITY_UPDATES_VIA_MYORACLESUPPORT, "":DECLINE_SECURITY_UPDATES, "":MYORACLESUPPORT_USERNAME, "":MYORACLESUPPORT_PASSWORD, "":PROXY_PORT, "":PROXY_HOST, "":PROXY_USER, "":PROXY_PWD, "":PROXY_REALM, "":COLLECTOR_SUPPORTHUB_URL, "":AUTOUPDATES_MYORACLESUPPORT_USERNAME, "":AUTOUPDATES_MYORACLESUPPORT_PASSWORD, "":oracle.installer.autoupdates.option, "":oracle.installer.autoupdates.downloadUpdatesLoc}' is expected.

  • Thanks
    Ramu

mounting existing database files

Hi,

I'm wondering what the correct mount is to mount an existing dataset, for instance /home/user/mysid to use the ORCL database. I've tried to mount my /home/user/mysid/oradata to /opt/oracle/app/oradata/orcl/oradata but the database denied connection by stating:

listener: TNS-12528: TNS:listener: all appropriate instances are blocking new connections

Any idea what could be the issue?

Checking shared memory... Filesystem Size Used Avail Use% Mounted on shm 64M 0 64M 0% /dev/shm Starting listener... tail: cannot open '/opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/trace/listener.log' for reading: No such file or directory tail: cannot watch parent directory of '/opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/trace/listener.log': No such file or directory tail: inotify cannot be used, reverting to polling lsnrctl: lsnrctl: LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-JAN-2017 09:14:29 lsnrctl: lsnrctl: Copyright (c) 1991, 2009, Oracle. All rights reserved. lsnrctl: lsnrctl: Starting /opt/oracle/app/product/11.2.0/dbhome_1/bin/tnslsnr: please wait... lsnrctl: tail: '/opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/trace/listener.log' has appeared; following end of new file listener: Mon Jan 23 09:14:29 2017 listener: Create Relation ADR_CONTROL listener: Create Relation ADR_INVALIDATION listener: Create Relation INC_METER_IMPT_DEF listener: Create Relation INC_METER_PK_IMPTS listener: Log messages written to /opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/alert/log.xml listener: Trace information written to /opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/trace/ora_24_139991079151424.trc listener: Trace level is currently 0 listener: listener: Started with pid=24 lsnrctl: TNSLSNR for Linux: Version 11.2.0.1.0 - Production lsnrctl: Log messages written to /opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/alert/log.xml lsnrctl: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0b5785e8d75c)(PORT=1521))) lsnrctl: lsnrctl: Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) lsnrctl: STATUS of the LISTENER lsnrctl: ------------------------ lsnrctl: Alias LISTENER lsnrctl: Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production lsnrctl: Start Date 23-JAN-2017 09:14:29 lsnrctl: Uptime 0 days 0 hr. 0 min. 16 sec lsnrctl: Trace Level off lsnrctl: Security ON: Local OS Authentication lsnrctl: SNMP OFF lsnrctl: Listener Log File /opt/oracle/app/diag/tnslsnr/0b5785e8d75c/listener/alert/log.xml lsnrctl: Listening Endpoints Summary... lsnrctl: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0b5785e8d75c)(PORT=1521))) lsnrctl: The listener supports no services lsnrctl: The command completed successfully Starting database... sqlplus: sqlplus: SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 23 09:14:45 2017 sqlplus: sqlplus: Copyright (c) 1982, 2009, Oracle. All rights reserved. sqlplus: sqlplus: Connected to an idle instance. sqlplus: sqlplus: SQL> Starting with pfile='/opt/oracle/app/product/11.2.0/dbhome_1/dbs/initorcl.ora' ... listener: Mon Jan 23 09:14:45 2017 listener: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0b5785e8d75c)(PORT=1521))) listener: Listener completed notification to CRS on start listener: listener: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE listener: WARNING: Subscription for node down event still pending listener: 23-JAN-2017 09:14:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=0b5785e8d75c)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0 alertlog: Mon Jan 23 09:14:45 2017 alertlog: Adjusting the default value of parameter parallel_max_servers alertlog: from 160 to 135 due to the value of parameter processes (150) alertlog: Starting ORACLE instance (normal) alertlog: Errors in file /opt/oracle/app/diag/rdbms/orcl/orcl/trace/orcl_ora_32.trc: alertlog: ORA-27167: Attempt to determine if Oracle binary image is stored on remote server failed alertlog: ORA-27300: OS system dependent operation:parse_df failed with status: 2 alertlog: ORA-27301: OS failure message: No such file or directory alertlog: ORA-27302: failure occurred at: parse failed alertlog: ORA-27303: additional information: Filesystem 1K-blocks Used Available Use% Mounted on alertlog: none 359238356 325915372 15051652 96% / alertlog: Image consistency checking encountered an error, checking disabled alertlog: LICENSE_MAX_SESSION = 0 alertlog: LICENSE_SESSIONS_WARNING = 0 alertlog: Picked latch-free SCN scheme 3 alertlog: Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST alertlog: Autotune of undo retention is turned on. alertlog: IMODE=BR alertlog: ILAT =27 alertlog: LICENSE_MAX_USERS = 0 alertlog: SYS auditing is disabled alertlog: Mon Jan 23 09:15:01 2017 alertlog: Starting up: alertlog: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production alertlog: With the Partitioning, OLAP, Data Mining and Real Application Testing options. alertlog: Using parameter settings in server-side spfile /opt/oracle/app/product/11.2.0/dbhome_1/dbs/spfileorcl.ora alertlog: System parameters with non-default values: alertlog: processes = 150 alertlog: sga_target = 500M alertlog: memory_target = 0 alertlog: control_files = "/opt/oracle/app/oradata/orcl/control01.ctl" alertlog: control_files = "/opt/oracle/app/flash_recovery_area/orcl/control02.ctl" alertlog: db_block_size = 8192 alertlog: compatible = "11.2.0.0.0" alertlog: db_recovery_file_dest = "/opt/oracle/app/flash_recovery_area" alertlog: db_recovery_file_dest_size= 3882M alertlog: undo_tablespace = "UNDOTBS1" alertlog: remote_login_passwordfile= "EXCLUSIVE" alertlog: db_domain = "" alertlog: dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" alertlog: audit_file_dest = "/opt/oracle/app/admin/orcl/adump" alertlog: audit_trail = "DB" alertlog: db_name = "orcl" alertlog: open_cursors = 300 alertlog: pga_aggregate_target = 100M alertlog: diagnostic_dest = "/opt/oracle/app" sqlplus: SQL> ORACLE instance started. sqlplus: sqlplus: Total System Global Area 521936896 bytes sqlplus: Fixed Size 2214936 bytes sqlplus: Variable Size 159384552 bytes sqlplus: Database Buffers 352321536 bytes sqlplus: Redo Buffers 8015872 bytes sqlplus: ORA-00205: error in identifying control file, check alert log for more info sqlplus: sqlplus: sqlplus: SQL> sqlplus: System altered. sqlplus: sqlplus: SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production sqlplus: With the Partitioning, OLAP, Data Mining and Real Application Testing options listener: Mon Jan 23 09:15:17 2017 listener: Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0b5785e8d75c)(PORT=1521))) listener: 23-JAN-2017 09:15:17 * service_register * orcl * 0 listener: 23-JAN-2017 09:15:17 * service_update * orcl * 0 listener: 23-JAN-2017 09:15:17 * service_update * orcl * 0 alertlog: Mon Jan 23 09:15:17 2017 alertlog: PMON started with pid=2, OS id=35 alertlog: Mon Jan 23 09:15:17 2017 alertlog: VKTM started with pid=3, OS id=37 alertlog: VKTM running at (100ms) precision alertlog: Mon Jan 23 09:15:17 2017 alertlog: GEN0 started with pid=4, OS id=41 alertlog: Mon Jan 23 09:15:17 2017 alertlog: DIAG started with pid=5, OS id=43 alertlog: Mon Jan 23 09:15:17 2017 alertlog: DBRM started with pid=6, OS id=45 alertlog: Mon Jan 23 09:15:17 2017 alertlog: PSP0 started with pid=7, OS id=47 alertlog: Mon Jan 23 09:15:17 2017 alertlog: DIA0 started with pid=8, OS id=49 alertlog: Mon Jan 23 09:15:17 2017 alertlog: MMAN started with pid=9, OS id=51 alertlog: Mon Jan 23 09:15:17 2017 alertlog: DBW0 started with pid=10, OS id=53 alertlog: Mon Jan 23 09:15:17 2017 alertlog: LGWR started with pid=11, OS id=55 alertlog: Mon Jan 23 09:15:17 2017 alertlog: CKPT started with pid=12, OS id=57 alertlog: Mon Jan 23 09:15:17 2017 alertlog: SMON started with pid=13, OS id=59 alertlog: Mon Jan 23 09:15:17 2017 alertlog: RECO started with pid=14, OS id=61 alertlog: Mon Jan 23 09:15:17 2017 alertlog: MMON started with pid=15, OS id=63 alertlog: Mon Jan 23 09:15:17 2017 alertlog: starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... alertlog: Mon Jan 23 09:15:17 2017 alertlog: MMNL started with pid=16, OS id=65 alertlog: starting up 1 shared server(s) ... alertlog: ORACLE_BASE from environment = /opt/oracle/app alertlog: Mon Jan 23 09:15:17 2017 alertlog: ALTER DATABASE MOUNT alertlog: ORA-00210: cannot open the specified control file alertlog: ORA-00202: control file: '/opt/oracle/app/oradata/orcl/control01.ctl' alertlog: ORA-27041: unable to open file alertlog: Linux-x86_64 Error: 13: Permission denied alertlog: Additional information: 9 alertlog: ORA-205 signalled during: ALTER DATABASE MOUNT... alertlog: Mon Jan 23 09:15:17 2017 alertlog: Checker run found 1 new persistent data failures listener: 23-JAN-2017 09:15:20 * service_update * orcl * 0 listener: Mon Jan 23 09:16:42 2017 listener: 23-JAN-2017 09:16:42 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=DBeaver 3.8.0)(HOST=__jdbc__)(USER=michael))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.17.0.1)(PORT=51302)) * establish * ORCL * 12528 listener: TNS-12528: TNS:listener: all appropriate instances are blocking new connections

Error Build Image

Hey I wan't to build this image for my own.
It's because I need to define a diffrent charset.

But if I try to run docker build . I get the error

Step 5/8 : RUN /assets/setup.sh
 ---> Running in 072e9066d1c6
๏ฟฝ[91m/assets/setup.sh: line 1: set: -
: invalid option
set: usage: set [-abefhkmnptuvxBCHP] [-o option-name] [--] [arg ...]
docker : The command '/bin/sh -c /assets/setup.sh' returned a non-zero code: 2
In Zeile:1 Zeichen:1
+ docker build .
+ ~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (The command '/b...on-zero code: 2:String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError

Is there any option to run the build by myself?

Recommend Projects

  • React photo React

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

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

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

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

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

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.