maksymbilenko/docker-oracle-xe-11g

:whale: Dockerfile of Oracle Database Express Edition 11g Release 2

docker-oracle-xe-11g's Issues

Latest image not running

Log stats: Database is not configured. Please run /etc/init.d/oracle-xe configure if needed.... and nothing happens!

Platform OSX. Docker 1.9.0, Kitematic 0.9.3

%hosename% and %port% found in tnsnames.ora

%hosename% and %port% found in tnsnames.ora, it's perfect if like listener.ora
root@c548af6660cf:/u01/app/oracle/product/11.2.0/xe/network/admin# cat tnsnames.ora

# tnsnames.ora Network Configuration File:
XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = %hostname%)(PORT = %port%))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Building docker image - Installing debian package fails

Since the image is removed from Docker Hub, I'm trying to build the image myself, but I can't seem to succeed with that. When building the docker image, the command dpkg --install /${ORA_DEB} in oracle-install.sh fails with this output:

(Reading database ... 12079 files and directories currently installed.)
Preparing to unpack .../oracle-xe_11.2.0-1.0_amd64.deb ...
Unpacking oracle-xe (11.2.0-1.0) ...
dpkg-deb (subprocess): decompressing archive member: lzma error: compressed data is corrupt
dpkg-deb: error: subprocess <decompress> returned error exit status 2
dpkg: error processing archive /oracle-xe_11.2.0-1.0_amd64.deb (--install):
 cannot copy extracted data for './u01/app/oracle/product/11.2.0/xe/config/seeddb/express.dfb' to '/u01/app/oracle/product/11.2.0/xe/config/seeddb/express.dfb.dpkg-new': unexpected end of file or stream
Processing triggers for mime-support (3.54ubuntu1.1) ...
Processing triggers for libc-bin (2.19-0ubuntu6.14) ...
Errors were encountered while processing:
 /oracle-xe_11.2.0-1.0_amd64.deb

Is there something that I can do about this (e.g. download the assets from somewhere else)?

Docker image was deleted from Docker Hub

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

Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections

Start a commited container in another machine

I've a container running in a host and need save it to share with anothers. Follow my steps:

1. docker commit <my-container-id> <my-image-name>
2. docker save -o <my-image-name>.tar <my-image-name>
3. Copy the tar file to another host.
4. docker load -i <my-image-name>.tar
5. docker run -d -p 8080:8080 -p 1521:1521 <my-image-name>

But it does not works anymore. What is wrong?

После запуска долгое время загрузка 100%

в момент первого чистого запуска загрузка CPU 100% на задаче:
/u01/app/oracle/product/11.2.0/xe/bin/sqlplus -s @/u01/app/oracle/product/11.2.0/xe/config/scrip...

скорее всего идёт инициализация, но проверить статус не получается. На 1521 порт ни под SYS, ни под SYSTEM не заходит:

• SYS -- ORA-01017: invalid username/password; logon denied
• SYSDBA -- ORA-01031: insufficient privileges
• SYSTEM -- ORA-01031: insufficient privileges

можно как-то присоединиться к базе данных и проверить, что там действительно ещё идёт инициализация (целый час?), или же она повисла?

Failed to start Oracle Net Listener and Oracle Express Database

Using Docker for OS X looking at the logs it's failing to start Oracle Net Listener and Oracle Express Database

Can not access APEX remotely

Hi, after pulling and run your docker image. I'm able to access to apex in localhost (it returns 401). But when i mapped it in URL, it's return 502 bad gateway. I've tried to run exec dbms_xdb.setListenerLocalAccess (l_access => FALSE); but not working. You have any solutions ? Thanks in advanced.

set the environment variable CHARACTER_SET is not use

docker run -d -p 18080:8080 -p 1521:1521 --name oracle1 -v /docker/oracle/myoracle0:/u01/app/oracle -e CHARACTER_SET=ZHS16GBK sath89/oracle-xe-11g
then i exec sql
select * from nls_database_parameters ;
this results:

NLS_CHARACTERSET AL32UTF8

it's alaways 'AL32UTF8' not 'ZHS16GBK'

how can i change it?

custom DEFAULT_SYS_PASS in docker-compose ,but not effect

Hi
I'm use win10 OS.
docker version is:

1. docker version

Client:
 Version:      17.06.2-ce
 API version:  1.30
 Go version:   go1.8.3
 Git commit:   cec0b72
 Built:        Tue Sep  5 19:57:19 2017
 OS/Arch:      windows/amd64

Server:
 Version:      17.06.2-ce
 API version:  1.30 (minimum version 1.12)
 Go version:   go1.8.3
 Git commit:   cec0b72
 Built:        Tue Sep  5 19:59:19 2017
 OS/Arch:      linux/amd64
 Experimental: true

2. docker-compose version is:

docker-compose version 1.14.0, build c7bdf9e3
docker-py version: 2.3.0
CPython version: 2.7.13
OpenSSL version: OpenSSL 1.0.2j  26 Sep 2016

3. it is my docker-compose ：

version: '3.1'
services: 
 db: 
    image: sath89/oracle-xe-11g:latest
    ports: 
      - 8080:8080
      - 1521:1521
    volumes: 
      - D:/0_docker_home/docker_data/oracle/oracle:/u01/app/oracle
      
    # environment:  cannot use
    #   - DEFAULT_SYS_PASS: 123456

and i cannot custom my passwor 123456. can you give me some point , thanks.

How to update this to 11.2.0.4.0?

The current image is 11.2.0.2.0 and it looks like you have a set of files that are the result of running split on the .deb of the oracle installer file. Can you update it to 11.2.0.4.0? It would also be easy to add some tags to the docker hub images corresponding to the versions.

Thanks for this image, it's very useful!

Issue on Ubuntu 18.04

Hi @MaksymBilenko,

Thank you for creating this docker image, it is really useful for our testing!
I am using it on MacOS and Ubuntu 16.04 without any problems but it seems to have an issue I cannot resolve on Ubuntu 18.04.
When I start up the container everything seems to be fine, the docker logs gives the following:

Database not initialized. Initializing database.
Setting up:
processes=500
sessions=555
transactions=610
If you want to use different parameters set processes, sessions, transactions env variables and consider this formula:
processes=x
sessions=x*1.1+5
transactions=sessions*1.1

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express 
Edition.  The following questions will determine whether the database should 
be starting upon system boot, the ports it will use, and the passwords that 
will be used for database accounts.  Press <Enter> to accept the defaults. 
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of 
different passwords for each database account.  This can be done after 
initial configuration:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
Setting sys/system passwords
Database initialized. Please visit http://#containeer:8080/apex to proceed with configuration
Oracle Database 11g Express Edition instance is already started

Starting import scripts from '/docker-entrypoint-initdb.d':
/entrypoint.sh: line 108: /docker-entrypoint-initdb.d/.cache: No such file or directory
/entrypoint.sh: line 109: /docker-entrypoint-initdb.d/.cache: No such file or directory
/entrypoint.sh: line 110: /docker-entrypoint-initdb.d/.cache: No such file or directory
Import finished

Database ready to use. Enjoy! ;)

But when I try to connect to it I get this error:

Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections

Have you experienced a similar issue on your side as well?

Thanks,
Szabolcs

Data volume cannot be persisted

1., I found in the process of using the mirror in different hosts on the database will not be able to persistent problems, such as: Ubuntu 16.04, server version is good, but sometimes in centOS 7 sometimes wrong. I felt puzzled
2. there will be errors when starting Oracle: mv: cannot remove'/u01/app/oracle-product/11.2.0/xe/dbs': Directory not empty"

Can i ssh into this image?

Can i ssh into this image ?

ORA-01033

sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Fri Feb 2 05:45:30 2018

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

Enter user-name: sys
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

Enter user-name:

ORA-12547: TNS:lost contact

After configuring my db (tables, schemas etc) and generating a new image via docker commit i am not able to connect to the database when running a container from my new image.

