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.
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.