| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle/AIX 3 tier config problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| cstauss |
 Posted: Wed Jun 09, 2004 6:49 am Post subject: Oracle/AIX 3 tier config problem |
 |
|
Apprentice
Joined: 20 Feb 2002
Posts: 36
|
All,
I am having difficulty with connectivity between my workflow host and my Oracle DB host. I get SQL 1017 errors (invalid userID/password combination) when attempting to import the reference FDL and XA errors when attempting to start the queue manager.
The install doc specifically states that the RT database user and transaction coordinator for Oracle must be the same AND that these users must only exist on the database host-this is what we have set up.
Also, in fmczutil, I am presented only with the option of "use existing database"
In the past on 4.3.3, I ahve always been presented with both database configuration options: create new and use existing. Possible AIX issue?
We are running Oracle 8.1.7.4 and AIX 5.1.0.0-05
Thanks in advance!
Cady |
|
| Back to top |
|
 |
| praveenchhangani |
| Posted: Fri Jun 11, 2004 5:05 am Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
Hi Cady,....long time buddy! 
I am not too sure about Oracle 8, however if Oracle 8 and 9 are not too different then check on the following:
I don't know if you have already tried this, but otherwise...
- Use the Oracle tool Net8 assisntant to add a new local service naming entry in the "tnsnames.ora" file. On UNIX, this is normally located in $ORACLE HOME\network\admin". Use for the service name the same name value as for the "Oracle SID" specified during the WF configuration. Start the Net8 assistant from Userid "oracle" with command "netasst".
The created entry in the "tnsnames.ora" should look like this:
| Code: |
FMCDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FMCDB)
)
)
|
- Now to ensure that Oracle can resolve the names correctly, add a domain and the name resolution path to the $ORACLE_HOME/network/admin/sqlnet.ora file
| Code: |
NAMES.DEFAULT_DOMAIN = CUSTOMER.COM
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME |
- Now Test the connection to the remote Oracle database, and see if the connection can be established.
Try tnsping FMCDB, you can use SQLPLUS with this command (i.e.sqlplus fmc@FMCDB)
I am not 100% sure on the XA errors and so am not quite sure where all that is coming from, but I would take a closer look at the ora file and manually test the connection to the Oracle instance.
Hope this helps! Hope all else is well with you. Talk to you later...
Thanks,
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| Back to top |
|
|
| newbiedude |
| Posted: Fri Jun 11, 2004 5:13 am Post subject: |
|
|
Voyager
Joined: 22 Dec 2002
Posts: 87
|
What version of WF are you running, FP's? - Nathan
_________________
Newbiedude |
|
| Back to top |
|
|
| cstauss |
| Posted: Fri Jun 11, 2004 5:37 am Post subject: |
|
|
Apprentice
Joined: 20 Feb 2002
Posts: 36
|
Running MQWF 3.4 CSD 5 on AIX 5.1, (64 bit mode)
Cady |
|
| Back to top |
|
|
| cstauss |
| Posted: Fri Jun 11, 2004 6:03 am Post subject: |
|
|
Apprentice
Joined: 20 Feb 2002
Posts: 36
|
Hi Praveen!
I have resolved the XA issue-this was just a missing link to libclntsh.a
I have also been able to connect via sqlplus and tnsping.
Database creation fails however, now producing ORA 12545 error.
In fmczutil, I have been entering the runtime UserID as fmc@FMCDB or fmc@FMCDB/fmc (where fmc is the password) Is this correct?
Also, the doc indicates that the runtime DB user should only exist on the DB host. Currently, I have fmc on both machines. What have you found with these issues?
Thanks,
Cady |
|
| Back to top |
|
|
| praveenchhangani |
| Posted: Mon Jun 14, 2004 1:02 pm Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 192
Location: Chicago, IL
|
| cstauss wrote: |
Hi Praveen!
I have resolved the XA issue-this was just a missing link to libclntsh.a
I have also been able to connect via sqlplus and tnsping.
Database creation fails however, now producing ORA 12545 error.
In fmczutil, I have been entering the runtime UserID as fmc@FMCDB or fmc@FMCDB/fmc (where fmc is the password) Is this correct?
Also, the doc indicates that the runtime DB user should only exist on the DB host. Currently, I have fmc on both machines. What have you found with these issues?
Thanks,
Cady |
Cady, glad to hear that you fixed the issue with the XA error. Sounds like the Transaction coordinator switch file was missing a link to the shared libraries. 
Anyway, the user id and password seem okay to me. And the fact, that you can get in through sql and tnsping, that's a good sign along with the fact that you can now issue the create database command from the fmczutil workflow command line utility.
I would say that either this is a permissions issue OR there is something missing from your .ORA files.
The ORA-12545 error occurs when the ADDRESS information in the TNSNAMES.ORA file does not match the address information in the server's LISTENER.ORA. Make sure that the SID is correct and that the port is correct for the host listed.
I can't think of this being anything other than
1) A permissions issue
2) Problems with the .ORA files.
I would check there Cady and see if there are any inconsistencies with any of the above. I am not sure what the experts on this forum think, but that's kind of where I'm headed towards with this problem.
Hope this helps and good luck! 
Thanks
_________________
Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
| 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
|
|
|
|
