Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Forms Servers -WinNT
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)
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
<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 CDT