Configuring - PowerPoint PPT Presentation

Loading...

PPT – Configuring PowerPoint presentation | free to view - id: 326e3-N2JhN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Configuring

Description:

Discoverer 9i Plus/Viewer. bundled with Oracle 9i database ... Discoverer Plus files are in iAS_HOME /Apache/Apache/htdocs/discwb4/scripts ... – PowerPoint PPT presentation

Number of Views:136
Avg rating:3.0/5.0
Slides: 36
Provided by: BS96
Category:
Tags: configuring | plus

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Configuring


1
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Srini Chavali
  • Oracle DBA
  • Cummins Inc
  • srini.chavali_at_cummins.com
  • NCOAUG Training Day - Mar 3, 2003

2
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Preliminary stuff
  • This is a technical presentation !
  • This is not a Discoverer tutorial !
  • This presentation is not about BIS !
  • For those still here, this presentation will
    cover -
  • Discoverer Versions Nomenclature
  • Required patches and setup steps (Solaris)
  • Overview of Discoverer usage

3
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Cummins background
  • Manufacturer of diesel engines, power gensets,
    filtration systems, turbochargers more .
  • Formed in 1919, now in Americas, Asia, Europe
    Australia
  • Brand names include Onan, Fleetguard, Holset,
    Cummins
  • Approx 26,000 employees worldwide
  • Many financials and manufacturing apps
    installations (10.7, 11.0.3, 11.5.5)

4
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • My background
  • One of many Apps DBAs in Cummins
  • Working with standard Oracle databases since 1993
  • Working with Apps databases since 1998
  • Experience with 10.7 (Char/SC), 11.0.3, 11.5.5 -
    11.5.8
  • My responsibility is primarily with Financials

5
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • 4i Versions Nomenclature
  • Discoverer Admin (client/server)
  • Discoverer User/Desktop (client/server)
  • Discoverer Plus (Java)
  • Discoverer Viewer (HTML)
  • Discoverer 9i Plus/Viewer
  • bundled with Oracle 9i database

6
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
7
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Pre-requisites
  • 9iAS version 2 (1.0.2.2.2)
  • Fresh 11.5.7 install
  • If upgraded to 11.5.7, requires tech stack
    upgrade (or separate 9iAS stack)
  • Netscape 4.7x or IE 5.5 (faster!) on client
  • Not certified with Netscape7 yet

8
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Items noted with a ! in this presentation are
    not well documented

9
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Patches
  • MetaLink Doc 139516.1 (27 pages)
  • Doc includes lot of info, incl -
  • upgrading from previous versions of Discoverer
  • BIS setup configuration for Discoverer
  • special considerations for NT / Compaq TRU64
  • setting up standalone 9iAS, if necessary

10
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Patches (contd)
  • This presentation is based on Discoverer 4.1.44
    on Solaris (patch 2587539) - YMMV
  • Before applying this patch, verify files reg.tmp
    and varfile.tmp in lt806_ORAHOMEgt/orainst have
    correct entries (especially true if this is a
    cloned instance) !

11
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Patches (contd)
  • Patch will backup and overwrite 3 config files,
    take manual backups anyway before applying patch
    (full path mentioned in Doc)
  • htmlvars.js
  • disco4iv.xml
  • discwb.sh
  • Patch takes less then 5 minutes to apply

12
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Patches (contd)
  • Discoverer Plus files are in ltiAS_HOMEgt/Apache/Apa
    che/htdocs/discwb4/scripts
  • Discoverer Viewer files are in ltiAS_HOMEgt/Apache/A
    pache/htdocs/disco4iv/html
  • ORAHOME files are in lt806_ORAHOMEgt/discwb4/util
  • Verify port numbers and SID entries in these
    files (especially if a cloned instance) !

13
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Re-apply config settings
  • Re-applying config setting using Autoconfig did
    not work - used manual method.
  • Verify TNS_ADMIN, FND_TOP and INSTANCE_NAME
    entries in lt806_ORAHOMEgt/discwb.sh file
  • Edit lt806_ORAHOMEgt/util/pref.txt as indicated in
    Doc
  • Also update the MachineIPs parameter in pref.txt,
    if necessary !

14
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Re-apply config settings (contd)
  • Run script lt806_ORAHOMEgt/util/startall.sh to
    start discoverer services
  • Run script lt806_ORAHOMEgt/util/applypreferences.sh
    (to apply preferences in pref.txt)
  • Then check file lt806_ORAHOMEgt/util/error.txt for
    errors

15
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Re-apply config settings (contd)
  • Run script lt806_ORAHOMEgt/util/registerall.sh to
    register preferences
  • Check log files in lt806_ORAHOMEgt/util for errors
  • Refer MetaLink Doc 198279.1 for further
    troubleshooting info
  • Running the above scripts is a one-time
    requirement

16
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Starting Stopping Discoverer Services
  • To start discoverer services -lt806_ORAHOMEgt/util/s
    tartall.sh
  • To stop services -lt806_ORAHOMEgt/util/stopall.sh
  • Incorporate in your instance startup shutdown
    scripts

17
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Running 4i Plus
  • URL is http//ltserverportgt/discwb4/html/english/w
    elcome.htm
  • Assumes Jinitiator 1.1.8.16 already installed
  • First access will download 8MB of jar files
  • Subsequent accesses will be faster

18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Running 4i Plus
  • Functionality same as Desktop, except -
  • No PDF output option available
  • Workbooks can only be saved to database
  • Workbooks can be shared to specific users or
    responsibilities
  • Response time comparable to Desktop
  • Need beefy client (gt500Mhz, gt256MB)

29
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Running 4i Viewer
  • URL is
  • http//ltserverportgt/discoverer4i/viewer
  • Pure HTML, no plug-in or JVM necessary

30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
(No Transcript)
34
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • Running 4i Viewer
  • Can only run workbooks stored in the database
    that you have been given access to
  • Cannot create new workbooks
  • Product is meant for the masses -
  • every user will need an Apps login
  • built-in security
  • Response time noticeably worse than Desktop/Plus
    - tuning opportunities ??

35
Configuring Using Discoverer 4i Plus/Viewer
with 11.5.7 Apps
  • End game
  • OK ! Time to wake up now !
  • Questions ??
  • srini.chavali_at_cummins.com
About PowerShow.com