Re: Oracle Report Server and Web Access

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Wed, 22 Dec 1999 15:36:24 GMT
Message-ID: <3860EFF8.47B4ABEA_at_edcmail.cr.usgs.gov>


You might also have a problem with SP6. I'm running on NT 4 SP 5 without any problems. I have my web server listening on port 90 (which is not the default). I did this because we have another web server running on the same machine using the default port. The web server port is not the same port listed in your TNSNAMES file. I used port 1949 for the reports server service. And like you said, you may have a problem with your Client version. I'm using Net8 on my system without any problems. Short of those tidbits, about the only other thing I can suggest is to call Oracle Support.

HTH,
Brian

"Jonathan D. Herridge" wrote:
>
> I'm on NT 4.0 sp 6
>
> I have the entry in tnsnames.ora on one line only in the format you described, but
> still no dice. When I installed Oracle WebServer, I told it to listen to port
> 88. My other applications connect to the database sever through a specific
> port. Those are the only two ports that I explicitly know of.
>
> It has recently come to my attention that the version of Oracle Client that I have
> installed may not be compatible with the version of Developer/2000 that I have.
> But I hope that isn't the problem. I guess I'm still at the drawing board.
>
> Brian Peasland wrote:
>
> > It is not the same port as your SQL*Plus connections. In my TNSNAMES.ORA
> > file, I have an entry similar to:
> >
> > reportserver.world =
> > (ADDRESS=(PROTOCOL=TCP)(Host=123.456.789.123)(Port=1949))
> >
> > I used the default port (1949) in my configuration. This entry must
> > appear on ONE LINE ONLY! And you'll probably need to use the IP number
> > for the host. After you put this entry in TNSNAMES, create the NT
> > Service.
> >
> > Another thought. What version of NT are you using and with what Service
> > Pack? You might have an incompatibility with NT SP and the version of
> > Developer Server.
> >
> > HTH,
> > Brian
> >
> > "Jonathan D. Herridge" wrote:
> > >
> > > I've narrowed my problem down to REP-0186 as the error. This means that the
> > > daemon failed to listen to the port. As far as I can tell the port is
> > > correct in the tnsnames.ora file. It is the same port that I use with my
> > > SQL Plus connection. Any ideas?
> > >
> > > "Jonathan D. Herridge" wrote:
> > >
> > > > I have installed this before, but cannot find the documentation. I have
> > > > installed Developer/2000 Reports and all the components. I am running
> > > > Oracle Web Server with the r25ows web cartridge set up. What I am
> > > > having trouble with is installing/configuring report server.
> > > >
> > > > According to /ORANT/REPORT25/DOC/R25OWS.HTM, I am supposed to install
> > > > the multi-tier server. So following the instructions outlined in
> > > > /ORANT/REPORT25/DOC/r25mtsus.htm, I installed teh multi-tier server with
> > > > the command: r25mts32 -install reportserver tcpip.
> > > >
> > > > Did the post-intallation steps, but when trying to start the service, I
> > > > get an error, "The Developer/2000 Reports Server [reportserver] service
> > > > returned service specific error 186." Now that might be specific to the
> > > > service, but I have no idea what error 186 is.
> > > >
> > > > Did I miss a step or do something else wrong? Any input is appreciated.
> > > >
> > > > --
> > > > Jonathan D. Herridge
> > > > Programmer
> > > > InfoWare, Inc.
> > > > http://www.infoware.com/
> > > >
> > > > ----------------------------------------------------------------------
> > > > The information attached is confidential and only intended for use by
> > > > the recipient party and in certain cases the associated firm where
> > > > recipient is currently employed. Any other use is prohibited. All
> > > > documents carry confidential notices and may not be altered.
> > > > ----------------------------------------------------------------------
> > >
> > > --
> > > Jonathan D. Herridge
> > > Programmer
> > > InfoWare, Inc.
> > > http://www.infoware.com/
> > >
> > > ----------------------------------------------------------------------
> > > The information attached is confidential and only intended for use by
> > > the recipient party and in certain cases the associated firm where
> > > recipient is currently employed. Any other use is prohibited. All
> > > documents carry confidential notices and may not be altered.
> > > ----------------------------------------------------------------------
>
> --
> Jonathan D. Herridge
> Programmer
> InfoWare, Inc.
> http://www.infoware.com/
>
> ----------------------------------------------------------------------
> The information attached is confidential and only intended for use by
> the recipient party and in certain cases the associated firm where
> recipient is currently employed. Any other use is prohibited. All
> documents carry confidential notices and may not be altered.
> ----------------------------------------------------------------------
Received on Wed Dec 22 1999 - 16:36:24 CET

Original text of this message