Discoverer Desktop/Administration Edition Invalid username/password; Logon Denied

Unable to connet to: user@database
Failed to connect to database Ora-01017: Invalid username/password; Logon Denied

Discoverer Desktop/Administration Edition

Depending on your discoverer version, follow the appropriate steps in this table:

Discoverer Version	Step	Actions
4.1	1	Ensure that required patches have been applied for Discoverer Desktop/Administrator. The latest patch information is listed in Note 139516.1, Discoverer 4i with Oracle Applications 11i under Section 5: Installation Tasks.
	2	Identify the Oracle Home directory on the Windows PC. You can search for dis4usr.exe. For example: The dis4usr.exe may be in a directory like C:\Orant\bin. Thus the Oracle Home is C:\Orant.
	3	Create a folder named "secure" in the ORACLE_HOME directory identified in step 2 (i.e. C:\Orant\Secure).
	4	Download the .dbc files from the Oracle Applications Database server and place them in the "secure" directory you created (above). The .dbc files are located in the $FND_TOP/secure directory. The default naming for the .dbc file is described in Note 353605.1, DBC File Naming Conventions for Discoverer Connections to Oracle Applications 11i and 12i.
	5	Discoverer requires Windows Environment variables to dynamically retrieve the location of the .dbc file on the PC.
	6	Open Windows Control Panel and double click on the System icon.
	7	Select the Environment tab and create two new System Variables FND_SECURE =\secure FND_TOP= NOTE: The Oracle Home is the one identified in step 2.
	8	Restart the PC and you should be able to connect to Discoverer in an Oracle Applications mode EUL in secure mode.
10gR1 (9.0.4)	1	Ensure that you have applied the most recent certified patch as listed in  Note 257798.1, Discoverer 10g (9.0.4) with Oracle Applications 11i , Section 5 Installation Tasks.
	2	Identify the Oracle Home for Discoverer by searching for the dis51usr.exe file. For example: You could find dis51usr.exe under the directory D:\IDS 904\bin. Thus the Oracle Home is D:\IDS 904
	3	Now follow step 3 through 8 as described above under Discoverer 4.1 section.
10gR2 (10.1.2) and 11g (11.1.1)	1	Ensure that you are using the Oracle Business Intelligence Tools 10.1.2 or later. See Applicable document based on your Oracle Applications and Discoverer versions:  Note 313418.1, Using Discoverer 10.1.2 with Oracle E-Business Suite 11i, Section 5: Installation Tasks for latest patch recommendations  Note 373634.1, Using Discoverer 10.1.2 with Oracle E-Business Suite Release 12,  Section 5: Installation Tasks for latest patch recommendations Note 1073963.1, Using Discoverer 11.1.1 with Oracle E-Business Suite Release 11i, Section 5: Installation Tasks Note 1074326.1, Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12, Section 5: Installation Tasks
	2	Identify the Oracle Home for Discoverer. You can search for dis51usr.exe. For example: You could find dis51usr.exe under the directory D:\oracle\BIToolsHome_1\bin. Thus the Oracle Home is D:\oracle\BIToolsHome_1.
	3	Now follow step 3 through 8 as described above under Discoverer 4.1 section.