How to check Embebbed PL/SQL Gateway using on APEX

Just run the script below:

[oradsv@f2chml admin]$ sqlplus / as sysdba
@
SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 30 12:28:08 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

epgstat.sql
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
+--------------------------------------+
| XDB protocol ports:                  |
|  XDB is listening for the protocol   |
|  when the protocol port is non-zero. |
+--------------------------------------+

HTTP Port FTP Port
--------- --------
     8080        0

1 row selected.

+---------------------------+
| DAD virtual-path mappings |
+---------------------------+

Virtual Path                     DAD Name
-------------------------------- --------------------------------
/apex/*                          APEX

1 row selected.

+----------------+
| DAD attributes |
+----------------+

DAD Name     DAD Param                DAD Value
------------ ------------------------ ----------------------------------------
APEX         database-username        ANONYMOUS
             default-page             apex
             document-table-name      wwv_flow_file_objects$
             request-validation-funct wwv_flow_epg_include_modules.authorize
             ion

             document-procedure       wwv_flow_file_mgr.process_download
             nls-language             american_america.al32utf8
             document-path            docs

7 rows selected.

+---------------------------------------------------+
| DAD authorization:                                |
|  To use static authentication of a user in a DAD, |
|  the DAD must be authorized for the user.         |
+---------------------------------------------------+

no rows selected

+----------------------------+
| DAD authentication schemes |
+----------------------------+

DAD Name             User Name                        Auth Scheme
-------------------- -------------------------------- ------------------
APEX                 ANONYMOUS                        Anonymous

1 row selected.

+--------------------------------------------------------+
| ANONYMOUS user status:                                 |
|  To use static or anonymous authentication in any DAD, |
|  the ANONYMOUS account must be unlocked.               |
+--------------------------------------------------------+

Database User   Status
--------------- --------------------
ANONYMOUS       OPEN

1 row selected.

+-------------------------------------------------------------------+
| ANONYMOUS access to XDB repository:                               |
|  To allow public access to XDB repository without authentication, |
|  ANONYMOUS access to the repository must be allowed.              |
+-------------------------------------------------------------------+

Allow repository anonymous access?
----------------------------------
false

1 row selected.

SQL>

APEX Installation Problem - ORA-04031 Compiling WWV_FLOW_GEN_API2

I just installed 4.2.5 APEX Installation and the component stays invalid.

I check wich object was invalid and got this package body below. I tried to compile and got SHARED POOL memory error.

SQL> alter package apex_040200.WWV_FLOW_GEN_API2 compile body;

alter package apex_040200.WWV_FLOW_GEN_API2 compile body
*
ERROR at line 1:
ORA-04031: unable to allocate 91248 bytes of shared memory ("shared pool","unknown object","PLMCD^72ae492e","BAMIMA: Bam Buffer")


#####################################

I them flush shared and buufer cache pool and compiled again. This works for me:

SQL> alter system flush buffer_cache ;

System altered.

SQL> alter system flush shared_pool;

System altered.

SQL> alter package apex_040200.WWV_FLOW_GEN_API2 compile body;

Package body altered.

SQL>

######################################


Best Regards,
Paulo Portugal