Category Archives: Database

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

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