Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dads configuration for APEX 5 accessed through OHS 12c

LauryMar 4 2016 — edited Mar 4 2016

Hi,

This thread deals about the configuration of Oracle OHS 12c for Oracle APEX (WebLogic not used).

I have some doubts about the configuration:

In the documentation (https://docs.oracle.com/cd/E59726_01/install.50/e39144/http_server.htm#HTMIG29263) there is a reference to:

Alias /i/ "ORACLE_HTTPSERVER_HOME/user_projects/domains/base_domain/images/"

Where should this line be added, in dads.conf (as stated in the doc) or in ssl.conf or httpd.conf?

The dads.conf can be configured as:

<Location /apex>
   Order deny,allow
   PlsqlDocumentPath docs
   AllowOverride None
   PlsqlDocumentProcedure         wwv_flow_file_mgr.process_download
   PlsqlDatabaseConnectString     my_server_name:1521:OLABI TNSFormat
   PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8
   PlsqlAuthenticationMode        Basic
   SetHandler                     pls_handler
   PlsqlDocumentTablename         wwv_flow_file_objects$
   PlsqlDatabaseUsername          APEX_PUBLIC_USER
   PlsqlDefaultPage               apex
   PlsqlDatabasePassword          myPassword
   PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
   PlsqlPathAlias                 r
   PlsqlPathAliasProcedure        wwv_flow.resolve_friendly_url
   Allow from all
</Location>

Where:
- my_server_name is the name of my remore database server (when APEX actually runs) and corresponds to an entry in the /etc/hosts file of the serer where will runs OHS 12c.
- OLABI is the service name of the database, as well as the corresponding TNS entry.
- APEX_PUBLIC_USER is the APEX_PUBLIC_USER user from APEX.
- myPassword is the password of the APEX_PUBLIC_USER.
- AMERICAN_AMERICA.AL32UTF8 is the value I have for NLS Language and for the database.
- 1521 is the port of the listener on which it is running.

Is the above dads.conf a correct dads for my configuration?

If the database is running on the same server as the OHS server, the dads configuration is:

<Location /apex>
   Order deny,allow
   PlsqlDocumentPath docs
   AllowOverride None
   PlsqlDocumentProcedure         wwv_flow_file_mgr.process_download
   PlsqlDatabaseConnectString     OLABI TNSFormat
   PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8
   PlsqlAuthenticationMode        Basic
   SetHandler                     pls_handler
   PlsqlDocumentTablename         wwv_flow_file_objects$
   PlsqlDatabaseUsername          APEX_PUBLIC_USER
   PlsqlDefaultPage               apex
   PlsqlDatabasePassword          myPassword
   PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
   PlsqlPathAlias                 r
   PlsqlPathAliasProcedure        wwv_flow.resolve_friendly_url
   Allow from all
</Location>

Is that correct?

Thanks by advance for sharing your experience.

Kind Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2016

Added on Mar 4 2016

#applications-integration-using-oracle-fusion-middleware, #soa-process-management

0 comments

1,047 views