| Author |
Message
|
| ben harris |
 Posted: Wed Mar 24, 2004 2:10 pm Post subject: config problem: fmczutil offers only db2 when I want oracle. |
 |
|
Novice
Joined: 25 Jun 2003
Posts: 19
|
I am trying to configure a workflow server in a 3tier setup.
I have run all the fmczinsx commands and everything looks good.
No db2 anywhere. Everything links to Oracle.
But when I run fmczutil and begin to configure the database:
FMC33590I Configuration of Runtime database ...:
u ... ( ) Use an existing Runtime database
n ... (X) Create a new Runtime database
l ... (X) Local database
r ... ( ) Remote database
DB2 instance : [db2inst1]
!! it says DB2 !!
Any ideas what I might have missed???
When I review the fmczinsx.log is shows that oracle was set correctly.
FMC003 15:07:39 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
FMC004 15:07:39 +++ Started at ......: Wed Mar 24 15:07:39 CST 2004
FMC005 15:07:39 +++ by user .........: root
FMC007 15:07:39 +++ invocation args .: /usr/bin/fmczinsx -o oracle9
FMC009 15:07:39 +++ current version .: 3.4.0
FMC003 15:07:39 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
FMC00100 15:07:39 Values from installation profile /usr/lpp/fmc/fmcrc successfully read.
FMC00150 15:07:39 System wide Workflow setup changed to support database Oracle 9i
FMC00155 15:07:39 Checking availability of required shared libraries for database Oracle 9i
FMC00156 15:07:39 Found shared library /usr/lpp/fmc/lib/workflow/libclntsh.a
FMC00171 15:07:39 +++ Function completed successfully +++
FMC00172 15:07:39 +++ Log information is located in: /var/fmc/fmczinsx.log
I am really at a loss and any help would be appreciated.
Has any ever experienced this? |
|
| Back to top |
|
 |
