Re: Help Forms Servers -WinNT

From: Eric Givler <egivler_at_flash.net>
Date: 2000/06/30
Message-ID: <Xf575.2369$7%3.202679_at_news.flash.net>#1/1


Here are the reports server setup notes I promised. IF you have any problems, let me know, or revise them and send them back.

Steps to install dev6i reports server (cgi version)

  1. setup a listener in tnsnames.ora ie. rpt6isvr.world=(address=(protocol=tcp) (host=10.10.30.214)(port=1949))
    (manually edit your tnsnames.ora file. Once this is done, you cannot use
    Sql*net easy config)
  2. Install the listener as a service c>rwmts60 -install rpt6isrv tcpip You can uninstall a previous service via: c>rwmts60 -uninstall rpt6isrv
  3. Go into control panel services, and find the service "Oracle Reports Server - <yourname>". From the startup dialog box, select This Account on the logon As section and type in your operating system username and password. You need to have a valid account that also has a default printer established.)

 Also, set the service to startup automatically.

4. Once started for the first time, the service creates the file: $oracle_home\report60\server\<yourname>.ORA This is the parameter file for this
service. You can edit these and then "bounce" the service for the changes to take
effect.

 If you open Event Viewer and find that the service terminated with an Unspecified
Error #186, it means you forgot to do STEP #1 above.

5. Edit the configuration file (from step 4)  Set cachedir, sourcedir, tempdir

   Mine now looks like this:

maxconnect=20
cachedir="D:\ORA6IDEV\REPORT60\server\cache" tempdir="C:\TEMP"

sourcedir="C:\INETPUB\WWWROOT\DEV6I"
cachesize=50
minengine=0
maxengine=1

initengine=0
maxidle=30
security=1
englife=50

<stop and restart the server>

5a. Make sure rwcgi60.exe is in your Web server script directory or another virtual
directory. Forms has you create dev60cgi, and that's where it resides after an install.
(D:\ORA6IDEV\TOOLS\web60\cgi)

6. add reports60_webloc to registry (hlm->software->oracle) and point it to a virtual
directory. set reports60_webloc_translated to the actual path, if the web server and the
reports server are on different physical machines.

7. add the virtual path, from 6, ie. /reports_cache to your web server's directories.

<stop and restart the server?>

8. Test that a report runs from the command line version. Copy the test.rdf from $ora_root\report60. Type: C>r60cli server=<svrname> report=<rpt> userid=<un/pw_at_db> destype=cache desformat=html

Verify that output is created in your cache directory.

9. Copy the web document, runrep.htm, or run it out of http://yourserver/<dev60html>
which points to D:\ORA6IDEV\TOOLS\web60\html. Type in the parameters and hit
submit. Make sure the Reports Server matches, along with your web host
(computer name) and port (web server port, not reports server port). A new
window should open which shows the report. The URL in the top should be similar
to the following:

http://fuji/dev60cgi/rwcgi60.exe?server=Rpt6iSVR&report=test.rdf &userid=egivler/hobknob_at_test&destype=cache&desformat=HTML Received on Fri Jun 30 2000 - 00:00:00 CEST

Original text of this message