Oracle DBA – A lifelong learning experience

Posts Tagged ‘PSU 11.1.0.7.2’

PSU dependancy checking with ASM now enforced in 11G

Posted by John Hallas on January 28, 2010

ASM has to be equal to or higher than the highest version of the databases that are using it and the compatability settings have to be correct.

PSU 1 (Oct 2009) did not enforce that requirement. PSU 2 (Jan 2010) does check.

We determined this because we do not always apply the latest PSU against the ASM binaries but we do against the RDBMS code. Today the following sequence of events took place along with the associated error message.

Read the rest of this entry »

Posted in 11g new features, ASM, Oracle | Tagged: , , , , , | 3 Comments »

Identifying applied PSU patches

Posted by John Hallas on January 27, 2010

Metalink/My Oracle support note 988624.1 states that PSU 2 for 11GR1 was released on January 12th 2010. When applied, this takes the database version to 11.1.0.7.2. I say this but it is not apparent what version is installed.

The same note states that one of the advantages of the PSU releases is that “the version number is incremented so it is easier to tell what is installed”. Well I beg to differ and I will give you some examples to support my argument.

Firstly there is now obvious way to tell from the database what (database) version is applied. That includes looking at sqlplus, dba_registry, v$version, or the output from traces files. There might be options with taking traces or block dumps but that is hardly ” Read the rest of this entry »

Posted in Oracle | Tagged: , , , , , | 7 Comments »

 
Follow

Get every new post delivered to your Inbox.

Join 133 other followers