Docker Oracle11g

1. docker pull wnameless/oracle-xe-11g

docker pull wnameless/oracle-xe-11g
Using default tag: latest
latest: Pulling from wnameless/oracle-xe-11g
a48c500ed24e: Pull complete
1e1de00ff7e1: Pull complete
0330ca45a200: Pull complete
471db38bcfbf: Pull complete
0b4aba487617: Pull complete
ae2e6e303543: Pull complete
e860d792de52: Pull complete
Digest: sha256:806c005a3d6af211e92b96015daaeefdcde53b7b6434d34353e620fb46ea7dad
Status: Downloaded newer image for wnameless/oracle-xe-11g:latest

root@debian:~# docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
centos6/fake latest d9791d553a78 21 hours ago 1.33GB
wnameless/oracle-xe-11g latest 698cc7361de4 7 months ago 2.13GB
alexeiled/docker-oracle-xe-11g latest f7304758169d 2 years ago 2.39GB

docker run -d -p 9090:8080 -p 1521:1521 -3222:22 –name Oracle11g wnameless/oracle-xe-11g

root@debian:~# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
c9a88cc47e3b wnameless/oracle-xe-11g “/bin/sh -c ‘/usr/sb…” 3 seconds ago Up 3 seconds 0.0.0.0:1521->1521/tcp, 0.0.0.0:3122->22/tcp, 0.0.0.0:9090->8080/tcp Oracle11g
9fb4edcca9f2 centos6/fake “/bin/bash” 21 hours ago Up 21 hours 0.0.0.0:2233->22/tcp, 0.0.0.0:8080->80/tcp, 0.0.0.0:3388->3306/tcp CentOS6-LAMP-WEB

root@debian:~# docker exec -ti c9a88cc47e3b bash

http://192.168.5.159:9090
username: ADMIN
password: Oracle_11g
or
username: system
password: oracle

1. vim /root/.profile
2. export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
3. export ORACLE_SID=hellooracle
4. export PATH=$PATH:$ORACLE_HOME/bin
5. source /root/.profile

su – oracle
sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 28 08:07:40 2018Copyright (c) 1982, 2011, Oracle. All rights reserved.

SQL> conn sys/sys as sysdba
Connected.

CREATE SMALLFILE TEMPORARY TABLESPACE “TS_MSG_TEMP” TEMPFILE ‘/u01/app/oracle/oradata/XE/TS_MSG_TEMP.dbf’ SIZE 1024M AUTOEXTEND ON NEXT 100M TABLESPACE GROUP “TS_MSG” EXTENT MANAGEMENT LOCAL UNIFORM;

CREATE SMALLFILE TABLESPACE “TS_MSG_D” DATAFILE ‘/u01/app/oracle/oradata/XE/TS_MSG_D.dbf’ SIZE 2048M AUTOEXTEND ON NEXT 100M LOGGING DEFAULT NOCOMPRESS ONLINE EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

create user USR_MSG IDENTIFIED BY asdf123123 default tablespace TS_MSG_D temporary tablespace TS_MSG_TEMP profile DEFAULT;

1. grant connect to USR_MSG;
2. grant dba to USR_MSG;
3. grant exp_full_database to USR_MSG;
4. grant imp_full_database to USR_MSG;
5. grant resource to USR_MSG;
6. — Grant/Revoke system privileges
7. grant select any table to USR_MSG;
8. grant unlimited tablespace to USR_MSG;
9. grant update any table to USR_MSG;

SQL> select instance_name from v$instance;

INSTANCE_NAME
—————-
XE