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

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:

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

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.

EXEC DBMS_XDB.SETHTTPPORT(8080);
Advertisements

Remove Oracle Apps Diagnostics Password Screen

To remove the Diagnostics Password Screen which appear when you go to the following path:

Help > Diagnostics > Custom Code > Personalize

do the following steps:

– Go to the following path : System Administrator (R) > Profile (M) > System (F)
– Find profile option name : Utilities:Diagnostics
– Set the Value : Yes