[Oracle-l] Manual DB creation in 11g for APEX 3.1

Try this script to dump the configuration of your embedded PL/SQL gateway:
$ORACLE_HOME/rdbms/admin/epgstat.sql

Then I'd turn on listener logging and look for errors.

Also, it seems that you can dump HTTP requests and responses with this
event:
event="31098 trace name context forever, level 2"

More info here:
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28424/adfns_web.htm#CHDFGFHB
http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28369/xdb22pro.htm#i1029414

-Jeremy

That did it, Jeremy. I was missing the "dispatchers" init.ora param for
XDB. And of course, I had messed up the install enough by then that I
needed to remove/reinstall APEX 3.1, but I needed the practice anyway. :)

Nice util in epgstat, too. I'll have to read up on those docs to
familiarize myself more with the underpinnings of APEX.

THANKS again!
Rich

event 31098 is used for "Internal event to turn on XDB tracing". It
traces the database create statements of types, tables etc, while using
the DBMS_XMLSCHEMA package to register an XML schema in the XDB
Repository.

The local APEX database structure is based on XMLDB functionality, also
the local dbconsole looks like it is using it to generate reports (in
11g)...
You can have a look here to get a first glance of the XDB protocol
server here: http://www.liberidu.com/blog/?cat=34

In 10.1 it is enabled by default. In 10.2 and 11.1, it is disabled, but
shared server architecture is still enabled by default.

If you don't need it, TURN it OFF. It is a security breach (and uses
resources while being idle)

AFAIK

there is no event for tracing the protocol server functionality, or more
specific in thie case of the "gateway" for APEX. It was never (afaik)
fully implemented, although the logging structures in de XDB Repository
exist. I would be very interested if someone knows, learned about how to
trace the HTTP/FTP calls via the proctocol listener (aka Listener XMLDB
functionality) .

Marco

I found eventually that APEX was already included in my install.
Not in office so cant check versions etc

Yep, APEX is installed as a part of 11g. It's possible that you might
have broken something if you installed an older version. I doubt it,
but it's possible. You might start with a fresh 11g install first.

The instructions on setting up the embedded gateway are a bit confusing for a first timer.
Did
you check that the HTTP port is enabled with DBMS_XDB.GETHTTPPORT? You
might need to enable the port if you have not already. Check the APEX
users guide and the 11g Database Install guide for more information on
this.

RF

Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

Original Message ----
From: Howard Latham
To: rjoralist_at_society.servebeer.com
Cc: oracle-l_at_freelists.org
Sent: Wednesday, April 30, 2008 12:04:12 PM
Subject: Re: Manual DB creation in 11g for APEX 3.1

I found eventually that APEX was already included in my install.
Not in office so cant check versions etc

On 29/04/2008, Rich Jesse wrote:
Hey all,

The subject about says it all. I'm attempting to fire up a test APEX 3.1
w/the embedded PL/SQL gateway on a manually created 11.1.0.6.0 DB in x86
Linux.

As per the prereqs in the APEX install docs, I've installed JVM, XDB, and
Text, using the 10gR2 instructions found on Metalink since I could not
locate any specifically for 11g. I also verified that PL/SQL Web Toolkit is
installed and meets the version requirement.

After setting the port to 8080, I see that it appears to be registered with
the Listener. However, trying to surf to port 8080 ends up with a
"connection was reset" error. I've attempted to bounce the instance,
listener, and reinstalling APEX to no avail. "netstat -l" confirms that the
listener is using port 8080.

For a huge caveat, I'm attempting this on a new build of Gentoo. However,
even if this was on EL5, I have no idea how to troubleshoot this. I
couldn't find any pertinent log files in the $ORACLE_BASE tree, including
the diags directory -- are there any? I'd like to troubleshoot this instead
of the Windowsesque option of reinstalling, this time using DBCA to
see if my manual creation is the issue.

Thoughts anyone?
Rich

p.s. Almost done (*finally!*) with my step-by-step instructions to manually
install 10gR2 replicated OID. Maybe even this week!