Question: I an getting the
ORA-26713 error when I run the Streams apply on a remote
MS-SQL database. How do I resolve the ORA-26713?
what can cause ORA-26713 error of apply process applying
changes to SQL Server database through Oracle Database
Gateway, if object to be modified exists and accessible from
Oracle database for streams admin user?
Answer: First, I would check my notes
on creating a database link between
Oracle and SQL Server. Here
are
detailed checklists for heterogeneous database connections
to SQL Server.
- Trace files(s) -
Check your trace file for details on this error
- MOSC - Open an SR on
MOSC, you may be seeing a bug. Note this bug and note
relating to the ORA-26713 and Streams:
- Bug 8560780 -
ORA-26713 DML handler procedure not invoked by apply process
for non Oracle Database.
- Note:
955276.1 -
DML Handler not invoked by Apply process when using
ORACLE to NON-ORACLE Streams setup [ID 955276.1]
- Error details - Use
oerr to look-up the error:
ORA-26713: remote object does not exist or
is inaccessible
Cause: Streams
replication could not access the named table or view at a
remote database to apply changes.
Action: Confirm that the
given remote table or view exists and is accessible through
the given database link.
When using a Heterogeneous Services
database link to access a non-Oracle system, it may be
necessary to check administration details for network
connections at the non-Oracle system.
