2024年5月2日,Oracle database 23AI发布带来了众多新特性,初步在docker上进行了安装体验。
0. 环境
CentOS Linux release 7.7.1908;
Docker version 26.1.1;
Oracle Database 23ai Free Release 23.4.0.24.05。
1. 检查docker为运行状态
[root@db23ai ~]# systemctl status docker● docker.service - Docker Application Container EngineLoaded: loaded (/usr/lib/systemd/system/docker.service; disabled; vendor preset: disabled)Active: inactive (dead)Docs: https://docs.docker.com[root@db23ai ~]# systemctl start docker[root@db23ai ~]# systemctl enable docker
2. 从官方拉取database 23ai镜像
拉取镜像:
[root@db23ai ~]# docker pull container-registry.oracle.com/database/free:latestlatest: Pulling from database/free6d6e36f7c9fb: Pull complete21def9023b6f: Pull complete5e7b2cfeb7fa: Pull completeb4a24759beff: Pull complete78bba54e9814: Pull complete716b489ad5ad: Pull completec23fd8c6cbee: Pull complete79dea26b3a5a: Pull complete5dfbcf799df3: Pull complete154719a62576: Pull completeDigest: sha256:83edd0756fda0e5faecc0fdf047814f0177d4224d7bf037e4900123ee3e08718Status: Downloaded newer image for container-registry.oracle.com/database/free:latestcontainer-registry.oracle.com/database/free:latest
查看镜像:
[root@db23ai ~]# docker image lsREPOSITORY TAG IMAGE ID CREATED SIZEcontainer-registry.oracle.com/database/free latest 7510f8869b04 9 days ago 8.7GB
3. 运行oracle
创建持久化目录:
[root@db23ai ~]# chmod -R 777 data
运行23AI:
[root@db23ai ~]# docker run -d --name db23ai-free -v data:/opt/oracle/oradata container-registry.oracle.com/database/free:latest3a6efd8cfa8a78defa62875b44804e663dcbb7723cc3d3adf5895469b3cdf724
--name指定容器名称,可自定义容器名称,如db23ai-free;
-v参数,指定持久化数据存储,/data:/opt/oracle/oradata表示将容器内的/opt/oracle/oradata路径映射到本地的/data目录下,容器停启后,数据仍然保留。
查看容器已经运行,监听为1521端口:
[root@db23ai ~]# docker psCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES3a6efd8cfa8a container-registry.oracle.com/database/free:latest "/bin/bash -c $ORACL…" 7 seconds ago Up 6 seconds (health: starting) 1521/tcp db23ai-free
4. 本地登录数据库
登录后,当前版本为23.4.0.24.05,免费开发、学习和运行。
[root@db23ai ~]# docker exec -it db23ai-free sqlplus as sysdbaSQL*Plus: Release 23.0.0.0.0 - Production on Sat May 4 15:00:18 2024Version 23.4.0.24.05Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for FreeVersion 23.4.0.24.05
默认有一个名为FREEPDB1的PDB:
SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO3 FREEPDB1 READ WRITE NO

通过简单安装Oracle database 23AI,小伙伴们快来尝鲜23AI新特性吧。
文章转载自rundba,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




