为了简单快速的在ubuntu下面安装一个测试oracle，选择试用docker进行安装

下载oracle11g安装包

下载oracle11g安装包

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#11g

解压oracle11g安装包

使用uzip解压到安装目录/opt/oracle下面

1sun@sun-system:/opt/oracle$ pwd
2/opt/oracle
3sun@sun-system:/opt/oracle$ ls
4database

获取jaspeen/oracle-11g镜像

查找镜像

1sun@sun-system:/opt/oracle$ sudo docker search oracle
2NAME                                  DESCRIPTION                                     STARS               OFFICIAL            AUTOMATED
3oraclelinux                           Official Docker builds of Oracle Linux.         631                 [OK]                
4jaspeen/oracle-11g                    Docker image for Oracle 11g database            148                                     [OK]
5oracleinanutshell/oracle-xe-11g                                                       83                                      
6oracle/openjdk                        Docker images containing OpenJDK Oracle Linux   60                                      [OK]
7oracle/graalvm-ce                     GraalVM Community Edition Official Image        57                                      [OK]

获取镜像

1sudo docker pull jaspeen/oracle-11g
2
3sun@sun-system:/opt/oracle$ sudo docker images
4REPOSITORY           TAG                 IMAGE ID            CREATED             SIZE
5jaspeen/oracle-11g   latest              0c8711fe4f0f        4 years ago         281MB

安装oracle11g

1sun@sun-system:/opt/oracle/database/install$ sudo docker run --privileged --name oracle11g -p 1521:1521 -v /opt/oracle:/install jaspeen/oracle-11g
2Database is not installed. Installing...
3Installing Oracle Database 11g
4Starting Oracle Universal Installer...
5
6Checking Temp space: must be greater than 120 MB.   Actual 410593 MB    Passed
7Checking swap space: must be greater than 150 MB.   Actual 8170 MB    Passed
8Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-02-21_03-53-10AM. Please wait ...You can find the log of this install session at:
9
10
11sudo docker run --privileged --name oracle11g -p 1521:1521 -v /opt/oracle:/install jaspeen/oracle-11g

• run 启动容器
• privileged 给这个容器root特权
• name 容器名称
• p 主机端口映射容器端口（主机1521端口映射容器1521端口）
• v 主机目录挂载到容器目录（主机/opt/oracle挂载到容器/install目录）
• jaspeen/oracle-11g 代表镜像jaspeen/oracle-11g的容器

等待一段时间安装完成

1sun@sun-system:/opt/oracle$ sudo docker ps -a
2CONTAINER ID        IMAGE                COMMAND                  CREATED             STATUS              PORTS                              NAMES
3194bc8439080        jaspeen/oracle-11g   "/assets/entrypoint.…"   31 minutes ago      Up 31 minutes       0.0.0.0:1521->1521/tcp, 8080/tcp   oracle11g

进入oracle11g容器配置oracle

进入oracle11g容器

1sun@sun-system:/opt/oracle$ sudo docker exec -it oracle11g /bin/bash
2[root@194bc8439080 /]#

切换为oracle用户

1[root@194bc8439080 /]# su - oracle
2Last login: Fri Feb 21 04:00:47 UTC 2020
3[oracle@194bc8439080 ~]$

登陆oracle数据库

1[oracle@194bc8439080 ~]$ sqlplus / as sysdba
2
3SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 21 04:25:59 2020
4
5Copyright (c) 1982, 2009, Oracle.  All rights reserved.
6
7
8Connected to:
9Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
10With the Partitioning, OLAP, Data Mining and Real Application Testing options
11
12SQL> 

解锁演示用户scott

1SQL> alter user scott account unlock;
2
3User altered.
4
5SQL> commit;
6
7Commit complete.
8
9SQL>

设置演示用户scott密码

1SQL> conn scott/tiger
2ERROR:
3ORA-28001: the password has expired
4
5
6Changing password for scott
7New password: 
8Retype new password: 
9Password changed
10Connected.
11SQL>

使用Navicat登陆oracle

Docker中创建表空间用户

• 登陆docker

• 创建表空间目录

• 修改表空间目录为oracle（为docker中用户）

• 切换oracle目录

• 超管连接登陆数据库

• 创建表空间

• 创建用户

• 赋予用户权限

  sun@sun_server:~$ sudo docker exec -it oracle11g /bin/bash [root@ef805f9c01c5 /]# mkdir /install/jiangtongindex [root@ef805f9c01c5 /]# chown oracle /install/jiangtongindex [root@ef805f9c01c5 /]# su - oracle [oracle@ef805f9c01c5 ~]$ sqlplus / as sysdba

  SQL> create temporary tablespace JIANGTONGJINDEX_TMP tempfile '/install/jiangtongindex/jiangtongindex_tmp.dbf' size 50m autoextend on next 50m maxsize 10240m extent management local;

  Tablespace created.

  SQL> create tablespace JIANGTONGJINDEX datafile '/install/jiangtongindex/jiangtongindex.dbf' size 50m autoextend on next 50m maxsize 10240m extent management local;

  Tablespace created.

  SQL> create user jiangtongindex identified by xxxxx default tablespace JIANGTONGJINDEX temporary tablespace JIANGTONGJINDEX_TMP;

  User created.

  SQL> grant connect,resource,dba to jiangtongindex;

  Grant succeeded.

  SQL>