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. 