Tag Archives: OAS

Materialized View with OID users data

Sometimes you need access users data of OID to integrate with other systems, follow bellow how to do:   1. Create Types : CREATE OR REPLACE TYPE LDAP_USU_TABLE is table of LDAP_USU_ROW; / CREATE OR REPLACE TYPE LDAP_USU_ROW as object (login       varchar2(200),            name        varchar2(200),            mail        varchar2(200),            phone      varchar2(200)); /   […]

How to invalidate pages in Webcache using database procedure

To invalidate dynamic pages in the webcache, you need send an XML file with the URL of the pages that you want to invalidate to web cache The advantage to use database procedure to invalidate is that should be invalidated as soon as the data in the database is updated. The better way is create […]

Undeploy/Deploy App in OC4J using linux Shell script

This note apply to Oracle OC4J 10.x to undeploy/deploy in cluster environment:   1. UNDEPLOY cd $ORACLE_HOME/j2ee/home $ORACLE_HOME/jdk/bin/java -jar admin_client.jar deployer:cluster:opmn://<host.domain>/<container name> oc4jadmin <password oc4jadmin> -undeploy <application name> example: $ORACLE_HOME/jdk/bin/java -jar admin_client.jar deployer:cluster:opmn://oas3.help2ora.com/production2 oc4jadmin welcome1 -undeploy Appsysclient     2. DEPLOY cd $ORACLE_HOME/j2ee/home $ORACLE_HOME/jdk/bin/java -jar admin_client.jar deployer:cluster:opmn://<host.domain>/<container name> oc4jadmin <password oc4jadmin> -deploy -file <application ear> […]

How to install PHP5, GD and OCI8 for Oracle Application Server on linux

Steps for linux 32 bits : 0.  Install rpm’s : httpd-devel –  Development tools for the Apache HTTP server libjpeg –  A library for manipulating JPEG image format files libjpeg-devel – libpng –   A library of functions for manipulating PNG image format files libpng-devel –  Development tools for programs to manipulate PNG image format files […]