Single-Sign On Configuration Assistant Fails to Update SSO Schema Due to ORA-12154 When Patching OracleAS 10g Identity Management
(Doc ID 788269.1)
Last updated on JULY 08, 2024
Applies to:
Oracle Fusion Middleware - Version 10.1.2.2.0 to 10.1.2.3.0 [Release AS10gR2]Oracle Fusion Middleware - Version 10.1.4.0.1 to 10.1.4.3.0 [Release AS10gR2 to AS10gR3]
Information in this document applies to any platform.
Symptoms
An OracleAS 10g Rel 2 or Oracle Identity Management 10.1.4 generic patchset has been successfully applied.
Post install, however, it is apparent that the SSO schema has not been updated. For example a SQL query against the app_registry view shows the difference:
An analysis of the installActions.log file shows that while the Single Sign-On Configuration Assistant reported back a "succeeded message", in fact part of it has not run e.g
INSTALL_ACTION: SSOConfigAssistant : Invoking sqlplus
<ORACLE_HOME>\bin\sqlplus orasso/*****@cn=iasdb,cn=oraclecontext @<ORACLE_HOME>\sso\admin\plsql\sso\ssopachk.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Feb 13 16:48:18 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SQL> SP2-0640: Not connected
SP2-0670: Internal number conversion failed
Usage: { EXIT | QUIT } [ SUCCESS | FAILURE | WARNING | n |
<variable> | :<bindvariable> ] [ COMMIT | ROLLBACK ]
ERROR: SSOConfigAssistant: Patch can not be installed.
INSTALL_ACTION: SSOConfigAssistant: Skipping SSO server patch
End output from spawned process.
----------------------------------
Configuration assistant "Single Sign-On Configuration Assistant" succeeded
In conclusion, the SSO Configuration Assistant skipped the SSO server patch instead of reporting an exception or halting the patchset installation.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |