Public | Automated Build

Last pushed: a year ago
Short Description
Oracle Express Edition 10g R2 (10.2.0.1) 32-bit on Debian 7.0 Wheezy.
Full Description

docker-oracle-xe-10g

(based on the work done by Wei-Ming Wu wnameless@gmail.com on
wnameless/docker-oracle-xe-11g

Oracle Express Edition 10g Release 2 (10.2.0.1) 32-bit on Debian 7.0 Wheezy.

Installation

docker pull dkfi/docker-oracle-xe-10g

Run with 22, 1521 and 8080 ports opened:

docker run -d -p 49160:22 -p 49161:1521 -p 49162:8080 dkfi/docker-oracle-xe-10g

Connect database with following setting:

hostname: localhost
port: 49161
sid: xe
username: system
password: oracle

For example, connect to database with sqlplus:

sqlplus system/oracle@localhost:49161/xe

Password for SYS & SYSTEM

oracle

Login by SSH

ssh root@localhost -p 49160
password: admin

Login to web administrator on a browser:

http://localhost:49162/apex
Docker Pull Command
Owner
dkfi
Source Repository

Comments (7)
cytus
9 months ago

The problem "TNS:listener does not currently know of service requested in connect"
please use 'docker build .' from dockerfile in git Repository
and it works.

oforous
10 months ago

Image is running ok, but I cannot connect using sqlplus version 12.1 with the following error:

"TNS:listener does not currently know of service requested in connect"

Tried using sql developer but same error occured (tried with sid: xe and also service: xe

dkfi
a year ago

Strangely enough the image seems to work fine if built from the git repo. If I run the registry built version I also get the same error as you. I will look into it and apply the appropriate fixes.

lukaso
a year ago

For some reason, I can't get this to work.

It looks like the oracle service doesn't start or can't be accessed:
root@8a0844788803:~# cat /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 27-MAY-2016 22:12:28

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

Started with pid=964
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 01-JUN-2016 16:58:19

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

Started with pid=20
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=8a0844788803)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP CONNECT DATA [ PROTOCOL INFO] EVENT [ SID] RETURN CODE
01-JUN-2016 16:58:19
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=8a0844788803)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) status 0
01-JUN-2016 16:58:45 (CONNECT_DATA=(CID=(PROGRAM=)(HOST=8a0844788803)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) status 0
01-JUN-2016 17:00:12
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=8a0844788803)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) status 0
01-JUN-2016 17:00:15 (CONNECT_DATA=(CID=(PROGRAM=)(HOST=8a0844788803)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) status * 0

also

root@8a0844788803:~# ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 4200 468 ? Ss 16:58 0:00 /bin/sh -c sed -i -E "s/HOST = [^)]+/HOST = $HOSTNAME/g" /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora; service oracle-
oracle 20 0.0 0.2 21816 9064 ? Ss 16:58 0:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit
root 24 0.0 0.1 49960 5028 ? S 16:58 0:00 /usr/sbin/sshd -D
root 25 0.0 0.1 71300 5468 ? Rs 16:58 0:00 sshd: root@pts/0
root 27 0.0 0.0 17872 3048 pts/0 Ss 16:58 0:00 -bash
root 49 0.0 0.0 15328 1912 pts/0 R+ 17:00 0:00 ps aux

Don't know if you have any ideas.

Thanks.

lukaso
a year ago

The pull command under installation is also incorrect. The one on the right is correct however.

dkfi
2 years ago

Fixed it. Thank you @stephanieerin!

stephanieerin
2 years ago

Your install instructions have a typo, it's docker run -d -p 49160:22 -p 49161:1521 dkfi/docker-oracle-xe-10g instead of oracle-xe-10g.