在centos7上使用Docker安装oracle 11g

如果还没安装docker，可查看

1、拉取 docker 镜像：

[root@localhost ~]# docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
Using default tag: latest
latest: Pulling from helowin/oracle_11g
ed5542b8e0e1: Pull complete 
a3ed95caeb02: Pull complete 
1e8f80d0799e: Pull complete 
Digest: sha256:4c12b98372dfcbaafcd9564a37c8d91456090a5c6fb07a4ec18270c9d9ef9726
Status: Downloaded newer image for registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g:latest

该镜像由阿里云提供，比较大，可能需要下载一会

等待下载即可……

2、用 docker images 命令查看镜像

[root@localhost ~]# docker images
REPOSITORY                                             TAG                 IMAGE ID            CREATED             SIZE
registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g   latest              3fa112fd3642        3 years ago         6.85GB

运行镜像

docker run -d -p 1521:1521 --name oracle registry.aliyuncs.com/helowin/oracle_11g

3、进入容器修改账号密码

3.1，检查容器是否运行成功

[root@localhost ~]# docker ps
CONTAINER ID        IMAGE                                      COMMAND                  CREATED              STATUS              PORTS                    NAMES
a151f9478f94        registry.aliyuncs.com/helowin/oracle_11g   "/bin/sh -c /home/o…"   About a minute ago   Up 30 seconds       0.0.0.0:1521->1521/tcp   oracle

启动oracle

[root@localhost ~]# docker start oracle

3.2，进入容器：docker exec -it oracle bash

[root@localhost ~]# docker exec -it oracle bash
[oracle@a151f9478f94 /]$

3.3，切换回root用户

[oracle@a151f9478f94 /]$ exit
exit
[root@localhost ~]#

3.4，编辑环境变量 vi /etc/profile 在文件的末尾添加一下内容

export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2

export ORACLE_SID=helowin

export PATH=$ORACLE_HOME/bin:$PATH

（注意：按i进入编辑模式，输入上述命令后，按ESC键退出编辑模式，再输入:wq保存退出）

3.6，使得修改生效：

[root@localhost ~]# source /etc/profile

3.7，进入容器（此处的id就是第一个命令下的id），加载一下用户环境变量，进入容器后，自动是oracle用户

[root@localhost ~]# docker ps
CONTAINER ID        IMAGE                                      COMMAND                  CREATED             STATUS              PORTS                    NAMES
a151f9478f94        registry.aliyuncs.com/helowin/oracle_11g   "/bin/sh -c /home/o…"   3 hours ago         Up 3 hours          0.0.0.0:1521->1521/tcp   oracle

[root@localhost ~]# docker exec -it a151f9478f94 /bin/bash
[oracle@a151f9478f94 /]$ source ~/.bash_profile

[oracle@a151f9478f94 /]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 4 14:44:44 2019
Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as  sysdba                                ## 使用sysdba 连接oracle，最大权限，os认证，只能在本机上登陆使用。
Connected.
SQL> alter user system identified by system;          ## 修改用户 system 的密码为 oracle ，可以自定义
User altered.
SQL> alter user sys identified by sys;
User altered.
SQL> create user ETS identified by ETS;
User created.
SQL> grant connect,resource,dba to ETS ;
Grant succeeded.

SQL> exit      ##退出编辑SQL
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@a151f9478f94 /]$ exit    ##回到root用户
exit
[root@localhost ~]#

4.连接 账号system密码system服务名helowin

用Navicat连接

用plsql连接

为方便plsql连接，可在本地instantclient_11_2配置tnsnames.ora文件

LS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.116.129)(PORT = 1521))
    )
    (CONNECT_DATA =
       (SERVER = DEDICATED)
      (SERVICE_NAME = helowin)

    )
  )