This discussion is archived
4 Replies Latest reply: Nov 7, 2012 12:12 PM by 896779 RSS

No suitable TCP address was found for ....in the TNSNAMES.ORA file

971180 Newbie
Currently Being Moderated
Hi,

i configure a New JDBC Data Source for a connection to my DB ORACLE 10g, when i test the connection the result is:

Connection test failed.
*[BEA][Oracle JDBC Driver]No suitable TCP address was found for the KMssl in the TNSNAMES.ORA file.*
weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
weblogic.jdbc.oracle.tns.TnsDescriptionList.CollectConnectDescriptors(Unknown Source)
weblogic.jdbc.oracle.OracleImplConnection.makeConnection(Unknown Source)
weblogic.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)
weblogic.jdbc.oracle.OracleImplConnection.open(Unknown Source)
weblogic.jdbc.base.BaseConnection.connect(Unknown Source)
weblogic.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
weblogic.jdbc.base.BaseConnection.open(Unknown Source)
weblogic.jdbc.base.BaseDriver.connect(Unknown Source)
com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:493)
com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:364)
sun.reflect.GeneratedMethodAccessor232.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:812)
org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:751)
org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:434)
org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:245)
org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:316)
...

The same tnsanems.ora used in Toad client with seccesses.

Where is the configuration problem?

Ty

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points