Category Archives: Linux

Error unable to allocate 4160 bytes of shared memory

This note apply to Oracle Database Enterprise Edition – Version to Symptoms: The system appears to be running very slowly and defunct processes can appear. Errors are seen in the alert log or Trace log : 1. ORA-04031 ORA-04031: unable to allocate 4160 bytes of shared memory (“shared pool”,”unknown object”,”sga heap(1,0)”,”modification “) Incident […]

Workaround to Grid Agent Restart Problem Due to a Daylight Savings Change

This note apply to Enterprise Manager Grid Control Version 10 to 11g   Oracle Management Agent does not start and show this error: Starting agent …… failed. The agentTZRegion value in /u01/app/oracle/product/grid11g/agent11g/sysman/config/ is not in agreement with what agent thinks it should be.Please verify your environment to make sure that TZ setting has not changed […]

How to uninstall Oracle database 11g

This note apply to linux version and Oracle Database RAC or Standalone.   1. First of all uninstall the database and after grid: To uninstall the database run as oracle user : $ORACLE_HOME/deinstall/deinstall This script will require at the end of process, to run other script as root user.     2. After uninstall the […]

How to install PHP5, OCI8, GD, LDAP, ZEND on linux

This note apply to Red-Hat linux 64, but it’s close for all linux version.   1. Download and install RPM’s from Oracle Site : oracle-instantclient11.2-basic- php53-5.3.8-1.el5.x86_64.rpm php53-cli-5.3.8-1.el5.x86_64.rpm php53-common-5.3.8-1.el5.x86_64.rpm php53-gd-5.3.8-1.el5.x86_64.rpm php53-ldap-5.3.8-1.el5.x86_64.rpm php53-oci8-11gR2-5.3.8-1.el5.x86_64.rpm install using :   rpm -ivh   2. Create log dir : mkdir -p /etc/php.d/logs   3. Modify the php.ini :  (/etc/php.ini) 3.1 Enable […]

How To Setup ASM & ASMLIB On Native Linux Multipath Mapper disks

This note apply to Oracle Database using ASM and linux S.O.   After installed and configured the Multipath, follow bellow: 1. Download and Install ASMLIB :   2. Check the disks : ls -l /dev/mapper brw-rw—- 1 root disk 253, 46 Jul 27 17:19 Prod_Orcl01 brw-rw—- 1 root disk 253, 67 Jul 27 17:59 […]

ORA-00845 When starting Up an 11g Instance with AMM

This note apply to Oracle Database 11g and linux S.O.   On a Linux system, trying to start up an 11g instance could fail with the following error: ORA-845: MEMORY_TARGET not supported on this system In the alert log, you could or could not see the below messages: ORA-04031 errors.   The problem occur when […]

Oracle Portal Performance

This note apply to Oracle Portal 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 […]

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

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, 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- rpmforge-release-0.5.2-2.el5.rf NOTE: The Grid installation verify […]