semon40/oracle12c repository overview

# 根据镜像创建oracle容器
docker run -d  \
--privileged  \
--name oracle12c \
--restart=always \
-p 21521:1521 \ 
-e ORACLE_PWD=test1234  \
-v /opt/wks/docker-script/data-dir/listener.ora:/opt/oracle/product/12.2.0.1/dbhome_1/network/admin/listener.ora \
-v /opt/wks/docker-script/data-dir/tnsnames.ora:/opt/oracle/product/12.2.0.1/dbhome_1/network/admin/tnsnames.ora \
semon40/oracle12c:12.2.0.1-ee 

# 查看构建进度
docker logs oracle12c  日志中出现（Completed:    ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE）为创建完成

# 监听文件listener.ora  
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCLCDB)
      (ORACLE_HOME = /opt/oracle/product/12.2.0.1/dbhome_1)
  )
)
LISTENER =
(DESCRIPTION_LIST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
  )
)

DEDICATED_THROUGH_BROKER_LISTENER=ON
DIAG_ADR_ENABLED = off


# 连接文件tnsnames.ora 
ORCLCDB=localhost:1521/ORCLCDB
ORCLPDB1=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCLPDB1)
    )
  )

lsnrctl stop;

lsnrctl start;

ALTER system set db_recovery_file_dest_size = 50G;
shutdown immediate
startup mount
alter database archivelog;
alter database open;
archive log list