Category Archives: Bugs

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

Posted on 5 March 2009 by Andrew Fraser

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 … Continue reading →

Posted in Bugs | 1 Comment

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

Posted on 2 May 2007 by Andrew Fraser

Thanks to Chris Carr for pointing out this: If you are upgrading or patching to 10.2.0.3 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 … Continue reading →

Posted in Bugs | 3 Comments

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

Posted on 25 April 2007 by Andrew Fraser

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 … Continue reading →

Posted in Bugs, Character sets | 4 Comments

Data block corruption cleared with alter system flush buffer_cache

Posted on 19 April 2007 by Andrew Fraser

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 … Continue reading →

Posted in Bugs, Rman | 2 Comments

Bug? with wrong results from all_objects in stored plsql procedures

Posted on 2 March 2007 by Andrew Fraser

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 … Continue reading →

Posted in Bugs, Scripts | 3 Comments

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

Posted on 15 January 2007 by Andrew Fraser

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 … Continue reading →

Posted in Bugs, Scripts | Leave a comment