标签：Oracle23ai 验证 数据库 Database bytes Free database Oracle open
Oracle23ai 数据库的简单验证
背景
2024年5.1期间发现有公众号再说Oracle23c
使用容器方式进行安装的
感觉可以试用把玩一下.
简单安装
docker pull container-registry.oracle.com/database/free:latest
运行
time docker run -d --name oracle23ai -h oracle23ai \
--net host --restart=always \
container-registry.oracle.com/database/free:latest
注意 这个容器的启动时间其实挺长的.
启动之后会提示为;
Up 5 seconds (health: starting)
大概一分钟后会提示:
Up About a minute (healthy)
进行简单查看
docker exec -it oracle23ai bash
sqlplus / as sysdba
select * from v$version ;
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
打开PDB
alter pluggable database all open;
PDB的名称为:
FREEPDB1
Oracle的简单设置-自动启动pdb
CREATE TRIGGER open_all_pdbs
AFTER STARTUP ON DATABASE
BEGIN
EXECUTE IMMEDIATE 'alter pluggable database all open';
END open_all_pdbs;
/
修改默认字符长度设置
alter system set nls_length_semantics='CHAR' scope=both;
设置完成后进行查看
show parameter nls ;
数据库简单确认
show sga
Total System Global Area 1603726344 bytes
Fixed Size 5360648 bytes
Variable Size 402653184 bytes
Database Buffers 1191182336 bytes
Redo Buffers 4530176 bytes
可以进行建库确认等
标签：Oracle23ai,
验证,
数据库,
Database,
bytes,
Free,
database,
Oracle,
open
From： https://www.cnblogs.com/jinanxiaolaohu/p/18171145