This content has been marked as final. Show 6 replies
Thanks,but that did not help. I brought down the firewalls on both client and server side
I also tried Microsoft, Oracle, Merant, DirectWire drivers and they work fine from the BI Admin tool
I am also able to log into BI Answers and start building the content.
However when I click on see results I get this error
try to ping your database directly using TNSPING <database schema> from cmd prompt.
set your tnsnames i.e. ODBC.INI file on Linux box correctly
set your tnsnames i.e. tnsnames.ora on windows box
try to directly query database from Administration tool and see if you can see data
right click any alias/physical table and choose VIEW DATA.
Hope it helps
tnsping works fine, BI Administration tool and ODBC works fine
I have a workaround
Here is what I learnt
1. On Windows the BI Server has difficulty connecting because it does not recognize the TND_ADMIN variable
2. Use OCI instead of ODBC and for Data Source put the raw entry
1. Before starting run-sa.sh, run-saw.sh have the environment variables TNS_ADMIN, LD_LIBRARY_PATH, ORACLE_HOME set an exported
here is my self written startBI.sh on Oracle Linux64
I am having an EBS R12 Instance for my database
. ./oc4j -start
Another landmine is that you may need to use lib32
The gateway libraries in NSConfig.ini may point to 10g libraries.
This is OK if you have 10g but for 11g you may have to relink libclntsh.so.10.1
Hope this helps
All these roadblocks make you dig more, google, read docs experiment and try work arounds
Though this is frustrating we get to discover more about the engine.