您好，登录后才能下订单哦！
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
今天就跟大家聊聊有关oracle 12c PDB随CDB启动以及链接PDB的方式是什么，可能很多人都不太了解，为了让大家更加了解，小编给大家总结了以下内容，希望大家根据这篇文章可以有所收获。
本来不知道有这个特性写了个trigger实现
sql_startup_pdb:='alter pluggable database test open';
EXECUTE IMMEDIATE sql_startup_pdb;
end;
/
12R2可以设置如下自动启动pdb
ALTER PLUGGABLE DATABASE test SAVE STATE;
select con_name, state from dba_pdb_saved_states
CON_NAME
STATE
------------------------------ --------------
TEST
OPEN
详细信息可以参考以下文章：
How to Preserve Open Mode of PDBs When the CDB Restarts (Doc ID 1933511.1)
和连接pdb的方式
jhpd1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.12.29)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jhpd1) ##PDB_NAME ) ) Service "763210eda4a67d57e05322640a0a58cb" has 1 instance(s). Instance "mldxt", status READY, has 1 handler(s) for this service... Service "7685cbd9bdd371c9e05322640a0a3b82" has 1 instance(s). Instance "mldxt", status READY, has 1 handler(s) for this service... Service "7685cbd9bdd471c9e05322640a0a3b82" has 1 instance(s). Instance "mldxt", status READY, has 1 handler(s) for this service... Service "7685cbd9bdd571c9e05322640a0a3b82" has 1 instance(s). Instance "mldxt", status READY, has 1 handler(s) for this service... Service "7685cbd9bdd671c9e05322640a0a3b82" has 1 instance(s). Instance "mldxt", status READY, has 1 handler(s) for this service... Service "7685cbd9bdd771c9e05322640a0a3b82" has 1 instance(s). Instance "mldxt", status READY, has 1 handler(s) for this service... Service "7685cbd9bdd871c9e05322640a0a3b82" has 1 instance(s). Instance "mldxt", status READY, has 1 handler(s) for this service... Service "7685cbd9bdd971c9e05322640a0a3b82" has 1 instance(s). Instance "mldxt", status READY, has 1 handler(s) for this service... alias xxpd1='sqlplus system/oracle@xxpd1' alias xxpd2='sqlplus system/oracle@xxpd2' alias xxpd3='sqlplus system/oracle@xxpd3' alias jhpd1='sqlplus system/oracle@jhpd1' alias jhpd2='sqlplus system/oracle@jhpd2' alias jhpd4='sqlplus system/oracle@jhpd4' alias jhpd6='sqlplus system/oracle@jhpd6' alias dxtdb='sqlplus system/oracle@dxtdb'
看完上述内容，你们对oracle 12c PDB随CDB启动以及链接PDB的方式是什么有进一步的了解吗？如果还想了解更多知识或者相关内容，请关注亿速云行业资讯频道，感谢大家的支持。
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。