My Oracle Support Banner

OID 10g Upgrade Fails at SSOCA With "Error While Adding to the Group: return code-2" (Doc ID 817343.1)

Last updated on MARCH 13, 2019

Applies to:

Oracle Internet Directory - Version 10.1.2 to 10.1.4 [Release 10gR2 to 10gR3]
Oracle Application Server Single Sign-On - Version 10.1.2 to 10.1.4 [Release 10gR2 to 10gR3]
Oracle Fusion Middleware - Version to [Release AS10gR2]
Information in this document applies to any platform.


During an upgrade of a Distributed OID environment, from to 10.1.4, SSOCA upgrades the database from to, then upgrades the first OID/SSO node. At this point the OUI fails in the SSO Upgrade Assistant stage with the following:


OracleAS Single Sign-On Upgrade Assistant
Release 10g (

Upgrade Started: Tue Apr 28 17:05:32 HKT 2009
Upgrade Log File: /program/oracle/product/10.1.4/idm/sso/log/ssoupg.log

Configuration assistant "Single Sign-On Upgrade Assistant" failed


INSTALL_ACTION: SSOConfigAssistant: Invoking sqlplus
/program/oracle/product/10.1.4/idm/bin/sqlplus orasso/*****@cn=orcl,cn=oraclecontext

SQL*Plus: Release - Production on Tue Apr 28 16:48:16 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> Connected.
1 row updated.
PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

1 row updated.

Commit complete.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release - 64bit
With the Partitioning, OLAP and Data Mining options

[SSOCA-UPG] SSO mid-tier configuration ended at: Tue Apr 28 16:48:16 HKT 2009
[SSOCA-UPG] Calling update verifier services method...
[SSOCA-UPG] Adding SSO identity to the following group...
[SSOCA-UPG] cn=verifierServices,cn=Groups,cn=OracleContext
[SSOCA-UPG] ERROR: Error while adding to the group: return code-2
[SSOCA-UPG] ERROR: Possible cause: unknown
[SSOCA-UPG] Updating SSO status...
[SSOCA-UPG] Updating SSO status...
[SSOCA-UPG] Updating SSO status...
[SSOCA-UPG] Upgrade status is set to INVALID.

Two midtiers ("abc1" and "abc2") with loadbalancer virtual hostname "abc0" and Metadata Repository on machine "oid0" with virtual host name "xyz".

Steps to Reproduce


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.