| Author |
Message
|
| Srinu |
 Posted: Fri Nov 04, 2005 10:48 am Post subject: interacting Remote Database |
 |
|
Acolyte
Joined: 15 Jun 2005
Posts: 51
|
Hi,
In one of my scenerio, I have to interact with remote database from oracle client. I am able to do it form WBIMB v5.0.
When doing with WBIMB v6.0 I am getting a database exception as access denied. So please suggest me the necessary changes I have to do. |
|
| Back to top |
|
 |
| seeknee |
| Posted: Tue Nov 08, 2005 2:03 pm Post subject: |
|
|
Apprentice
Joined: 08 Aug 2002
Posts: 41
Location: Melbourne, Australia
|
Hi
Have you set the db parameters
mqsisetdbparms %BROKER% -n %DBNAME -u %USER% -p %PWD%
 |
|
| Back to top |
|
|
| Srinu |
| Posted: Wed Nov 09, 2005 5:42 am Post subject: Interacting with Oracle database from WBIMB6.0 |
|
|
Acolyte
Joined: 15 Jun 2005
Posts: 51
|
Hi,
I have set the db parameters, even then it is not working in WBIMB6.0. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Wed Nov 09, 2005 8:13 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Did you create a new user or something...??
Why dont you add the MB user to the DB group again....
Check in your services whether the DB and MB are running on Local System......set it to that if not...
Regards. |
|
| Back to top |
|
|
| Srinu |
| Posted: Thu Nov 10, 2005 6:10 am Post subject: Interacting remote database. |
|
|
Acolyte
Joined: 15 Jun 2005
Posts: 51
|
Hi,
No,I did not create any new user.
I am having oracle client on my system and trying to connect remote database. Where should i add my user.
Thanks |
|
| Back to top |
|
|
| EddieA |
| Posted: Thu Nov 10, 2005 10:39 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Are the v5 and v6 brokers on the same box.
Can you connect, from where you have v6 installed, to the DB using SQLPlus AND the user/passwd you specified in mqsidbparms.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| Srinu |
| Posted: Fri Nov 11, 2005 7:41 am Post subject: |
|
|
Acolyte
Joined: 15 Jun 2005
Posts: 51
|
Yes I am having V5 and V6 in the same system.
Yes I am able to connect DB using SQLPlus with the userid and password specified in dbparms.
Thanks |
|
| Back to top |
|
|
| EddieA |
| Posted: Fri Nov 11, 2005 9:55 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
And are you using the same ODBC connection.
I'd try an ODBC trace to verify the DB name and ID being used.
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Nov 11, 2005 9:17 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Are you promoting the Database Name to the Bar level.....if yes, are you accessing the right database there....???
Just try to use a Mapping node or something and attempt to open some table in the database u need.....you'll know if its access issues or something i the compute that is not working.....
Regards. |
|
| Back to top |
|
|
|
|
