Friday, May 27, 2016

Create New Repository – The connection has failed

That was installed last two weeks. As you see I’m a beginner in OBI.
To day, I follow the document “Creating a Repository Using the Oracle BI 11g Administration Tool” to create the new repository for the BI system. But I have error “The connection has failed”. The error is as the follow image:

The logfile say that:
[2014-06-23T01:03:25.000+07:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1b9c]  [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach.]]

But I can connect to Database server using sqlplus via cmd in Windows. I don’t know why. After google I found the solution.

To fix this error you must define environment variable TNS_ADMIN as bellow:

No comments:

Post a Comment