Page 1 of 1
Unable to connect to Oracle using Connector Stage
Posted: Thu Mar 28, 2013 1:15 pm
by 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!!
Posted: Thu Mar 28, 2013 6:36 pm
by 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"
Posted: Thu Mar 28, 2013 7:25 pm
by 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
Posted: Mon Apr 01, 2013 6:59 am
by priyadarshikunal
Did you set TNS_ADMIN in datastage? if yes, is it in dsenv?