Author Archives:
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 […]
Be careful when migrating – Difference between oracle 10g and 11g
All of DBAs know about new features of Oracle Database 11g, but here will expose of the possible problems to migrate. This note apply to Oracle Database 11g Release 2. New Features: ASM Fast Mirror Resync, a snapshot standby database is a fully updatable standby, Data Recover Advisor automatically diagnoses data failures, Improved Block Corruption […]
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 solve the error – ADVM/ACFS is not supported on epel-release-5-4
This issue is about Oracle Database 11g Release 2 Grid Infrastructure installation on linux Red Hat 5 x86_64 The error “ADVM/ACFS is not supported on epel-release-5-4” is one bug related a installed packages. Bug Evidence – Look the packages (root user) rpm -qa |grep release Result: redhat-release-notes-5Server-36 epel-release-5-4 redhat-release-5Server-5.6.0.3 rpmforge-release-0.5.2-2.el5.rf NOTE: The Grid installation verify […]
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 […]
Error Messages ORA-40001 to ORA-40322
ORA-40001 to ORA-40322 ORA-40001: value for string must be greater than zero Cause: The input parameter in question has a value of zero or less. Action: Provide a value greater than zero for the relevant parameter. ORA-40002: wordsize must be string or greater Cause: The input wordsize is less than the prescribed limit for […]