DSXchange

Please help me ,i cant get oracle 10g and datastage 7.5.2 to work.
Oracle 10g and Datastage 7.5.2.Two questions and my errors.

1.Is there anyone who has Oracle 10g client and can connect using Datastage 7.5.2?If yes please send me your dsenv and odbc.ini
2.Can i use datastage 7.5 client to connect to datastage 7.5.2 server.Using the oracle ORAOCI8 or ORAOCI9 plugins.

Error i am getting importing metadata is
DSR.MetaGeta(GET.TABLES)(SQLConnect('erp_oracle','dwh')): BCI Error:
SQLSTATE=IM003,CODE=0,[DataStage][SQL Client][ODBC][unixODBC][Driver Manager]Can't open lib '/export/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMora20.so' : ld.so.1: dsapi_slave: fatal: libVMicu20.so: open failed: No such file or directory

native connectivity,
the plugin import i get the unable to initialise plugin.I checked other post but no luck.

-------------------
dsenv
########################################################################
dshome=`cat /.dshome`

# ALL PLATFORMS SECTION

ODBCINI=/export/home/dsadm/Ascential/DataStage/DSEngine/.odbc.ini; export ODBCIN
I
HOME=${HOME:-/}; export HOME
PATH=$PATH:$dshome/bin:/usr/local/bin:/usr/local; export PATH
#UDTHOME=$dshome/../ud41; export UDTHOME
#UDTBIN=$dshome/../ud41/bin; export UDTBIN
ODBCHOME=/export/home/dsadm/Ascential/DataStage/DSEngine/; export ODBCHOME

# PLATFORM SPECIFIC SECTION

LD_LIBRARY_PATH=/usr/lib/lwp:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
LD_LIBRARY_PATH=/.dslibs:$dshome/lib:$LD_LIBRARY_PATH:/usr/local/lib:/export/hom
e/sybase/ASIQ-12_5/lib32; export LD_LIBRARY_PATH

### Sybase ASIQ ###
SYBASE=/export/home/sybase
export SYBASE
ASDIR=$SYBASE/ASIQ-12_5
export ASDIR
SYBASE_OCS=OCS-12_5
export SYBASE_OCS
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ASDIR/usrlib:$ASDIR/lib:$SYBASE/$SYBASE_OCS/li
b:$ASDIR/lib32
export LD_LIBRARY_PATH
LD_LIBRARY_PATH_64=$LD_LIBRARY_PATH_64:$ASDIR/lib:$ASDIR/usrlib:$SYBASE/$SYBASE_
OCS/lib
export LD_LIBRARY_PATH_64
PATH=$PATH:$ASDIR/bin:$SYBASE/$SYBASE_OCS/bin
export PATH

#oracle 10g
ORACLE_HOME=/data14/oracle/product/10.2.0/client_1
ORAHOME=/data14/oracle/product/10.2.0/client_1
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$dshome/branded_odbc/lib:$dshome/lib:$dshome/uv
dlls$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib;export LD_LIBRARY_PATH
ORACLE_SID=DEV
TNS_ADMIN=/data14/oracle/product/10.2.0/client_1/network/admin
ORASID=DEV
export ORACLE_HOME ORAHOME ORACLE_SID ORASID TNS_ADMIN




### Ingres Advantage ###
II_SYSTEM=/export/home
export II_SYSTEM
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/export/home/ingres/lib
export LD_LIBRARY_PATH
ODBCSYSINI=/export/home/dsadm/Ascential/DataStage/branded_odbc
export ODBCSYSINI

--------------------
odbc.ini
[erp_oracle]
Driver=/export/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMora20.so
Description=DataDirect 4.20 Oracle Wire Protocol
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=10.0.4.202
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=appsdataconv
Password=appsdataconv
PortNumber=1521
ProcedureRetResults=0
SID=DEV
UseCurrentSchema=1
----------------------
tnsnames.ora
$ pwd
/data14/oracle/product/10.2.0/client_1/network/admin
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\NET
WORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gperpdat02.harmony.co.za)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DEV)
)
)

erp_oracle =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gperpdat02.harmony.co.za)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DEV)
)
)

PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gperpdb01)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PROD)
)
)

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gperpdat01.harmony.co.za)(PORT = 1531))
)
(CONNECT_DATA =
(SID = TEST)
)
)


Thank you,

the problem was my dsenv,

I specified lib instead of lib32.

Thank you,

If you have an Oracle client installed and everything configured, why would you use ODBC over OCI?

If you have Enterprise Edition (parallel jobs) - which I assume you have because you posted in this particular forum - then try importing using the Orchestrate orchdbutil facility. It's the most accurate.