Hi,
I've several questions about the process to unistall an application from the application root container.
1.The process more similar to remove is uninstall.
ALTER PLUGGABLE DATABASE APPLICATION CRM_APP begin UNINSTALL;
However, you need manually remove all apps objects like: tablespaces, users etc.
Why not is done automatically?
2. If I try to reuse the same apps name, fails.
ALTER PLUGGABLE DATABASE APPLICATION crm_app begin install '1.0'
*
ERROR at line 1:
ORA-65245: application CRM_APP has been uninstalled
Is not possible to remove an apps? May be I may have been wrong, I need to erase it.
3. When I unistall an apps, in the alert log say, that try to create a clone , however my file system doesn't support cloning, but create a physical clone on the file system
CRM_ROOT(4):ALTER PLUGGABLE DATABASE APPLICATION CRM_APP begin UNINSTALL
CREATE PLUGGABLE DATABASE "F1715659061_21_1" AS APPLICATION CONTAINER from "CRM_ROOT" CREATE_FILE_DEST='/u01/app/oracle/oradata/CDB1/CRM_ROOT/' SNAPSHOT COPY STANDBYS=NONE
2019-06-11T21:55:15.088156+02:00
CRM_ROOT(4): AUDSYS.AUD$UNIFIED (SQL_TEXT) - CLOB populated
2019-06-11T21:55:15.139868+02:00
CRM_ROOT(4):Errors in file /u01/app/oracle/diag/rdbms/cdb1/CDB1/trace/CDB1_p001_2219.trc:
ORA-17525: Database clone using storage snapshot not supported on file /u01/app/oracle/oradata/CDB1/CRM_ROOT/crm_tbs.dbf
And finally I see at OS, the clone.
ls -ltr /u01/app/oracle/oradata/CDB1/CRM_ROOT/CDB1/8B12ACE584C90FCAE053BEE4A8C0BEB7/datafile/
total 839768
-rw-r-----. 1 oracle oinstall 37756928 Jun 11 21:55 o1_mf_temp_gj01s35y_.dbf
-rw-r-----. 1 oracle oinstall 104865792 Jun 11 21:55 o1_mf_crm_tbs_gj01s35y_.dbf
-rw-r-----. 1 oracle oinstall 104865792 Jun 11 21:55 o1_mf_undotbs1_gj01s35x_.dbf
-rw-r-----. 1 oracle oinstall 367009792 Jun 11 21:55 o1_mf_sysaux_gj01s35x_.dbf
-rw-r-----. 1 oracle oinstall 283123712 Jun 11 21:55 o1_mf_system_gj01s35w_.dbf
4. Exists any view to track all the objects associated to an apps?
Many thanks and sorry my high number of questions.
Arturo