6 Replies Latest reply: Nov 12, 2013 11:18 PM by Azhar01 RSS

    ORA-12541: TNS:no listener. (HY000)

    Jimit

      Hi,

       

      I created a DSN A and added the name to my connection pool in OBIEE 10G rpd. When i click on "Test Connection" in the DSN, it connects successfully. However, when i create an ad-hoc report in Answers with a subject area that uses the same connection pool, i get the no listener error:

       

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 16001] ODBC error state: S1000 code: 12541 message: [Oracle][ODBC][Ora]ORA-12541: TNS:no listener. (HY000)

       

      What am i doing wrong?