Sign Up

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In


Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.


Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.


Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

Oracle APEX Tutorials & Forum

Oracle APEX Tutorials & Forum Logo Oracle APEX Tutorials & Forum Logo

Oracle APEX Tutorials & Forum Navigation

  • Home
  • Oracle Apex
  • PL/SQL
  • SQL
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges
  • Home
  • Oracle Apex
  • PL/SQL
  • SQL
Subrat
Subrat

Subrat

  • 1 Question
  • 4 Answers
  • 0 Best Answers
  • 26 Points
View Profile
  • 0
SubratContributor
Asked: October 9, 20202020-10-09T15:33:24+05:30 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
  • 4k
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer

8 Answers

  1. Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 62 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    2020-10-09T15:40:29+05:30Added an answer on October 9, 2020 at 3:40 pm

    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
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • Subrat

      Subrat

      • 1 Question
      • 4 Answers
      • 0 Best Answers
      • 26 Points
      View Profile
      Subrat Contributor
      2020-10-09T16:56:56+05:30Replied to answer on October 9, 2020 at 4:56 pm

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

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

      Note : after removing apex I have validated APEX_200100 was not present under all_users. 

      Is there any compatibility issue? Please note that I have used same version of apex in oracle xe 11 without any issue.

       

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Subrat

        Subrat

        • 1 Question
        • 4 Answers
        • 0 Best Answers
        • 26 Points
        View Profile
        Subrat Contributor
        2020-10-09T16:58:44+05:30Replied to answer on October 9, 2020 at 4:58 pm

        Install logs,

         

        Thank you for installing Oracle Application Express 20.1.0.00.13

        Oracle Application Express is installed in the APEX_200100 schema.

        The structure of the link to the Application Express administration services is as follows:
        http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
        http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
        http://host:port/apex/apex_admin (Oracle REST Data Services)

        The structure of the link to the Application Express development interface is as follows:
        http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
        http://host:port/apex (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
        http://host:port/apex (Oracle REST Data Services)

        timing for: Phase 3 (Switch)
        Elapsed: 00:00:17.56
        timing for: Complete Installation
        Elapsed: 00:10:45.03

        PL/SQL procedure successfully completed.

         

         

        1 row selected.

        ...null1.sql

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
  2. Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 62 Best Answers
    • 4k Points
    View Profile
    Vinish Enlightened
    2020-10-09T17:08:28+05:30Added an answer on October 9, 2020 at 5:08 pm

    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
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • Subrat

      Subrat

      • 1 Question
      • 4 Answers
      • 0 Best Answers
      • 26 Points
      View Profile
      Subrat Contributor
      2020-10-09T17:10:53+05:30Replied to answer on October 9, 2020 at 5:10 pm

      I have already followed that step, changed the PDB.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
  3. Subrat

    Subrat

    • 1 Question
    • 4 Answers
    • 0 Best Answers
    • 26 Points
    View Profile
    Subrat Contributor
    2020-10-09T17:34:08+05:30Added an answer on October 9, 2020 at 5:34 pm

    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
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Oleg

    Oleg

    • 0 Questions
    • 1 Answer
    • 0 Best Answers
    • 25 Points
    View Profile
    Oleg Contributor
    2021-01-02T04:41:26+05:30Added an answer on January 2, 2021 at 4:41 am

    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
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • 0 Questions
    • 1 Answer
    • 0 Best Answers
    • 0 Points
    View Profile
    [Deleted User]
    2021-01-06T23:22:17+05:30Added an answer on January 6, 2021 at 11:22 pm

    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
    • Share
      Share
      • Share on Facebook
      • Share on Twitter

You must login to can add an answer.


Forgot Password?

Sidebar

Explore

  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2022 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us