Docker安装oralce

XingYuyu_Coder

已于 2024-10-30 13:09:02 修改

阅读量4.2k

点赞数 4

文章标签： docker 容器 oracle

于 2024-05-10 15:14:18 首次发布

XingYuyu—本文版权归作者所有，欢迎转载，但必须给出原文链接，并保留此段声明，否则保留追究法律责任的权利。

本文链接：https://blog.youkuaiyun.com/m0_60758951/article/details/138667533

版权

Docker安装oralce

1.部署Oracle 11G企业版环境（11.2.0.4)

# 1.前提是安装好docker

# 2.拉取镜像(该镜像是我修改过的，可以直接使用)
[root@api-new local]# docker pull xingyuyu123/oracle:oracle11204
oracle11204: Pulling from xingyuyu123/oracle
5dd797628260: Pull complete 
ea1a739ab78d: Pull complete 
593d06e585fc: Pull complete 
12ad75124c46: Pull complete 
edfb37612170: Pull complete 
ad7a03f14bef: Pull complete 
Digest: sha256:a597bdb0523ffb4cf3cee677269f8dba5555d38441f1e819fed06a1c845c0c7e
Status: Downloaded newer image for xingyuyu123/oracle:oracle11204
docker.io/xingyuyu123/oracle:oracle11204
[root@api-new local]#

[root@api-new local]# docker images
REPOSITORY           TAG           IMAGE ID       CREATED          SIZE
xingyuyu123/oracle   oracle11204   1a15bc19ad81   42 minutes ago   13.5GB
[root@api-new local]# 

[root@api-new local]# docker run -itd --name oracle11204 -h oracle11204 --privileged=true -p 1521:1521 -p 222:22 -p 21158:1158 xingyuyu123/oracle:oracle11204 init
697f19ec9a768211a85afd958ab0a8b3fd7ea8c6aef860979f555c7e2f3ebbdc
[root@api-new local]#

[root@api-new local]# docker ps
CONTAINER ID   IMAGE                            COMMAND   CREATED          STATUS          PORTS                                                                                                                         NAMES
697f19ec9a76   xingyuyu123/oracle:oracle11204   "init"    34 seconds ago   Up 31 seconds   0.0.0.0:1521->1521/tcp, :::1521->1521/tcp, 0.0.0.0:222->22/tcp, :::222->22/tcp, 0.0.0.0:21158->1158/tcp, :::21158->1158/tcp   oracle11204
[root@api-new local]#

#服务名：orcl或者JEM11GR2
#sys密码：sys/system
#root用户密码：root
#oracle用户密码：oracle

# 拉取失败，提示Error response from daemon: Get "https://registry-1.docker.io/v2/": net/http: request canceled while waiting for connection (Client.Timeo
vim /etc/docker/daemon.json
{
  "registry-mirrors": ["https://docker.registry.cyou",
  "https://docker-cf.registry.cyou",
  "https://dockercf.jsdelivr.fyi",
  "https://docker.jsdelivr.fyi",
  "https://dockertest.jsdelivr.fyi",
  "https://mirror.aliyuncs.com",
  "https://dockerproxy.com",
  "https://mirror.baidubce.com",
  "https://docker.m.daocloud.io",
  "https://docker.nju.edu.cn",
  "https://docker.mirrors.sjtug.sjtu.edu.cn",
  "https://docker.mirrors.ustc.edu.cn",
  "https://mirror.iscas.ac.cn",
  "https://docker.rainbond.cc"]
  }

systemctl daemon-reload
systemctl restart docker

vim /etc/resolv.conf
nameserver 114.114.114.114
nameserver 8.8.8.8
nameserver 8.8.4.4

1.1 拉取镜像

# 1.下面是拉取一个镜像该如何配置成上面那样的
docker pull registry.cn-shanghai.aliyuncs.com/techerwang/oracle:ora11g11204
# 2.重新打tag
docker tag registry.cn-shanghai.aliyuncs.com/techerwang/oracle:ora11g11204 jemora11g:11204

1.2 创建容器

