Tuesday, June 24, 2008

cannot connect 11i using Discoverer/ADI/TOAD

Problem cannot login through applications user using ADI/Discoverer/TOAD :

the Oracle Applications Authentication mode is defined in the the Applications context file:
$APPL_TOP/admin/_.xml context file

Look for the following context variable: s_appserverid_authentication
By default, in E-Business Suite 11.5.10, this is set to SECURE. In previous E-Business Suite 11i versions, this was set to OFF.There are 3 Modes of authentication:

* ON : Partial
* SECURE : activates full server security (SECURE mode)
* OFF : deactivates server security

As a workaround, you may set this to OFF from the default of SECURE.Run Autoconfig to instantiate the changes.
Now you should be able to access E-Business Suite 11.5.10 databases using Discoverer/ADI/TOAD.

No comments: