| Author |
Message
|
| mqwbiwf |
 Posted: Tue Apr 24, 2007 1:51 pm Post subject: error while creating broker |
 |
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
hi,
here's the env:
aix , message broker 6, oracle 9(external).
when creating a broker, it's throwing the foll msg:
$ mqsicreatebroker **** -i **** -a **** -q **** -n **** -u **** -p ***
AMQ8110: WebSphere MQ queue manager already exists.
WebSphere MQ queue manager running.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
BIP8146E: Unable to retrieve the SQL primitives supported by the Database.
The command attempted to retrieve the SQL primitives that the Database supports, however the primitives retrieved indicate that the Database could not be contacted successfully. Refer to the Administration Guide for information about Database setup, ensure that the Database libraries are available in the library path and that the ODBC ini file is correct.
Correct the problem and retry the command.
made sure that user id has full permissions on the db. tried creating a table and was successful. the LIBPATH variable is pointing to oracle lib32 directory.
guys, any other thoughts on this issue will be greatly appreciated...thanks:)
Last edited by mqwbiwf on Tue Apr 24, 2007 1:59 pm; edited 1 time in total |
|
| Back to top |
|
 |
| wschutz |
| Posted: Tue Apr 24, 2007 1:53 pm Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
| Quote: |
| Refer to the Administration Guide for information about Database setup, ensure that the Database libraries are available in the library path and that the ODBC ini file is correct. |
_________________
-wayne |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Tue Apr 24, 2007 2:00 pm Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
the LIBPATH variable is pointing to oracle lib32 directory. infact, i was able to create table using sqlplus using the same id/pwd used to create the broker.
odbcini file:
[ODBC Data Sources]
X321=DataDirect 5.0 Oracle
[X321]
Driver=/usr/opt/mqsi/merant/lib/UKor820.so
Description=DataDirect 5.0 Oracle
EnableDescribeParam=1
OptimizePrepare=1
ServerName=XXX
WorkArounds=536870912
ProcedureRetResults=1
tnsnames.ora also has the entry for the above db server. |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Wed Apr 25, 2007 5:33 am Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
| Guys, could someone tell me where else should I be looking at to fix this issue? |
|
| Back to top |
|
|
| PieterV |
| Posted: Wed Apr 25, 2007 5:33 am Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
try:
mqsi_setupdatabase oracle9 $ORACLE_HOME |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Wed Apr 25, 2007 6:01 am Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
i have already done that Peter. and it created symbolic links.
dont think this helps, but we have java 1.3.something on this box, should it be java1.4? |
|
| Back to top |
|
|
| PieterV |
| Posted: Wed Apr 25, 2007 6:10 am Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Wed Apr 25, 2007 6:22 am Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
yeah, the first thing i did was to get this page and made sure every thing is defined properly. and yes it is. infact i didn't had any problem while doing on a diff system!
Say XYZ is defined as the data source in ODBCINI, and a corresponding entry is made in tnsnames.ora. tried connecting using sqlplus using the same uid and pwd used to connect to external db, was successful, and create a test table as well.
LIBPATH is set to $ORACLE_HOME/lib32 and all files in there have permissions set to 664.
One question though: I don't remember properly, but do we have the /var/wmqi/lib directory even before creating the broker? Or is this directory created after creating the broker? Coz in the other box where I have the broker setup, I also have LIBPATH=/var/wmqi/lib:$LIBPATH. Not sure if I added this to profile after creating the broker or before creating the broker.
I don't find this directory (/var/wmqi/lib) on the box where I'm trying to create broker. |
|
| Back to top |
|
|
| PieterV |
| Posted: Wed Apr 25, 2007 10:14 pm Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
I dont have a lib folder in /var/mqsi/ (MB 6 / Solaris).
have you tried starting a trace (in /var/mqsi/.odbc)? |
|
| Back to top |
|
|
|
|
