My Oracle Support Banner

Enable SQL prompt output display for Mandatory DB patch in patch 24927639 (Doc ID 2234192.1)

Last updated on MARCH 04, 2019

Applies to:

Identity Manager - Version to [Release 11g]
Information in this document applies to any platform.



Attempting to manually install the OIM patch that is part of the OIM patch that is in Suite BP 170117 (patch 25038775). 

In the Suite BP 170117 patch 25038775/iamsuite/patch/oim for patch 24927639, there is a Mandatory database patch oim11gr2ps3_initrans_postinstallation.sql that has to be applied per 13 Applying the Database Patch (Mandatory) in the ReadMe.html for patch 24927639.

When it is run, it appears to be successful per the following:
SQL> @oim11gr2ps3_initrans_postinstallation.sql
SP2-0265: serveroutput must be set ON or OFF
PL/SQL procedure successfully completed.

However, the documentation shows an output from the SQL prompt which was not displayed.

A look through MOS shows to set serveroutput to either off or on, but which is needed for the oim11gr2ps3_initrans_postinstallation.sql to display the output shown in the ReadMe.html?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.