Datatombraider's Blog


Patch 10110625 is broken

Filed under: Linux,Oracle — datatombraider @ 19:47

The post-install script of Patch 10110625 for is wrong. It sets current schema to SYS and calls rdbms/admin/prvtblib.plb, which recreates the body of package BSLN_INTERNAL without specifying the schema which end up in an error message because the package and it’s body are in schema DBSNMP, not SYS and recreating a body without a package header does not work.
Issue can easily be fixed by setting current_schema to DBSNMP in postinstall.sql.

The same patch for is correct and works fine.

Update: patch for was re-released, silently i might add, works now as it should.



  1. and then came back in Jul 2014 PSU ???

    Comment by Hazel — 2014/08/07 @ 16:40 | Reply

  2. It did? Didn’t notice, i’m already at Unfortunately It’s not the first time and will be certainly not the last time Oracle dropped a patch, by accident of course 😉

    Comment by datatombraider — 2014/08/09 @ 13:53 | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a free website or blog at