Re: Help Forms Servers -WinNT
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)
- 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) - Install the listener as a service c>rwmts60 -install rpt6isrv tcpip You can uninstall a previous service via: c>rwmts60 -uninstall rpt6isrv
- 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