RE: [sqr-users] ORA-1004 or ORA-3113

["Bruce Young" <b.young@cqu.edu.au>]

We use SQR 4.3.4 with PeopleSoft.  I re-linked it against Oracle 9.2 before 
using it and have had no issues.  PeopleSoft listed the relink as a required 
update for using oracle 9.2.

The relink was done using sqrmake.

hope this helps,

Bruce 

-----Original Message-----
From: George Jansen [mailto:GJANSEN@aflcio.org]
Sent: Thursday, 1 January 2004 4:42 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] ORA-1004 or ORA-3113


We have SQR 4.3.4 linked against Oracle 8.1.7 as our production SQR.
When I try to run it against Oracle 9.2.0, I get one of two errors:

  ORA-01004: default username feature not supported; logon denied

if I try to log in over a dispatched connection,

     ORA-03113: end-of-file on communication channel

if I try to log in over a dedicated connection (no @db in my
connectivity string, or with (Server=Dedicated) specified in my
tnsnames.ora).

With SQR 6.2 linked against Oracle 9.2.0, I can connect to 9.2 or 8.1.7
databases with no problem.

This strongly suggests, of course, that I should quit worrying and run
with 6.2; unfortunately I'm not ready to do that yet.

Has anybody else run up against this particular problem with SQR 4.3.4
and Oracle 9.2?

George Jansen

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users