| Author |
Message
|
| bijesh |
 Posted: Tue Dec 02, 2008 4:39 am Post subject: Connection to Oracle DB |
 |
|
Acolyte
Joined: 30 Jan 2007
Posts: 66
|
Hi,
I've a query on connecting to Oracle DB from WMB v6.1 fixpack 1.
I've created the SystemDSN as given in the infocenter and modified the registry entry to have the WorkArounds value in it. But when I use the SystemDSN in a message flow as a data source name, I get an error during the message flow execution which says, ORA-12154: TNS could not resolve service name . Please respond if any of you'd gone through this.
Is it mandatory to have oracle client installed on the local machine where message broker is installed? The Oracle Db is available on a unix box and the broker is in Windows.
Thanks |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Dec 02, 2008 5:18 am Post subject: Re: Connection to Oracle DB |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| bijesh wrote: |
| Is it mandatory to have oracle client installed on the local machine where message broker is installed? |
Only on 32 bit machines. The DataDirect 64-bit Oracle ODBC Driver is a "wire level" driver and does not need the Oracle client. |
|
| Back to top |
|
|
| bijesh |
| Posted: Tue Dec 02, 2008 6:38 am Post subject: Re: Connection to Oracle DB |
|
|
Acolyte
Joined: 30 Jan 2007
Posts: 66
|
I already have Oracle SQL developer installed on my Windows machine where Broker resides. Am able to connect to the Oracle DB from SQL developer. At the same time, am able to execute queries using SQL developer. But from the broker message flows it gives me the error mentioned in the earlier post.
Hence I would like to know if any configuration is missing. |
|
| Back to top |
|
|
| SAFraser |
| Posted: Tue Dec 02, 2008 10:03 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
When you connect using SQL developer, aren't you using the tnsnames.ora file directly, rather than the SystemDSN? (I don't use this tool, so I'm just asking. But certainly SQLPlus does not use ODBC.)
From the ODBC configuration tool in Windows, is a test connection to the Oracle database successful? |
|
| Back to top |
|
|
| jr_martin |
| Posted: Tue Dec 02, 2008 3:28 pm Post subject: |
|
|
Apprentice
Joined: 24 Aug 2005
Posts: 36
Location: NY
|
Check odbc.ini file, tnsnames.ora on your windows machine.
If your DSN name is ABC:
1.you need to set the parameters for - ABC in odbc.ini.(also make sure that correct odbc.ini file is pointed in mqsiprofile)
2. you need an entry for ABC in tnsnames.ora (ABC=) |
|
| Back to top |
|
|
| jr_martin |
| Posted: Tue Dec 02, 2008 3:35 pm Post subject: |
|
|
Apprentice
Joined: 24 Aug 2005
Posts: 36
Location: NY
|
| Quote: |
| 1.you need to set the parameters for - ABC in odbc.ini.(also make sure that correct odbc.ini file is pointed in mqsiprofile) |
My mistake, For windows you need to do this by odbc tool. What I said was for unix. |
|
| Back to top |
|
|
| bijesh |
| Posted: Wed Dec 03, 2008 12:42 am Post subject: |
|
|
Acolyte
Joined: 30 Jan 2007
Posts: 66
|
| SAFraser wrote: |
From the ODBC configuration tool in Windows, is a test connection to the Oracle database successful? |
Yest it is successful. |
|
| Back to top |
|
|
| AkankshA |
| Posted: Wed Dec 03, 2008 12:45 am Post subject: Re: Connection to Oracle DB |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
| bijesh wrote: |
Hi,
.
Is it mandatory to have oracle client installed on the local machine where message broker is installed? The Oracle Db is available on a unix box and the broker is in Windows.
Thanks |
yes
you do need an oracle client in this case.
_________________
Cheers |
|
| Back to top |
|
|
| bijesh |
| Posted: Thu Dec 04, 2008 6:58 am Post subject: Re: Connection to Oracle DB |
|
|
Acolyte
Joined: 30 Jan 2007
Posts: 66
|
Thanks to all who replied.
I am able to connect to Remote Oracle DB after installing the Oracle client on the local Windows desktop. |
|
| Back to top |
|
|
|
|
