FAQ
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!

Search Discussions

  • Jeremy Schneider at Apr 30, 2008 at 5:14 pm
    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
    On 4/29/08, 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!

    --
    http://www.freelists.org/webpage/oracle-l

    --
    Jeremy Schneider
    Chicago, IL
    http://www.ardentperf.com/category/technical

    --
    http://www.freelists.org/webpage/oracle-l
  • Rich Jesse at May 1, 2008 at 5:02 am
    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
    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
    --
    http://www.freelists.org/webpage/oracle-l
  • Marco Gralike at May 5, 2008 at 10:43 am
    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

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Rich Jesse
    Sent: donderdag 1 mei 2008 7:03
    To: oracle-l_at_freelists.org
    Subject: Re: Manual DB creation in 11g for APEX 3.1

    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
    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
    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l
  • Howard Latham at Apr 30, 2008 at 6:04 pm
    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!


    --
    http://www.freelists.org/webpage/oracle-l

    --
    Howard A. Latham

    --
    http://www.freelists.org/webpage/oracle-l
  • Robert Freeman at Apr 30, 2008 at 7:01 pm
    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!

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 29, '08 at 2:41p
activeMay 5, '08 at 10:43a
posts6
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase