Re: Has anyone ever seen ORA-11928 ???
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).
Has anyone ever seen ORA-11928 ???
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] 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).
Re: Has anyone ever seen ORA-11928 ???
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).