Sign inSign up

wangbangming/oracle11g

By wangbangming

Updated over 4 years ago

Oracle 11g DataBase

Image
4

1.5K

wangbangming/oracle11g repository overview

Oracle DataBase 11.2.0.1.0

使用方法

1. 下载Docker镜像

docker pull wangbangming/oracle11g:11.2.0.1.0

2. 根据镜像创建容器

docker run -d --privileged --name oracle11g --restart=always -p 1521:1521 -e DEFAULT_SYS_PASS=test1234 wangbangming/oracle11g:11.2.0.1.0

3. 创建账号

  • 进入容器,切换至oracle用户,连接数据库

docker exec -it -u oracle oracle11g /bin/bash

sqlplus /nolog

conn /as sysdba

  • 创建工作空间

CREATE TABLESPACE TEST DATAFILE '/opt/oracle/app/oradata/orcl/test.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

  • 创建用户

CREATE USER TEST IDENTIFIED BY test1234 DEFAULT TABLESPACE TEST QUOTA UNLIMITED ON TEST;

4. 开启归档日志

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

  • 查看归档日志是否开启,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.4 GB

Last updated

over 4 years ago

docker pull wangbangming/oracle11g:11.2.0.1.0