5 Replies Latest reply: Oct 15, 2012 3:46 AM by Lutfi.Hedir RSS

    Install APEX 4.2 on XE 11g

    Lutfi.Hedir
      hi..all
      any experienced installing apex 4.2 to fresh install XE 11g?

      because i always unsuccessfull with this code:

      -- Now beginning upgrade. This will take several minutes.-------
      -- Ensuring template names are unique -------
      -- Migrating metadata to new schema -------
      -- Switching Builder to new schema -------
      -- Migrating SQL Workshop metadata -------

      Warning: Package Body altered with compilation errors.

      -- Upgrading new schema. -------
      -- Copying preferences to new schema. -------
      -- Upgrading Websheet objects. -------
      begin
      *
      ERROR at line 1:
      ORA-04063: package body "APEX_040200.WWV_FLOW_UTILITIES" has errors
      ORA-06508: PL/SQL: could not find program unit being called:
      "APEX_040200.WWV_FLOW_UTILITIES"
      ORA-06512: at "APEX_040200.WWV_FLOW_UPGRADE", line 4962
      ORA-06512: at line 4


      ERRORS EXIST!!!
      ...There are 11 errors in the log table!
      ...Select upgrade_error from WWV_FLOW_UPGRADE_PROGRESS to review errors.
      -- Upgrade is complete -----------------------------------------
      timing for: Upgrade
      Elapsed: 00:01:52.04
      VIII. I N S T A L L O R A C L E A P E X A P P L I C A T I O N S
      define "^" (hex 5e)
      ...Internal messages
      APPLICATION 4411 - Oracle APEX System Messages and Native Types
      Set Credentials...
      Check Compatibility...
      WWV_FLOW_API.FLOWS_API_LAST_EXTENDED20120101
      WWV_FLOW_API.CURRENT_FLOWS_VERSION20120101
      WWV_FLOW_API.IMPORT_COMPATIBLE_WITH_VERSION 20120101
      WWV_FLOW_API.COMPATIBLE
      Set Application ID...
      begin
      *
      ERROR at line 1:
      ORA-04063: package body "APEX_040200.WWV_FLOW_UTILITIES" has errors
      ORA-06508: PL/SQL: could not find program unit being called:
      "APEX_040200.WWV_FLOW_UTILITIES"
      ORA-06512: at "APEX_040200.WWV_FLOW_AUDIT", line 70
      ORA-06512: at line 3


      Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - Produ
      ction
        • 1. Re: Install APEX 4.2 on XE 11g
          Prabodh
          Check the install*.log file created by install. It will show you the error.
          Chances are you ran out of space in one of the tablespaces.
          If that is the case,
          a. Add a datafile to the tablespace
          b. Drop the APEX_040200 user, with cascade
          c. Run apexins again.

          Not really a 4.2 specific issue, applies to all prior versions as well.
          Cheers,
          • 2. Re: Install APEX 4.2 on XE 11g
            Lutfi.Hedir
            hi prabodh
            log file say exactly like i posted.
            This never happen when install 4.0 or 4.1.

            i already have new tablespace apex42 before i run @apexins.sql APEX42 APEX42 TEMP /i/

            any suggestion?
            • 3. Re: Install APEX 4.2 on XE 11g
              Prabodh
              log file say exactly like i posted.
              This never happen when install 4.0 or 4.1.

              i already have new tablespace apex42 before i run @apexins.sql APEX42 APEX42 TEMP /i/

              any suggestion?>
              Look for errors before the below error. Some table, view or other db object has failed in creation.
              begin
              *
              ERROR at line 1:
              ORA-04063: package body "APEX_040200.WWV_FLOW_UTILITIES" has errors
              ORA-06508: PL/SQL: could not find program unit being called:
              We did an upgrade from 4.1 to 4.2 this morning and went through smoothly, so I doubt there is an issue with the scripts.

              Cheers,
              • 4. Re: Install APEX 4.2 on XE 11g
                Lutfi.Hedir
                Praboth i think this is happen on fresh install on oracle XE 11g (existing 4.0) not like your scenario update from existing 4.1 to 4.2
                BTW there many error on log file
                ERROR at line 1:
                ORA-01920: user name 'FLOWS_FILES' conflicts with another user or role name 
                ORA-06512: at line 3 
                
                ...create flows_files
                ... create wwv_flow_file_objects
                create table wwv_flow_file_objects$ (
                             *
                ERROR at line 1:
                ORA-00955: name is already used by an existing object 
                create index wwv_flow_files_file_idx on wwv_flow_file_objects$ (security_group_id, filename, flow_id)
                             *
                ERROR at line 1:
                ORA-00955: name is already used by an existing object 
                
                create public synonym wwv_flow_file_objects$ for wwv_flow_file_objects$
                                      *
                ERROR at line 1:
                ORA-00955: name is already used by an existing object 
                
                declare
                *
                ERROR at line 1:
                ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "APEX42" 
                ORA-06512: at line 7 
                
                Table altered.
                
                           m.c048, m.c049, m.c050, m.clob001, m.blob001, m.xmltype001, m.n001, m.n002, m.n003,
                                                                         *
                ERROR at line 7:
                ORA-00904: "M"."XMLTYPE001": invalid identifier 
                .
                .
                .
                many more
                • 5. Re: Install APEX 4.2 on XE 11g
                  Lutfi.Hedir
                  i found it actually my problem on existing tablespace not on installation

                  drop and re-create tablespace installation succeeded

                  thanks praboth