| Author |
Message
|
| mq_abcd |
 Posted: Tue Jan 04, 2005 11:55 am Post subject: Oracle connectivity |
 |
|
Acolyte
Joined: 13 Jun 2004
Posts: 69
|
hi guys,
I am using WBIMB5.0 CSD03
and oracle 9.2 for the database on solaris m/c.
my .odbc.ini file is
[ODBC Data Sources]
ORACLEDB=DataDirect 410 Oracle 8 Driver
[ORACLEDB]
Driver=/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle9
ServerName=DETSORCL
EnableDescribeParam=1
OptimizePrepare=1
[ODBC]
Trace=0
TraceFile=/var/wmqi/odbc/odbctrace.out
TraceDll=/opt/wmqi/merant/lib/odbctrac.so
InstallDir=/opt/wmqi/merant
I am able to connect to the database using the userid and passwd using sqlplus but when use mqsicreatebroker it is unable to connect to the database.
The error is:
BIP2321E: Database error: ODBC return code '-1'.
Please suggest me where i am wrong.
thanks |
|
| Back to top |
|
 |
| kingsley |
| Posted: Tue Jan 04, 2005 1:03 pm Post subject: |
|
|
Disciple
Joined: 30 Sep 2001
Posts: 175
Location: Hursley
|
1. The .odbc.ini must have file permissions of mqm:mqbrkrs
2. LD_LIBRARY_PATH (Set this parameter to the path of .odbc.ini
Set the above
I hope it should solve the problem. |
|
| Back to top |
|
|
| tillywern |
| Posted: Tue Jan 04, 2005 1:03 pm Post subject: Setting database access in WBIMB 5 |
|
|
Centurion
Joined: 28 Jan 2003
Posts: 109
Location: Colorado
|
In version 5 there is a command line utility that is run to set the user name password to be used for each stanza in your odbc.ini..
Check into the 'mqsisetdbparms' command and see if that does the trick. I think it is like
mqsisetdbparms stanza_name db_user_name db_user_passwd |
|
| Back to top |
|
|
| chenulu |
| Posted: Tue Jan 04, 2005 6:28 pm Post subject: |
|
|
Voyager
Joined: 27 Mar 2002
Posts: 87
Location: Research Triangle Park, NC
|
Hi,
Please post the detailed error message from the syslog. Also, make sure that you have run mqsisetupdatabase command.
-- Chenulu |
|
| Back to top |
|
|
| mq_abcd |
| Posted: Wed Jan 05, 2005 6:18 am Post subject: |
|
|
Acolyte
Joined: 13 Jun 2004
Posts: 69
|
Thanks guys
its working, after i craeted the user on the database(using sql).
i thought it is fine if we have the unix userid in the dba group.
but now i'm trying to use the broker on differnt m/c(whihc has oracle client installed) to access this database. I'm unable toconnect to the database even using sqlplus. the listener is running on theOracle server. |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Jan 05, 2005 4:38 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
If there are issues with connecting to the DB using sqlplus then ask your DBA for help.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
