Category Archives: Linux
Error unable to allocate 4160 bytes of shared memory
This note apply to Oracle Database Enterprise Edition – Version 11.2.0.1 to 11.2.0.3 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/emd.properties 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 : http://oss.oracle.com/projects/php/files/EL5/x86_64 oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm 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 : http://www.oracle.com/technetwork/topics/linux/asmlib/index-101839.html 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 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 […]
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> […]
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 […]