IBM Support

** Troubleshooting ** 'ORA-12541: TNS:no listener' errors, for example inside Event Log

Troubleshooting


Problem

User tries to launch Controller. User receives error message on screen. If they look at their client PC's 'application' Event Log, there is an entry there, corresponding with the time when they tried to logon. On the Controller application server, there are periodic VBRUNTIME errors.

Symptom

Client PC screen:

An error occurred while trying to access the server

Client PC Event Log:

Event Type: WarningEvent Source: Cognos ControllerEvent Category: NoneEvent ID: 0Date: 1/31/2008Time: 10:20:10 AMUser: N/AComputer: PCNAMEDescription:Error occured at 1/31/2008 10:20:10 AM in Cognos Controller, Error No=5, Source=FrangoDirect.ServerInfoD.GetServerInfo#ControllerProxyClient, Description=System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException (0x80004005): ORA-12541: TNS:no listener at FrServerB.ServerInfoClass.GetServerInfo(String sGuid, String sUser) at Cognos.Controller.Proxy.CCRWS.ServerInfo_GetServerInfo(String sGuid, String sUser) --- End of inner exception stack trace ---, HelpFile= HelpContext=0

Application Server Event Log:

    Event Type: Warning
    Event Source: VBRuntime
    Event Category: None
    Event ID: 1
    Date: 1/31/2008
    Time: 10:08:02 AM
    User: N/A
    Computer: SERVERNAME
    Description:
    The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 3424 ,Logged: Error occured at 1/31/2008 10:08:02 AM in FrSrvFunc, Error No=-2147467259, Source=Server function:Db_CreateConnection(..) , Description=ORA-12541: TNS:no listener, HelpFile= HelpContext=0

And:
    Event Type: Error
    Event Source: VBRuntime
    Event Category: None
    Event ID: 1
    Date: 1/31/2008
    Time: 10:08:02 AM
    User: N/A
    Computer: SERVERNAME
    Description:
    The VB Application identified by the event source logged this Application FrSrvFunc: Thread ID: 3424 ,Logged: Connection Error: Udl=File Name=C:\Program Files\cognos\c8\Data\DEVELOPMENT.Udl But security is OFF!!!
    Error No=-2147467259, Source=OraOLEDB, Description=ORA-12541: TNS:no listener, Native Error=12541, Sql State =

In addition, if using TNSPING, you may get the error 'TNS-12541: TNS: no listener'.

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.2","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1038229

Document Information

Modified date:
08 May 2025

UID

swg21361712

Page Feedback