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.
I said at the start of the article, I'm using OMF, so I don't need to specify file names or converts.
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
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.
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. :)
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 18.104.22.168 patched to the JAN2018 PSU on RHEL7.
Yep. Just tried it out. You are correct. I've altered the article to say either option is available... :)
Ranjith said...Excellent Article on Multi-tenancy arch. I have one question.
The table we create inside ref_app_user, while connected to Appcon1 container using SYS account, by way of "CREATE TABLE ref_app_user." gets Synced to PDB when we do Application SYNC. However If we connect to ref_app_user directly using sql*plus (i.e. sqlplus ref_app_user/Password1) and create table, it doesn't sync. why so?
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.