ORA-12541: TNS:no listener.

building reports webintelligence
1

Database error: ORA-12541: TNS:no listener
. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)

I get this error and I am logged on as administrator into infoview/webi. If I log onto the server and write an adhoc query from DeskI, I do not get any errors. I am only getting the errors from Infoview/WebI. From the server, I can tnsping the instance with no problems and I can log onto the database server via SQL*PLUS without any issues, so its hard for me to believe its a middleware issue.

Oracle 9.2.0.5 repository
Oracle 9.2.0.5 data warehouse
Oracle 9.2.0.1 client middleware

Windows 2003 Server for WebI servers.
HPUX for oracle rdbms

I did a forum search first, and found some hits on ORA-1541 and WIS10901, but nothing seemed to match my case.

any suggestions?

thanks.
Hao.

browncow (BOB member since 2002-09-05)

2

Bounce the server and try…

BO_Chief :us: (BOB member since 2004-06-06)

3

thanks for the suggestion, but that is usually the first thing i try.
for grins, i tried again and no luck.

browncow (BOB member since 2002-09-05)

4

A) Double-check your tnsnames.ora file on the BusinessObjects server.

B) Ask your DBA to double-check that the Oracle Listener process is up and running.

Andreas :de: (BOB member since 2002-06-20)

5

I thought of that too, but I am able to remote desktop to the server and launch Desktop Intelligence and run the same query to the same oracle database with no TNS Listener errors. Also, I can remote desktop to the server and connect to the oracel database via SQL*PLUS.

Isn’t this a sufficient test to verify my middleware is setup correctlly and the listener is up? I figured if the listener wasn’t up I couldn’t connect via sql*plus. Also, I figured if I had a tnsnames.ora problem, I couldn’t connect via tns name, rather IP, but I can connect via the tns name.

thanks for the suggestions. its really bugging me now.
Thanks.
Hao.

browncow (BOB member since 2002-09-05)

6

That is strange…

The only thing which is coming to my mind is:
Check the universe connection, User Name, password and Connection string… Are these correct ? and Is this universe exported to CMS.?

Create another WebI report and try …with the same login id.

Ask your DBA to trace it.

No more ideas from me…

BO_Chief :us: (BOB member since 2004-06-06)

7

Hello Hao,

Even i am getting the same error when i try to run the query from webi,but its working perfectly fine in Deski and sqlplus.

can you please explain how did you able to run the query finally

Thanks
msr

KSReddy (BOB member since 2006-08-17)

8

What and how did you solve this issue ?

/ Stig Henning

kilko :norway: (BOB member since 2006-01-27)

9

Is anybody got soluction?
In my case Universe connection is working. But when i try to run report, i am getting error. Error is Ora-12541 TNS no listner, WIS-10901.

This problem with only one tns entry. I have checked via tnsping, but i got same error.

We have same configuration in Dev and Test. Dev is fine but In Test we have problem.

Thanks,

BOpat :us: (BOB member since 2006-11-09)

10

Finaly we got soluction. Working with DBA we figure it out, in our TNS entry port name was incorrect. I have changed port name and resolved this issue.

Thanks,

BOpat :us: (BOB member since 2006-11-09)

11

Hi ,
We are having similar kind of issue Database error: ORA-12154: TNS:could not resolve the connect identifier specified
. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901) .

When  we  run  Adhoc  reports   or  Customized reports in webI  from the Infoview   only for some  reports we  are facing the above  issue  but some  reports  work fine  for the same  universe.

We have tested the connection string and it is working fine.

Kindly suggest to trouble shoot.

Thanks

CTuser (BOB member since 2007-04-10)

12

Hi ,
We are having similar kind of issue Database error: ORA-12154: TNS:could not resolve the connect identifier specified
. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901) .

When we run Adhoc reports or Customized reports in webI from the Infoview only for some reports we are facing the above issue but some reports work fine for the same universe.

We have tested the connection string and it is working fine.

Kindly suggest to trouble shoot.

Thanks

CTuser (BOB member since 2007-04-10)

13

We’re currently running into a similar issue. This seems to only affect us from the infoview side of things as I can create the same report on Deski and retrieve data with no problems. Hao, did you ever find a solution to your problem?

TIA!

baird.rt (BOB member since 2006-09-14)

14

We had same issue few days ago. we were getting same error with few reports. I have seen that 4 webi report server was down. After restarting them, they all worked fine. You can also try to restart your Webi reports servers.

BOpat :us: (BOB member since 2006-11-09)

15

We are currently experiencing the same error:
“Database error: ORA-12154: could not resolve the connect identifier specified. Contact your business objects administrator or database supplier for more information (Error: WIS 10901) (Error: INF)”

Has anyone found a solution to this?

Thanks in advance for your help. :nonod:

rbrito :ecuador: (BOB member since 2007-09-06)

16

rbrito - for what it’s worth, I ended up doing an uninstall, reinstall and the problem went away. IMO that’s hardly an answer, as I still have no idea what really caused or fixed it. I was stuck in the mud for so long I eventually just reinstalled out of desperation and for some reason it worked.

I hope you have more luck finding an answer than I did. Good Luck!

baird.rt (BOB member since 2006-09-14)

17

Today I solved this same problem: in SQL Plus the Oracle connection was fine, but using Web Intelligence or Desktop Intelligence I received the error ORA-12541.

In my case the tnsnames was with a wrong entry.

This code didn’t work:

ORADS067.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = orads067.cc.br)(Port = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orads067)
)
)

Removing the word “.World” the connection works well.

powerpuff :brazil: (BOB member since 2007-07-24)