Hello,
I am in the process of converting our database to use an Oracle RAC with two nodes in the cluster. This will be primarily for High Availability (that is, we are not using it for load balancing). I modified the openfire.xml configuration file, specifying the server url like so:
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@(DESCRIPTION =
(
address_list=(load_balance=off)(failover=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = orac01)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = orac02)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = my_service_name)
)
)
username
secret
5
15
1.0
When starting Openfire I get the following:
2009.03.25 08:44:06 [org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:111)] Faile
d to create new connections on startup. Attempt 0 of 3
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
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.(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jivesoftware.database.ConnectionPool.createCon(ConnectionPool.java:443)
at org.jivesoftware.database.ConnectionPool.(ConnectionPool.java:88)
at org.jivesoftware.database.DefaultConnectionProvider.start(DefaultConnectionProv ider.java:
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.j
ava:459)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:77)
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:330)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:72)
at org.jivesoftware.util.JiveProperties$JivePropertyHolder.(JiveProperties .java:39)
at org.jivesoftware.util.JiveProperties.getInstance(JiveProperties.java:51)
at org.jivesoftware.util.JiveGlobals.getProperty(JiveGlobals.java:524)
at org.jivesoftware.openfire.XMPPServer.initialize(XMPPServer.java:327)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:434)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:155)
And, of course, Openfire doesn’t start.
Has anyone successfully configured Openfire to connect to an Oracle RAC service?
Environment Notes:
Server is running CentOS 5.1
Openfire 3.4.4
Oracle 10g w/ RAC
Oracle 10 jdbc driver
Any help would be greatly appreciated!
TIA,
Mike L.