We are using WAS 6.1.0.9 on z/OS and Oracle 10g . The Oracle is on a
2 node RAC. We are unable to configure the connection to Oracle with
the multiple nodes. Can you please help me with URL to be used for
such a configuration ?
We are able to connect to the nodes individually but not as a RAC
together.
Any help is appreciated.
Thanks & Regards,
Prasanna M S
Adding further information on the exception I get when I test the
configuration with muptilple nodes
I am using the information from the link below to configure the 2
nodes
http://www.ibm.com/developerworks/websphere/techjournal/0710_barghouthi/0710_barghouthi.html
Message: BBOO0220E: DSRA8040I: Failed to connect to the DataSource.
Encountered "": java.sql.SQLException: Io exception: NL Excep
tion was generatedDSRA0010E: SQL State = null, Error Code = 17,002
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
146)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
420)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:
35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at
oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:
297)
at
oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:
472)
at
oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:
159)
at
oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:
133)
at com.ibm.ws.rsadapter.DSConfigurationHelper
$1.run(DSConfigurationHelper.java:1138)
at
com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:
118)
at
com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:
1133)
at
com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:
2356)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
64)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:615)
at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:
532)
at
com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:
460)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
64)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:615)
at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:62)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
64)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:615)
at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:265)
at
javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:
1089)
at
javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:
971)
at
com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:
231)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:
238)
at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:
833)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:
802)
at
com.ibm.ws390.management.connector.corba.CorbaConnectorImpl.invoke(CorbaConnectorImpl.java:
705)
at
com.ibm.ws390.management.connector.corba._CorbaConnectorImplBase._invoke(_CorbaConnectorImplBase.java:
406)
at com.ibm.ws390.orb.CommonBridge.invoke(Unknown Source)
at com.ibm.ws390.orb.ORBEJSBridge.invoke(Unknown Source)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:615)
at
com.ibm.ws390.orb.parameters.ORBEJSBridgeInvoke.ORBEJSBridgeInvokeParmSetter(ORBEJSBridgeInvoke.java:
149)
. com.ibm.ws.management.DataSourceConfigHelperMBean
com.ibm.ws.management.DataSourceConfigHelperMBean
Hi,
I am facing same problems in my setup (WebSphere6.10.15 with RAC-
oracle 10g-2node), can you please tell me how to solve this problem.
Basically I use the following link for configuration help
http://www.ibm.com/developerworks/websphere/techjournal/0706_banerjee/0706_banerjee.html
This is very argent for so please reply as soon as possible.
Please Help Me
Thanks & Regards
Ashish Singh