| Author |
Message
|
| wendy |
 Posted: Thu Apr 14, 2005 1:06 am Post subject: Store data into a remote Oracle database |
 |
|
Apprentice
Joined: 10 Dec 2001
Posts: 47
|
Im running a broker on Unix(Sun solaris) -wqmi v 2.1 .I am trying to store data into remote oracle database and i am getting the following error :
'Specified driver could not be loaded'
I have added the remote database on my odbc.ini file. I am able to store data onthe local DB2 tables .
Please help. |
|
| Back to top |
|
 |
| wendy |
| Posted: Thu Apr 14, 2005 6:01 am Post subject: Do I need to install Oracle on the unix Server |
|
|
Apprentice
Joined: 10 Dec 2001
Posts: 47
|
The examples on the manual assume that oracle is installed on the unix server.
This is now confusing,In my case the oracle database i need to store data is remote. Do i need to install any oracle software on my unix server ? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Apr 14, 2005 6:10 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I think you need the oracle client installed.
And the right oracle odbc drivers (which might be installed with WMQI).
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| JT |
| Posted: Thu Apr 14, 2005 11:28 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| I think you need the oracle client installed |
You do. Once the Oracle client is installed on the broker server, the /oracle_home/network/admin/tnsname.ora file has to be configured to point to the remote database server.
| Quote: |
| And the right oracle odbc drivers (which might be installed with WMQI). |
They are. I believe they're located in the same lcoation as v5.0: /opt/wmqi/merant/lib/ |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Apr 14, 2005 11:35 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| JT wrote: |
| I believe they're located in the same lcoation as v5.0: /opt/wmqi/merant/lib/ |
Wendy is using 2.1. But they should still be in the same place.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wendy |
| Posted: Fri Apr 22, 2005 1:32 am Post subject: Orcacle Driver error |
|
|
Apprentice
Joined: 10 Dec 2001
Posts: 47
|
The f file /oracle_home/network/admin/tnsname.ora is configured correctly ,including the odbc.ini file.I am still get the error
'Specified driver could not be loaded'.
Pls help .What do i do.
On the admin manual it says i need to run the commands mqsi_seupdatabase and run the ln.
I have done that but the oracle_home i used is the on the local server not the remote.Im not sure what to do.Please shed some light guys.
Thanks.
pl note that the remote server is unix. |
|
| Back to top |
|
|
| JT |
| Posted: Fri Apr 22, 2005 7:41 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
Post the contents of your .odbc.ini file and the format of the mqsi_setupdatabase command you used.
| Quote: |
| .....the oracle_home i used is the on the local server not the remote |
That's correct.
Did you set the environment variables, ORACLE_HOME, ODBCINI......? |
|
| Back to top |
|
|
| wendy |
| Posted: Fri Apr 22, 2005 10:21 am Post subject: ORA-12154: TNS:could not resolve service name |
|
|
Apprentice
Joined: 10 Dec 2001
Posts: 47
|
I am now getting the error [MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-12154: TNS:could not resolve service name
Below is my odbc details :
PAPDEV=MERANT 3.70 Oracle 8 Driver
[PAPDEV]
Driver=/opt/wmqi/merant/lib/UKor816.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=fnetdev
EnableDescribeParam=1
OptimizePrepare=1
The command i ran is mqsi_setupdatabase oracle /udd001/app/oracle/product/8.1.7_client/
I can tnsping the remote database and i can connect to it without a problem but wmiq keeps crashing.
Help  |
|
| Back to top |
|
|
| JT |
| Posted: Fri Apr 22, 2005 10:26 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Post the contents of tnsnames.ora |
|
| Back to top |
|
|
| wendy |
| Posted: Sun Apr 24, 2005 4:17 am Post subject: Tnsnames.ora file contents |
|
|
Apprentice
Joined: 10 Dec 2001
Posts: 47
|
contents of the tnsname.ora file are below.Pls note that the server i am connecting to is fnetdev ,database name is papdev.
# TNSNAMES.ORA Network Configuration File: /udd001/app/oracle/product/8.1.7_client/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
#PAPYRUS =
# (DESCRIPTION =
# (ADDRESS_LIST =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 163.202.9.166)(PORT = 1521))
# (ADDRESS = (PROTOCOL = TCP)(HOST = 163.202.9.166)(PORT = 1526))
# )
# (CONNECT_DATA =
# (SERVICE_NAME = papyrus)
# )
# )
PAPDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = fnetdev)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = fnetdev)(PORT = 1526))
)
(CONNECT_DATA =
(SID = papdev)
(GLOBAL_NAME = papdev)
)
) |
|
| Back to top |
|
|
| JT |
| Posted: Sun Apr 24, 2005 8:52 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
The ServerName parameter needs to reference an entry in the tnsnames.ora file:
| Quote: |
[PAPDEV]
Driver=/opt/wmqi/merant/lib/UKor816.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=PAPDEV
EnableDescribeParam=1
OptimizePrepare=1 |
|
|
| Back to top |
|
|
| wendy |
| Posted: Sun Apr 24, 2005 9:19 am Post subject: invalid username/password; logon denied |
|
|
Apprentice
Joined: 10 Dec 2001
Posts: 47
|
Thanks so much!!! the is progress.I wqould have never figured that out!!! I am now getting the error :
'[MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-01017: invalid username/password; logon denied '
I suppose i need to create the wmqi user name on the remote database.
Please confirm.
Below is the entry on the sql.log on the remote server
24-APR-2005 19:07:00 * (CONNECT_DATA=(SID=papdev)(GLOBAL_NAME=papdev.world)(CID=(PROGRAM=)(HOST=fnetdev)(USER=mqm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.202.9.25)(PORT=58406)) * establish * papdev * 0
24-APR-2005 19:07:00 * (CONNECT_DATA=(SID=IDBExtProc)) * (ADDRESS=(PROTOCOL=ipc)(KEY=extproc)) * establish * IDBExtProc * 0
24-APR-2005 19:07:02 * (CONNECT_DATA=(SID=papdev)(GLOBAL_NAME=papdev.world)(CID=(PROGRAM=)(HOST=fnetdev)(USER=mqm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.202.9.25)(PORT=58412)) * establish * papdev * 0
24-APR-2005 19:07:02 * (CONNECT_DATA=(SID=papdev)(GLOBAL_NAME=papdev.world)(CID=(PROGRAM=)(HOST=fnetdev)(USER=mqm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=163.202.9.25)(PORT=58413)) * establish * papdev * 0
Does that mean i need to create the user 'mqm' on the oracle database? |
|
| Back to top |
|
|
| Tibor |
| Posted: Mon Apr 25, 2005 1:01 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
AFAIK, you *have* to connect with same userid/password to all databases This is a known limitation in v2.1.
Tibor |
|
| Back to top |
|
|
| wendy |
| Posted: Mon Apr 25, 2005 2:08 am Post subject: Hoooray!! |
|
|
Apprentice
Joined: 10 Dec 2001
Posts: 47
|
We created the same user on the remote database ,its now working  .
Thanks for all your input, i appreciate.I am now storing data into a remote oracle db.
P.S. JT Rocks!!! |
|
| Back to top |
|
|
| wendy |
| Posted: Tue Apr 26, 2005 5:28 am Post subject: Invalid precision value.6044' |
|
|
Apprentice
Joined: 10 Dec 2001
Posts: 47
|
Spoke too soon!!!
When the XML data I am inserting into the remote database is small (> 4 KB) it works, but when I put big message (> 9kb). I get the error:
‘MQSI: Database error: [MERANT][ODBC Oracle 8 driver] Invalid precision value.6044'
The column I am inserting in is data type CLOB.
One of the posting suggested I use oracle drivers instead of the Merant WMQI drivers (/opt/wmqi/merant/lib/UKor816.so). How do I go about doing this?
I think there is a limitation on either the drivers I am using or the client. Please help.
Thanks |
|
| Back to top |
|
|
|
|
