"SQL*Loader-128: unable to begin a session" Signalled In ODI When Using LKM File To Oracle(SQLLDR)

(Doc ID 2000954.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


When executing an Oracle Data Integrator (ODI) 12c Mapping (or 11g / 10g Integration Interface) loading flat file data to an Oracle database using LKM File to Oracle(SQLLDR), the Scenario crashes at the call sqlldr with the following error message:

SQL*Loader: Release - Production on Fri Apr 10 13:18:52 2015

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL*Loader-128: unable to begin a session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HPUX-ia64 Error: 2: No such file or directory

Note also that the generated Jython code from the call sqlldr Task indicates an empty string value for the oracle_sid variable:


if len('orcl')>0: oracle_sid = '@'+''


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