暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

0200.O docker运行Oracle Database 23ai Free

rundba 2024-05-04
90

  

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 Engine
    Loaded: 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:latest
      latest: Pulling from database/free
      6d6e36f7c9fb: Pull complete
      21def9023b6f: Pull complete
      5e7b2cfeb7fa: Pull complete
      b4a24759beff: Pull complete
      78bba54e9814: Pull complete
      716b489ad5ad: Pull complete
      c23fd8c6cbee: Pull complete
      79dea26b3a5a: Pull complete
      5dfbcf799df3: Pull complete
      154719a62576: Pull complete
      Digest: sha256:83edd0756fda0e5faecc0fdf047814f0177d4224d7bf037e4900123ee3e08718
      Status: Downloaded newer image for container-registry.oracle.com/database/free:latest
      container-registry.oracle.com/database/free:latest

      查看镜像:

        [root@db23ai ~]# docker image ls
        REPOSITORY TAG IMAGE ID CREATED SIZE
        container-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:latest
            3a6efd8cfa8a78defa62875b44804e663dcbb7723cc3d3adf5895469b3cdf724

            --name指定容器名称,可自定义容器名称,如db23ai-free;

            -v数,指定持久化数据存储,/data:/opt/oracle/oradata表示将容器内的/opt/oracle/oradata路径映射到本地的/data目录下,容器停启后,数据仍然保留。

            查看容器已经运行,监听为1521端口:

              [root@db23ai ~]# docker ps
              CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
              3a6efd8cfa8a 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 sysdba


                SQL*Plus: Release 23.0.0.0.0 - Production on Sat May 4 15:00:18 2024
                Version 23.4.0.24.05


                Copyright (c) 1982, 2024, Oracle. All rights reserved.


                Connected to:
                Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
                Version 23.4.0.24.05

                默认有一个名为FREEPDB1的PDB:

                  SQL> show pdbs;


                  CON_ID CON_NAME OPEN MODE RESTRICTED
                  ---------- ------------------------------ ---------- ----------
                  2 PDB$SEED READ ONLY NO
                  3 FREEPDB1 READ WRITE NO

                   

                  通过简单安装Oracle database 23AI,小伙伴们快来尝鲜23AI新特性吧。


                  文章转载自rundba,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

                  评论