My Oracle Support Banner

Oracle9ias Single Sign-On Server Status Is Down After Upgrade to iAS (Doc ID 262838.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Application Server Single Sign-On - Version 9.0.4 to 10.1.2 [Release 10gR1 to 10gR2]
Information in this document applies to any platform.
This problem can occur on any platform.


After patchset version Oracle9iAS upgrade SSO no longer works.
The EM website shows SSO as down.
No one can login to any SSO applications.
All attempts to login to SSO result in the error:

HTTP error 503 Service Temporarily Unavailable

After enabling SSO debugging the following is found in the orasso.wwsso_log$ table:

   get_ls_cofiguration:  error NO_DATA in wwsso_ls_configuration_info$

When logging into sqlplus as ORASSO the following query returns 0 rows:
SQL> select * from wwsso_ls_configuration_info$;

When logging into sqlplus as SYS the following query returns 1 row:
SQL> select * from orasso.wwsso_ls_configuration_info$;


Recently upgraded to Oracle9iAS


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.