Oracle APEX Errors

Issues we may encounter post installation of Oracle Application Express:

In my previous post we have seen how to install Oracle Application Express, and below are the errors that I've encountered after installation-

First time login to admin page - localhost:8080/apex/apex_admin throws error  like -

A user name and password are being requested by http://localhost:8080. The site says: “XDB”

Fix:

1) Try restarting listener and see if the issue is resolved or not.

2) Unlock xdb user and change password if necessary (default pwd is xdb)

       And try accessing the admin page.

3) If you still see the same error

Check if user ANONYMOUS is locked. If yes, unlock him and change the password if required.

SQL> alter user ANONYMOUS account unlock;

just in case, is to check whether or not APEX is installed properly. The status should show VALID.                                                                    

SQL> select comp_name, version, status  from dba_registry  where comp_name='Oracle Application Express';

  COMP_NAME

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

VERSION                        STATUS

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

Oracle Application Express

4.2.2.00.11                    VALID

User altered.

SQL> alter user ANONYMOUS identified by ANONYMOUS;

User altered.

We can also run a sql “epgstat.sql” to see what exactly is going on with XDB user, and take necessary steps.

Script location is-

Windows-  C:\app\vmummadi\product\11.2.0\dbhome_1\RDBMS\ADMIN

Unix- $ORACLE_HOME/RDBMS/ADMIN