Tuesday, December 18, 2007

Connect Oracle Discoverer Administrator to 11i DB

Oracle Discoverer Administrator is a client tool. After it is installed on the PC, there are setup steps for you to connect it to the 11i database using 11i account and password. One of the steps (and maybe the last step if you have trouble in making the connection) is to create a system variable FND_SECURE on your PC and point it to the folder where you have saved the .dbc file(s).

Other steps (for Discoverer Administrator client version 10.1.2.48.18) include:
. Copy hostname_sid.dbc file from $FND_TOP/secure on the MT server to a folder on your PC.
. Discoverer Administrator --> Tools --> Connection --> Check "Connect to both standard and application EULs", and fill two fields there.
. Test your TNSNAME configuration by using SQL*Pluse to connect a database account.

No comments: