1.Introduction to Discoverer and Connecting to it.

#Introduction:

Discoverer is reporting tool used to support organizational decisions and data will show in the form of excel format.

Versions:4i,6i,9i,10g,11g

#Connection Steps:

1.Take a copy of TNSNames.ora file for every instance we have separate TNS Names entry in tnsnames.ora file

2. we need to keep in network/admin folder in the discoverer home

Ex:Path : D:/Discoverer/Network/Admin

For every instance TNS Entry is same,only 'host name' and 'port number' and 'service name id' will vary. In place of host name,port number we can see the server id address also some times.

After Every Cloning the '.dbc' files will change , we need to download fresh '.dbc' file related to any instance and keep into secure folder

Set the environment variable initially

We usually download the .dbc files from unixbox by using any FTP(ex: putty,filezillah,toad..etc)

EUL Settings:

Oracle Discoverer administrator->tools->options->choose the option

*connect to both standard and application EUL's gateway

userid/pwd(applsys/pub)

Foundation Name: APPS