#创建容器
docker run -itd --name jemora11204 -h jemora11204 \
--privileged=true -p 21521:1521 -p 222:22  -p 21158:1158 \
jemora11g:11204 init
#这里要说明的是：这里给容器起的名字就是jemora11204，容器里面listener.ora和tnsnames.ora文件里面的host也是这个，如果不一致的话将报错，无法启动listener

1.3 进入容器

#进入容器
docker exec -it jemora11204 bash

1.4 启动数据库和监听

[root@jemora11204 /]# su - oracle
[oracle@jemora11204 ~]$ lsnrctl start
[oracle@jemora11204 ~]$ sqlplus / as sysdba
SYS@JEM11G2> startup
SYS@JEM11G2> select * from v$version;

1.5 外部连接容器内的数据库

sqlplus sys/jem@192.168.1.54:21521/JEM11GR2 AS SYSDBA
注意：此处访问宿主机端口为21521，容器内部是1521，端口映射,系统管理员密码为jem

1.6 修改配置


docker run -itd --name oracle11204 -h oracle11204 --privileged=true -p 1521:1521 -p 222:22 -p 21158:1158 xingyuyu123/oracle:oracle11204 init
#那么现在的容器名称就是oracle11204,但是配置文件不是需要修改

[root@api-new local]# docker ps
CONTAINER ID   IMAGE                            COMMAND   CREATED          STATUS          PORTS                                                                                                                         NAMES
697f19ec9a76   xingyuyu123/oracle:oracle11204   "init"    21 minutes ago   Up 21 minutes   0.0.0.0:1521->1521/tcp, :::1521->1521/tcp, 0.0.0.0:222->22/tcp, :::222->22/tcp, 0.0.0.0:21158->1158/tcp, :::21158->1158/tcp   oracle11204
[root@api-new local]# 

#进入容器
docker exec -it oracle11204 bash

# 修改root以及oralce口令
echo root | passwd root --stdin
echo oracle | passwd oracle --stdin

# 修改主机名
su - oracle

#修改listener.ora(将HOST后面修改为容器名称)
vim /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle11204)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

#修改tnsnames.ora(将HOST后面修改为容器名称)，这里的orcl是已经修改过的服务名
vim /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/tnsnames.ora
orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle11204)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      #(SERVICE_NAME = JEM11GR2)
      (SERVICE_NAME = orcl)
    )
  )
  
#修改服务名
sqlplus / as sysdba或者sqlplus sys/jem as sysdba
#查看当前服务名
show parameter service_name
#修改服务名
alter system set service_names='orcl' scope=both;
#修改tnsnames.ora(将HOST后面修改为容器名称)，这里的orcl是已经修改过的服务名
vim /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/tnsnames.ora
orcl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle11204)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      #(SERVICE_NAME = JEM11GR2)
      (SERVICE_NAME = orcl)
    )
  )
#修改两处

#修改sys密码
ALTER USER sys IDENTIFIED BY system;
#验证密码是否修改成功
exit
sqlplus sys/new_password as sysdba

1.7 数据库密码过期的方法

select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
#显示结果是密码的生命周期是180天。
若要将其设置为生命周期无限制可以执行下面语句：
alter profile default  limit password_life_time unlimited;
commit;
#进行以上步骤之后需要改变密码，否则还会出现password has expired异常
#改变密码的命令
alter user XXXUSER identified by yourPassword;  
#如果账号被锁住，则需要解锁命令
alter user XXXUSER identified by oracle account unlock;

2.部署Oracle 12CR2环境（12.2.0.1)

docker pull registry.cn-shanghai.aliyuncs.com/techerwang/oracle:ora12c_12201

#docker tag  registry.cn-shanghai.aliyuncs.com/techerwang/oracle:ora12c_12201 oracle:oracle12201

docker tag registry.cn-shanghai.aliyuncs.com/techerwang/oracle:ora12c_12201 jemora12c:12201

#docker run -itd --name oracle12201 -h oracle12201 --privileged=true -p 1521:1521 -p 422:22 -p 15500:5500 -p 15501:5501 oracle:oracle12201 init

