Tuesday, October 12, 2010

Discoverer Installation Steps (Secure Env)


1) Install BI Tool (discoverer) using below link:
http://www.oracle.com/technology/software/products/ids/htdocs/101202winsoft.html
- Apply below patch to upgrade discoverer to latest version- 10.1.2.55.26:
https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=5983622&urlc=v1.2~4CCAD0AC87DF49E94C1BD6FEE81FDF1C1A863C2773B61A934293703FE27E60561C77DE
FCBE89C5319CE51B05760B7D0466210C3BFB0D480BE7CEAB2FE335769B6EAA830E420C75519C56667074E2C4129140BA774EC6BCB80AE5894843D82A872B730C33A77E7287704828F331EF8760804
5ACEDF264A13AE6D21842ECC8DB7B96AECD925C2EF112FE3B9C3E61B6A18B030E529B217647520668D6A364DA779A81C4ED7B88AEEDC42E2A13BF05ED38B489DE1B4CDD12EF0001D4FCFBF3598D33
6055C1C266851E2ED7FF726BD10497E7C707C0DA0DFABA579E207B4EB9087DBD02E9B7BEE815C3868D0CB5AD1F56DD2644AC7C34E8111C1D583017A65980EE6DCFE660C4E8E8DB31C9A1AE572A981
EA699941C057092A7BAB5F297FED7CAE1E2BEAD52E8A979889C6A1038580938ECDE276F48004F648A242AEB9BCC569EBC09CA82AEAAE7D6CD131D0AB8819B68AE023E4EF807E7EA5F4CD5EDE10660
5038A3314ED9C22808B44F30559D95B433C87F

2) Identify the Oracle Home for Discoverer
For example: You could find dis51usr.exe under the directory D:\oracle\BIToolsHome_1\bin. Then the Oracle Home is D:\oracle\BIToolsHome_1

3) Create a folder named "secure" in the ORACLE_HOME directory identified in step 2 (i.e. D:\oracle\BIToolsHome_1\Secure). Copy DBC files in this secure
folder

4) Discoverer requires Windows Environment variables to dynamically retrieve the location of the .dbc file on the PC.

5) Open Windows Control Panel and double click on the System icon.

6) Select the Environment tab and create two new System Variables
FND_SECURE = ORACLE_HOME\Secure
FND_TOP= ORACLE_HOME
NOTE: The Oracle Home is the one identified in step 2.

7) Restart the PC and you should be able to connect to Discoverer in an Oracle Applications mode EUL in secure mode.
/

No comments:

Post a Comment