LOCATION :
$IAS_ORACLE_HOME/Apache/modplsql/cfg
SIGNIFICANCE :
> This file is used by mod_plsql component of Apache to connect to database. This is the PL/SQL Gateway configuration file.
> PL/SQL stored procedures can retrieve data from database tables and generate HTTP responses containing data and code to display in a Web browser.
IMPORTANT POINTS :
> modplsql is not used in R12
> MOD_PLSQL is an Oracle HTTP Server (Apache) extension module that allows developers to create dynamic web pages from PL/SQL packages and stored procedures within the database. It is ideal for developing fast and flexible applications that can run on the Internet or an Intranet.
> MOD_PLSQL was formerly called the Oracle PL/SQL Cartridge and OWA (Oracle Web Agent).
> Starting with Oracle 10g, DAD's must be created by editing configuration files with a text editor. The Web Browser interface is no longer available.
> MOD_PLSQL uses a 2-tier architecture where clients (with Web Browsers) interact directly with the databases.
+-CLIENT-+ +-----------------S E R V E R---------------+
| | | |
| Web | <--Internet--> | Oracle HTTP <--> mod_plsql <--> Oracle |
| Browser| HTTP | Server Database |
| | | |
+--------+ +-------------------------------------------+
> By default MOD_PLSQL is started when the Oracle HTTP Server (Apache) is started.
>
> Having changed APPS password, but still using old password in the wdbsvr.app can results in not opening a function When selecting a function that is expected to start Forms, but also no error is raised for the user. Calling Forms using /dev60cgi/f60cgi starts the Forms applet as expected, so Forms is available and up and running. The request to the PLS Apache listener done as part of starting Forms responds with a 403 (Forbidden) due to login problem of MOD_PLSQL (ORA-1017 invalid username/password). This causes that the redirect to /dev60cgi/f60cgi call is not performed and Forms applet is not started.
> DAD used in file refers to Database Access Descriptors.
> Please do not edit this file directly. Use the Gateway Database Access Descriptor configuration page in Oracle Portal
http://<hostname>:<port>/pls/DAD/<admin_path>/gateway.htm
>
FILE :
#########################################################################################################
;
; $Header: wdbsvr.app 115.25 2004/11/25 13:19:18 adan ship $
;
; ###############################################################
;
; This file is automatically generated by AutoConfig. It will be read and
; overwritten. If you were instructed to edit this file, or if you are not
; able to use the settings created by AutoConfig, refer to Metalink document
; 165195.1 for assistance.
;
; ###############################################################
;
[WVGATEWAY]
defaultDAD = qata
administrators = system
adminPath = /admin_/
debugModules = all
LoggingLevel = Debug
;custom_auth = CUSTOM
;
[DAD_qata_admin]
connect_string = qat
cgi_env_list=SERVER_NAME=ebsqa.adr.corp.com,REQUEST_PROTOCOL=http,SERVER_PORT=8013,HOST=ebsqa.adr.corp.com:8013
input_filtering = Yes
;
[DAD_qata] (A DAD or Database Access Descriptor is used to specify configuration parameters for an application.)
connect_string = qat
password = w0rldtest
username = apps
default_page = fnd_web.ping
document_table = apps.fnd_lobs_document
document_path = docs
document_proc =
upload_as_long_raw =
upload_as_blob = *
reuse = Yes
connmax = 10
pathalias = fndgfm
pathaliasproc = fnd_gfm.dispatch
enablesso = No
cgi_env_list=SERVER_NAME=ebsqa.adr.corp.com,REQUEST_PROTOCOL=http,SERVER_PORT=8013,HOST=ebsqa.adr.corp.com:8013
input_filtering = Yes
stateful=STATELESS_RESET
;
[DAD_qat_archive]
connect_string = qat
password = w0rldtest
username = xxebsarch
default_page = fnd_web.ping
document_table = apps.fnd_lobs_document
document_path = docs
document_proc =
upload_as_long_raw =
upload_as_blob = *
reuse = Yes
connmax = 10
pathalias = fndgfm_archive
pathaliasproc = fnd_gfm.dispatch
enablesso = No
cgi_env_list=SERVER_NAME=ebsqa.adr.corp.com,REQUEST_PROTOCOL=http,SERVER_PORT=8013,HOST=ebsqa.adr.corp.com:8013
input_filtering = Yes
stateful=STATELESS_RESET
;
[DAD_qata_portal30]
connect_string = qat
password = W0RLDtest
username = PORTAL30
default_page = portal30.home
document_table = portal30.wwdoc_document
document_path = docs
document_proc = portal30.wwdoc_process.process_download
upload_as_long_raw =
upload_as_blob = *
reuse = Yes
connmax = 10
enablesso = Yes
pathalias = url
pathaliasproc = portal30.wwpth_api_alias.process_download
cgi_env_list=SERVER_NAME=ebsqa.adr.corp.com,REQUEST_PROTOCOL=http,SERVER_PORT=8013,HOST=ebsqa.adr.corp.com:8013
;name_prefix =
;always_describe =
;after_proc =
;before_proc =
stateful=STATELESS_RESET
;
[DAD_qata_portal30_sso]
connect_string = qat
password = W0RLDW1DE
username = PORTAL30_SSO
default_page = portal30_sso.wwsso_home.home
document_table = portal30_sso.wwdoc_document
document_path = docs
document_proc = portal30_sso.wwdoc_process.process_download
upload_as_long_raw =
upload_as_blob = *
reuse = Yes
connmax = 10
enablesso = Yes
pathalias = url
pathaliasproc = portal30_sso.wwpth_api_alias.process_download
cgi_env_list=SERVER_NAME=ebsqa.adr.corp.com,REQUEST_PROTOCOL=http,SERVER_PORT=8013,HOST=ebsqa.adr.corp.com:8013
;name_prefix =
;always_describe =
;after_proc =
;before_proc =
stateful=STATELESS_RESET
;