Stephane, Thanks for the info, an MVS error is interesting??? I'm not on MVS, the source database is V 9.2.0.1 (Solaris), the trigger is updating a V 8.1.7.2 (SGI) db via database link. I may need to increase the DISTRIBUTED_TRANSACTIONS init parameter. It is currently set at 46 and this db gets updated via db link from several other instances.
...JIM... >>> [EMAIL PROTECTED] 1/20/03 3:07:59 PM >>> James Howerton wrote: > > DBA's > > We are getting an intermittent ORA-11928 in conjunction with ORA-2063 > and ORA-4088 during a batch load that runs every 5 minutes. (See below) > It only happens once every few days and at different times. When we > re-run the transaction it loads correctly. > > I also get ORA-11928 in an OEM alert on another database from time to > time. The log shows: new connection cannot be established. ora-11928: > Message 11928 not found; product=rdbms; facility=ora. However I have > never been unable to establish a connection and I get an event cleared > the next time OEM checks??? > > ORA-11928 is not listed in the FM, Metalink, or google. > > Thoughts anyone. > > ...JIM... > > ERROR text... > > 20030118060618_healthquest_280 java.sql.SQLException: ORA-11928: > Message 11928 not found; product=RDBMS; facility=ORA 01/18/2003 > 06:11:07 > ORA-02063: preceding line from ADT_HRZ > ORA-04088: error during execution of trigger 'ADT.AE_AIS_TRG' > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: James Howerton > INET: [EMAIL PROTECTED] > Jim, If you have a look in oraus.msg (the primary source of information for error messages) you will find the following : / 11000 - 11999 Reserved for mvs sql*net errors LU 6.2 strikes again ? I guess that you must be accessing ADT_HRZ through a database link in your trigger. You should have some specific documentation for MVS / SQL*Net somewhere, the error message is likely to be explained into it. You may also find some useful information in sqlnet.log files you may collect here and there. -- HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
