FND_NODES

FND_NODES table is present in the APPS schema.

In a muti-tier environment if we want to check the Application services which are running on different node then we can check from fnd_nodes table.

select NODE_NAME,SUPPORT_CP,SUPPORT_FORMS,SUPPORT_WEB,SUPPORT_ADMIN from FND_NODES;

NODE_NAME       SUPPORT_CP           SUPPORT_FORMS        SUPPORT_WEB          SUPPORT_ADMIN
---------------              -------------------                  --------------------                  --------------------                   --------------------

DEV01                          N                                  N                                    N                                         N
DEV02                          Y                                  Y                                     Y                                         Y

or

11i/R12 query FND_NODES

    set lines 200
    col host_name for a11
    col node_name for a11
    col database for a10
    col concmgr for a9
    col forms for a7
    col webserver for a11
    col admin for a7
    select
    NODE_NAME,
    decode(STATUS,'Y','ACTIVE','INACTIVE') Status,
    decode(SUPPORT_CP,'Y', 'YES','NO') ConcMgr,
    decode(SUPPORT_FORMS,'Y','YES', 'NO') Forms,
    decode(SUPPORT_WEB,'Y','YES', 'NO') WebServer,
    decode(SUPPORT_ADMIN, 'Y','YES', 'NO') Admin,
    decode(SUPPORT_DB, 'Y','YES', 'NO') Database
    from fnd_nodes
    where node_name != 'AUTHENTICATION' order by NODE_NAME;

SUPPORT_CP: Concurrent Server

SUPPORT_FORMS: Form Server

SUPPORT_WEB: Apache Server

SUPPORT_ADMIN : Admin Server

Cleaning Of FND_NODES table

In the FND_NODES table at certain times we can find there useless entry present which may be the result of the cloning from production which may be the entry other than our present host. So we to need to clean up the FND_NODES table.

Steps:

1.Stop the application services.

2.Run EXEC FND_CONC_CLONE.SETUP_CLEAN; and issue commit after successful completion.

3.Now there must not be any entry present in FND_NODES table.

    select * from fnd_nodes;

    no row selected

4. Run autoconfig on DB_node.

    cd $ORACLE_HOME/appsutil/scripts

    adautocfg.sh

    It will prompts for the apps password.

5.Run autoconfig on Apps_node.

   cd $INST_TOP/admin/scripts

   adautocfg.sh

   It will prompts for the apps password.

This will populate the FND_NODES tables with the correct entry for the application and database node.