Error DA0005 CONNECTION or SQL SENTENCE ERROR - ORA-12154
Environment: Business Objects XI R 3.1 - Desktop Intelligence/ Rich Client We had this error CONNECTION or SQL SENTENCE ERROR (DA0005) ORA-12154: TNS:could not resolve service name :-12154 just for one a client in another site of our customer. We checked this problem by typing in CMD tnsping Oracle SID for example: tnsping oracledatabase. The problem was that int the tnsname on the client under the path : C:\app\username\product\11.2.0\client_1\network\admin had not the same Oracle SID. Another solution could also be that the tnsping does not respond so the listener could be down. Similar case: On another Desktop Intelligence client with the same issue (error code) the problem was due to a double Oracle installation and a double Business Obects Intallation. Solution: In this case we unified the two different TNSNAMES in only one ! For other error see also: BUSINESS OBJECTS ERRORS LIST