I have an application and when data in a table is updated a trigger is executed and sends information from oracle to sql server 2005. This was working correctly and all of a sudden I began seeing the following error message:
Detail Message=java.sql.SQLException: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][S1000] General error in nvITrans_BeginT - rc = -1. Please refer to the log file for details. ORA-02063: preceding 2 lines from KANCARD
I'm not sure why this error occurred or how to correct it. Help is greatly appreciated as this is in our production environment.
Veeam is a VMworld 2017 US & Europe Platinum Sponsor. Enter the raffle to get the full conference pass. Pass includes the admission to all general and breakout sessions, VMware Hands-On Labs, Solutions Exchange, exclusive giveaways and the great VMworld Customer Appreciation Part
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.