Author Archives: admin

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

How to create textual index with phoneme

  First of all you need create one user (schema to test), in this example the user is scott and the language example is PORTUGUESE. 1. Grant permissions to scott with sys user : GRANT EXECUTE ON CTXSYS.CTX_ADM TO SCOTT; GRANT EXECUTE ON CTXSYS.CTX_CLS TO SCOTT; GRANT EXECUTE ON CTXSYS.CTX_DDL TO SCOTT; GRANT EXECUTE ON […]

How to test Multicast CLUSTER INTERCONNECT on Oracle Database 11g R2

This note apply to Oracle Database 11.2.0.2.0 .   Sometimes the Interconnect latency is high. If one instance is down and when try to restart this instance, the CSS daemon can’t start, and when ran the “crsctl stat res -t -init” the status showed forever “starting”. The error of CSSD : 2010-09-16 23:13:15.839: [ CSSD][1087465792]clssnmvDHBValidateNCopy: […]

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

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