Re: HELP: Web Server's Configuration for PL/SQL Cartridge

In article <3711824E.1BF87B06_at_jis.ne.jp>,   Huiming Li <huiming_at_jis.ne.jp> wrote:
> According to the Manual "Using Oracle Web Application Server
> Cartridges",
> the configuration for pl/sql cartridge includes two parts as follows:
> 1. Create a DAD
> 2. Configure the PL/SQL agent.

  The part about creating a virtual directory is missing here. You should map, in the Web Listener's configuration, the URL you want, as if it were a CGI directory. As the OWAS I had configures were all updated from OWS 1.0, they had to have a directory with the DAD name mapping to $ORAWEB_HOME/bin.

>
> My question is : when I do the PL/SQL agent configuration, what port
> number should I use in the Authorized Ports Field?

    The number of the port for the listener you want to host the service. Probably 80, in your case.

> On my web server, there are two listeners running, one is admin, port
> no. is 8888. the other is www, port no. is 80. I tried both of them, but
> none of them works.

    Something is missing in the configuration them. You should check the configuration files and the logs.

    Hoping to help, here goes part of the OWAS directory tree (version 3.0):

$ORACLE_HOME/ows/admin/ows/<host>/wrb/config/wrb.app

                                  |  /log/wrb.log
                                  |      /xlf.log
                                 /httpd_<host>/<listener>/config/
                                                         /log

    You will find the configuration files at the "config" directories, one for each listener. The wrb.app file should have a line like:

/<service>/plsql PLSQL %ORACLE_HOME%/ows/bin

or

/<service>/owa PLSQL %ORACLE_HOME%/ows/bin

    and the <listener>/config/sv<listener>.cfg should have a directory mapping like

/<service> C %ORACLE_HOME%/ows/bin

    Sometines is better to check the files than use the browser itself to edit them, but be careful - OWAS is very syntax-sensitive, and you shouldn't mess with the files if you are not sure of what you are doing.

>
> When I finished all the configuration procedures as described in the
> manual, I got "The requested URL was not found." in my browser.
>

    This looks more like a missing directory mapping, indeed, than DAD misconfiguration.

> Are there any other steps or tricks to fulfill the configuration?
>
> Please help me out, thanks in advances.
>

             HTH,

                  Eduardo Pimenta.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own