OID 11g ODS Schema is Not Updated when using non-SYS User as sysdba in Patch Set Assistant "SP2-0306: Invalid option" (Doc ID 1613310.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Internet Directory - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

We need to run Patch Set Assistant (PSA) to upgrade Oracle Internet Directory 11g (OID) Schema.

The PSA has a step for specifying DBA User to connect to Database.
When usingĀ non-SYS User as sysdba, PSA can not execute necessary scripts. PSA screen displays 'Successfully' message, but in fact, necessary SQL scripts are not executed. The schema is not updated correctly.

In this case, SQL*Plus (executed by PSA) can not connect to Database. The PSA output log (psa{timestamp}.out) reports the following messages.

$MW_HOME/oracle_common/upgrade/logs/psa{timestamp}.out:

Changes

Upgrade OID to 11.1.1.7.0.

Cause

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