Operating System - HP-UX
1846606 Members
1857 Online
110256 Solutions
New Discussion

Re: Oracle HTTP Server URL Redirection

 
Sundar_7
Honored Contributor

Oracle HTTP Server URL Redirection

I am asked to setup a Oracle HTTP server in one of my development server. We are going to primarily use the mod_plsql module to execute the SQL procedures on a database instance.

I configured Database Access Descriptor (DAD) and managed to get everything working

Now the user has to try

http:///pls//
http://somewebserver.comp.com/pls/database1/helloworld

But since this server is going to be used for executing the procedure only on one database I would like the user to be able to use

http:///

http://somewebserver.comp.com/helloworld.

I am very new to apache and tried rewriting URL rules - any help will be appreciated

-- Sundar.
Learn What to do ,How to do and more importantly When to do ?
7 REPLIES 7
Steven E. Protter
Exalted Contributor

Re: Oracle HTTP Server URL Redirection

Oracle http server is an apache port.

All redirection that works with apache will work with oracle. That includes web pages and httpd.conf directives.

httpd syntax check should show some potential problems.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Ganesh Babu
Honored Contributor

Re: Oracle HTTP Server URL Redirection

can u post what u rewrote for the URL rules and which files??

Ganesh
Sundar_7
Honored Contributor

Re: Oracle HTTP Server URL Redirection


RewriteEnginer on
RewriteRule ^/(.+)$ /pls/database1/$1
Learn What to do ,How to do and more importantly When to do ?
Ganesh Babu
Honored Contributor

Re: Oracle HTTP Server URL Redirection

Can u try this

RewriteEngine on
RewriteCond %{HTTP_PHOST} ^(.)+$
RewriteRule ^/(.+)$ pls/database1/$1 [R]

Ganesh
Sundar_7
Honored Contributor

Re: Oracle HTTP Server URL Redirection

Ganesh, it did nt help
Learn What to do ,How to do and more importantly When to do ?
Ganesh Babu
Honored Contributor

Re: Oracle HTTP Server URL Redirection

Sundar,

this line

RewriteCond %{HTTP_PHOST} ^(.)+$

is not HTTP_PHOST it has to be HTTP_HOST..

sorry i missed it..

Ganesh
Sundar_7
Honored Contributor

Re: Oracle HTTP Server URL Redirection

The result is same Ganesh
Learn What to do ,How to do and more importantly When to do ?