Monday, October 31, 2011

Enable APEX in Oracle 11.2

cd $ORACLE_HOME/apex
sqlplus / as sysdba


SQL> @apxconf.sql

PORT
----------
8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.


Enter a password for the ADMIN user []
Enter a port for the XDB HTTP listener [ 8080]
...changing HTTP Port

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Session altered.

...changing password for ADMIN

PL/SQL procedure successfully completed.


Commit complete.

SQL> alter user anonymous account unlock;

User altered.

# now access by http://server:8080/apex/apex_admin (login admin/password entered above)