8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Multitenant : Running Scripts Against Container Databases (CDBs) and Pluggable Databases (PDBs) in Oracle Database 12c Release 1 (12.1)


Anju Garg said...

If there is an active transaction in the parent container and you attempt to start a new transaction in the new container, you will get ORA-65023 : active transaction exists in container ..
Reason: on switching the container ,pending transactions in the original container are not committed / rolled back
(http://oracleinaction.com/ora-65023

Tim... said...

Hi.

Thanks for the information, but I'm not sure how relevant it is to this article, unless people are in the habit of making changes without committing them. :)

Cheers

Tim...

Terri Wright said...

This is my first go-to website for Oracle as it is always very helpful and concise. Thank you very much for this website!

Catharine Winden said...

Hi Tim, I like the concept of the External Password store for connection credentials. How does it affect the keystore used with TDE?

-catharine

Tim... said...

Hi.

Can't say I've tried it, but it should be fine to store multiple types of things inside a wallet. Just make sure you back it up before try it. :)

Of course, there's nothing to stop you using a separate location for your wallet and sqlnet.ora and tnsnames.ora by using TNS_ADMIN when making your client connections.

Cheers

Tim...

Catharine Winden said...

Doh, just realized that there are two distinct sqlnet.ora parameters: wallet_location and encryption_wallet_location ... so there can be a wallet just for sqlplus passwords that does not impact the encryption wallet at all... amazing what reading an article multiple times will reveal... cheers !

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.