Skip to Content
author's profile photo Former Member
Former Member

A database error occured. The database error text is: ORA-12154: TNS:could not resolve service name . (WIS 10901)

Hi All,

Few users are getting the below error:

A database error occured. The database error text is: ORA-12154: TNS:could not resolve service name

. (WIS 10901)


but i didn't get any error when run simple report in my PC.


Any help


Thanks,

Bhaskar

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Dec 04, 2013 at 06:45 AM

    Hi Bhaskar

    Kindly refer the SAP KBA

    http://scn.sap.com/thread/3464729

    1489167 - Web Intelligence Report cannot connect to Oralce DB


    Regards

    Ram

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2013 at 06:50 AM

    HI,

    First of all,

    Where do you run report ? Internet Explorer? or Webi Rich Client?

    If you run it in IE, This problem is Oracle Client(64bit)

    but In Webi Rich Client, This problem is Oracle Client(32bit).

    You has to check Oracle Client bit-version.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2013 at 08:18 AM

    If users are getting the error in the Rich Client and you are not getting this error from Rich Client then just try to copy the TNS entries from your desktop to the users desktop and then check the report.

    Also check the version of the oracle client on your system and user's system who is getting the error.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2013 at 09:18 AM

    The TNSORA file present in the subfolders under oracle folder is not same on your machine and the other machine. Just find the TNS entry from your TNSORA file and copy the same in the TNSORA file on another machine where the problem is.

    The TNSORA file presents in the subfolders in the Oracle folder.


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2013 at 10:18 AM

    Hello Naidu,

    You need to install both 32bit and 64bit Oracle clients on your BO server as well. You also need to configure your TNS.ora file after the installation.

    The reason you are not getting an error on your machine is probably defined TNS settings in your computer. You have to do the same on your server.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.