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.
In place of datasource Name use string in this format. then use database user name and password.
Put your HOST IP ADRESS,
Put your Port number,
put your service name,
take above field from database team.
It will work,
mark if correct,
Is the database and Obiee lying in same machine???
if so use localhot in place of IP Address.
If not try pinging the database IP from Obiee machine,
It should work if you can ping the database machine from obiee machine. Its not rocket science, do some checks here and there,
check whether you have put proper IP , Port and SID
You might need some changes in sqlnet.ora file
try to add HOSTNAME in entry NAMES.DIRECTORY_PATH
and comment out the below line using # as
These suppose to be at the db server's SQLNET.ORA file once you done with these you might need to restart the db server service.
If helps pls mark if not reach out your dba.
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.