Oracle Configuration

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
altruist
Participant
Posts: 73
Joined: Thu May 11, 2006 6:50 am

Oracle Configuration

Post by altruist »

Hi All,

I am trying to configure Datastage to connect to Oracle database by adding the below highlighted contents in dsenv file. But I am getting the error as "Unable to Initialize plug-in". I have bounced the server after modifying the dsenv, but it's still not working.

Code: Select all

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
        ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
        HOME=${HOME:-/}; export HOME


       export ORACLE_HOME=/as_ora/oracle/oracle_client112
       export ORACLE_BASE=/as_ora/oracle
       export ORACLE_BIN=$ORACLE_HOME/bin

       export TNS_ADMIN=$ORACLE_HOME/network/admin

       # add to lib path
       LIBPATH=$LIBPATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
        export LIBPATH

      # add to path
      export PATH=$ORACLE_BIN:$PATH

        #LANG="<langdef>";export LANG
        #LC_ALL="<langdef>";export LC_ALL
        #LC_CTYPE="<langdef>";export LC_CTYPE
        #LC_COLLATE="<langdef>";export LC_COLLATE
        #LC_MONETARY="<langdef>";export LC_MONETARY
        #LC_NUMERIC="<langdef>";export LC_NUMERIC
        #LC_TIME="<langdef>";export LC_TIME
        #LC_MESSAGES="<langdef>"; export LC_MESSAGES

        LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/lib/ppc64:$ASBHOME/apps/jre/lib/ppc64/j9vm:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:$LIBPATH
        export LIBPATH

        ulimit -d unlimited
        ulimit -m unlimited
        ulimit -s unlimited
        ulimit -f unlimited
        ulimit -n 131072

        LDR_CNTRL=USERREGS
        export LDR_CNTRL

fi

export PATH=$APT_ORCHHOME/bin:.:$PATH
export LIBPATH=$APT_ORCHHOME/lib:.:$LD_LIBRARY_PATH
Top
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

Please post the un-edited error message in full which will enable us to identify the issue correctly.

I think you need to mention the LIB_PATH as $ORACLE_HOME/lib32 to use 32 bit library instead of 64 bit library.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Top
altruist
Participant
Posts: 73
Joined: Thu May 11, 2006 6:50 am

Post by altruist »

That is the entire error message in dialog box, it occurs when I try to import column definitions from Oracle - "Unable to initialize Plug-in"

I have rectified minor mistakes and bounced the server, but still with the same error
if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME


export ORACLE_HOME=/as_ora/oracle/oracle_client112
export ORACLE_BASE=/as_ora/oracle
export ORACLE_BIN=$ORACLE_HOME/bin

export TNS_ADMIN=$ORACLE_HOME/network/admin

# add to lib path
LIBPATH=$LIBPATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
export LIBPATH

# add to path
export PATH=$ORACLE_BIN:$PATH

#LANG="<langdef>";export LANG
#LC_ALL="<langdef>";export LC_ALL
#LC_CTYPE="<langdef>";export LC_CTYPE
#LC_COLLATE="<langdef>";export LC_COLLATE
#LC_MONETARY="<langdef>";export LC_MONETARY
#LC_NUMERIC="<langdef>";export LC_NUMERIC
#LC_TIME="<langdef>";export LC_TIME
#LC_MESSAGES="<langdef>"; export LC_MESSAGES

LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/lib/ppc64:$ASBHOME/apps/jre/lib/ppc64/j9vm:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:$LIBPATH
export LIBPATH



ulimit -d unlimited
ulimit -m unlimited
ulimit -s unlimited
ulimit -f unlimited
ulimit -n 131072

LDR_CNTRL=USERREGS
export LDR_CNTRL


fi

export PATH=$APT_ORCHHOME/bin:$ORACLE_HOME/bin:.:$PATH
export LIBPATH=$APT_ORCHHOME/lib:$ORACLE_HOME/lib:.:$LIBPATH
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As already noted, if you have both Oracle "lib" and "lib32" directories, switch to "lib32" for your LIBPATH and see if that fixes it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
altruist
Participant
Posts: 73
Joined: Thu May 11, 2006 6:50 am

Post by altruist »

I see only "lib" in oracle home directory.

Note: I am connecting to 10.2.0.4 - 32 bit Oracle Server on windows, through client on AIX 6.1 with 11.2.0.1 - 64 bit. We have tested the connected through AIX with sqlplus and it worked fine.
Top
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

Out of curiosity - are you using an Oracle Connector, and do you have the Variant set to 11 (since you are using the 11g client)?
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Try putting lib32 into LIBPATH ahead of lib in the dsenv script.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
altruist
Participant
Posts: 73
Joined: Thu May 11, 2006 6:50 am

Post by altruist »

ISSUE::
Now I am able to import metadata definitions, but not able to connect through oracle connector. While connecting I am specifying Client version as 11g.

ERROR:
Error loading connector library libccora11g.so. Could not load module /opt/IBM91/InformationServer/Server/DSComponents/bin/libccora11g.so

Dependent module libcIntsh.a(shr.o) could not be loaded.
Could not load module libcIntsh.a(shr.o).
System error: No such file or directory

Dependent Module Could not load module /opt/IBM91/InformationServer/Server/DSComponents/bin/libccora11g.so

Note: :
a) I see only "lib" in oracle home directory.

