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... >>> sfaroult_at_oriole.com 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: jhowerton_at_uabmc.edu
>

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: sfaroult_at_oriole.com 

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: ListGuru_at_fatcity.com (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: jhowerton_at_uabmc.edu

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: ListGuru_at_fatcity.com (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).