Query gets ORA-24777 using "dblink" when connecting from DB2 on AS400 through ODP4DRDA (Doc ID 1950085.1)

Last updated on JUNE 22, 2016

Applies to:

Oracle Database Provider for DRDA - Version 12.1.0.1 and later
Linux x86-64

Symptoms

After connecting from  DB2 on AS400 iSeries v7.1 through DP4DRDA 12.1.0.2  
to   Oracle Database 12.1.0.1 on Linux x86-64, query using "dblink"
(to Oracle 12.1 Database) gets "ORA-24777: use of non-migratable database link not allowed".
 
Connection, and query with dblink, works from  DB2 Connect EE on Linux x86-64  
through DP4DRDA 12.1.0.2 to   Oracle Database 12.1.0.1 on Linux x86-64.

DP4DRDA trace (ORACLE_HOME/log/diag/dps/(instance)/drdaproc/trace/) contains:

Entering SetEffectiveSchema at 2014-10-08 07:58:47.420415000
 ORATEST QSQL400.QSQL0000 DynamicRules: R, Stmt#0 Type: 101
 Applying DYNAMIC RULES: DRDAUSR
Exiting  SetEffectiveSchema, RC= 0 at 2014-10-08 07:58:47.420526000
MyMemoryAlloc(4200) => 0xfdced0
 OCIStmtPrepare2(0xfaa040[@0xfdd848],0xfad400,27,L=1) -> RC=0
 OCIStmtExecute(0xfaa040[0xfdd848]) -> RC=-1
Entering dpsaddoeDoOciError at 2014-10-08 07:58:52.481824000
From line 530
Oracle Errno = 24777
Entering dpsaddoEProcessOracleError at 2014-10-08 07:58:52.482937000
errP(59):ORA-24777: use of non-migratable database link not allowed

There are 12 tokens in the text.
MyMemoryAlloc(4280) => 0xfddf40
Parse error offset is 21
 OCIAttrGet(h0xfdd848,OCI_ATTR_STATEMENT) -> RC=0 (sqlstmtP=0xfdd7a8, len=27)
There are 6 tokens in the text.
 Stmt SQL(27) >>select * from dbname@linkp8<<
Oracle err=24777:"ORA-24777: use of non-migratable database link not allowed"
Unrecognized Oracle Error 24777; sending SQLCODE=-84, SQLSATE=42612

===

Updating Severity Code to 8
Entering WriteSQLCARD at 2014-10-08 07:58:52.484998000
Entering SQLCAWriteFifo at 2014-10-08 07:58:52.485045000
 SQLCA: sqlcode=-84 sqlstate=42612 sqlerrproc=DSNprsqs      

===

Entering dpsaaptwep_PpTaskWorkEntryPoint at 2014-10-08 07:59:26.789890000
CMN:RecvDSSChain DSS 0xf578a0
ALERT: short receive, 0 bytes, wanted 2
ALERT "hdr < 2" for PID 10971: REPLYCP-1232, RAISECP-1232, CODE-0040,
SVRCOD-0040
ALERT: short receive, 0 bytes, wanted 4
ALERT "hdr < 6" for PID 10971: REPLYCP-124C, RAISECP-114A, CODE-0001,
SVRCOD-0008

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms