How to connect to Oracle "real application cluster" RAC?

[matthias_prller]

Hello,

I don't know how the dbUrl-Parameter should look like to connect to an Oracle RAC.

normally I use:

jdbc:oracle:thin:@(Server):(port):(servicename)

e.g.:

jdbc:oracle:thin:@frxxx7....world.com:1521:kfics

but what should I use if I want to connect to an RAC? In this case I don't have a single server?

Thanks for your help.

Regards.

Matthias

[matthias_prller]

Hello again,

I found out half of the solution.

Normally you use a serverUrl like:

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=service)))

normally you can also add other information like failover_mode etc.

BUT: MII (12.0.6) only alows a string of 200 characters. Here is a part of the error-log:

Exception of type com.sap.sql.log.OpenSQLException caught: Cannot assign a java.lang.String object of length 309 to host variable 3 which has JDBC type VARCHAR(200)..

so if I have more than two servers or additionally information for failover_mode etc. I'm not able to use the oracle RAC, because the serverUrl is too long.

Any suggestions?

Regards

Matthias

[Former Member]

In version 12.0, can you use a NetWeaver-defined database connection instead of an MII-defined database connection? Also, be sure to report the bug with the column size - that's far too small for supporting some "exotic" JDBC connection URL's.

[matthias_prller]

Hello,

just for dokumentation: Answer from the SAP support: The issue will be fixed in MII 12.0 SP 7

Regards

Matthias