Installing and configuring Oracle HTTP 10g on Windows 2003 x64
There is no such thing as 64-bit OracleHTTP server (yet), that’s why you must download and install 32-bit OracleHTTP.
1) Download 32-bit Oracle10g R2 Companion disk for Windows
2) Start OUI from Companion disk (directory) and proceed as:
- Next -> select “Oracle Database 10g Companion Products 10.2.0.1
- Next -> select new Oracle home, such as D:\ORACLE\ORAHTTP
- Next -> select Apache Standalone 10.1.2.0.0
- Next -> check that Product Prerequisite Check is OK and proceed with install
- Next -> check that Oracle HTTP is properly installed trying to connect to http://yourserver:7777
3) Configure DAD (assuming you installed Oracle HTTP in D:\ORACLE\ORAHTTP
- open dads.conf file in
D:\ORACLE\ORAHTTP\Apache\modplsql\confand add your application specific DAD. Sample file:
# ============================================================================ # mod_plsql DAD Configuration File # ============================================================================ # 1. Please refer to dads.README for a description of this file # ============================================================================ # Note: This file should typically be included in your plsql.conf file with # the "include" directive. # Hint: You can look at some sample DADs in the dads.README file # ============================================================================ AddType text/xml xbl AddType text/x-component htc Alias /i/ "D:\oracle\ORAHTTP\Apache\Apache\images/" <Location /yourApp> SetHandler pls_handler Order deny,allow Allow from all AllowOverride None PlsqlDatabaseConnectString yourserver:1521:orcl PlsqlAuthenticationMode Basic PlsqlDefaultPage !yourApp.menu.app PlsqlDocumentTablename htmldocs PlsqlDocumentPath PF PlsqlDocumentProcedure htmldocs.docproc PlsqlNLSLanguage SLOVENIAN_SLOVENIA.EE8MSWIN1250 </Location>
4) Change Oracle HTTP default port (optional)
- open http.conf in
D:\ORACLE\ORAHTTP\Apache\Apache\confand change 7777 to 80:
Port 80 Listen 80
5) Restart the HTTP server and check your url
- go to
D:\ORACLE\ORAHTTP\opmn\binand restart the service:
D:\ORACLE\ORAHTTP\opmn\bin>opmnctl status Processes in Instance: standalone -------------------+--------------------+---------+--------- ias-component | process-type | pid | status -------------------+--------------------+---------+--------- HTTP_Server | HTTP_Server | 1844 | Alive LogLoader | logloaderd | N/A | Down dcm-daemon | dcm-daemon | N/A | Down D:\ORACLE\ORAHTTP\opmn\bin>opmnctl stopall opmnctl: stopping opmn and all managed processes... D:\ORACLE\ORAHTTP\opmn\bin>opmnctl startall opmnctl: starting opmn and all managed processes...
- You should always start troubleshooting Oracle HTTP errors with Apache logs at:
Posted on 26.10.2009, in Oracle and tagged oracle. Bookmark the permalink. 2 Comments.
Is OracleHTTP missing on 11g media?
Oracle recommended method of deploying Apex in 11g changed from Oracle HTTP to embedded PL/SQL gateway that includes core mod_plsql features. That’s why Oracle removed Oracle HTTP from Examples disk (formerly known as Companion).
You can still download Oracle HTTP for Windows x86 from OTN 11g Release 1 download page or Linux x86.
This is what Oracle is saying about Oracle HTTP 10.1.3.3.0 on download page:
The Oracle HTTP Server is a release of the Apache Webserver that contains modules that provide HTTP interfaces with different components of the Oracle database. The Oracle database itself also supports direct communication to these components via native support for the HTTP protocol, so the Oracle HTTP Server is not required. However, if you want to service HTTP requests on a different machine than what the Oracle database is installed, you may want to download and configure the Oracle HTTP Server to act as an independent web server.
The major difference between OracleHTTP that ships with Oracle10g and this separate download is in Apache version. Oracle HTTP that was shipped with 10g runs on Apache 1.3, and OracleHTTP in iAS_101330_Apache2_Modplsql2_win32 runs on Apache 2.0.
Installation notes for Oracle HTTP server 10.1.3.3.0 slightly differ from 10g, specifically in the following (assuming that we installed HTTP server in D:\ORACLE\ORAHTTP):
Bug in OHS 10.1.3.3
Soon after I finished with installation of 10.1.3.3 OHS I noticed that ProcessManager Windows service was not created. A quick search on Metalink confirmed my suspicion that it must to be a bug, refer to:
761489.1 “OHS 10.1.3.3.0 Does Not Create ProcessManager Windows Service”
It’s beyond my comprehension how can such an obvious (amateurish) bug bypass QA process unnoticed. Every time I hit the bug like this, I know we’re paying Oracle waaay tooo much.
Anyway, to clean the the mess after the Oracle we need to create Process Manager service manually with Microsoft service control utility (sc.exe):
Everything must be entered on the same line. Also be careful that you leave a blank space after = for binPath, DisplayName and start command line switches.
I picked up OracleHTTPProcessManager for the service name, you’re free to pick different name.
Considering that Oracle (obviously) didn’t bother to truly test OHS 10.1.3.3 delivered from 11g download area, I’ll stick with older, but trusted release (10.1.2).