Category Archives: ORACLE
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 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 […]
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 […]
Error Messages ORA-29250 to ORA-32775
ORA-29250 to ORA-32775 ORA-29250: Invalid index specifed in call to dbms_sql.bind_array Cause: An invalid index was specified in a call to bind_array of dbms_sql. The index may have been null or of an improper value. Action: Correct the index value by modifying your PL/SQL program and try the bind_array call again. ORA-29251: Index1 is […]
Error Messages ORA-00000 to ORA-00832
ORA-00000 to ORA-00832 ORA-00000: normal, successful completion Cause: Normal exit. Action: None. ORA-00001: unique constraint (string.string) violated Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level. Action: Either remove […]