When creating a new repository or while importing from a data source using OCI interface, you get the “connection has failed” error.
This is because, the BI Admin tool is not able to find the TNS entry. to resolve this,
Copy your tnsnames.ora (from your oracle database home\network\admin) to {Oracle_BI1}\network\admin directory & {oracle_common}\network\admin directory
OR
go to $ORACLE_INSTANCE\bifoundation\OracleBIApplication\coreapplication\setup
add this entry in the user.cmd / user.sh file
set TNS_ADMIN=D:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN
you might want to restart the BI Admin Tool.
No comments:
Post a Comment