Error in OCI stage

vasubabu · Post by **vasubabu** » Wed Oct 20, 2010 12:58 am

Hi ,

I am getting the fallowing error when tryin to view the date from OCI enterprise stage.

"ORA-12514: TNS:listener does not currently know of service requested".

But i am able to connect with ODBC stage ,can import the meta data from Plug-in as well.

When using the OCI stage only i am getting the above error.
Can anybody help on this to resolve.

chulett · Post by **chulett** » Wed Oct 20, 2010 7:51 am

Have you used any of the native Oracle stages yet? They are configured in a different manner than ODBC. Do you have an Oracle client installed on your DataStage server?

vasubabu · Post by **vasubabu** » Wed Oct 20, 2010 9:47 pm

Yes.I have the Oracle client installed on Datastage server.I am having the problem with OCI stage alone.
Please advice me to set any properties.

cfuller · Post by **cfuller** » Wed Oct 20, 2010 10:16 pm

Have you checked you have the tnsnames.ora file configured correctly on the Datastage server. Are you able to tnsping your database from the Datastage server?

vasubabu · Post by **vasubabu** » Thu Oct 21, 2010 12:04 am

Hi,

I am able to ping tnsping and working fine.

do i need to set the Datastage environment variables?

evee1 · Post by **evee1** » Wed May 18, 2011 5:43 pm

Hello, have you managed to solve this issue?

chulett · Post by **chulett** » Wed May 18, 2011 7:34 pm

evee1, why don't you start your own post and tell us the details of your particular issue?

evee1 · Post by **evee1** » Wed May 18, 2011 8:11 pm

I think I will. I just didn't want to double up posts.
I managed to fix THIS problem, but I'm having another one

. So see you in the other post.