Sign inSign up

wangbangming/oracle12c

By wangbangming

•Updated over 4 years ago

Oracle DataBase 12.2.0.1-ee

Image
3

1.8K

wangbangming/oracle12c repository overview

⁠Oracle DataBase 12.2.0.1-ee

镜像使用oracle-linux + oracle官网提供的linuxx64_12201_database.zip安装包构建

使用方法：

⁠1. 下载镜像

docker pull wangbangming/oracle12c:12.2.0.1-ee

⁠2. 创建容器

根据镜像创建oracle容器
docker run -d --privileged --name oracle12c --restart=always -p 1521:1521 -e ORACLE_PWD=test1234 wangbangming/oracle12c:12.2.0.1-ee

查看容器创建进度，出现（Completed:    ALTER PLUGGABLE DATABASE ORCLPDB1 SAVE STATE）为创建完成
docker logs oracle12c

⁠3. 安装vim插件

非必要可以不装，oracle-linux基础镜像没有编辑工具，需要自己安装

docker exec -it -u root oracle12c bash;

yum install vim

安装完成后退出容器

⁠4. 进入容器，登陆数据库

docker exec -it oracle12c bash

sqlplus sys/test1234@//localhost:1521/ORCLCDB as sysdba

⁠5. 修改数据库监听文件

由于当前配置未监听数据库mount启动，需先修改数据库配置文件

  • 进入配置文件目录

cd /opt/oracle/product/12.2.0.1/dbhome_1/network/admin/

  • 修改 listener.ora 和 tnsnames.ora （如下）

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)
    )
  )
  • 修改后重启oracle

lsnrctl stop;

lsnrctl start;

⁠6. 开启归档日志

非必需，如若要记录数据库数据变化，可开启归档日志

  • 查看归档日志是否开启，Enable未开启状态，Disable为未开启状态

archive log list

  • 开启归档日志
ALTER system set db_recovery_file_dest_size = 50G;
shutdown immediate
startup mount
alter database archivelog;
alter database open;
archive log list

Tag summary

Content type

Image

Digest

Size

2.6 GB

Last updated

over 4 years ago

docker pull wangbangming/oracle12c:12.2.0.1-ee