Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » 9iAS mod_plsql
9iAS mod_plsql [message #77053] Wed, 04 August 2004 08:21 Go to next message
Paul
Messages: 164
Registered: April 1999
Senior Member
Hi

Does anyone have experience of configuring Oracle 9iAS Release 2 mod_plsq?  Any pointers in the right direction would be apriciated.

Thanks,
Paul
Re: 9iAS mod_plsql [message #77054 is a reply to message #77053] Wed, 04 August 2004 08:52 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
It's actually pretty simple. Are you using 9.0.1 or 9.0.2? They are quite different in architecture. In 9.0.2, go to tthe OEM website http://hostname:1810/emd/console (by default). After logging in, select your Infrastructure tier (not middle tier), select HTTP server, select PL/SQL properties. You can now add a DAD. If it's just a straight connection to the database (not a Portal connection), then add it like this:
Select General
DAD name: pls/test
user: scott
pass: tiger
connection string: mydb.domain.com
OR host:port:sid (like sun1:1521:orcl)

Create a test proc like this in scott:
CREATE OR REPLACE PROCEDURE env
AS
BEGIN
   HTP.htmlOpen;
      HTP.headOpen;
         HTP.title ('Environment Test');
      HTP.headClose;
      HTP.bodyOpen;
         HTP.p ('REMOTE_ADDR=' || OWA_UTIL.get_cgi_env ('REMOTE_ADDR'));
         HTP.br;
         HTP.p ('REMOTE_USER=' || OWA_UTIL.get_cgi_env ('REMOTE_USER'));
         HTP.br;
         HTP.p ('HTTP_HOST=' || OWA_UTIL.get_cgi_env ('HTTP_HOST'));
         HTP.br;
         HTP.p ('SERVER_NAME=' || OWA_UTIL.get_cgi_env ('SERVER_NAME'));
         HTP.br;
         HTP.p ('<b>All CGI Environment variables</b>
');
         OWA_UTIL.print_cgi_env;
      HTP.bodyClose;
   HTP.htmlClose;
END;
/

You may need to restart the HTTP portion of 9iAS from the OEM website (no impact to connected users). Test it: http://hostname:7777/pls/test/env

You can check your Infrastructure or Middle tier ports under their own homes in:
.../Apache/install/portlist.ini
Previous Topic: Oracle Web Developer Survey
Next Topic: Please help me in solving the error :You cannot login because there is no config
Goto Forum:
  


Current Time: Thu Mar 28 18:43:44 CDT 2024