| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| need help in setting up Oracle database / odbc .ini |
« View previous topic :: View next topic » |
| Author |
Message
|
| ydsk |
 Posted: Fri Dec 30, 2005 10:38 am Post subject: need help in setting up Oracle database / odbc .ini |
 |
|
Chevalier
Joined: 23 May 2005
Posts: 410
|
Hi,
We have a AIX box and WMQv5.3 has been installed on it. A qmgr was also built aready. WMBv6 has been installed and I need to configure it and then build a broker and configmgr on the same box.
The oracle database is set up on a different ( remote) AIX box, and we need to use it for the broker.How do I configure the odbc entries and tnsnames.ora file on the box where the broker resides ? Please help.
Thanks.
ydsk. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Dec 30, 2005 10:41 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Please read the Documentation.
There are specific, explicit, step by step instructions for what you have just asked.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| premkumar |
| Posted: Sun Jan 01, 2006 10:35 pm Post subject: |
|
|
Apprentice
Joined: 24 Feb 2004
Posts: 40
|
In case of AIX...
1. Issue the following command...
mqsi_setupdatabase database_type <database_install_directory>
where database_type is db2, oracle9, oracle10, or sybase12_5 and <database_install_directory> is the directory in which the database is (or will be) installed (for example, /usr/lpp/db2_08_01 or /opt/IBM/db2)
2.Logon as root.
3. Create a database instance. Use the commands shown here for guidance for the different platforms.
On AIX:
/usr/lpp/db2_07_01/instance/db2icrt -u <fence userID> <username>
4. Logon as <username>
Create a database (in this example called WBRKBKDB) using the following commands (on some platforms, an explicit path name is required).
Note: You must insert a space between the starting period and the tilde character in the first command shown here:
. ~/sqllib/db2profile
db2start
db2 create database WBRKBKDB
db2 connect to WBRKBKDB
db2 bind ~/sqllib/bnd/@db2cli.lst grant public CLIPKG 5
5. You must increase the database heap size to ensure it is sufficient for the broker
_________________
Thanks and Regards,
Premkumar.S |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
