| 9iAS mod_plsql [message #77053] |
Wed, 04 August 2004 08:21  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
