docker 安装oracle12c

1.  docker search oracle

2. docker pull truevoly/oracle-12c

3. docker images

4. docker run -d --name oracle_hj -p 9080:8080 -p 1521:1521 -v E:\docker-data\oracle:/u01/app/oracle truevoly/oracle-12c:latest

5. 查看启动日志docker logs -f 94b4a550948d

Database ready to use. Enjoy! ;)启动成功

6. 进入容器docker exec -it 94b4a550948d /bin/bash

7.连接sqlplus

su oracle

$ORACLE_HOME/bin/sqlplus / as sysdba

//设置密码有效期为无限制 SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

SQL> alter user SYSTEM account unlock;

User altered.
//创建一个账号为test 的用户密码设置为test
SQL> create user test identified by test ;     

User created.
//为这个用户赋予管理员的权限
SQL> grant dba to test ;

Grant succeeded.

hostname:docker所在宿主机的ip

port:1521

username1:system

password:oracle

username2:test

password:test

sid:xe 

8. 使用pl/SQL连接数据库

选择安装好的oracle client

9. 修改tnsnames.ora

D:\app\Administrator\product\11.2.0\client_1\network\admin

localHj =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = xe)
    )
  )
10.