"SQL*Loader-128: unable to begin a session" Signalled In ODI When Using LKM File To Oracle(SQLLDR)
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Data Integrator - Version 10.1.3.2.0 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:
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
Million Knowledge Articles and hundreds of Community platforms