| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [Solved]Howto configure WMB 6.1.0.3 for Oracle DataGuard DB? |
« View previous topic :: View next topic » |
| Author |
Message
|
| tucanen |
 Posted: Thu May 14, 2009 12:32 am Post subject: [Solved]Howto configure WMB 6.1.0.3 for Oracle DataGuard DB? |
 |
|
Novice
Joined: 27 Jun 2005
Posts: 22
Location: Sweden
|
How to configure WMB 6.1.0.3 64-bit ODBC Data Sources for Oracle Data Guard DB?
I currently struggling with understanding how I can configure WMB 6.1.0.3 (AIX) 64-bit ODBC datasource for an Oracle Data Guard database having two physical servers with failover possibility between the databases.
I don't feel that the documentation (http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ah14444_.htm) is telling us how to configure Oracle RAC Wire Protocol Driver for multiple hostnames. It supports only one hostname and port etc. 
My DBA is referring to a TAF name that appears to be kind of a logical name for both the hot database and the stand by database as I understand. But it looks like it is on a oracle TNS name service level. If I've got it right..
Unfortunately I don't know if the Oracle RAC Wire protocol driver is even compatible with Oracle Data Guard. It is hard to find documentation on this subject.
Since the 5.3 64-bit data direct drivers for Oracle are all "Wire protocol drivers" Oracle Client and tnsnames.ora is not used by the broker/Data direct ODBC-drivers as I understand from the forum and documentation.
Is there any way or undocumented property of any of the 64-bit oracle data direct drivers bundled with wmb 6.1.0.3 that supports resolving services using the oracle runtime client or oracle instant client using SQL Net (tnsnames.ora) ?
What I'm trying to achieve is "connect time failover". transparent application failover would be even better though  But failing over to the secondary database in case of a broken connection or a time out is maybe good enough.
Has anyone done this or know how to do this? 
Grateful for all input.
/ contact admin
Last edited by tucanen on Tue May 19, 2009 5:39 am; edited 1 time in total |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Thu May 14, 2009 1:28 am Post subject: Re: How to configure WMB 6.1.0.3 for Oracle Data Guard DB? |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| tucanen wrote: |
[b]
Since the 5.3 64-bit data direct drivers for Oracle are all "Wire protocol drivers" Oracle Client and tnsnames.ora is not used by the broker/Data direct ODBC-drivers as I understand from the forum and documentation.
|
I dont understand what you meant by this statement,
Very recently i have set up an environment, where MB V6.1/MQV7 runs on Linux Box (Virtual Machine) and Oracle10g runs on another windows Box (Virtual Machine)
Instead of pointing to the DSN, i made the broker to point TNSNames.ora via ODBC.INI.
*MB communicates with DB through Oracle Client.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Thu May 14, 2009 2:52 am Post subject: Re: How to configure WMB 6.1.0.3 for Oracle Data Guard DB? |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
|
| Back to top |
|
|
| tucanen |
| Posted: Thu May 14, 2009 2:54 am Post subject: Re: How to configure WMB 6.1.0.3 for Oracle Data Guard DB? |
|
|
Novice
Joined: 27 Jun 2005
Posts: 22
Location: Sweden
|
| Gaya3 wrote: |
| tucanen wrote: |
[b]
Since the 5.3 64-bit data direct drivers for Oracle are all "Wire protocol drivers" Oracle Client and tnsnames.ora is not used by the broker/Data direct ODBC-drivers as I understand from the forum and documentation.
|
I dont understand what you meant by this statement,
Very recently i have set up an environment, where MB V6.1/MQV7 runs on Linux Box (Virtual Machine) and Oracle10g runs on another windows Box (Virtual Machine)
Instead of pointing to the DSN, i made the broker to point TNSNames.ora via ODBC.INI.
*MB communicates with DB through Oracle Client. |
Hi Gaya,
Thanks for your reply.
Which fix pack level do you use for wmb 6.1?
Would it be possible to have a look at the relevant data source definition from your odbc.ini?
What I mean is there appears to be no bundled 64-bit odbc driver with wmb 6.1.0.3 that is not wire protocol drivers. I don't think that the Wire protocol drivers use the oracle net (and tnsnames.ora). They talk directly to Oracle over the network instead of going through the local client.
I think that the data direct v5.0 drivers works with the oracle net, but that would be using old drivers. I see in the documentation for WMB 6.1.0.3 that Oracle Net _is_ supported using _32-bit_ version of the data direct v5.3 drivers = Non wire protocol driver.
Now when I read also the 32-bit config instructions at http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ah14444_.htm I start to wonder if it might also be supported in 64-bit mode, but not documented in the wmb info center.
I will try it out and let you know the result
Thanks,
contact admin |
|
| Back to top |
|
|
| tucanen |
| Posted: Tue May 19, 2009 5:36 am Post subject: |
|
|
Novice
Joined: 27 Jun 2005
Posts: 22
Location: Sweden
|
 
Good news!
I think I understand now what you mean Gaya.
I think the WMB manual might be a bit misleading in the sense that it is easy to get the impression that the new Oracle Wire Protocol ODBC driver requires us to specify the hostname, port number and SID/SERVICE of the oracle database, instead of using SQL Net to resolve those details.
In the ODBC64 directory under $MQSI_FILEPATH/ODBC64/V5.3/help/ I found a text file "oraclewp_connect.txt" that contained the following important info among others:
| Code: |
NOTE: If you want to configure a TNSNames connection, complete only the following field.
SERVER NAME: Type a net service name that exists in the TNSNAMES.ORA file. The corresponding entry in the TNSNAMES.ORA file is used to obtain Host, Port Number, and SID information.
If you enter a value for this field, the Host, Port Number, SID, and Service Name fields are not available.
If you enter a value for either the Host, Port Number, SID, or Service Name fields, this field is not available. |
Using this method seems to work fine with the oracle wire protocol driver.
It seems that one needs to set the ORACLE_HOME environment variable and place the tnsnames.ora file under $ORACLE_HOME/network/admin/tnsnames.ora
My plan is to use the following kind of setup in order to achive connect time failover at the database client side.
Example tnsnames.ora config:
| Code: |
WMBDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <NODE1>)(PORT = <XXXX>))
(ADDRESS = (PROTOCOL = TCP)(HOST = <NODE2>)(PORT = <XXXX>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WMBDB)
)
)
|
Example cut out from odbc.ini:
| Code: |
;# Oracle stanza
[WMB001]
Driver=/usr/wmb6.1.0.3/ODBC64/V5.3/lib/UKora23.so
Description=Broker Database for message broker WMB001
;;HostName=
;;PortNumber=
;;SID=
ServerName=WMBDB
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
|
Thanks for all input in this matter.
Kind regards,
contact admin |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue May 19, 2009 11:06 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
great to know that its been resolved.
We have set up DSN to resolve the IPAddress issues too..
you can make your MB not to depend on the Static IPAddress.
Let the ODBC Points to TNSName.ora and TNSNames.ora uses DSN Values instead of IPAddress.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| tucanen |
| Posted: Tue May 19, 2009 11:24 pm Post subject: |
|
|
Novice
Joined: 27 Jun 2005
Posts: 22
Location: Sweden
|
| Gaya3 wrote: |
great to know that its been resolved.
We have set up DSN to resolve the IPAddress issues too..
you can make your MB not to depend on the Static IPAddress.
Let the ODBC Points to TNSName.ora and TNSNames.ora uses DSN Values instead of IPAddress. |
Hi Gaya,
That sounds interesting.
Can you describe what you mean by TNSNames.ora uses DSN values instead of ip address? Perhaps give an example
Kind regards,
contact admin |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