b) I am connecting to 10.2.0.4 - 32 bit Oracle Server on windows, through client on AIX 6.1 with 11.2.0.1 - 64 bit. We have tested the connected through AIX with sqlplus and it worked fine. Also Import Metadata Definitions from Datastage worked fine as well.

c) I have IIS 8.5 and 9.1 installed on the same machine.

d) I have checked and the libcIntsh.a(shr.o) file exists.

Code: Select all

$  ldd  /opt/IBM91/InformationServer/Server/DSComponents/bin/libccora11g.so
/opt/IBM91/InformationServer/Server/DSComponents/bin/libccora11g.so needs:
Cannot find libicuio.a
         /usr/vac/lib/libicuuc.a
Cannot find libicui18n.a
Cannot find libfcl.so
         /as_ora/oracle/oracle_client112/lib/libclntsh.a(shr.o)
         /usr/lib/threads/libc.a(shr_64.o)
         /usr/vacpp/lib/libC.a(shr_64.o)
         /usr/vacpp/lib/libC.a(ansi_64.o)
         /usr/vac/lib/libicudata38.a(libicudata38.1.so)
         /usr/lib/libpthread.a(shr_xpg5_64.o)
         /usr/vacpp/lib/libC.a(shr2_64.o)
         /usr/lib/libpthreads.a(shr_xpg5_64.o)
         /usr/lib/libdl.a(shr_64.o)
         /usr/lib/libperfstat.a(shr_64.o)
         /usr/lib/libodm.a(shr_64.o)
         /usr/lib/threads/libc.a(aio_64.o)
         /unix
         /usr/lib/libcrypt.a(shr_64.o)
         /usr/vacpp/lib/libC.a(shrcore_64.o)
         /usr/vacpp/lib/libC.a(ansicore_64.o)
         /usr/lib/libcfg.a(shr_64.o)
         /usr/lib/liblvm.a(shr_64.o)
         /usr/lib/libcorcfg.a(shr_64.o)
         /usr/lib/libsrc.a(shr_64.o)
$ ls -latr /as_ora/oracle/oracle_client112/lib/libclntsh.a
-rwxrwxrwx    1 oracle   dba        49586984 Dec  8 12:10 /as_ora/oracle/oracle_client112/lib/libclntsh.a

Below is the env file

Code: Select all

set +u

if [ -z "$DSHOME" ] && [ -f "/.dshome" ]
then
        DSHOME=`cat /.dshome`
        export DSHOME
fi

if [ -z "$DSHOME" ]
then
DSHOME=/opt/IBM91/InformationServer/Server/DSEngine; export DSHOME
fi


if [ -z "$DSRPCD_PORT_NUMBER" ]
then
        true
DSRPCD_PORT_NUMBER=31538; export DSRPCD_PORT_NUMBER
fi

if [ -z "$APT_ORCHHOME" ]
then
APT_ORCHHOME=/opt/IBM91/InformationServer/Server/PXEngine; export APT_ORCHHOME
fi

#if [ -z "$UDTHOME" ]
#then
UDTHOME=/opt/IBM91/InformationServer/Server/DSEngine/ud41 ; export UDTHOME
UDTBIN=/opt/IBM91/InformationServer/Server/DSEngine/ud41/bin ; export UDTBIN
#fi

#if [ -z "$ASBHOME" ] && [ -f "$DSHOME/.asbnode" ]
#then
        ASBHOME=`cat $DSHOME/.asbnode`
        export ASBHOME
#fi

#if [ -z "$ASBHOME" ]
#then
        #ASBHOME=`dirname \`dirname $DSHOME\``/ASBNode
        #export ASBHOME
#fi

if [ -n "$DSHOME" ] && [ -d "$DSHOME" ]
then
        ODBCINI=$DSHOME/.odbc.ini; export ODBCINI
        HOME=${HOME:-/}; export HOME


       export ORACLE_HOME=/as_ora/oracle/oracle_client112
       export ORACLE_BASE=/as_ora/oracle
       export ORACLE_BIN=$ORACLE_HOME/bin

       export TNS_ADMIN=$ORACLE_HOME/network/admin

       # add to lib path
       LIBPATH=$LIBPATH:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
        export LIBPATH

      # add to path
      export PATH=$ORACLE_BIN:$PATH

        #LANG="<langdef>";export LANG
        #LC_ALL="<langdef>";export LC_ALL
        #LC_CTYPE="<langdef>";export LC_CTYPE
        #LC_COLLATE="<langdef>";export LC_COLLATE
        #LC_MONETARY="<langdef>";export LC_MONETARY
        #LC_NUMERIC="<langdef>";export LC_NUMERIC
        #LC_TIME="<langdef>";export LC_TIME
        #LC_MESSAGES="<langdef>"; export LC_MESSAGES

        LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/lib/ppc64:$ASBHOME/apps/jre/lib/ppc64/j9vm:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:$LIBPATH:$APT_ORCHHOME/lib
        export LIBPATH



        ulimit -d unlimited
        ulimit -m unlimited
        ulimit -s 32768
        ulimit -f unlimited
        ulimit -n 131072

        LDR_CNTRL=USERREGS
        export LDR_CNTRL


fi

export PATH=$APT_ORCHHOME/bin:$ORACLE_HOME/bin:$PATH
export LIBPATH=$APT_ORCHHOME/lib:$ORACLE_HOME/lib:$LIBPATH
Top
altruist
Participant
Posts: 73
Joined: Thu May 11, 2006 6:50 am

Post by altruist »

My apologies, restarting ASBNode solved the issue.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”