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

Posted: February 24, 2013 in Apex
Tags: , , , , , , , , , , , , ,

In a new installation, we must configure the embedded PL/SQL gateway by running the configuration script apex_epg_config.sql. Then, we must unlock the ANONYMOUS account.

1- Change your working directory to the apex directory where Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. Run apex_epg_config.sql passing the file system path to the base directory where the Oracle Application Express software was unzipped. For example if your APEX directory is /u01/app/apex then you must pass /u01/app as file system path. Otherwise you will receive an error.

@apex_epg_config /u01/app

2- Then enter the following statement to unlock the ANONYMOUS account:


3- The embedded PL/SQL gateway runs in the Oracle XML DB HTTP server in the Oracle database. We must set connection port for it.  Usually this port is 8080.

Connect to the Oracle as SYSDBA and run the following command to set HTTP port.

About these ads
  1. […] The article direct link  Oracle APEX the server requires a username and password the server says XDB […]

  2. Kamal says:

    Super, worked :-)

  3. Suhail says:

    Thanks Fawzy

  4. Spot on, mate. Good job! Thank you.

  5. jrk says:

    More Crisp and Brief than RTFM.. Good show!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s