Hello BO experts,
I am getting an some errors while Refreshing the reports on DESKI.
'Connection or SQL sentence error: (DA0005).'
'Exception: DBD, ORA-12154: TNS:could not resolve the connect identifier specified.'
'A connection required to refresh this document is unavailable. (DA0004).'
Some suggested that it is related to tnsnames.ora, i tried to get it replaced bt still no use.
Has anybody ever faced this kind of issue and could suggest possible workaround for this problem
Thanks and Regards
first you have to check that your BO server can reach the DB using the tnsnames.ora file
go to your server and from there check that you can access the DB correctly with the same credentials you use.
is this report deployed to the enterprise or you use it from your client machine?
My problem is solved !!!
This issue was arising because we had 2 version of oracle client-- oracle 8 and oracle 10 g (which we got recently installed) as a result of which there were 2 tnsnames.ora in the system and the DESKI was trying to make an connection using tnsnames.ora present in oracle 10g as oracle_home variable got changed to point to oracle 10g after its installation.
So to rectify this problem--
1. we first copied the tnsnames.ora of oracle 8 to oracle 10 g
2. and then we set the oracle_home variable to point back to oracle 8
And hence our problem got resolved.