6 Replies Latest reply on Nov 13, 2013 5:18 AM by Azhar01

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




      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?