WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  test connection failed

    Posted Mon August 12, 2013 04:43 PM
    The test connection operation failed for data source Service Catalog Datasource on server nodeagent at node varhqa39Node01 with the following exception: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: b2bpqa-scan.cusa.canon.com:1521:SCATQA DSRA0010E: SQL State = null, Error Code = 0. View JVM logs for further details.
    The test connection operation failed for data source Service Catalog Datasource on server nodeagent at node varhqa40Node01 with the following exception: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: b2bpqa-scan.cusa.canon.com:1521:SCATQA DSRA0010E: SQL State = null, Error Code = 0. View JVM logs for further details.

    i am getting this error when i tried to create a datasource....... pls help me


  • 2.  test connection failed

    Posted Thu August 15, 2013 04:37 PM
    harry,
    harry,
    This error means that the database address that you use in datasource (IP, PORT, SID) is wrong. Check it.     If use SQLplus , connect you to database? Enter the same data that are in your tnsnames.ora file Oracle client.


  • 3.  test connection failed

    Posted Fri August 16, 2013 03:30 PM
    thank you, it helped.
     


  • 4.  test connection failed

    Posted Tue September 03, 2013 02:58 PM
    Hi,

    Might be useful 

    www.redstonecontentsolutions.com/5/post/...

    www-01.ibm.com/support/docview.wss?uid=s...  




    Hope this helps.  Thank you
     


Related Content