Re: Reports 2.5 Unix runs for one ORACLE_SID, but not for another...

[Quoted] [Quoted] Are you using the same alias each time you run the report? You may need two reports, one for each database (alias)/

Mike Rose

mmrose_at_home.com

Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl> wrote in message news:7gsidd$dl4$1_at_weber.a2000.nl...
> Hi all,
>
> we are stuck with a strange problem. We have two databases running on a
Unix
> system. Both need to run a report that was created using Windows NT
> Developer/2000, Reports 2.5. If we set ORACLE_SID to one database, we can
run
> a report using, for example,
>
> r25runm my_report.rdf batch=yes ...
>
> This will prompt for the username and password, and runs fine. However,
when
> we issue a
>
> export ORACLE_SID=something else
>
> we can use SQL*Plus without problems (so I guess that proves that the
> ORACLE_SID is correct; TWO_TASK is not set), but cannot run the report.
> r25runm keeps prompting for the username and password.
>
> The table definitions are the same. And using Reports on WinNT also works
> fine. We even compiled the report explicitly connecting to the second
> database, but still it runs for the first database only, and not for the
> second. We have the same problem when trying to run r25convm to convert a
REX
> file to a RDF file.
>
> Any hint?
>
> Thanks,
> Arjan.
>
>
>
Received on Sat May 08 1999 - 23:52:04 CEST