运行在容器中的Oracle XE-11g

docker run -d            -p 38080:8080 -p 31521:1521     -e DEFAULT_SYS_PASS=liumiaocn    -e processes=500          -e sessions=555           -e transactions=611         --name oracle-11g          liumiaocn/oracle:11.2.0

[root@liumiaocn ~]# docker run -d            > -p 38080:8080 -p 31521:1521     > -e DEFAULT_SYS_PASS=liumiaocn    > -e processes=500          > -e sessions=555           > -e transactions=611         > --name oracle-11g          > liumiaocn/oracle:11.2.0
f66b569769e6ba7eacf57b141afccc76cef973f3da3c6a79557c98e5d4727c2b
[root@liumiaocn ~]#

[root@liumiaocn ~]# docker exec -it oracle-11g sh
# su - oracle
oracle@32d01719b30a:~$ sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 11 15:01:15 2018
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION  STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS  SHU DATABASE_STATUS INSTANCE_ROLE   ACTIVE_ST BLO EDITION
---------- --- ----------------- ------------------ --------- --- -------
    1 XE
32d01719b30a
11.2.0.2.0  11-SEP-18 OPEN NO    1 STOPPED
ALLOWED  NO ACTIVE  PRIMARY_INSTANCE  NORMAL  NO XE
SQL>

SQL> conn /as sysdba
Connected.
SQL> show parameter processes
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes    integer 0
db_writer_processes    integer 1
gcs_server_processes    integer 0
global_txn_processes    integer 1
job_queue_processes    integer 500
log_archive_max_processes   integer 4
processes    integer 500
SQL> show parameter sessions
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size   integer 0
java_soft_sessionspace_limit   integer 0
license_max_sessions    integer 0
license_sessions_warning   integer 0
sessions    integer 772
shared_server_sessions    integer
SQL> show parameter transactions
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
transactions    integer 611
transactions_per_rollback_segment  integer 5
SQL>