MQSeries.net :: View topic - Remote-Access Oracle v9.2 with WBIMB v5 on Solaris v9

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 » Remote-Access Oracle v9.2 with WBIMB v5 on Solaris v9

Remote-Access Oracle v9.2 with WBIMB v5 on Solaris v9

« View previous topic :: View next topic »

Author

Message

RAIQ

Posted: Thu Jul 08, 2004 7:25 am Post subject: Remote-Access Oracle v9.2 with WBIMB v5 on Solaris v9

Novice

Joined: 06 Feb 2003
Posts: 23
Location: Switzerland

hi
i have to access a oracle v9.2 database on a remote solaris-box with wbimb v5 with db2 v8.

and i got the following error:

Quote:

DatabaseException
BIP2322E: Database error: SQL State 'IM003'; Native Error Code '80'; Error Text 'Specified driver could not be loaded'.
The error has the following diagnostic information: SQLState: 'IM003' SQL Native Error Code: '80' SQL Error Text 'Specified driver could not be loaded'

i used the odbc-driver that came with wbimb 5 (ukora818.so)
i installed the oracle-client 9.2.0.1.0
i configured/set the odbc.ini / tnsnames.ora / params as follows:

Code:

odbc.ini:
EODS01=DataDirect 410 Oracle 8 Driver

[EODS01]
Driver=/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle9
ServerName=EODS01
EnableDescribeParam=1
OptimizePrepare=1

tnsnames.ora:
EODS01 =
   (DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = etlentw)(PORT = 1521))
   )
   (CONNECT_DATA =
      (SERVICE_NAME = EODS01)
   )
   )

mqsi_setupdatabase:
mqsi_setupdatabase oracle9 /home/oracle/product/9.2.0

env-variables:
oracle_home, ld_library_path, odbcini in profile of broker-user 'wbimb':

ORACLE_HOME=/home/oracle/product/9.2.0
LD_LIBRARY_PATH=/var/mqsi/lib:
      /opt/mqsi/lib:
      /opt/mqsi/jre/lib/sparc:
      /opt/mqsi/merant/lib:
      :
      /home/db2inst1/sqllib/lib:
      /home/oracle/product/9.2.0/lib

ODBCINI=/var/mqsi/odbc/.odbc.ini

set db-params wmqi:
mqsisetdbparms QD02BRK -n EODS01 -u epcr -p *****

yes, sqlplus runs well...

any ideas?
permission-problems?

i read similar topics:
http://www.mqseries.net/phpBB2/viewtopic.php?t=10002

http://www.mqseries.net/phpBB2/viewtopic.php?t=15415

Any help would appreciated.

Jack W. Khaw

Posted: Thu Jul 08, 2004 9:59 am Post subject: try this library instead

Newbie

Joined: 08 Jul 2004
Posts: 7

MQSeries DataDirect 4.10 32-BIT Oracle
_________________
jkhaw

RAIQ

Posted: Tue Jul 13, 2004 11:15 pm Post subject:

Novice

Joined: 06 Feb 2003
Posts: 23
Location: Switzerland

hi jack

i tried with datadirect 5.0 (32bit) and 4.21 (64bit) no success til now...
where can i find datadirect 4.1 (32bit)?

regards!

RAIQ

Posted: Wed Jul 14, 2004 11:31 pm Post subject: no 64bit database

Novice

Joined: 06 Feb 2003
Posts: 23
Location: Switzerland

hi
ibm support told me that wbimb v5 doesn't support 64bit databases. so they suggest me a workaround with a 32bit oracle-client....
i will try it....

regards

RAIQ

Posted: Mon Jul 26, 2004 2:59 am Post subject: Success with 32bit oracle-client

Novice

Joined: 06 Feb 2003
Posts: 23
Location: Switzerland

hi
i tried with 32bit oracle-client...and it works!

regards

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Remote-Access Oracle v9.2 with WBIMB v5 on Solaris v9

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