I get a ORA-12547: TNS:lost contact , even if trying to connect as sysdba.

Any tips on that error ?

Updating Apex to Latest Version

Hi,

I just came across your image, which is quite awsome, i just wanted to know if it is possible to update apex to the latest version?

I'm kind of new to all this docker stuff, i tried updating directly from the terminal but i wasn't possible.

Hope you could help me

Thank you

couldn't start up oracle database after re-image

I run the following commands:
docker run -d -p 8080:8080 -p 1521:1521 sath89/oracle-xe-11g;
(The docker container id is ba8ad053939f)
docker commit -m "oracle xe" -a "anne" ba8ad053939f oracle/xe:v1 (without any changes)
(The new image id is 71a3e3a0569b )
docker tag 71a3e3a0569b test98/oracle-xe:latest
Then run the command that:
docker run -d -p 8081:8080 -p 1522:1521 test98/oracle-xe:latest.

But the oracle database failed to startup in the container which created by my new docker image 71a3e3a0569b,

Is there anything I need to pay attention to when recreating new image with your image file?

Thank you very much!

Impdp problems

Hi, everytime I execute an impdp command, its always saying that tablespace 'APEX1680444387356849' does not exist. I'm a total newbie at oracle databases and I don't have any idea about this. Can you help me?

Only when I use OCCI via VS to connect to Oracle can I fail ???

I have connected to db successfully within OJDBC/C#/sqlplus/PLSQL.
Only OCCI failed.
Why?

#include "stdafx.h"//including iostream and using std
#include <occi.h>
using namespace oracle::occi;
int main(){
	string usr = "system";
	string psw = "oracle";
//	string connect = "192.168.3.122:1521/XE";//one        //append double '/' result the same 
	string connect = "XE=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.122)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = XE)))";  
//remove XE= result the same 
	try
	{
		cout << "createEnvironment" << endl;
		Environment* env = Environment::createEnvironment();
		cout << "createConnection" << endl;
		Connection* con = env->createConnection(usr, psw, connect);
		/*codes*/
	}
	catch (SQLException e)
	{
		cout << e.what();
	}
	return 0;
}

results:

createEnvironment
createConnection
ORA-12154: TNS:could not resolve the connect identifier specified

if i use connectstring one,the third line would become
ORA-12154: TNS:could not resolve the connect identifier specified

I think the problem is in listner or tns file..
then I update the tnsnames.ora file and restart it
(lsnrctl stop //////(replace %hostname% to host_ip and replace %port% to 1521 ////// lsnrctl start)

it doesn't work...
I can still connect to it via JDBC/C#/sqlplus/PLSQL except OCCI

use sqlplus
sqlplus system/[email protected]:1521/XE
connect success.

it really puzzle me for a week and still cannot find a way to solve it .
So do I submit this issue.
Thanks.:pray:

Mounted datafile is not getting picked up by the database

HI,

When i run the container using this below command

docker run -d -p 8080:8080 -p 1521:1521 -v /Users/agaddale/Docker/ssue_oracle_db_files/dbf_files/SSUE:/u01/app/oracle -e processes=1000 -e sessions=1105 -e transactions=1215 sath89/oracle-xe-11g

I see that the instance XE is not using the database files that are there in the location '/Users/agaddale/Docker/ssue_oracle_db_files/dbf_files/SSUE'.

And hence i don't see my data objects in XE.

Can somebody tell what is that i am missing here.

Execute SQL on startup

Hi there,

I'd like to provide an initdb.sql script which will get run on startup of the database.

In my dockerfile, i'd like to do the following:
ADD initdb.sql /etc/entrypoint-initdb.d/initdb.sql

Is this something already supported, or that is possible to be supported in future?

It's something I have found works with the following image (at dockerhub): alexeiled/docker-oracle-xe-11g, but that doesn't support persistent data.

Thanks in advance for your help,
Ryan

DMP File Import Failed

I run the command below to start a container with a test.dmp file inside the sh_sql_dmp_files directory to get it auto import:

docker run -d --restart=always --name oracle -p 8080:8080 -p 1521:1521 -v /docker/oracle/data:/u01/app/oracle -v /docker/oracle/init/sh_sql_dmp_files:/docker-entrypoint-initdb.d sath89/oracle-xe-11g

Then I print the log:

Database not initialized. Initializing database.
Setting up:
processes=500
sessions=555
transactions=610
If you want to use different parameters set processes, sessions, transactions env variables and consider this formula:
processes=x
sessions=x*1.1+5
transactions=sessions*1.1

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
Setting sys/system passwords
Database initialized. Please visit http://#containeer:8080/apex to proceed with configuration
Oracle Database 11g Express Edition instance is already started

Starting import scripts from '/docker-entrypoint-initdb.d':
f337c90696eea6f432f25246383345ad  /docker-entrypoint-initdb.d/test.dmp
Import finished

Database ready to use. Enjoy! ;)

