Oracle internals, debugging and undocumented features

Apex in 11g database.


My pain developer http://www.oraclenerd.com/  keep buging me for some time to install APEX…   We had it installed and it worked fine and sudenly APEX images did not work…

In the past I have installed APEX  using Oracle Application server and configuring dads.conf file etc..

Well with 11g database installing APEX is much easier.In Oracle Database 11g, Oracle Application Express is installed when the database is installed.

Only thing you have to do is to run script  apxconf located under $ORACLE_HOME/apex directory.This script will confugure PL/SQL gateway.

-sh-3.2$ sqlplus / as sysdba

SQL*Plus: Release – Production on Tue Feb 17 14:46:42 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release – 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining and Real Application Testing options

SQL> @apxconf


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              [] admin_123
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.

SQL> exit

You can find Oracle tutorial 


No more messing with app server and encrypting password for apex user…


3 responses to “Apex in 11g database.

  1. chet February 17, 2009 at 9:01 pm

    that guy sounds like a real pain in the ass…you should lock his account sometime. actually, you should just expire the password but set it up so that he can’t change his password too…

    oh wait, you already did that.


  2. Crisatunity June 5, 2009 at 9:48 pm

    You should definitely delete that guy’s account. There’s no telling what trouble he might get into.

    I’m surprised he hasn’t asked you to upgrade from the built in 3.0 version to the fancy new 3.1 version of APEX.

  3. ara February 24, 2011 at 11:38 am

    Hi I have a question, what version of apex have 11g database?

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: