We are unable to connect to the database using OCI call Interface , through the RPD(OBIEE 10g).
It is throwing the error :
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
The same machine , the database is connecting via SQl client.We are able to tnsping the database also.
Try to connect to your schema on TOAD with the same credentials and make sure they are all fine. Then check your tnsnames.ora file to see if the data source is mentioned. Also make sure correct tnsnames.ora file is being used.
I had similar issue in which there were multiple tnsnames.ora files and I had to redirect to the correct one by editing bi_init.bat in $ORACLE_HOME\oraclebi\orahome\bifoundation\server\bin. Then restart your application.