ORA-6508 using Citrix/NT2000, Forms 6.0.8

2001-05-03 Thread Oweson Flynn

Hi,

(I apologise for cross-posting, but we are totally stuck ...)

Our Environment:
Oracle 7.3.4 database (on Solaris)
Forms 6.0.8
Citrix 1.8 Metaframe (on Win NT/2000 sp1)

We get 'ORA-06508   PL/SQL: could not find program unit being called' errors
on a regular basis recently.  We are trying very hard to isolate the cause,
without much luck.

We cannot re-produce the error consistently, and cannot cause it to happen
on demand - it seems to happen at random.

We have checked  - all stored program units (in the database) are valid and
accessible.
It has only been happening (or at least, it has only been noticed), since we
upgraded to Developer/6 and Citrix 1.8. (At least the upgrade to Oracle 8
hasn't happened yet, so IT can't be blamed ...)
We THINK that it only seems to happen when in a Citrix session - nobody can
recall it occurring using a 'direct' connection.
It happens in various forms, and other users can use those forms
simultaneously, without an error occurring.

We have been investigating things like the timeouts, memory leaks (in
Citrix) but without luck.

We logged a TAR, but as we can't give them a reproducible case, they have
closed it.

Citrix say it's an Oracle problem.

Microsoft say 'change to SQL Server' (just joking ...)

Anybody got any ideas / had a similar experience?


Regards
Oweson Flynn
--
Certifiable - Oracle DBA  Developer
The Flynn Consultancy
Tel: 082-600-7-006
Fax: (011) 782-9313
EMail: [EMAIL PROTECTED]




***

This message may contain information which is confidential and subject to legal 
privilege. If you are not the intended recipient, you may not peruse, use, 
disseminate, distribute or copy this message. If you have received this message in 
error, please notify the sender immediately by email, facsimile or telephone and 
return and/or destroy the original message.

***
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oweson Flynn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: ORA-6508 using Citrix/NT2000, Forms 6.0.8

2001-05-03 Thread Srini . Chavali


Oweson,
Check MetaLink for Doc # 1626.997.
It might help !
Srini Chavali
Oracle DBA
Cummins Inc




Oweson Flynn [EMAIL PROTECTED]@fatcity.com on 05/03/2001
10:51:12 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:



Hi,

(I apologise for cross-posting, but we are totally stuck ...)

Our Environment:
 Oracle 7.3.4 database (on Solaris)
 Forms 6.0.8
 Citrix 1.8 Metaframe (on Win NT/2000 sp1)

We get 'ORA-06508   PL/SQL: could not find program unit being called'
errors
on a regular basis recently.  We are trying very hard to isolate the cause,
without much luck.

We cannot re-produce the error consistently, and cannot cause it to happen
on demand - it seems to happen at random.

We have checked  - all stored program units (in the database) are valid and
accessible.
It has only been happening (or at least, it has only been noticed), since
we
upgraded to Developer/6 and Citrix 1.8. (At least the upgrade to Oracle 8
hasn't happened yet, so IT can't be blamed ...)
We THINK that it only seems to happen when in a Citrix session - nobody can
recall it occurring using a 'direct' connection.
It happens in various forms, and other users can use those forms
simultaneously, without an error occurring.

We have been investigating things like the timeouts, memory leaks (in
Citrix) but without luck.

We logged a TAR, but as we can't give them a reproducible case, they have
closed it.

Citrix say it's an Oracle problem.

Microsoft say 'change to SQL Server' (just joking ...)

Anybody got any ideas / had a similar experience?


Regards
Oweson Flynn
--
Certifiable - Oracle DBA  Developer
The Flynn Consultancy
Tel: 082-600-7-006
Fax: (011) 782-9313
EMail: [EMAIL PROTECTED]




***

This message may contain information which is confidential and subject to
legal privilege. If you are not the intended recipient, you may not peruse,
use, disseminate, distribute or copy this message. If you have received
this message in error, please notify the sender immediately by email,
facsimile or telephone and return and/or destroy the original message.

***
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oweson Flynn
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).