Setting the DSN in UNIX.

[anujgarg]

Hi Gurus,

I am able to create the DSN in windows and use it.
When i am trying to create the DSN and use it , I am getting the below error.

DSR.MetaGeta(GET.TABLES)(SQLConnect('Ora','dwd6')): BCI Error:
SQLSTATE=HY000,CODE=7505,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.
SQLSTATE=HY000,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination

Below are the settings.

First i have created the DSN in .odbc.ini in DSEngine

[Ora]
Driver=/opt/Ascential/DataStage/branded_odbc/lib/VMora19.so
Description=DataDirect 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=149.27.178.145
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=1521
ProcedureRetResults=0
SID=DWTST01
UseCurrentSchema=1

And Then i have added DSN in Uvodbc.config in specific Projects folder.

<Ora>
DBMSTYPE = ODBC

I have missed something,but i am unable to find out or some extra settings need to be added.
Please help me.
Thanks in advance,
Anuj