8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 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 !

Johannes said...

Hi Tim
you saved my life again: for installing oracle text in 19c you need --p to pass all the parameters. Couldn't find anything in the documentation but in your blog.
Great

Thanks
Johannes

Anonymous said...

Hi

How to set oracle sid on 18c xe db.

while i set ORACLE_PDB_SID=(PDBNAME) ,if i connect syspromt and checked its showing cdb as well as pdb.


if i set sys level its altered.its showing only pdb.but if set os level its not work cuse i am unable to import or export on pdb.


Please help me

Tim... said...

Hi.

The article shows you how to set the ORACLE_SID.

It is the value use defined for the instance when it was created. You can see it in the "/etc/oratab" file.

CHeers

Tim...

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.