docker run -itd --name jemora1221 -h jemora1221 --privileged=true -p 41521:1521 -p 422:22 -p 15500:5500 -p 15501:5501 jemora12c:12201 init

docker exec -it jemora1221 bash

su - oracle

lsnrctl start

sqlplus / as sysdba

startup

select * from v$version;

默认服务名：jem sys/jem

# 1.前提是安装好docker

# 2.拉取镜像(该镜像是我修改过的，可以直接使用)
[root@api-new local]# docker pull xingyuyu123/oracle:oracle12201
oracle11204: Pulling from xingyuyu123/oracle
5dd797628260: Pull complete 
ea1a739ab78d: Pull complete 
593d06e585fc: Pull complete 
12ad75124c46: Pull complete 
edfb37612170: Pull complete 
ad7a03f14bef: Pull complete 
Digest: sha256:a597bdb0523ffb4cf3cee677269f8dba5555d38441f1e819fed06a1c845c0c7e
Status: Downloaded newer image for xingyuyu123/oracle:oracle12201
docker.io/xingyuyu123/oracle:oracle12201
[root@api-new local]#

[root@api-new local]# docker images


[root@api-new local]# docker run -itd --name oracle12201 -h oracle12201 --privileged=true -p 1522:1521 -p 222:22 -p 21158:1158 xingyuyu123/oracle:oracle12201 init
697f19ec9a768211a85afd958ab0a8b3fd7ea8c6aef860979f555c7e2f3ebbdc
[root@api-new local]#

[root@api-new local]# docker ps


#服务名：orcl或者jem
#sys密码：sys/system
#root用户密码：root
#oracle用户密码：oracle

# Tomcat配置连接
-- Multitenant Environment：多租户环境
-- CDB（Container Database）：数据库容器
-- PDB（Pluggable Database）：可插拔数据库
-- COMMON USERS(普通用户)：经常建立在CDB层，用户名以C##或c##开头；
--  LOCAL USERS(本地用户)：仅建立在PDB层，建立的时候得指定CONTAINER。
SELECT * FROM v$version;
select sys_context ('USERENV', 'CON_NAME') from dual;
-- Oracle 12当中指定容器才能创建用户；查看容器
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
-- 打开pdb
alter pluggable database JEMPDB open;
-- 查看容器
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
-- 切换容器
alter session set container=JEMPDB;
-- 查看当前使用容器
select sys_context ('USERENV', 'CON_NAME') from dual; 
-- 创建用户
create user jkzl IDENTIFIED BY 123456;
SELECT username FROM dba_users;

ALTER SESSION SET container=JEMPDB;
SELECT username FROM dba_users;

select INSTANCE_NAME from v$instance;

#Oracle12连接方式
    <dataSource>
        <property name="driverClassName" value="oracle.jdbc.OracleDriver"></property>
        <property name="url" value="jdbc:oracle:thin:@192.168.124.224:1522/JEMPDB"></property>
        <property name="username" value="JKZL"></property>
        <property name="password" value="123456"></property>
        <property name="initSize" value="50"></property> <!--初始化连接池个数-->
        <property name="maxIdle" value="50"></property> <!--最大个数-->
        <property name="minIdle" value="20"></property> <!--最小个数-->
        <property name="maxWait" value="6000"></property> <!--连接超时时间-->
    </dataSource>

#Oracle11连接方式
    <dataSource>
        <property name="driverClassName" value="oracle.jdbc.OracleDriver"></property>
        <property name="url" value="jdbc:oracle:thin:@192.168.124.224:1521:JEM11GR2"></property>
        <property name="username" value="JKZL"></property>
        <property name="password" value="123456"></property>
        <property name="initSize" value="50"></property> <!--初始化连接池个数-->
        <property name="maxIdle" value="50"></property> <!--最大个数-->
        <property name="minIdle" value="20"></property> <!--最小个数-->
        <property name="maxWait" value="6000"></property> <!--连接超时时间-->
    </dataSource>
    
    
    #oracle11的服务名或者sid是JEM11GR2
    #oracle12的服务名或者sid是jem,容器的名是JEMPDB，必须先在容器当中创建本地用户才行，否则使用普通用户。