It seems that auto import is successful. When I connect the database to execute SQL select * from all_tables, however, none of the tables in test.dmp can be found. Also, the user credential for the import is not exist according to this guide:

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}

As the instructions and logs of auto import are limited, can anyone figure out what the problem is ?

How to use `/docker-entrypoint-initdb.d/*.sql`?

Hey, thank you for this image.

I'm trying to create a table with some test data by providing a file dump.sql in /docker-entrypoint-init.db/dump.sql but I don't see the table when connecting to the database in DataGrip. Here's what I'm doing:

Dockerfile:

FROM sath89/oracle-xe-11g
EXPOSE 1521
COPY dump.sql /docker-entrypoint-initdb.d/dump.sql

dump.sql:

CREATE TABLE inventory (name VARCHAR(20));
INSERT INTO inventory (name) VALUES ('Grandiosa');

Build command: docker build -t oracle11g-test .
Start command: docker run -d -p 1521:1521 oracle11g-test

Logs after starting:

Database not initialized. Initializing database.
Setting up:
processes=500
sessions=555
transactions=610
If you want to use different parameters set processes, sessions, transactions env variables and consider this formula:
processes=x
sessions=x*1.1+5
transactions=sessions*1.1

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
Setting sys/system passwords
Database initialized. Please visit http://#containeer:8080/apex to proceed with configuration
Oracle Database 11g Express Edition instance is already started

Starting import scripts from '/docker-entrypoint-initdb.d':
found file /docker-entrypoint-initdb.d/dump.sql
[IMPORT] /entrypoint.sh: running /docker-entrypoint-initdb.d/dump.sql

Table created.


1 row created.


Import finished

Database ready to use. Enjoy! ;)

What I see in DataGrip:

My question is this: How can I set this up so that I'll see my test table and data when connecting with DataGrip?

/docker-entrypoint-initdb.d/.cache: Not a directory

Just noticed the following output, if /docker-entrypoint-initdb.d is a file.

Starting import scripts from '/docker-entrypoint-initdb.d':
/entrypoint.sh: line 108: /docker-entrypoint-initdb.d/.cache: Not a directory
/entrypoint.sh: line 109: /docker-entrypoint-initdb.d/.cache: Not a directory
/entrypoint.sh: line 110: /docker-entrypoint-initdb.d/.cache: Not a directory

Can't start oracle

docker run -d --name oracle -p 8080:8080 -p 1521:1521 -v /opt/oracle/data:/u01/app/oracle sath89/oracle-xe-11g
b26a72b4f61d6f213e521bcd32b21b3b3a9ee5c8d8fa1d4f0503f6b2cdaf4d35
docker: Error response from daemon: driver failed programming external connectivity on endpoint oracle (cb1dff295208f321616513ba641ec8b6376486c64856c98cd9de3a1f5c10d61a): (iptables failed: iptables --wait -t nat -A DOCKER -p tcp -d 0/0 --dport 8080 -j DNAT --to-destination 172.17.0.4:8080 ! -i docker0: iptables: No chain/target/match by that name.
(exit status 1)).

