DSXchange

Oracle and DS working seperately for me in Windows server edition but couldn't connect Oracle from DataStage. I'm getting TNS couldn't resolved.

Moreover I'm the admin user so no problem in accessibility.

Is there anything i have to do additional setup?

Check your ORACLE_HOME value.

Have you made the correct settings in tnsnames.ora file on your datastage server?in tnsnames.ora file,there should be entry for your oracle server.

Sathishkumarins wrote:Oracle and DS working seperately for me in Windows server edition

Hence tnsnames.ora must be correct.

Ok.Then have you selected the property "Remote Server" under "connection" in your OCI stage ?By default,this property does not appear.And because of this the error "TNS could not resolve" ...appears

please check...

I opened a OCI 8i Stage and searched for Remote server or connections and i couldn't locate any property like tht.....

I have only database name user and password and then column details and finally sql query builder. Could you please tell me exactly where this would be available?

Moreover don't i need to modify any settings in Admin?

Error when i connect using a ODBC stage.

DSR.MetaGeta(GET.DSNINFO)(SQLConnect('ORA_USER','ORA_USER')): BCI Error:
SQLSTATE=08001,CODE=12154,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle driver][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified

Sathishkumarins wrote:I opened a OCI 8i Stage and searched for Remote server or connections and i couldn't locate any property like tht.....

I have only database name user and password and then column details and finally sql query builder. Could you please tell me exactly where this would be available?

Moreover don't i need to modify any settings in Admin?

Oh..you are using a server job..i thought it to be parallel job .This option is there in parallel job...

One more check..

In ther server OCI stage,there is a text box "Database Source Name"

If your tns entry is

testserver.domain.com=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =test@test.com)(PORT = 1521))
(CONNECT_DATA = (SID = WERT))
)

then,the vale of "Database Source Name" should be "testserver.domain.com".

Have you correctly specified this?

I have checked and not seen any setting specific to this in Datastage Administrator...

Which stage are you planning on using? OCI or ODBC? They have different configuration requirements. And there's no dsenv file on a DataStage Windows server, so don't go looking for that either.

Thanks to everyone who gave a helping hand...
It's been found that Oracle server connection was working fine but the client connection had some problem.....That's why DS refused connection to Oracle.... Currently team was working on it resove that...