Thursday, June 23, 2011

How to Configure FNDFS in a PCP Environment to View the Log/Out File Which Was Generated on a Failed Node

How to Configure FNDFS in a PCP Environment to View the Log/Out File Which Was Generated on a Failed Node [ID 1065704.1]
Modified 19-JUN-2011 Type HOWTO Status MODERATED
In this Document
Goal
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Applies to:

Oracle Application Object Library - Version: 11.5.1 to 11.5.10.2 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.
Goal

How to configure FNDFS in a multi-node environment with Parallel Concurrent Processing (PCP)
The goal is that you still can view the out and logfile for a concurrent request if one node goes down and that you avoid the following error :

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_XXXX. There may be a network configuration problem, or the TNS listener on node FNDFS_XXXX may not be running. Please contact your system administrator.




Solution

Add a 2nd FNDFS_ connection string definition to the
$ORACLE_HOME/network/admin/tnsnames.ora for viewing Text Report at Failover.

You will also need to add a 2nd FNDFS_ connection String definition
to the iAS $ORACLE_HOME/network/admin/tnsnames.ora file for Web Report Viewing
(ie. TOOLS > COPY FILE viewing with the browser).

Example:

FNDFS_ = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=5010))
(CONNECT_DATA=(SID=FNDFS))
)

FNDFS_ = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=5010))
(CONNECT_DATA=(SID=FNDFS))
)

Important note : if you have several nodes in your configuration and you have more then 255 characters in the tnsnames.ora file you need to review note : 270679.1 => Multiple Address List 8.0.6 Home Fails When TNS Alias is Greater Than 255 Characters. Patch : 3259441 was released to handle the limitations of 255 characters.


References

NOTE:188062.1 - Cannot View Reports after Failover
NOTE:270679.1 - Multiple Address List 8.0.6 Home Fails When TNS Alias is Greater Than 255 Characters

Related
Products
Oracle E-Business Suite > Applications Technology > Application Object Library > Oracle Application Object Library

Back to top

No comments:

Post a Comment