“iptables --wait -t nat -A DOCKER -p tcp -d 0/0 --dport 8080 -j DNAT --to-destination 172.17.0.4:8080 ! -i docker0”
Can't do it ,don't match -A DOCKER
How can I run it?

unable to log in

unable to log into the url http://localhost:8080/apex using provided credentials .
message : "Invalid Login Credentials"

update SID and SYSTEM Password for oracle 11g

hi i want to update your image to new SID name system password .

tried committing the your image, and im having problems with connect to sid .

im new to this.
please guide me. thanks

Can't access Apex

After installation, I run the docker:

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

But can't access http://localhost:8080/apex

The error message is:

This page isn’t working
localhost didn’t send any data.
ERR_EMPTY_RESPONSE

Any idea? Thanks.

oracle table created and saved but records can't be saved after PC reboot

I run this script
docker run -d -p 8081:8080 -p 1521:1521 --restart=always -v /mypath/oracle:/u01/app/oracle sath89/oracle-xe-11g

I created a table

CREATE TABLE Boy (
  col int not null
);
INSERT INTO new_table (col) VALUES (23333);
SELECT *
FROM Boy;

docker run with option --restart=always.It seems nothing wrong but the table ramains while the records gone.
only to show

COL
---

ENV:
JDBC Tools:Jetbrains IDEA Database
OS: Deepin OS 15.4 (based on Debian8?)

How to run sqlplus while building a new image from yours

Hi.

First thanks for this (thin) docker image.

I want to make a Docker image that extends docker-oracle-xe-11g. Aditionally to your image i want my image to clone some scripts under one of my repos and finally I want to unlock HR account. I want to use that image for some experiments and it would be useful for to to have HR account unlocked on startup.

This is a link to my Dockerfile.

When i run the build this is the output (i remove all output related to git installation because it is irrelevant for this issue):

Step 0 : FROM sath89/oracle-xe-11g:latest
 ---> 2c83b63b204f
Step 1 : RUN apt-get -y update && apt-get install -y git
 ---> Running in e99099f080eb
 ...
 ---> 6497f6473194
Removing intermediate container e99099f080eb
Step 2 : RUN mkdir /u01/scripts
 ---> Running in ca8462b0aedc
 ---> abcbe836f3a6
Removing intermediate container ca8462b0aedc
Step 3 : RUN git clone https://github.com/SirRagnar/sqlPlusToolBox.git /u01/scripts
 ---> Running in 741e743e24af
Cloning into '/u01/scripts'...
 ---> f47c47a9f409
Removing intermediate container 741e743e24af
Step 4 : RUN mkdir /u01/scripts/init
 ---> Running in 5d4d3f2c9998
 ---> e8faa48ba9d1
Removing intermediate container 5d4d3f2c9998
Step 5 : COPY unlockhr.* /u01/scripts/init/
 ---> 2d2a3a1c2fbe
Removing intermediate container fcfa3eef7f01
Step 6 : RUN chmod +x /u01/scripts/init/unlockhr.sh
 ---> Running in cffd64bb3ed5
 ---> c98358edb596
Removing intermediate container cffd64bb3ed5
Step 7 : RUN /u01/scripts/init/unlockhr.sh
 ---> Running in 1640209aa3be
unlocking hr account
-su: /u01/app/oracle/product/11.2.0/xe/bin/sqlplus: No such file or directory

The shell script simply does this:

#!/bin/bash
echo unlocking hr account
/bin/su - oracle -c "$ORACLE_HOME/bin/sqlplus -S system/oracle @/u01/scripts/init/unlockhr.sql"

As you can see the build failed with /u01/app/oracle/product/11.2.0/xe/bin/sqlplus: No such file or directory.

It seems that because of the "ln -f" at the begining of your entrypoint the shell script is unable to find sqlplus. I've tryed to call sqlplus with a RUN with the same result.

