DSXchange

Hi,
I have installed Datastage 11.3 on Solaris. All the tiers and Oracle DB are installed on same machine and this is for the development environment.
I have made the configuration in .odbc.ini and uvodbc.config and tested the connection successfully with command line.
Modified the dsenv file to point LD_LIBRARY_PATH to oracle libraries and
ORACLE_HOME=<oracle home directory>; export ORACLE_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

I can load the table definitions also using import ODBC Table definitions. However when I test a job extracting data from oracle database, the job fails with error:
"Parallel job reports failure (code 256)":
<
Event: Starting Job OracleTest.
Event: Environment variable settings: (...)
Event: Parallel job initiated
Event: Parallel job default NLS map UTF-8, default locale OFF
Event: main_program: IBM InfoSphere DataStage Enterprise Edition 11.3.0.7169 (...)
Event: main_program: The open files limit is 256; raising to 65536.
Event: main_program: conductor uname: -s=SunOS; -r=5.10; -v=Generic_147147-26; -n=SGJ-SUN-SOLARIS.GEO.CORP.HCL.IN; -m=sun4v
Event: main_program: orchgeneral: loaded (...)
Event: Parallel job reports failure (code 256)
Event: Job OracleTest aborted.>

Please suggest what am I missing?

Oracle doesn't use ODBC. Can you connect to Oracle (or at least tnsping your instance) from the ETL server? Is your tnsnames.ora file setup correctly? Suggest you verify your native sqlnet connectivity first.

Hi,
ORACLE_HOME environment parameter was pointing to wrong directory, hence encountered that error. After pointing it to correct ORACLE_HOME directory, the error did not occur.

However, now I have a different issue; The job throws this error:
<main_program: (aptoci.C:105). Message: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA>
I have checked TNSNAMES.ora and listener.ora and connected to database from client tool and Reporting tool. There is no issue in connection.

Since the oracle server is installed on the same machine, do I still need a client to be installed? If so, does it has to be Oracle 11g or 10g for Datastage 11.3?


Thanks,
Arti

Check which Oracle environment variables are set in $DSHOME/dsenv, and to which values.

Hi Ray,

The following environment variables are set in $DSHOME/dsenv:
ORACLE_HOME=<Oracle Server Home Directory>; export ORACLE_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
PATH=$PATH:$DSHOME:$ORACLE_HOME/bin; export PATH
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
ORACLE_SID=<DB_SID>; export ORACLE_SID


Thanks,
Arti

Also, I can import data using Import --> PlugIn metadata definitions --> ORAOCI9.

I can see the enteries of databases defined in TNSNAMES.ORA in dropdown for Database Source Name.

What error entries are in the log of the parallel job itself when it fails? (You have shown us entries from the sequence's log.)

The issue resolved when I gave Database name in RemoteServer property of Oracle Enterprise stage.

Thanks.

I recall reading a tech note about needing to do that, but I can't immediately recall where.