Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how oracle 12c PDB starts with CDB and how to link PDB. Many people may not know much about it. In order to make you understand better, the editor summarizes the following content for you. I hope you can get something according to this article.

I didn't know there was such a feature. I wrote a trigger implementation.

Sql_startup_pdb:='alter pluggable database test open'

EXECUTE IMMEDIATE sql_startup_pdb

End

/

12R2 can be set to automatically start pdb as follows

ALTER PLUGGABLE DATABASE test SAVE STATE

Select con_name, state from dba_pdb_saved_states CON_NAME STATE

TEST OPEN

For more information, please refer to the following article:

How to Preserve Open Mode of PDBs When the CDB Restarts (Doc ID 1933511.1)

And how to connect to the 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' after reading the above, do you have any further understanding of how oracle 12c PDB starts with CDB and how to link PDB? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.