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

Home » Misc » Here

Comments for Multitenant : Application Containers in Oracle Database 12c Release 2 (12.2)


Dan Morgan said...

Excellent demo ... however:
Sample Code: CREATE TABLESPACE ref_app_ts DATAFILE SIZE 1M AUTOEXTEND ON NEXT 1M;
Works Better: CREATE TABLESPACE ref_app_ts DATAFILE SIZE 1M AUTOEXTEND ON NEXT 1M;
Hope this helps.

Dan Morgan said...

Lovely: your blog code eliminated my suggestion so I will write it out ... after DATAFILE it works better if the datafile name is provided.

Tim... said...

Hi.

I said at the start of the article, I'm using OMF, so I don't need to specify file names or converts.

Cheers

Tim...

Anju Garg said...

Hello Tim,
I tried out your demo without OMF. when I try to sync application ref_app with apppdb1, I get following error:
ALTER PLUGGABLE DATABASE APPLICATION ref_app SYNC;
ALTER PLUGGABLE DATABASE APPLICATION ref_app SYNC
*
ERROR at line 1:
ORA-01537: cannot add file
'/u01/app/oracle/oradata/orclcdb/appcon1/app_tbs1.dbf' - file already part of
database
regards
Anju Garg

Mike said...

Anju, me too, but from first line:

The examples in this article use Oracle Managed Files (OMF) so no file name conversions are needed. Although not currently documented, OMF is mandatory for application container synchronisation. Some pieces will work with the appropriate FILE_NAME_CONVERT or PDB_FILE_NAME_CONVERT settings if you need them, but others will fail.

Tim... said...

Hi.

I had a conversation offline with Anju. I should have written some feedback here for others to read. Yes, it is the dependency on OMF that is the issue. If you are not using OMF you will get errors like this. :)

Cheers

Tim...

Oscar said...

Hi Tim,

Thanks for the article, very useful in getting to grips with Application Containers. Maybe just a small correction but in regards to dropping an Application PDB, it appears it can be done outside of the Application Container as I was able to drop an Application PDB from the CDB$ROOT. It worked on my test database on Oracle 12.2.0.1 patched to the JAN2018 PSU on RHEL7.

Tim... said...

Hi.

Yep. Just tried it out. You are correct. I've altered the article to say either option is available... :)

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.