Home/Questions/Q 2067
In Process
Subrat
Subrat

Subrat

View Profile
  • 0
Contributor
Asked: 2020-10-09T15:33:24+05:30

Unable to login into Apex - login screen doesn't appear after installation

  • 0

Apex 20.1 installed on 18c express edition but failed it in below steps, rest of the steps were successful. I am getting different login screen. PFA. I can't login using different possible methods/users. please assist.

Steps followed in following link, 

https://www.foxinfotech.in/2019/04/install-oracle-apex-19-1-in-eleven-easy-steps.html

error : 

. FAIL - This version of Application Express is already installed.

. FAIL - Precondition for Phase 1 failed: APEX_200100 already exists

SQL> @apxrtins.sql SYSAUX SYSAUX TEMP /i/ ...set_appun.sql

PL/SQL procedure successfully completed.

...set_ufrom_and_upgrade.sql

PL/SQL procedure successfully completed.

Session altered.

FOO3 -------------------------------- installrt2020-10-09_15-19-09.log

. ORACLE . . Application Express Runtime Installation. ........................................... . ...set_appun.sql ... Checking prerequisites (RUNTIME) . . SYSDBA Privilege . pass - Connection with SYSDBA privilege. . Database rolling upgrade . pass - No rolling upgrade. . DB components . FAIL - This version of Application Express is already installed. . pass - CATPROC: version=18.0.0.0.0 . pass - XDB: version=18.0.0.0.0 . XDB . pass - skipped (RUNTIME install) . PL/SQL Web Toolkit . pass - version 11.2.0.0.1 . Tablespaces . pass - found SYSAUX . pass - found SYSAUX . pass - found TEMP . PHASES (1,2,3)... . FAIL - Precondition for Phase 1 failed: APEX_200100 already exists . . 2 errors occurred declare * ERROR at line 1: ORA-20001: Prerequisite checks failed; unable to proceed with APEX installation ORA-06512: at line 288

Disconnected from Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0

oracle apex

    8 Answers

    1. Vinish

      Vinish

      View Profile
      Enlightened

      It is clearly stating that the installation of Oracle Apex 20.1 already exists, but still, you are trying to install it.

      . FAIL – This version of Application Express is already installed.

      . FAIL – Precondition for Phase 1 failed: APEX_200100 already exists

      If you really want it to install a new installation, you must first remove the old one using the following script (must be logged on as SYS):

      @apxremov.sql
      • 0
    2. Vinish

      Vinish

      View Profile
      Enlightened

      Ok I think, there is an issue due to the pluggable database. To install Oracle Apex on Oracle database 12c or later, you need to set the session's container database (PDB).

      After logging in as SYS user, execute the following command:

      alter session set container = yourPDBname;

      Then run your scripts.

      Also, before running the installation, run the apxremove.sql to remove the existing installation.

      • 0
    3. Subrat

      Subrat

      View Profile
      Contributor

      worked this time, after executing below.

      SQL> CONN sys@cdb1 AS SYSDBA

DECLARE
  l_passwd VARCHAR2(40);
BEGIN
  l_passwd := DBMS_RANDOM.string('a',10) || DBMS_RANDOM.string('x',10) || '1#';
  -- Remove CONTAINER=ALL for non-CDB environments.
  EXECUTE IMMEDIATE 'ALTER USER anonymous IDENTIFIED BY ' || l_passwd || ' ACCOUNT UNLOCK CONTAINER=ALL';
END;
/
      • 1
    4. Oleg

      Oleg

      View Profile
      Contributor

      I have the same problem. Please, help. I am running everything on my laptop with hostname MSI. The OS is Windows 10, the database is Oracle 18c (18.4.0.0.0) Express Edition. I installed APEX 20.2 into a pluggable database, under login SYS@pdbname AS SYSDBA. Then, I downloaded ORDS, ran it in install mode, and finally started it in a standalone mode. The URL: http://MSI:8080/ords/apex_admin shows a Web page with the title ORACLE REST Data Services and with 404 error message:

      • The procedure named apex_admin could not be accessed, it may not be declared or the user executing this request may not have been granted execute privilege on the procedure. Check the spelling of the procedure and check that the execute privilege has been granted to the caller

      I checked in the database and - yes- there is no PL/SQL procedure named APEX_ADMIN in any of the following schemas that I have in this pluggable DB: APEX_200200, APEX_INSTANCE_ADMIN_USER, APEX_LISTENER, APEX_PUBLIC_USER, APEX_REST_PUBLIC_USER, ORDS_METADATA, and ORDS_PUBLIC_USER.

      • 0
    5. Mad Mexx

      Mad Mexx

      View Profile
      Contributor

      Hi

      You can't install two versions of Apex in the same (pluggable) database.

      You wrote:

      I see the user APEX_200100 is already getting created in 4th step (@apexins.sql) itself.

      apexins.sql is the setup for Apex with Apex Builder.

      When I run 5th step (@apxrtins.sql), it fails with same error.

      apxrtins.sql is the run-time only version of Apex.

       

       

       

      • 0

    You must login to add an answer.