Unable to connect to Oracle using Connector Stage

[AmeyJoshi14]

Hi experts,

We are unable to connect to Oracle database (wallet) through Oracle connector stage. Below is the error:-

Code: Select all

OCIServerAttach, Error Code: 28,759, Error message ORA-28759: failure to open file.

When I try to login with the same credentials in linux it is working fine.

Is there any specific setting which we have to do for accessing Oracle tables in wallet?

Thanks in Advance!!

[PaulVL]

Mr Google says this:


http://docs.oracle.com/cd/B19306_01/net ... asossl.htm


ORA-28759: Failure to Open File
Cause: The system could not open the specified file. Typically, this error occurs because the wallet cannot be found.
Action: Check the following:

Ensure that the correct wallet location is specified in the sqlnet.ora file. This should be the same directory location where you saved the wallet.

Enable Oracle Net tracing to determine the name of the file that cannot be opened and the reason.

Ensure that auto login was enabled when you saved the wallet. Refer to "Using Auto Login"

[AmeyJoshi14]

Thanks for the help!

We are able to sucessfully login to Oracle wallet from the linux box where DS is installed. But some how the same credentials are not working in Oracle connector stage.
Do we have to restart the DSEngine so that these changes(changes in sqlnet.ora and tnsnames) will be effective?

Appreciate all your help!!

Thanks

[priyadarshikunal]

Did you set TNS_ADMIN in datastage? if yes, is it in dsenv?