Installing and configuring Oracle HTTP 10g on Windows 2003 x64

Oct 26

Posted by

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\conf and 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>
  • now open plsql.conf in the same directory as dads.conf and check that dads.conf is included with the statement such as:
    • include D:\ORACLE\ORAHTTP\Apache\modplsql\conf\dads.conf

4) Change Oracle HTTP default port (optional)

  • open http.conf in D:\ORACLE\ORAHTTP\Apache\Apache\conf and change 7777 to 80:
    • Port 80
Listen 80

5) Restart the HTTP server and check your url

  • go to D:\ORACLE\ORAHTTP\opmn\bin and 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...
  • point your browser to http://yourserver/yourApp and you should be prompted to logon

6) Troubleshooting

  • You should always start troubleshooting Oracle HTTP errors with Apache logs at: 
    D:\ORACLE\ORAHTTP\Apache\Apache\logs
Advertisement

Posted on 26.10.2009, in Oracle and tagged . Bookmark the permalink. 2 Comments.

  1. alesk | 26.10.2009 at 00:00

    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):

    • 1) Unzip iAS_101330_Apache2_Modplsql2_win32 and install according to above notes.
    • 2) Run Setp.exe and enter new Oracle home into which you’ll install Oracle HTTP
    • 3) Next -> Install
    • 4) Check you installation by pointing your browser at: http://yourserver:7778
    • 5) dads.conf and plsql.conf are located at D:\ORACLE\ORAHTTP\ohs\modplsql\conf
    • 6) httpd.conf is located in D:\ORACLE\ORAHTTP\ohs\conf
  2. alesk | 26.10.2009 at 00:10

    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):

    cmd> sc create OracleHTTPProcessManager binPath= "D:\ORACLE\ORAHTTP\opmn\bin\opmn.exe -S" DisplayName= OracleHTTPProcessManager start= auto

If everything is fine with the sc command, you should be greet with:
[SC] CreateService SUCCESS

    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).