Datatombraider's Blog

2013/03/31

Patch 10110625 is broken

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

The post-install script of Patch 10110625 for 11.1.0.7 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 11.2.0.3 is correct and works fine.

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

Advertisements

2 Comments »

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

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

  2. It did? Didn’t notice, i’m already at 11.2.0.4. 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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.