5 Replies Latest reply on Jul 12, 2018 10:31 AM by Franck N

    The installation progress is spooled into apexins_cdb*.log files.

    Khamis Khalil

      Hello Everyone,

       

      I am facing issues while installing Apex 5.1.4 in 12.1.0 DB. Following is the detail of error:

       

      Copyright (c) 1982, 2013, Oracle.  All rights reserved.

       

      Enter user-name: sys as sysdba

      Enter password:

       

      Connected to:

      Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt

      ions

       

      SQL> select version from dba_Registry where comp_id = 'APEX';

       

      no rows selected

       

      SQL> @apexins.sql sysaux sysaux temp /i/

       

      PL/SQL procedure successfully completed.

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      PL/SQL procedure successfully completed.

       

       

       

       

       

       

      PL/SQL procedure successfully completed.

       

       

      Session altered.

       

       

      FOO3

      ------------------------------

      install2018-07-11_13-47-43.log

       

      . ORACLE

      .

      . Application Express (APEX) Installation.

      ..........................................

      .

      ... Checking prerequisites (MANUAL)

      .

       

      PL/SQL procedure successfully completed.

       

       

      PL/SQL procedure successfully completed.

       

       

      PL/SQL procedure successfully completed.

       

       

      PL/SQL procedure successfully completed.

       

       

      PL/SQL procedure successfully completed.

       

       

      PL/SQL procedure successfully completed.

       

       

      PL/SQL procedure successfully completed.

       

      .

      ... Prerequisite checks passed.

      .

       

      FOO_USR

      --------------------------------------------------------------------------------

       

      APEX_040200

       

      Performing installation in multitenant container database in the background.

      The installation progress is spooled into apexins_cdb*.log files.

       

      Please wait...

       

       

      And after this stuck there.

       

      Regards,

        • 1. Re: The installation progress is spooled into apexins_cdb*.log files.
          Franck N

          Hi,

           

          I would like to know what are the presetting you did before starting the installation.

          A specially concerning the Old Apex Folder containing Apex 4.

           

          regards,

          Franck

          • 2. Re: The installation progress is spooled into apexins_cdb*.log files.
            Khamis Khalil

            Hello Franck,

             

            First of all thanks for your reply and before running this script i uninstall default 4.2 version. I also notice this and i think that default version is not properly uninstalled because APEX 4.2 schema is still exist. Now i drop it manually and try to install it again and let you know about it soon.

             

            Regards,

            Khamis

            • 3. Re: The installation progress is spooled into apexins_cdb*.log files.
              Franck N

              Hi,

               

              i think it was the wrong approach to deinstall 4.2 first before installing the new apex version.

              Anyway let me know if an error occur again.

               

              Then we will see how to solve it.

               

              Regards,

              Franck

              • 4. Re: The installation progress is spooled into apexins_cdb*.log files.
                Khamis Khalil

                Hi Franck,

                 

                I deinstall last 5.1 which is not installed properly and install it again but same error came again following is the detail:

                 

                C:\Users\Administrator>cd c:\apex5.1.4\apex

                 

                c:\apex5.1.4\apex>sqlplus \nolog

                 

                SQL*Plus: Release 12.1.0.1.0 Production on Thu Jul 12 13:13:27 2018

                 

                Copyright (c) 1982, 2013, Oracle.  All rights reserved.

                 

                Enter password:

                 

                Connected to:

                Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

                With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt

                ions

                 

                SQL> select version from dba_registry where comp_id = 'APEX';

                 

                VERSION

                ------------------------------

                5.1.4.00.08

                 

                SQL> @apxremov.sql

                 

                PL/SQL procedure successfully completed.

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                PL/SQL procedure successfully completed.

                 

                 

                 

                 

                 

                 

                PL/SQL procedure successfully completed.

                 

                Performing de-installation in multitenant container database in the background.

                The de-installation progress is spooled into apxremov*_cdb*.log files.

                 

                Please wait...

                 

                next_proc: total processes (2) != number of live processes (1); giving up

                A process terminated prior to completion.

                Review the apxremov1_cdb*.log files to identify the failure.

                Died at C:\Oracle\app\Administrator\product\12.1.0\dbhome_1/rdbms/admin/catcon.p

                m line 3648.

                 

                 

                 

                De-installation completed. Log files for each container can be found in:

                 

                apxremov*_cdb*.log

                 

                You can quickly scan for ORA errors or compilation errors by using a utility

                like grep:

                 

                grep ORA- *.log

                grep PLS- *.log

                 

                SQL> select version from dba_registry where comp_id = 'APEX';

                 

                no rows selected

                 

                SQL> @apexins.sql sysaux sysaux temp /i/

                 

                PL/SQL procedure successfully completed.

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                 

                PL/SQL procedure successfully completed.

                 

                 

                 

                 

                 

                 

                PL/SQL procedure successfully completed.

                 

                Performing installation in multitenant container database in the background.

                The installation progress is spooled into apexins_cdb*.log files.

                 

                Please wait...

                 

                next_proc: total processes (2) != number of live processes (1); giving up

                A process terminated prior to completion.

                Review the apexins_cdb*.log files to identify the failure.

                Died at C:\Oracle\app\Administrator\product\12.1.0\dbhome_1/rdbms/admin/catcon.p

                m line 3648.

                 

                 

                Installation completed. Log files for each container can be found in:

                 

                apexins_cdb*.log

                 

                You can quickly scan for ORA errors or compilation errors by using a utility

                like grep:

                 

                grep ORA- *.log

                grep PLS- *.log

                 

                SQL> select version from dba_registry where comp_id = 'APEX';

                 

                VERSION

                ------------------------------

                5.1.4.00.08

                 

                Regards,

                Khamis

                • 5. Re: The installation progress is spooled into apexins_cdb*.log files.
                  Franck N

                  Hi,

                   

                  it ´s  good that you uninstalled it completly.

                  now please verify if you have a previous apex version in your DB

                   

                  To verify, Start SQL*Plus and connect to the database and execute the command.

                  To verify whether you have a previous release of Application Express:

                  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example
                    •  
                  2. Execute the following command in SQL*Plus:
                    select username from dba_users 
                           where regexp_like(username,'(FLOWS|APEX)_\d{6}')
                           and username <> (select table_owner from all_synonyms
                           where synonym_name = 'WWV_FLOW' and owner = 'PUBLIC')
                    If the query above returns any rows, the database contains a previous release of Oracle Application Express.

                  Regards,