The issue is something else?I will figured out the cause.

Thanks for yor reply

7399:OLEDB provider'MSDORA' reported an error

EXEC sp_addlinkedserver

@server = 'DDDD_sql', using --- Priovder

@srvproduct = 'Oracle',

@provider = 'MSDAORA',

@datasrc = 'ORCL'

GO

Done but still facing the issue.

EXEC sp_addlinkedserver...

Thanks