Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then you are going to love this place.

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

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/Questions/Q 2067
In Process
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
  • 252
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
Answer

    8 Answers

    1. Vinish

      Vinish

      • 1 Question
      • 416 Answers
      • 39 Best Answers
      • 2k Points
      View Profile
      Vinish Legendary
      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

      Vinish

      • 1 Question
      • 416 Answers
      • 39 Best Answers
      • 2k Points
      View Profile
      Vinish Legendary
      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
    5. Mad Mexx

      Mad Mexx

      • 0 Questions
      • 1 Answer
      • 0 Best Answers
      • 25 Points
      View Profile
      Mad Mexx Contributor
      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 add an answer.

    Forgot Password?

    Sidebar

    Ask Question
    Write a Post
    • Recent
    • Answers
    • Bheem

      What is best way to design school time table?

      • 0 Answers
    • OrclQA Wiki

      How to display file contents in MAC terminal app?

      • 1 Answer
    • Greg

      Displaying image in modal window

      • 3 Answers
    • Greg Grimes

      20.2 APEX: How can I pre-select the searchable column in ...

      • 0 Answers
    • ApexPadawan
      ApexPadawan added an answer Have you tried using the built in file browse item,… January 21, 2021 at 1:29 pm
    • ApexPadawan
      ApexPadawan added an answer First Add the following to CSS > Inline under Page… January 21, 2021 at 1:21 pm
    • Vinish
      Vinish added an answer Yes, this is also fine. January 19, 2021 at 3:25 pm
    • Greg
      Greg added an answer I tried your solution and it worked, but since I… January 19, 2021 at 3:23 pm
    • Vinish
      Vinish added an answer You can use the cat command to display file contents… January 19, 2021 at 10:41 am

    Recent Blog Posts

    • Vinish

      Copy URL to Clipboard on Button Click Examples

    • Vinish

      Find When Your Mac Was Last Shutdown

    • Vinish

      Oracle SELECT Statement

    • Vinish

      Python Append List to List Example

    • Vinish

      JavaScript Object Get Value by Key

    Explore

    • Home
    • Blog
    • New Questions
    • Tutorials
      • Oracle Apex
      • Python
    • Tags
    • Users
    • Badges & Points
    • About

    © 2020 OrclQA.Com. All Rights Reserved. Privacy Policy