当前位置:   article > 正文

Docker 运行 Oracle Database Free Release 23c (23.2.0.0)_oracle database 23c docker

oracle database 23c docker


Oracle Database 23c Free 是关系数据库服务器的开发者版本,此映像包含具有一个 PDB 的多租户配置中的默认数据库。

通过 Docker 运行 Oracle Database Free Release 23c

创建挂载路径,请根据各自环境修改,

sudo mkdir -p /u01/data/oracledb && sudo chown oracle:oracle /u01/data/oracledb && sudo chmod 777 /u01/data/oracledb
  • 1

运行 Oracle Database Free Release 23c,

docker run --name oracledb23c --restart=always \
-p 1521:1521 \
-e ORACLE_PWD=<your database passwords> \
-v /u01/data/oracledb:/opt/oracle/oradata \
-d container-registry.oracle.com/database/free:latest
  • 1
  • 2
  • 3
  • 4
  • 5

注意:Oracle 建议输入的密码应该至少有8个字符的长度,至少包含1个大写字母,1个小写字母和1个数字[0-9]。SYS、SYSTEM和PDBADMIN账户将使用同一个密码。

查看安装日志,

docker logs oracledb23c -f

--- output
(略)
Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
The Oracle base remains unchanged with value /opt/oracle
The Oracle base remains unchanged with value /opt/oracle
#########################
DATABASE IS READY TO USE!
#########################
The following output is now a tail of the alert.log:

XDB initialized.
ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
Completed: ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
2023-04-08T01:36:03.608797+00:00
ALTER SYSTEM SET control_files='/opt/oracle/oradata/FREE/control01.ctl' SCOPE=SPFILE;
2023-04-08T01:36:03.625859+00:00
ALTER SYSTEM SET local_listener='' SCOPE=BOTH;
ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
Completed: ALTER PLUGGABLE DATABASE FREEPDB1 SAVE STATE
---
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23

从容器内连接

docker exec -it oracledb23c sqlplus / as sysdba
  • 1

在这里插入图片描述

docker exec -it oracledb23c sqlplus sys/<your_password>@FREE as sysdba
  • 1

在这里插入图片描述

docker exec -it oracledb23c sqlplus system/<your_password>@FREE
  • 1

在这里插入图片描述

docker exec -it oracledb23c sqlplus pdbadmin/<your_password>@FREEPDB1
  • 1

在这里插入图片描述

从容器外部连接

# To connect to the database at the CDB$ROOT level as sysdba:
  $ sqlplus sys/<your password>@//localhost:<port mapped to 1521>/FREE as sysdba
  • 1
  • 2
# To connect as non sysdba at the CDB$ROOT level:
  $ sqlplus system/<your password>@//localhost:<port mapped to 1521>/FREE
  • 1
  • 2
# To connect to the default Pluggable Database (PDB) within the FREE Database:
  $ sqlplus pdbadmin/<your password>@//localhost:<port mapped to 1521>/FREEPDB1
  • 1
  • 2

完结!

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/小舞很执着/article/detail/835253?site
推荐阅读
相关标签
  

闽ICP备14008679号