本文主要是介绍Oracle创建容器DB,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
Oracle创建容器DB
1 DBCA图形化创建容器数据库
1.1 启动Xmanager-passive
![](/upload/202107/19/202107191911080883.png)
1.2 设置DISPLAY环境变量
oracle用户设置DISPLAY,将图形化界面显示在宿主机(windows)桌面上DISPLAY设置的ip为宿主机windows对应仅主机网卡ip(本例中是 192.168.9.1)
export DISPLAY=192.168.9.1:0.0
![](/upload/202107/19/202107191911085155.png)
1.3 启动监听程序listener
lsnrctl start
![](/upload/202107/19/202107191911097694.png)
1.4 dbca建库
dbca
![](/upload/202107/19/202107191911102567.png)
![](/upload/202107/19/202107191911108886.png)
![](/upload/202107/19/202107191911122421.png)
![](/upload/202107/19/202107191911132821.png)
![](/upload/202107/19/202107191911139589.png)
![](/upload/202107/19/202107191911149037.png)
![](/upload/202107/19/202107191911156112.png)
![](/upload/202107/19/202107191911162831.png)
![](/upload/202107/19/202107191911169906.png)
![](/upload/202107/19/202107191911177465.png)
![](/upload/202107/19/202107191911183920.png)
![](/upload/202107/19/202107191911194306.png)
![](/upload/202107/19/202107191911201864.png)
![](/upload/202107/19/202107191911215736.png)
![](/upload/202107/19/202107191911222821.png)
1.5 修改环境变量并登录
1.5.1 临时修改
export ORACLE_SID=cdb1
sqlplus / as sysdba
![](/upload/202107/19/202107191911227695.png)
1.5.2 永久修改
修改环境变量
vi .bash_profile
source .bash_profile
![](/upload/202107/19/202107191911236347.png)
这篇关于Oracle创建容器DB的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!