MQSeries.net :: View topic - Database connection with broker's service uid

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Database connection with broker's service uid

Database connection with broker's service uid

« View previous topic :: View next topic »

Author

Message

ajomillar

Posted: Wed Aug 04, 2004 3:06 pm Post subject: Database connection with broker's service uid

Centurion

Joined: 22 Aug 2003
Posts: 121
Location: Milwaukee, WI

I'm using v2.1 on Windows 2000. While running a broker with a service userid called "testid", the broker connects to a Oracle database where testid's account is open (I verified connection with a SQL query tool).

However, when I run a message through the broker, I get this error message in the Event Viewer:

Code:

Database error: SQL State 'HY000'; Native Error Code '28000'; Error Text '[MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-28000: the account is locked

After checking around, it seems like the userid that is being passed to the ODBC driver is my domain id ("arnold"). I used to have an Oracle account but it has been locked for a while. Why is this happening? I created the broker with the service uid of "testid." How do I change the broker (or any other settings) so it uses "testid"?

Nizam

Posted: Wed Aug 04, 2004 4:47 pm Post subject:

Disciple

Joined: 10 Feb 2004
Posts: 160

AJM,
Stop the broker/configuration manager.
Use the command MQSICHANGEBROKER/MQSICHANGECONFIGMGR command.
To change the database service id of the broker use

mqsichangebroker BROKER NAME -a servicePassword -i serviceID -p databasePassword -s UserNameServerQueueManagerName.

Restart the broker.

For documentation on using this command refer to Integrator's Administration Guide.
Nyzam

Nizam

Posted: Wed Aug 04, 2004 5:06 pm Post subject:

Disciple

Joined: 10 Feb 2004
Posts: 160

AJM,
I am sorry, I think my earlier post did not answer your question.
Check out this post
http://www.mqseries.net/phpBB2/viewtopic.php?t=16791
I am sure you would find several posts that would answer your question.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Database connection with broker's service uid

Jump to:

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

Protected by Anti-Spam ACP