I have noticed a few instances recently of Discoverer 11g Plus failing to open or taking an awful long time to open.
In both of the cases where this has been reported to me by my clients, changing the plus communication protocol from Default to Tunneling did the trick.
To enable tunneling for use with Discoverer Plus, use this workflow:
Launch Enterprise Manager using something like: http://server.domain.com:7002/em
Enter your Username and Password. Username is typically Weblogic
Under Farm, on left-hand side, expand Discoverer and Discoverer(11.1.1.x.0)
In the Components window, highlight Discoverer Plus then click the Configure button
In the Communication Protocols window, click the Tunneling radio button (see below)
Click the Apply button
Shut Down the Discoverer service from the top link by clicking on Discoverer | Control | Shut Down - confirm the action
Restart the Discoverer service from the top link by clicking on Discoverer | Control | Start Up - confirm the action (sometimes you have to do this twice)
Michael is co-owner, CIO and principal consultant of Armstrong-Smith Consulting. He is the author of the Oracle Discoverer 10g Handbook. Armstrong-Smith specialize in everything Business Intelligence, including data warehouse and curriculum design. Michael is also the founder and owner of this blog and has over 25 years experience in applications development. He has presented at many conferences and is one of the founder members of Oracle's advisory board for business intelliegence. Appointed to be an Oracle ACE in 2006, Michael has been working in the Business Intelligence arena for over 12 years. Please contact me if you would like help with your BI installtion or are planning or implementing any BI initiative.
Join my LinedIn Group
Rod West
Rod has been using Oracle databases since 1985 and is principal consultant at Cabot Consulting in the United Kingdom. He specializes in Oracle Applications 11i / 12i as well as Oracle Discoverer
Fortune 500 and the Art of Execution
-
The Fortune 500 Companies 2018 rankings came out last week, and browsing
the list, the following random thoughts struck me about the list and the
technolo...
VAT Filter for WooCommerce Reports
-
Recently, upon a request by one of our customer, within the WooCommerce
Reporting plugin we updated the Sales by Country World Map Report to
include the op...