docker 安装oracle12c_docker安装oracle12 c

作者：煮酒与君饮 | 2024-07-31 00:40:45

踩

docker安装oracle12 c

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

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.

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/煮酒与君饮/article/detail/906123