Hisham Galal: Oracle Database RAC configuration with UCM

Friday, October 2, 2009

Oracle Database RAC configuration with UCM

If want to configure Oracle Database RAC with Oracle UCM, you will need only to change database connection string inside UCM configuration file (/config/config.cfg), also you can change the connection string using System Properties utility if you want.

The new UCM configurations are:

JdbcDriver=oracle.jdbc.driver.OracleDriver
JdbcConnectionString=jdbc:oracle:thin:@(description=(address_list=(address=(host=your.host1.name)(protocol=tcp)(port=123))(address=(host=your.host2.name)(protocol=tcp)(port=123))(load_balance=yes)(failover=yes))(connect_data=(service_name=service.name)))

4 comments:

lalo620 said...: Hi

I put this connection string:

(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhostname1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = myhostname2)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = my servicename)
)
)

i test that string with a datasource connection and work fine but when i tried to configure UCM with that string cause an error "The Network Adapter could not establish the connection"

Anny suggestion?

Thnks; February 14, 2011 at 6:21 PM
Unknown said...: Try to use ip addresses instead, another thing if you installed DB 11gR2 you can use one IP address (no need for that connection string) called Ora Scan in that case; February 15, 2011 at 11:32 PM
lalo620 said...: I test change the hostname by ip address but i have the same error.

My DB is 10.2.0.4 Enterprise edition

I will change the driver connection; February 16, 2011 at 6:39 PM
Unknown said...: Network Adapter error

ok try to make sure that you can ping those machines from ucm machine. If no problem is there, may be the driver.; February 16, 2011 at 8:46 PM