| vennela |
| Posted: Wed Mar 24, 2004 3:09 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
What OS??
If it is HP (or even Solaris) then you should apply the latest service pack before you configure workflow.
This is just a guess, because I have no experience with workflow on Oracle but looking at the APARs listed in the service pack I think that is the right thing to do before you try anything.
This is one of the PMRs
| Quote: |
18596 HP-UX: Configuration switch for Oracle or MQServer fails
|
-------
Vennela |
|
| Back to top |
|
|
| ben harris |
| Posted: Wed Mar 24, 2004 3:15 pm Post subject: |
|
|
Novice
Joined: 25 Jun 2003
Posts: 19
|
AIX 5.
I have applied fp4.
I have done an slibclean but still I get the db2 prompt.
I am almost thinking of requesting a system reboot.(?) |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Mar 24, 2004 3:18 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
In your AIX installation profile what do you have for RTDatabaseType
The installation profile is in the file
/usr/lpp/fmc/fmcrc
See if it is set to Oracle. If you don't have a problem post the fmcrc |
|
| Back to top |
|
|
| ben harris |
| Posted: Thu Mar 25, 2004 7:38 am Post subject: |
|
|
Novice
Joined: 25 Jun 2003
Posts: 19
|
Here is my fmcrc:
Installation/InstallationDirectory=/usr/lpp/fmc
Installation/ConfigurationRootDirectory=/var/fmc
Installation/InstalledComponents=WSIHPJCUAD
Installation/MQWorkflowAdministrator=fmc
Installation/MQWorkflowGroup=fmcgrp
Installation/VRM=030400
Installation/ServiceLevel=4
Installation/Language=enu
Installation/RTDatabaseType=ORACLE
Installation/MQConnectionType=MQServer
I had the system rebooted and I still experience the db2 prompts.
b. |
|
| Back to top |
|
|
| vennela |
| Posted: Thu Mar 25, 2004 7:46 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| I have no more ideas. Maybe you should open a PMR. |
|
| Back to top |
|
|
| mqworkflow |
| Posted: Sun Mar 28, 2004 8:12 am Post subject: |
|
|
Apprentice
Joined: 23 Feb 2004
Posts: 32
|
The following is from 3.4 SP4 or SP5 Readme.
1. Make sure that you have installed Oracle 9i Release 2. Before you can use this database version in a new configuration, you must set the
environment variable 'FMC_CFG_RT_DBVERSION' to '9.2' and then start the configuration utility fmczutil to create a new configuration.
2. Make sure you have the ORACLE_HOME env variables set for the user who is configuring the workflow.
Hope this helps.
mqwf |
|
| Back to top |
|
|
| sshaker |
| Posted: Tue Mar 30, 2004 12:45 pm Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 185
|
i hope u did run the fmczinsx -0 <db> command before configuring?
_________________
shaker |
|
| Back to top |
|
|
| vennela |
| Posted: Tue Mar 30, 2004 12:52 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
shaker:
You should read the post completely and give some better answers or do not answer the question.
Thanks for being helpful but sometimes you also need to give some useful answers ..........
In his very first post he said
| Quote: |
I have run all the fmczinsx commands and everything looks good.
|
|
|
| Back to top |
|
|
| sshaker |
| Posted: Tue Mar 30, 2004 1:13 pm Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 185
|
i appreciate your correction.. ! i just wanted to make sure that the particular command was issued and with proper value !! once again, it was a great effort on your part to help the forum.
_________________
shaker |
|
| Back to top |
|
|
| ben harris |
| Posted: Wed Mar 31, 2004 2:30 pm Post subject: |
|
|
Novice
Joined: 25 Jun 2003
Posts: 19
|
I have opened a PMR with IBM.
They haven't been able to identify anything yet.
Does anyone know what link or file triggers the fmczutil tool to prompt for db2 or oracle information?
I keep looking over my files looking for something mis-linked or with the wrong info. But I haven't seen anything...That's not to say I know exactly what Iam looking for.
Ben. |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Mar 31, 2004 2:41 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
Ben
Did you try this.
Let us know whether it worked or not.
| mqworkflow wrote: |
The following is from 3.4 SP4 or SP5 Readme.
1. Make sure that you have installed Oracle 9i Release 2. Before you can use this database version in a new configuration, you must set the
environment variable 'FMC_CFG_RT_DBVERSION' to '9.2' and then start the configuration utility fmczutil to create a new configuration.
2. Make sure you have the ORACLE_HOME env variables set for the user who is configuring the workflow.
Hope this helps.
mqwf |
|
|
| Back to top |
|
|
| mqworkflow |
| Posted: Thu Apr 01, 2004 6:24 am Post subject: |
|
|
Apprentice
Joined: 23 Feb 2004
Posts: 32
|
Hi Ben,
I have a few things for you to check.
1. Just making sure you are chosing 'r' here as you said you are trying to set up a 3-tier environment. And also you dont have any DB2 server running on either the machine with workflow or the machine with oracle.
| Quote: |
l ... (X) Local database
r ... ( ) Remote database
|
2. Wondering if you did follow the exact instructions from Page 85 Installation Guide
configure an MQ Workflow server to use Oracle for the Runtime
database, check that the shared libraries are in the search path.
If you want to configure an MQ Workflow server to use Oracle for the
Runtime database, make sure that the shared libraries used by Oracle
applications are available via a standard library search path.
These libraries are necessary for the Transaction Coordinator (XA)
switch file ″oraswit″ located in InstDir/oraswit. ’oraswit’ will search
through the following directories for the required shared libraries:
1. InstDir/lib/workflow (InstDir has the default values: On AIX,
/usr/lpp/fmc. On HP-UX and Solaris, /opt/fmc)
2. /usr/lib
3. /opt/oracle/product/8.1.7/lib
4. /opt/oracle/product/9.0.1/lib
5. /opt/oracle/product/9.2.0/lib
One of these directories must contain a link to the following shared
libraries within $ORACLE_HOME/lib:
For AIX: libclntsh.a
For Solaris: libclntsh.so, libwtc8.so or libwtc9.so
For HP-UX 11: libclntsh.sl
Note: It is not enough to set a libpath environment variable like
LIBPATH (for AIX), LD_LIBRARY_PATH (for Solaris), or SHLIB_PATH (for
HP-UX).[/quote]
3. Your fmcrc says the link file as libclntsh.a. I have checked my file here and it says
| Quote: |
FMC00156 10:45:55 Found shared library /opt/fmc/lib/libclntsh.so
FMC00156 10:45:55 Found shared library /opt/fmc/lib/libwtc9.so
|
4. Also check the qm.ini file in the var/mqm/QMGR directory. It should have something like
| Quote: |
XAResourceManager:
Name=FMCDB
SwitchFile=/opt/fmc/oraswit/oraswit
XAOpenString=Oracle_XA+Acc=P/*user*/*password*+SqlNet=FMCDB+SesTm=15
|
where user/password is the one who you defined as the database user for runtime database.
5. Try doing a sqlplus from the workflow machine and connect to the database
6. check the AMQERR01.LOG file, if it says something like Qmanager started without the XA resource.
7. Make sure you have the following defined in the profile file for both the
'root' and 'workflow config user'
ORACLE_BASE=/opt/app/oracle
ORACLE_HOME=/opt/app/oracle/product/9.2.0
I didnt realize they were these many though.
Good Luck
mqwf |
|
| Back to top |
|
|
| ben harris |
| Posted: Thu Apr 01, 2004 6:58 am Post subject: |
|
|
Novice
Joined: 25 Jun 2003
Posts: 19
|
| Quote: |
And also you dont have any DB2 server running on either the machine with workflow or the machine with oracle.
|
 hmm...well it turns out I think I do have db2 running.
Here is a ps:
| Quote: |
root 13958 1 0 Mar 26 - 0:01 /usr/opt/db2_08_01/bin/db2fmcd
websphe 15228 1 0 Mar 26 - 4:28 /usr/local/opt/WebSphere/DeploymentManager/java/bin/java...
websphe 5298 1 0 Mar 26 - 3:38 /usr/local/opt/WebSphere/AppServer/java/bin/java...
|
The system where I am creating my configuration is used by other groups for development. They run WebSphere AppServer and Deployment Manager.
The people who should know told me that db2 wasn't running. But doesn't it have to be running when the WS AppServer and Deployment Manager are running?
Anyway... do you think this might be my problem?
Ben. |
|
| Back to top |
|
|
| mqworkflow |
| Posted: Thu Apr 01, 2004 7:50 am Post subject: |
|
|
Apprentice
Joined: 23 Feb 2004
Posts: 32
|
AFAIK it is a problem. But I would certainly suggest you to wait for more expert comments here.
Thanks
mqwf |
|
| Back to top |
|
|
|
|
