Not able to access Oracle DB using DRS stage in Windows OS

[tirumal_nit]

Hi Experts,

We've done the following to access Oracle database using DRS stage.
1. Installed Oracle client
2. Made sure
ORACLE_HOME and PATH variables are set properly in System properties > Environment variables.
3. Open DRS stage properties and hard coded connection name, user details to access database.
4. Able to open sql session using sql client
5. But using DRS stage we are getting the error.
ORA-12154: TNS:could not resolve the connect identifier specified

Tried with OCI stage as well but no luck.

Can someone please suggest anything is missed here.

Thanks
Tirumal

[ray.wurlod]

Have you properly installed Oracle client software on your DataStage server and configured tnsnames.ora (and, possibly, sqlnet.ora)?

[tirumal_nit]

Hi Ray,

Yes, tnsnames.ora is configured properly and and I can connect to that service name using sql client.

Thanks

[tirumal_nit]

Any other thoughts? Appreciate your response.

I did search on the error 'TNS:could not resolve the connect identifier specified' in the forum and made sure the below are file.
1. tnsnames.ora has the valid service name
2. Configured ORACLE_HOME and PATH variables to oracle client installation
3. User is able to create a sql session in sql client

Not sure what has missed here.

[chulett]

So... this is marked as Resolved with no resolution noted. Can you please add whatever secret sauce you were missing?