Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

WAS configuration for Oracle RAC

266 views
Skip to first unread message

Prassi

unread,
Apr 29, 2008, 2:26:40 PM4/29/08
to
Hi,

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

Prassi

unread,
Apr 29, 2008, 2:29:36 PM4/29/08
to

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

aks....@gmail.com

unread,
Jun 24, 2008, 5:24:38 PM6/24/08
to
On Apr 29, 11:29 pm, Prassi <prasann...@gmail.com> wrote:
> On Apr 29, 11:26 am, Prassi <prasann...@gmail.com> wrote:
>
> > Hi,
>
> > 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_barghout...

>
> 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.ja­va:
> 297)
>         at
> oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSo­urce.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.jav­a:
> 118)
>         at
> com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurat­ionHelper.java:
> 1133)
>         at
> com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigura­tionHelper.java:

> 2356)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 64)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp­l.java:

> 43)
>         at java.lang.reflect.Method.invoke(Method.java:615)
>         at
> com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSourc­e2(DataSourceConfigHelperMBean.java:
> 532)
>         at
> com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSource­ConfigHelperMBean.java:

> 460)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 64)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp­l.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(DelegatingMethodAccessorImp­l.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(RequiredModelMB­ean.java:
> 1089)
>         at
> javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.ja­va:

> 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(DefaultMBeanSe­rverInterceptor.java:

> 833)
>         at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:
> 802)
>         at
> com.ibm.ws390.management.connector.corba.CorbaConnectorImpl.invoke(CorbaCon­nectorImpl.java:
> 705)
>         at
> com.ibm.ws390.management.connector.corba._CorbaConnectorImplBase._invoke(_C­orbaConnectorImplBase.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(DelegatingMethodAccessorImp­l.java:

> 43)
>         at java.lang.reflect.Method.invoke(Method.java:615)
>         at
> com.ibm.ws390.orb.parameters.ORBEJSBridgeInvoke.ORBEJSBridgeInvokeParmSette­r(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

0 new messages