SAP Knowledge Base Article - Preview

2900425 - SLT replication from Oracle fails with ORA-01031: insufficient privileges - SAP Landscape Transformation Replication Server

Symptom

  • SLT replication of Oracle table fails.
  • LTRC > Application Logs shows the error:
        Failed to create logging table /1CADMC/00000XXX for table NODE
        Database connection: XXXX
        SQL code: 1.031
        SQL message: con=4(IPADDRESS:1521/DATABASE): ORA-01031: insufficient privileges

    SM21 search for ORA-01031:
        CREATE OR REPLACE FUNCTION IOV /*VERS1*/ (L IN NUMBER,V IN NUMBER) RETURN NUMBER IS $IF DBMS_DB_VERSION.VERSION>11 $THEN
        ...
        e: OCIStmtExecute() failed with -1=OCI_ERROR, SQL error 1031:
        ORA-01031: insufficient privileges
        Creating function IOV failed with SQL error 1031
        ORA-01031: insufficient privileges
        SQL function RTRIM2 does not exist (orc=1403).
        SQL function CONCAT3 does not exist (orc=1403).
  • Failed to create synonym
    ORA-01031: insufficient privileges


Read more...

Environment

  • SAP Landscape Transformation Replication Server
  • Oracle source

Product

SAP Landscape Transformation replication server 2.0 ; SAP Landscape Transformation replication server 3.0 ; SAP NetWeaver 7.4

Keywords

Oracle, source, database, ORA-01031, insufficient privileges , KBA , HAN-DP-LTR , Use CA-LT-SLT instead , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.