Forum Stats

  • 3,838,758 Users
  • 2,262,398 Discussions
  • 7,900,750 Comments

Discussions

Oracle APEX the server requires a username and password the server says XDB?

Laury
Laury Member Posts: 1,665 Silver Badge
edited May 17, 2015 7:43AM in APEX Discussions

Hi,

After having installed the version of APEX 5.0 and trying to access the APEX admin page using EPG, I get prompted with a pop-window that asks for a username and pasword for the XDB?

Does somone has experience with it? What can be wrong in the configuration?

Thanks by advance.

Kind Regards.

Kiran Pawar

Best Answer

  • Laury
    Laury Member Posts: 1,665 Silver Badge
    edited May 17, 2015 7:43AM Answer ✓

    Hi,

    I have found the problem.

    There was somwthing wrong in the security settings.

    I re-run one of the steps with the right parameters calling:

    dbms_network_acl_admin.append_host_ace

    There was a mistake in passing the parameters.

    Now, i works.

    Kind Regards.

    Kiran Pawar

Answers

  • John_K
    John_K Member Posts: 2,498 Gold Trophy
    edited May 15, 2015 10:27AM

    What database version are you using? If 12c then are you installing into the CDB or a PDB? Ensure the CDB ANONYMOUS user is unlocked.

    Apex 5 with EPG - The server requires a username and password

    Laury
  • Kiran Pawar
    Kiran Pawar Member Posts: 2,951 Bronze Crown
    edited May 15, 2015 12:24PM

    Hi Laury,

    Laury wrote:
    
    After having installed the version of APEX 5.0 and trying to access the APEX admin page using EPG, I get prompted with a pop-window that asks for a username and pasword for the XDB?
    
    Does somone has experience with it? What can be wrong in the configuration?
    

         It is due to faulty configuration of EPG.

         Assuming that you are using Oracle Database 12c.

         The reason for this issue are listed by Jason Straub in the following thread:

         Refer :

         The above thread discussions are for Oracle Database 12c, but you will find threads for Oracle Database 11g as well, if you search the forum.

        

         Hope this helps!

    Regards,

    Kiran

    Laury
  • Laury
    Laury Member Posts: 1,665 Silver Badge
    edited May 15, 2015 1:44PM

    Hi,

    Thanks for the ansers.

    But not all these tips could help me.

    Here is to summarize what I have done:

    1) I have downloaded the zip file at: /u01/oracle/base/product/rdbms/121/apex50

    2) I have run the necessary scripts as:

    cd /u01/oracle/base/product/rdbms/121/apex50/apex

    SQL>start apexins.sql APEX50_USER_D APEX50_FILES_D TEMP /i/

    and

    SQL>start apex_epg_config.sql /u01/oracle/base/product/rdbms/121/apex50

    and

    cd /u01/oracle/base/product/rdbms/121/apex50/apex

    SQL>start apxldimg.sql /u01/oracle/base/product/rdbms/121/apex50

    3) Status or relevant users:

                              Account                   Lock

    Username                  status                    date

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

    ANONYMOUS                 OPEN

    APEX_050000               EXPIRED & LOCKED          15-MAY-15

    APEX_PUBLIC_USER          OPEN

    FLOWS_FILES               EXPIRED & LOCKED          15-MAY-15

    4 rows selected.

    4) Checked the EPG status:

    SQL> start $ORACLE_HOME/rdbms/admin/epgstat.sql

    +--------------------------------------+

    | XDB protocol ports:                  |

    |  XDB is listening for the protocol   |

    |  when the protocol port is non-zero. |

    +--------------------------------------+

    HTTP Port FTP Port

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

         8080        0

    1 row selected.

    +---------------------------+

    | DAD virtual-path mappings |

    +---------------------------+

    no rows selected

    +----------------+

    | DAD attributes |

    +----------------+

    no rows selected

    +---------------------------------------------------+

    | DAD authorization:                                |

    |  To use static authentication of a user in a DAD, |

    |  the DAD must be authorized for the user.         |

    +---------------------------------------------------+

    no rows selected

    +----------------------------+

    | DAD authentication schemes |

    +----------------------------+

    no rows selected

    +--------------------------------------------------------+

    | ANONYMOUS user status:                                 |

    |  To use static or anonymous authentication in any DAD, |

    |  the ANONYMOUS account must be unlocked.               |

    +--------------------------------------------------------+

    Database User   Status

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

    ANONYMOUS       OPEN

    1 row selected.

    +-------------------------------------------------------------------+

    | ANONYMOUS access to XDB repository:                               |

    |  To allow public access to XDB repository without authentication, |

    |  ANONYMOUS access to the repository must be allowed.              |

    +-------------------------------------------------------------------+

    Allow repository anonymous access?

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

    false

    1 row selected.

    SQL>

    5) Status of the Listener:

    LSNRCTL> status

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel5964-odb-ISIS)(PORT=1521)))

    STATUS of the LISTENER

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

    Alias                     LISTENER

    Version                   TNSLSNR for Linux: Version 12.1.0.1.0 - Production

    Start Date                15-MAY-2015 16:43:07

    Uptime                    0 days 0 hr. 9 min. 8 sec

    Trace Level               off

    Security                  ON: Local OS Authentication

    SNMP                      OFF

    Listener Parameter File   /u01/oracle/base/product/rdbms/121/network/admin/listener.ora

    Listener Log File         /u01/oracle/base/diag/tnslsnr/oel5964-odb-isis/listener/alert/log.xml

    Listening Endpoints Summary...

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel5964-odb-ISIS)(PORT=1521)))

      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel5964-odb-ISIS)(PORT=8080))(Presentation=HTTP)(Session=RAW))

    Services Summary...

    Service "ISIS" has 1 instance(s).

      Instance "ISIS", status READY, has 1 handler(s) for this service...

    Service "ISISXDB" has 1 instance(s).

      Instance "ISIS", status READY, has 1 handler(s) for this service...

    The command completed successfully

    LSNRCTL>

    6) Check against the dispatchers:

    SQL> show parameter dispatcher

    NAME                                 TYPE        VALUE

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

    dispatchers                          string      (PROTOCOL=TCP) (SERVICE=ISISXDB)

    To my surprise there is no DAD attributes?

    Any idea where I should look further?

    Thanks and Regards

  • Laury
    Laury Member Posts: 1,665 Silver Badge
    edited May 15, 2015 1:45PM

    I forgot to mention, I use an Oracle RDBMS 12cR2 EE.

  • Kiran Pawar
    Kiran Pawar Member Posts: 2,951 Bronze Crown
    edited May 16, 2015 6:32AM

    Hi Laury,

    Here is to summarize what I have done:
    1) I have downloaded the zip file at: /u01/oracle/base/product/rdbms/121/apex50
    2) I have run the necessary scripts as:
    cd /u01/oracle/base/product/rdbms/121/apex50/apex
    SQL>start apexins.sql APEX50_USER_D APEX50_FILES_D TEMP /i/
    
    

         Are the tablespaces APEX50_USER_D and APEX50_FILES_D created in the database? (If doing CDB based installation are these created in CDB, if PDB based installation are these created in appropriate PDB)

         As you are installing Oracle APEX 5.0 in Oracle Database 12c, you have not mentioned that you are doing a CDB Based installation or PDB Based installation.

         If you are doing PDB Based installation ( forum member ORA-01033) has mentioned what steps he has followed in this thread:

         (Check the last two comments of this thread)

         While executing the installation scripts you have to make sure you are in the right container (viz. CDB/PDB). If not you have to change your container(Refer: Switching Between Containers). If doing a PDB based installation you have to be sure that the PDB is opened and is in READ WRITE mode before executing the scripts.

         (If you will search the forum related to apex installation in database 12c you will find much more help)

         Also, I would recommend to go through these white papers and documentation related to APEX in 12c:

    SQL>start apex_epg_config.sql /u01/oracle/base/product/rdbms/121/apex50
    and
    cd /u01/oracle/base/product/rdbms/121/apex50/apex
    SQL>start apxldimg.sql /u01/oracle/base/product/rdbms/121/apex50
    
    

         Instead of this, you have to do only:

    cd /u01/oracle/base/product/rdbms/121/apex50/apex
    SQL>@apex_epg_config.sql /u01/oracle/base/product/rdbms/121/apex50
    
    

         You should always use the apex_epg_config.sql script for both purposes viz. while installing or while upgrading.(in APEX 5.0)

         Refer :

    To my surprise there is no DAD attributes?
    
    

         That's what Jason Straub (in his thread mentioned above) and I am trying to tell, that EPG is not configured properly.

         Hope this helps!

    Regards,

    Kiran

    Laury
  • Laury
    Laury Member Posts: 1,665 Silver Badge
    edited May 17, 2015 7:43AM Answer ✓

    Hi,

    I have found the problem.

    There was somwthing wrong in the security settings.

    I re-run one of the steps with the right parameters calling:

    dbms_network_acl_admin.append_host_ace

    There was a mistake in passing the parameters.

    Now, i works.

    Kind Regards.

    Kiran Pawar
This discussion has been closed.