Thursday, May 17, 2012

application express installation -http server option

1. configure apex on oracle database installation.
cd $ORACLE_HOME/Apex/bin
sqlplus / as sysdba
sqlplus > @apxchpwd   # change admin password
sqlplus > alter user apex_public_user account unlock
sqlplus > password apex_public_user
2. download oracle http server
#current it is available from version 11.2.0.1 as oracle fussion medtier.
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html
3. install http server
./runInstaller     # install software only
4. configure http server
WebTier_ORAcLE_OME/bin/config.sh #don't select "associate to a domain' if you don't have a domain setup
5. load the mod_plsql module
vi WebTier_ORAcLE_OME/instances/instance1/config/OHS/ohs1/httpd.conf
add
   LoadModule plsql_module "${ORACLE_HOME}/ohs/modules/mod_plsql.so" 
   include /u01/app/oracle/product/11.1.1/ofm/Oracle_WT1/ohs/conf/mod_plsql/*.conf
6. configure dads.conf file
vi /u01/app/oracle/product/11.1.1/ofm/Oracle_WT1/ohs/conf/mod_plsql/dads.conf
add
Alias   /i/               "/u01/app/oracle/product/4.0.2/apex/images/" 
AddType text/xml          xbl 
AddType text/x-component  htc 
   
<Location /pls/apex> 
Order                          deny,allow 
PlsqlDocumentPath              docs 
AllowOverride                  None 
PlsqlDocumentProcedure         wwv_flow_file_manager.process_download 
PlsqlDatabaseConnectString     localhost:1521:XE ServiceNameFormat 
PlsqlNLSLanguage               AMERICAN_AMERICA.AL32UTF8 
PlsqlAuthenticationMode        Basic 
SetHandler                     pls_handler 
PlsqlDocumentTablename         wwv_flow_file_objects$ 
PlsqlDatabaseUsername          APEX_PUBLIC_USER 
PlsqlDefaultPage               apex 
PlsqlDatabasePassword          parsingschemapasswd 
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize 
Allow from all 
</Location>

7. stop and start http server
/u01/app/oracle/product/11.1.1/ofm/Oracle_WT1/instances/instance1/bin/opmnctl stopproc ias-component=ohs1
/u01/app/oracle/product/11.1.1/ofm/Oracle_WT1/instances/instance1/bin/opmnctl startproc ias-component=ohs1
8. access application express at https://hostname:4443/pls/apex


reference:
http://docs.oracle.com/cd/B28359_01/install.111/b28264/apex.htm
http://www.warp11.nl/2011/05/fully-freeware-apex-environment-vii-oracle-http-server-configuration/
http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21673/otn_install.htm#BABEGAEJ

No comments:

Post a Comment