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/Subrat/Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments
  1. Asked: October 9, 2020

    Unable to login into Apex – login screen doesn’t appear after installation

    Subrat

    Subrat

    • 1 Question
    • 4 Answers
    • 0 Best Answers
    • 26 Points
    View Profile
    Subrat Contributor
    Added 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_pRead more

    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;
    /
    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: October 9, 2020

    Unable to login into Apex – login screen doesn’t appear after installation

    Subrat

    Subrat

    • 1 Question
    • 4 Answers
    • 0 Best Answers
    • 26 Points
    View Profile
    Subrat Contributor
    Replied to answer on October 9, 2020 at 5:10 pm

    I have already followed that step, changed the PDB.

    I have already followed that step, changed the PDB.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: October 9, 2020

    Unable to login into Apex – login screen doesn’t appear after installation

    Subrat

    Subrat

    • 1 Question
    • 4 Answers
    • 0 Best Answers
    • 26 Points
    View Profile
    Subrat Contributor
    Replied 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 withRead more

    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

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: October 9, 2020

    Unable to login into Apex – login screen doesn’t appear after installation

    Subrat

    Subrat

    • 1 Question
    • 4 Answers
    • 0 Best Answers
    • 26 Points
    View Profile
    Subrat Contributor
    Replied 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 haveRead more

    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.

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter

Sidebar

Ask Question
Write a Post
  • Recent
  • Answers
  • Engr. SM Hasem

    How to insert item data with default IG in IG ...

    • 0 Answers
  • suriya

    how to download multiple view/table data in one excel

    • 1 Answer
  • Engr. SM Hasem

    How to add one column data to another column in ...

    • 11 Answers
  • Bheem

    What is best way to design school time table?

    • 0 Answers
  • Vinish
    Vinish added an answer Below is an example to download the CSV file using… January 25, 2021 at 12:54 pm
  • afzal
    afzal added an answer step 1--- report query like-- select EMPNO, ENAME, JOB, MGR,… January 25, 2021 at 10:14 am
  • Engr. SM Hasem
    Engr. SM Hasem added an answer Thank you so much sir. January 25, 2021 at 9:22 am
  • Vinish
    Vinish added an answer For all rows? It seems you want to compare the… January 25, 2021 at 6:19 am
  • Vinish
    Vinish added an answer Ok, then create a dynamic action on the bill month… January 25, 2021 at 6:17 am

Recent Blog Posts

  • Vinish

    Pro*C - Connect to Oracle Database

  • 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

Explore

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

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