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

Last updated on JUNE 18, 2017

Applies to:

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

Goal

OIM 11.1.2.3.0

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?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms