ORA-28500 Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-28500 Error

Hybrid View

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    ORA-28500 Error

    Hi,

    I'm getting the following the error while the following query is being executed,

    SELECT M_V.OPERATION, M_V.COMBINATION, M_V.VDS, M_V.VDS_6, M_V.FLAG,
    M_V.FRANCHISE, M_V.WARRANTY, M_V.SUBMISSION, M_V.MULTI_HOUR, M_V.YEAR, M_V.YEAR_ALPHA, M_V.SOURCE, M_V.ACTION, M_V.HOUR, M_V.ACTIVITY_DATE,
    M_V.WMI FROM M_V
    Code:
    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
    DSNT408I SQLCODE = -924, 
    ERROR:  DB2 CONNECTION INTERNAL ERROR, 0001, 0100,
             00F30018
    ORA-02063: preceding 3 lines from DB2.WORLD
    In this query M_V is a view which access DB2 tables using the Database link DB2.WORLD.
    Now I checked the Database link and by giving select * from M_V, it is giving the result.
    This problem occurs quite often even when the DB2 db is up and running and there is no connection
    problem.Can anyone tell me what could be the root cause of this problem? My database is 9iR2 and OS is HP_UX.

    Thanks...

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    So the query works consistently in DB2? It seems that either
    DB2 is having issues or you have s network timeout issue.
    this space intentionally left blank

  3. #3
    Join Date
    Apr 2009
    Posts
    10
    Check in the alert log at your end for any entries. Also check the listener log at the source db if you can.

  4. #4
    Join Date
    Apr 2009
    Posts
    10
    Check in the alert log at your end for any entries. Also check the listener log at the source db if you can.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width