| Author |
Message
|
| friedl.otto |
 Posted: Tue Jan 15, 2008 3:10 am Post subject: WebSphere Message Broker 6.1.0.1 on SLES x86 64-bit |
 |
|
Centurion
Joined: 06 Jul 2007
Posts: 116
|
PLEASE HELP!
- I installed WebSphere MQ 6.0.1.0 for Linux 64-bit.
- I patched it to 6.0.2.2
- I created a queue manager.
- I installed WebSphere 6.1.0.0 for Linux 64-bit.
- I patched its to 6.1.0.1
- I added . /<install_path>/bin/mqsiprofile to .profile
- I exported the ODBCINI.
- I edited /<install_path>/ODBC64/V5.2/odbc64.ini
- I tested TNS connectivity to Oracle 10g 10.2.0.2.0 - 64bit.
- I executed ./mqsi_setupdatabase oracle <oracle_home>
And when I execute ./mqsicreatebroker this is what I get:
BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
BIP2322E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text ''[DataDirect][ODBC lib] Data source name not found and no default driver specified''.
The error has the following diagnostic information: SQL State ''IM002'' SQL Native Error Code '0' SQL Error Text ''[DataDirect][ODBC lib] Data source name not found and no default driver specified''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
BIP8040E: Unable to connect to the database.
The database cannot be accessed with the userid and password that were specified with the broker.
- Check that the database is running.
- On Windows check that an ODBC connection has been created.
- On systems which use $ODBCINI check that the file pointed to by $ODBCINI has been correctly updated.
- Check that the userid and password pair specified for ODBC connect on the mqsicreate or mqsichangebroker command are capable of being used to connect to the database using an ODBC connection.
- Check that the database has a adequate number of database connections available for use. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Jan 15, 2008 3:14 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Jan 15, 2008 3:14 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Do you have the oracle client installed too? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| friedl.otto |
| Posted: Tue Jan 15, 2008 3:18 am Post subject: |
|
|
Centurion
Joined: 06 Jul 2007
Posts: 116
|
| fjb_saper wrote: |
| Do you have the oracle client installed too? |
If I can sqlplus and run queries ... does that count!?  |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Jan 15, 2008 3:23 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| friedl.otto wrote: |
| fjb_saper wrote: |
| Do you have the oracle client installed too? |
If I can sqlplus and run queries ... does that count!? |
yes that does. Now you need to make sure that the oracle client libraries are accessible to the broker service id. (path, libpath) and that the broker service id has dba rights to its db. Check as well the ora group membership of the broker's service id.
Hope this works for you...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| friedl.otto |
| Posted: Tue Jan 15, 2008 3:24 am Post subject: |
|
|
Centurion
Joined: 06 Jul 2007
Posts: 116
|
| jefflowrey wrote: |
| http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ah14460_.htm |
The Oracle user has:
| Code: |
GRANT CREATE SESSION TO dbid;
GRANT CREATE TABLE TO dbid;
|
|
|
| Back to top |
|
|
| friedl.otto |
| Posted: Tue Jan 15, 2008 3:28 am Post subject: |
|
|
Centurion
Joined: 06 Jul 2007
Posts: 116
|
| fjb_saper wrote: |
yes that does. Now you need to make sure that the oracle client libraries are accessible to the broker service id. (path, libpath) and that the broker service id has dba rights to its db. Check as well the ora group membership of the broker's service id.
Hope this works for you... |
If I log in as Broker's Service ID and I can navigate anywhere in /opt/oracle
does that count?
If the Broker's Service ID is part of the oracle group, are we happy?
Why exactly would a civilised product need dba access? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Jan 15, 2008 3:43 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| friedl.otto wrote: |
The Oracle user has:
| Code: |
GRANT CREATE SESSION TO dbid;
GRANT CREATE TABLE TO dbid;
|
|
Navigating in /opt/oracle does not count.
Can you start SQL plus without giving the path from /var/mqsi using the broker's service Id?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Jan 15, 2008 3:45 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You say "the Oracle user".
Does this mean a different ID than the Broker Service id?
Did you specify a different ID when creating the broker, in addition to specifying the Broker service ID?
Did you specify the right password for that user?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| friedl.otto |
| Posted: Tue Jan 15, 2008 4:01 am Post subject: |
|
|
Centurion
Joined: 06 Jul 2007
Posts: 116
|
Guys ... I sincerely apologise for wasting your time.
When one uses the TNS name where one should in fact use the Data Source Name ... well ... then things will go awry!
Thanks anyway!  |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Jan 15, 2008 4:25 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Easy fix - make the DSN name = TNS name.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
