Home » RDBMS Server » Networking and Gateways » ORA-28500 Error
ORA-28500 Error [message #398101] Wed, 15 April 2009 04:23 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
Hi,

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

Quote:
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


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...
Re: ORA-28500 Error [message #398143 is a reply to message #398101] Wed, 15 April 2009 06:18 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Try

select * from table_name@db_link


let us know output of the above query.

Babu
Previous Topic: parsing tnsnames.ora
Next Topic: User Disconnected after 5min (merged)
Goto Forum:
  


Current Time: Tue Mar 19 04:26:40 CDT 2024