| 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. |
|
| Back to top |
|
 |
| 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 |
|
| Back to top |
|
|
| 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! |
|
| Back to top |
|
|
| 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 |
|
| Back to top |
|
|
| 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 |
|
| Back to top |
|
|
|
|
