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

Laury

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.

Laury

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.

John_K

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

Kiran Pawar

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 :

• Re: Apex installation ( 4.2.2 on 12c )
• Apex 5 with EPG - The server requires a username and password (Thread referred by ORA-01033, where we have discussed this in detail)

     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

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

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

Kiran Pawar

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:

• Application Express in Oracle Database 12c
• http://docs.oracle.com/cd/E59726_01/install.50/e39144/db_pluggable.htm#HTMIG29434

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

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.