"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 10.1.3.2.0 and later
Information in this document applies to any platform.

Symptoms

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 10.2.0.4.0 - 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:

...
oracle_sid=''

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

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