3 Replies Latest reply on Jul 17, 2019 9:19 PM by Markus Flechtner

    Applications Containers: Uninstall Apps procedure

    Arturo Gutierrez

      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