I've downloaded the Oracle Fusion Middleware Web Tier Utilities and installed the components. The Oracle HTTP Server is up and running as verified by both the opmnctl status and the fact that I can get to my server and see the Weblogic "interactive overviews" page. I then modified the dads.conf file found on the OHS configuration directory: $INSTANCE_HOME/config/ohs/ohs1/mod_plsql/dads.conf.
I copied the contents of my working dads.conf file (OHS 10.1.3)
Alias /i/ "D:\apex_images\images/"
AddType text/xml xbl
AddType text/x-component htc
<Location /paris>
Order deny,allow
PlsqlDocumentPath docs
#AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_downloadd
#PlsqlDatabaseConnectString ecydblcyaddd4:1521:wqdev SIDFormat
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage f?p=PARIS:1
PlsqlDatabasePassword *******
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
PlsqlErrorStyle DebugStyle
Allow from all
PlsqlCGIEnvironmentList AUTHORIZATION
</Location>
I modified the $INSTANCE_HOME/config/ohs/ohs1/http.conf file so that the OHS would listen on port 80. However, when I point my browser to my apex application I get an error.
http://ecydblcyaddd4/paris/f?p=PARIS:1
Illegal PLSQL identifer in input
DAD name: paris
PROCEDURE : f
URL : http://ecydblcyaddd4.ecy.wa.lcl:80/paris/f?p=PARIS:1
PARAMETERS :
===========
p:
PARIS:1
...
...
I can tnsping my database as referenced in the PlsqlDatabaseConnectString, so this isn't a connectivity issue. The OHS logs has the following entry:
[2011-07-13T08:02:26.1590-07:00] [OHS] [ERROR:32] [OHS-9999] [mod_context.c] [host_id: ecydblcyaddd4] [host_addr: 165.151.25.165] [pid: 18388] [tid: 1848] [user: SYSTEM] [VirtualHost: main] MODPLSQL-00367: mod_plsql: /paris/f HTTP-400 Illegal PLSQL identifer in input
Any ideas of what to look at next?