Thanks for the question, Senthil Kumar.
Asked: June 02, 2017 - 4:49 am UTC
Last updated: June 02, 2017 - 2:10 pm UTC
Version: 12c
Viewed 1000+ times
You Asked
Hi All,
Currently the application exposes HTML pages to users. This is done using HTF packages in Oracle 8.1. The setup is in such away that the application web server(apache http) , DB all reside in the same server host. The mod_plsql is configured to invoke the stored procedure and page works fine.
Now the plan is to move to oracle 12c. Migration of data is one issue which is being worked upon. I have a basic query on how the HTF packages will work in the 12C setup. The setup will now be the Oracle HTTP Server will be present in a different host on enterprise Linux (Hope Oracle HTTP can be installed individually on a Linux server???) . The DB will be on other host as DB will be behind the firewall. Now can I configure mod_plsql to invoke the required store procedure on DB in different host ?
Am little confused with the setup ... Could some one clarify please?
and Connor said...
htf etc will still be there in the database, so as long as you have your DAD (data access descriptor) successfully configured to connect to the database, things should remain unchanged.
So it will be:
- client => app server (running http server)
- app server => via DAD, connect to database over SQL Net.
Is this answer out of date? If it is, please let us know via a Comment