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

Mike Rose wrote
> When I mentioned 'alias' I mean the Oracle SQL*Net alias that has been
> established in the LISTENER.ora file on the server and MUST be in your
> TNSNAMES.ora file.

Thanks. By now I am sure it has something to do with SQL*Net versus Net8, so you are right about the aliases that need to be there.

> Imagine using SQL*Plus to report from each database (SQL*Net alias):
>
> sqlplus USER/PASSWORD_at_ALIAS1
> Execute the Report...
>
> sqlplus USER/PASSWORD_at_ALIAS2
> Execute the Report...

True, but in my case for the second report, imagine the following:

  sqlplus USER/PASSWORD_at_ALIAS2
  Enter user-name: user_at_alias2
  Enter password: password
  Enter user-name: user/password_at_alias2

etc., or in real, for the first database the expected behavior:

  export ORACLE_SID=db1
  r25runm xyz userid=scott/tiger batch=yes

  REP-0110: Unable to open file 'xyz'.
  REP-1070: Object store failure occurred.
  REP-0110: Unable to open file 'xyz'.  

but not for the second:

  export ORACLE_SID=db2
  r25runm xyz userid=john/doe batch=yes
  Enter Username:

john/doe_at_db2 works fine for SQL*Plus. Well, another day to find the solution; I'll let the group know.

Arjan. Received on Mon May 10 1999 - 08:49:56 CEST