It seems that while building the image the path `/u01/app/product' is unreacheable. I've started a container of your image and exec a bin/bash inside it and I've executed sqlplus normally without trouble.

Do you know how could i avoid this error?

Thanks in advance

Disable account auto locking

Thank you @MaksymBilenko for this really awesome Docker image. I never worked with an Oracle database, and it's really painful just to import a dump file, but thanks to your magic image, I'm able to do imports 👍.

Now, I have an issue to connect to the DB, and after a few tried I got the following error:

ORA-28000: the account is locked

It looks like it's possible to disable (or increase the amount of tries) the auto locking.

Could you please add this? (Maybe with an env variable to do it or not so that we can have the best of both worlds?)

Again: THANK YOU!

Errors on file creation

Hi, im facing several errors when trying to use the container with data persisted on the host. With this run command:

docker run -t -d -p 8080:8080 -p 1521:1521 -v /c/Users/USER/DATA/:/u01/app/oracle sath89/oracle-xe-11g

I get the following log:

https://gist.github.com/vertigo7x/0931117a5baa83b501a1f69dd6b5a50e

Not sure if the problem is related to the image or with docker.

Thanks in advance!

PS: Im using Windows 7 with docker-toolbox 1.11

PS2: Inspect file added to Gist: https://gist.github.com/vertigo7x/22bec10a9bc3e526e65953a6a6281dad

Oracle won't start if i use some command

Timezone configuration

Hello.

Is there any approach to set a timezone for the container?
I use this solution to set a timezone, but it does not work.

I try to link -v /etc/localtime:/etc/localtime into a container and it works. However, for Windows you don't have any /etc/localtime or /etc/timezone...

Is anybody know how to set the host time for container?

Thanks.

tnsnames.ora %hostname% and %port%

Hi, thanks for putting this docker image together. I have a problem with the tnsnames.ora file. I see it's setup with %hostname% and %port%. Is the tnsnames.ora file supposed to be automatically updated so these match the current host and port for Oracle? Is there a way to update this file every time the docker container is started?

Connection via sql developer to docker image on EC2 AWS

1521 port is open on security policy and mapped from docker
5bdf90c96f62 sath89/oracle-xe-11g "/entrypoint.sh " 21 minutes ago Up 21 minutes 0.0.0.0:1521->1521/tcp, 0.0.0.0:8010->8080/tcp

enable to connect via sqlplus inside the container, get connection timeout from sql developer

Change default sys/system password

Can the sys & system password be set in some of the configuration files or passed in as an env variable?

Mount Volume is not working

Hi,

I copied the Oracle directory(/u01/app/oracle) from an environment where XE is working fine into D:\data\oracle-xe

I ran the container with below command
docker run -d -p 8080:8080 -p 1521:1521 -v D:\data\oracle-xe:/u01/app/oracle sath89/oracle-xe-11g

I got the below error in the container startup logs
rm: cannot remove '/u01/app/oracle/product': Is a directory
ln: failed to create symbolic link '/u01/app/oracle/product/oracle-product': File exists

After that, it says "Database ready to use. Enjoy! ;)" but I couldn't able to connect to the Oracle XE it says "TNS listener does not currently know of SIS given in connect descriptor"

Any help would be much appreciated

Image deleted?

Hi,

It seems this image has been deleted from docker hub. Is this intentional?

Tag releases

Please could you tag releases in Dockerhub so that we can fix our build process to a known version of the container?

ORA-12547: TNS:lost contact

Hi,

I am getting this error, when i try to login to sqlplus

docker exec -it a673fd18addc bash
root@a673fd18addc:/# sqlplus system/oracle

SQL*Plus: Release 11.2.0.2.0 Production on Wed Feb 17 11:52:00 2016

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

ERROR:
ORA-12547: TNS:lost contact

Enter user-name:

ORA-01031: insufficient privileges

root@7aa0609ac215:/# sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Wed Jun 21 08:32:34 2017

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

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL>

can you help me?

lost Connection

Hi,
First off all, thanks for share your work.
Some times, when the oracles listener delays a litle bit more and the script starts tos import the *.sql files, we get a lost connection error.

I inserted a "sleep" instruction in the entrypoint.sh script to work around this, but I know you can do better.

thanks