JDBC connection string for RAC database(Oracle 11g)

[Former Member]

Hi,

Has any one tried using the TNSNAMES entry into the connection string instead of the standard connection string format.

So instead of connection string format " jdbc:oracle:thin:@hostname:port:Databasename" can we use connection string of format "jdbc: oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xyz1.us.oracle.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = xyz2.us.oracle.com)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.xyz.com)))"

Are there any issues/restrictions when configuring RAC database access through JDBC sender adapter?

I have read through a few threads for this but could not find a confirmation regarding succesfully configured RAC url in the connection string for JDBC sender adapter.

The SAP PI version is 7.11 sp4 and Oracle database is 11g(11.2.0)

Thanks.

Siddhesh S.Tawate

[Former Member]

this is what we have been using to connect to the RAC

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.10.11) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST= 192.168.10.12)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME= rac.hostname)))

Nesimi

[Former Member]

Thanks Nesimi,

I was looking for this confirmation, that we can succesfully use the RAC url in JDBC sender adapter.

Regards,

Siddhesh S.Tawate

[Former Member]

Hi Siddesh,

PI JDBC sender adapter does not support RAC support, you have to give JDBC url manually in the comm. channel. JDBC adapter does not manupulate or evaluvate the RAC format.

Regards,

RK

[Former Member]

Hi RK,

You mean to say PI JDBC sender adapter would not support RAC URL format even if the hostname/port are static i.e., I need not pass the host name/port dynamically.

The requirement here is basically to pass the entry in TNSNAMES in place of single host name/port in the conection string jdbc:oracle:thin:@localhost:1521:ora.

In below thread, reply from Anurag Garg talks about using this URL format in JDBC sender succesfully. Just wanted to have a confirmation on this one.

Thanks.

Siddhesh S.Tawate