Blog Archives

Bug (ora-2019 or ora-2069) with User Defined Functions Insert/Update over Database Links

If you try to insert or update across a database link some values called by a user defined function: insert into mytable@remote (mycol) values ( myfunction (’01-JAN-2009′) ) ; That will fail with either: ORA-02019: connection description for remote database

Posted in Bugs patch fails if database word size had ever been changed in the past

Thanks to Chris Carr for pointing out this: If you are upgrading or patching to and the word size is different to the word size when the database was created the upgrade will fail with an ora-600. This applies

Posted in Bugs

And on the seventh day, God fiddled with His NLS settings

This would seem to be pretty authoritative: “And on the seventh day God ended his work which He had made; and he rested on the seventh day from all his work which He had made. And God blessed the seventh

Posted in Bugs, Character sets

Data block corruption cleared with alter system flush buffer_cache

So I had: ORA-08103: object no longer exists being reported on SQL affecting one application table. But that table existed ok in dba_tables, could be described ok, and selects restricted to its indexed columns returned data ok. Suspicion was some

Posted in Bugs, Rman

Bug? with wrong results from all_objects in stored plsql procedures

Wouldn’t it be nice if sql code produced the same result, regardless of whether it is inside a stored procedure or is a standalone plsql block? But that’s not what happens when the all_ views are used. Run this code

Posted in Bugs, Scripts

Pre 9202/9014: Advanced queuing runs away with server memory.

Using the below memory listing script, I found two databases with large PGAs. That was strange since pga_aggregate_target was unset, sort_area_size was just 64k, and there were very few sessions. Checking PGA at session level showed the QMN sessions had

Posted in Bugs, Scripts