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

Oracle Application Express 4.1 Installation Guide Step by Step on Windows 7 [PDF]

Welcome to Release 4.1 of the Oracle Application Express Installation Guide Step by Step

This guide consists of the following parts:

  • Install oracle XE database.
  • Install application express.

you can download the Oracle Application Express R4.1 Installation Guide Step by Step on Windows7 from the following link:

Oracle Database XE 10g Installation Guide Step by Step on Linux RHEL4 [PDF]

This (quick-) installation guide is just an abstract of the Oracle Database Express Edition Installation Guide 10g Release 2 (10.2) for Linux.

you can download oracle database XE 10g installation guide step by step on linux_RHEL4 from the following link:

oracle_database_xe_10g_installation_guide_step_by_step_on_linux_rhel4.pdf

Reference:  ORATECH_blog

 

Specify Where Application Express (APEX) Should Redirect to after Logout

To specify where Application Express should redirect to after logout  (post log-out URL) do the following steps:

1) Go to the following path: Shared Components > Security > Authentication Schemes > Your Authentication

2) Change the Logout URL to: wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:9 or f?p=&APP_ID.:9