Category Archives: 10g

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-12400 to ORA-12497

ORA-12400 to ORA-12497 ORA-12400: invalid argument to facility error handling Cause: An argument to a facility error handling function exceeded a maximum limit or referred to an invalid product/facility. Action: Specify a valid facility error handling parameter value. ORA-12401: invalid label string: string Cause: The policy could not convert the label string to a valid […]

Error Messages ORA-12315 to ORA-12354

ORA-12315 to ORA-12354   ORA-12315: database link type is invalid for the ALTER DATABASE statement Cause: The database link name you specified on the ALTER DATABASE statement is not an ROM: link. You must specify an ROM: link when using the ALTER DATABASE statement to mount or open a secondary database. Action: Re-issue the ALTER […]

Error Messages ORA-12150 to ORA-12236

ORA-12150 to ORA-12236   ORA-12150: TNS:unable to send data Cause: Unable to send data. Connection probably disconnected. Action: Reestablish connection. If the error is persistent, turn on tracing and reexecute the operation. ORA-12151: TNS:received bad packet type from network layer Cause: Internal error. Action: Not normally visible to the user. For further details, turn on […]