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
可以進行建庫確認等