Unable To Get Connection Status Verified For A DAD (Doc ID 560922.1)

Last updated on NOVEMBER 30, 2023

Applies to:

Symptoms

Status of DAD is showing down in AS Console, although the DAD does work.
The status of the DAD is derived by a HTTP request sent from the AS Console
to the HTTP Server in the format of http://host.domain:port/DAD_NAME/htp.p?cbuf=Test.

This can be seen by a simple test as follows.
1. From the command line, "cd $ORACLE_HOME/Apache/Apache/logs".
2. Issue the command "tail -f <latest access_log>".
    example tail -f access_log.xxxxxxxxx
3. Next, in a new browser, login to AS Console, and click on HTTP Server.
    Click on Administration Tab.
    Click on PL/SQL Properties.
4. Immediately go back to the tail -f access_log and you should see an entry
    like this.  "GET /DAD-NAME/htp.p?cbuf=Test HTTP/1.1" 200 5
5. Note, that there should be one entry in the access_log for for each number of
    DADs that are defined. For example, if there are three DADs configured, then
    there should be three entries in the access_log.

If the above is not written to the access_log, then the request is not making it
to the Oracle HTTP Server and thus the status of the DAD will show down in
the AS Console.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.