My Oracle Support Banner

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 MARCH 06, 2023

Applies to:

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


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.



Upgrade OID to


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.