Error importing metadata from Oracle server

[Prakashs]

We are configuring Datastage v7.5 EE on RH Linux for Oracle 9i.

I have taken the following steps to configure.

1) Updated uvodbc.config available in the project library with the following codes.

<Ruttora>
DBMSTYPE = ODBC

2) Removed all the comments from odbc.ini available in branded_odbc and
added the following codes.

[Ruttora]
Driver=#branded_odbc/lib/VMora19.so
Description=
ApplicationUsingThreads=1
ArrySize=60000
CachedCursorLimit=32
CachedDesLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongdataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorForLongData=0
EnableTimestampWithTimeZone=0
HostName= Ip address
LocalTimeZoneoffset=
LOCKTimeOut=-1
LogonID=userid on oracle server
Password=
PortNumber=1521
ProcedureRetResults=0
SID=ODBCSOL
UseCurrentSchema=1

3) Updated dsenv in DSEngine and added the following codes.

TNS_ADMIN= /opt/oracle/app/oracle
export TNS_ADMIN

ORACLE_HOME=/opt/oracle/app/oracle
export ORACLE_HOME

LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_HOME

4) checked .dslibs in root point to branded_odbc/lib


While importing metadata we are getting the following errors:

a) ODBC Error:

DSR.MetaGeta(GET.TABLES)(SQLConnect(Ruttora,woc):BCI Error:
SQLSTATE=01000,CODE=0,[DataStage][SQL Client] [ODBC]

b) Plugin Oracle OCI

Unable to initialize plug-in

c) Orclestrate Schema

##I TCDU 000005 14:35:27(001) <main_program> Unable to access database {0}DB type 'oracle' presumed to be oracle.
##E TCDU 000002 14:35:27(002) <main_program> Unable to access database {0}Oracle: not present
##E TCDU 000006 14:35:27(003) <main_program> Unable to access database {0}Unable to load library 'orchoracle'.

Any help in resolving the above connection problem would be highly appreciated.

[ray.wurlod]

Check that the 32-bit Oracle library occurs ahead of the 64-bit library in LD_LIBRARY_PATH.

Make sure that you export LD_LIBRARY_PATH, not LD_LIBRARY_HOME.

Also make sure in dsenv that there's no space either side of the "=" character when setting values for environment variables.

And what's the "#" in front of branded_odbc in the first line of the data source definition?

[Prakashs]

Thanks Ray.

I have problem with both Server and Parallel jobs.

Apart from the above four steps is there any further steps I am missing ?

[elavenil]

Library path should include lib32, bin and rdbms/lib32 directories in the Oracle home directory.

Execute the DSENV file to ensure all the required path set.

HTWH.

Regards
Saravanan

[Eric]

You need to add the Oracle bin directory to your path environment:

PATH=$PATH:$ORACLE_HOME/bin; export PATH

Check the setup sections of the Docs, remember that ODBC (wired and non-wired), Plug-ins and PX stages al lhave their own setup instructions.