Author Archives:
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 […]
Error WWC-41417 Oracle Portal user cannot login
This note apply to Oracle Portal 10.1.4. When a user is deleted then re-created in OID, the internally generated orclguid value for the user entry changes. Portal stores the orclguid value for the user in the Portal wwsec_person$.guid field and if the value stored does not match the orclguid value in OID then the […]
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 […]