Category Archives: PLSQL

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

Oracle Portal Performance

This note apply to Oracle Portal 10.1.4.2.0 in HA environment and linux S.O. In the webcache event.log file , continuously this message is shown : [warning 11366] [ecid: xxxxxx] A client connection to listening port 80 is dropped. If the mandatory patches was applied and portal performance is really slow, follow bellow : This note […]

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 invalidate pages in Webcache using database procedure

To invalidate dynamic pages in the webcache, you need send an XML file with the URL of the pages that you want to invalidate to web cache The advantage to use database procedure to invalidate is that should be invalidated as soon as the data in the database is updated. The better way is create […]

Error Messages ORA-24280 to ORA-28674

ORA-24280 to ORA-28674   ORA-24280: invalid input value for parameter string Cause: The parameter has been provided a negative, out of range, or NULL input value. Action: Correct the input value such that it is valid, and is within the range as specified in the documentation. ORA-24281: invalid access past the maximum size of LOB […]

Error Messages ORA-19400 to ORA-24276

ORA-19400 to ORA-24276   ORA-19400: System type conflict with object SYS.string Cause: The user had an object with the same name as one of the system types. The system types were not initialized properly. Action: Remove the conflicting object and rerun migration. ORA-19500: device block size string is invalid Cause: the device block size returned […]

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