| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| problem running the fmczutil to created tables |
« View previous topic :: View next topic » |
| Author |
Message
|
| zaklum |
 Posted: Tue Apr 19, 2005 10:40 am Post subject: problem running the fmczutil to created tables |
 |
|
Voyager
Joined: 17 Mar 2005
Posts: 96
Location: Boca Raton
|
post wortkflow installation when running the fmczutil I get connection to db but for some reason it tries to connect again and it fails.
I check the the trace log and this is what I get:
ORACLE XA: Version 9.2.0.1.0. RM name = 'Oracle_XA'.
140309.413820.1:
xaolog: Could not open file in directory /u011001/app/oracle/product/9.2.0/rdbms/log
ORACLE XA: Version 9.2.0.1.0. RM name = 'Oracle_XA'.
140309.413820.1:
ORA-01017: invalid username/password; logon denied
what is the id that should access db and why is trying to access it more than once. Where should this id exist and with what permissions?
140309.413820.1:
xaolgn: XAER_INVAL; logon denied.
~
fmc@wt00011:/var/fmc/cfgs/FMC/sql #> fmczutil
FMC33201I Configuration Commands Menu:
l ... List
s ... Select
x ... Exit Configuration Commands Menu
s
Configuration identifier : [FMC]
FMC33202I Selected Configuration Commands Menu:
Selected configuration : FMC (Default configuration)
c ... Configuration Settings Menu
r ... Runtime Database Commands Menu
q ... Queue Manager Commands Menu
x ... Exit Selected Configuration Commands Menu
r
FMC33206I Selected Runtime Database Commands Menu:
Selected Runtime database : wfltst01
s ... Create SQL files
t ... Create tables
u ... Drop tables
f ... Import topology FDL
o ... Optimize Database
p ... Change password
x ... Exit Selected Runtime Database Commands Menu
t
FMC33041I Specify the user ID to access the Runtime database ...:
FMC33436I Tables are created with this username as a prefix.
Oracle user ID to access Runtime database : [fmc]
Enter password for user ID 'fmc' : []
Confirm password for user ID 'fmc' : []
FMC33003I /u011001/app/oracle/product/9.2.0/bin/sqlplus fmc/********@wfltst01.TYCO.NET @/var/fmc/cfgs/FMC/fmczctab.sql
SQL*Plus: Release 9.2.0.6.0 - Production on Mon Apr 18 14:20:58 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production
SQL>
SQL> spool /var/fmc/cfgs/FMC/log/fmczctab.log
SQL>
SQL> -- ***********************************************************************************
SQL> -- MQSeries Workflow Database Creation Script
SQL> --
SQL> -- generated at: 2005-04-18 17:33:53
SQL> -- on host : wt00011
SQL> -- **********************************************************************************
SQL>
SQL>
SQL> DEFINE SPOOLFILE_FOR_ORACLE_SCRIPTS=/var/fmc/cfgs/FMC/log/createDict.log
SQL> DEFINE SPOOLFILE_FOR_TBS_CREATION=/var/fmc/cfgs/FMC/log/fmczctbs.log
SQL>
SQL> set termout off
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production
FMC33978E Oracle call 'connect' ended with SQL code 'ORA-01017: invalid username/password; logon denied'.
FMC33206I Selected Runtime Database Commands Menu:
Selected Runtime database : wfltst01
s ... Create SQL files
t ... Create tables
u ... Drop tables
f ... Import topology FDL
o ... Optimize Database
p ... Change password
x ... Exit Selected Runtime Database Commands Menu |
|
| Back to top |
|
 |
| vennela |
| Posted: Tue Apr 19, 2005 1:41 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
From the installation guide:
| Quote: |
| Oracle Enterprise Edition Version 8.1.7.1 or 9.2.0 (32 bit support libraries only). Version 9.0.1 is deprecated because Oracle no longer provides service for |
From your post looks like you are using 64 bit. I don't think that works unless the new service pack supports it. |
|
| Back to top |
|
|
| zaklum |
| Posted: Wed Apr 20, 2005 7:05 am Post subject: |
|
|
Voyager
Joined: 17 Mar 2005
Posts: 96
Location: Boca Raton
|
yes, I'm aware about the 32-bit libraries. We this issue with IBM and they say that it should not matter. Also, we have the same setup in another environment and it works fine.
please explain to me why we are having multiple connection to the database? My understanding was that we only needed the initial connection.
why are we trying to connect for a second time, and if so, is it the same userid as the first connection? |
|
| 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
|
|
|
|
