Category Archives: Application Server

How to modify search lexer preferences in Oracle Portal

This note apply to Oracle Portal 10.1.4.   OracleAS Portal includes a set of built-in features tuned for searching content stored and managed within the OracleAS Portal Repository. The OracleAS Portal search feature is installed with default and the Oracle Text index is used. Oracle Text indexes use a number of Lexer preferences to control […]

Oracle Portal Performance

This note apply to Oracle Portal 10.1.4.2.0 in HA environment and linux S.O. In the webcache event.log file , continuously this message is shown : [warning 11366] [ecid: xxxxxx] A client connection to listening port 80 is dropped. If the mandatory patches was applied and portal performance is really slow, follow bellow : This note […]

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> […]

TRUSTED CERTIFICATES COULD NOT BE INSTALLED WITH OWM

This case is when we try to install the SERPRO trusted certificate “ACSERPROv2.cer” . This error is one BUG in OWM (Oracle Wallet Manager) follow bellow the solution :   1. Download patch 7352022 from metalink   2. Unzip the patch (e.g: linux) : unzip p7352022_10105_LINUX.zip   3. Apply the patch stopping the OAS: cd 7352022 […]

Tuning Linux OS Kernel Parameters for Oracle WebCache

This note is to increase the kernel parameters for better performance in tcp connection on Linux red-hat. First of all verify the system requirements to install WebCache in oracle.com, and check other required parameters like “kernel.sem” and  “kernel.shmall”. Tuning: Add in /etc/sysctl.conf net.ipv4.nonlocal_bind = 1 net.ipv4.tcp_timestamps = 0 net.ipv4.tcp_max_tw_buckets = 2000000 net.ipv4.tcp_sack = 0 net.ipv4.tcp_window_scaling […]

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 […]