on 06-16-2012 6:12 PM
Hi Guys,
We have several XI interfaces in a Production landscape that make use of the sender and receiver JDBC adapter which they use to send and receive data from an external Oracle database. The connection URL has the following fomat jdbc:oracle:thin:@IPaddress:dbname
The Oracle database has now changed and it is going to be a cluster with 3 IP addresses that will be accessed via DNS names. Therefore, I need to modify the connection URL as well. Is this going to be simply by using the cluster's hostname instead of the IP, i.e. jdbc:oracle:thin:@hostname:dbname ?
Waiting for your comments. Thank you.
Hi,
>>>simply by using the cluster's hostname instead of the IP, i.e. jdbc:oracle:thin:@hostname:dbname ?
yes - you can use the hostname,
please also have a look at oracle pages for alternatives:
Regards,
Michal Krawczyk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your helpful reply Michal. I have one more question in a separate thread:
After the DB switch to cluster, the JDBC sender adapter returned the following error when trying to update the data in the database: "java.sql.SQLException:ORA-08177: can't serialize access for this transaction. For details, contact your database server vendor."
The trasaction isolation level in the Advanced tab of the sender JDBC adapter is set to "serializable". Do you think that this is not supported by the cluster/rac DB environment? And what is the best value for that field to be used when in a cluster/rac database landscape? I've set it to "read-commited" instead and it worked. Thanks.
Hi ,
Have you checked with your DB team like what is the SID name, usually they create Create SID , use SID and DB name.
Better to check with DB team.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you use cluster mode, referring hostname is the better practice. Because in unix level you can map hostname with multiple ip address in the host file.
So use hostname for the connection jdbc connection string.
http://programmersjournal.blogspot.com/2008/08/jdbc-connection-string-for-oracle-rac.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.