Connect to multiple Applications 11i Instance using ADI

I had issue with connecting to ADI to individual instance when more than one Oracle Applications were running on same server. I performed following to overcome issue. 1. Defined the RRA: Service Prefix in each of your instances at site level as FNDFS_ntest. 2. Added in the Desktop PC tnsnames.ora in $ORACLE_HOME/network/admin and $ORACLE_HOME/net80/admin should be equal and include definitions for FNDFS which name should be FNDFS__

FNDFS_ntest_nfinox = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=nfinox)(PORT=1522)) (CONNECT_DATA=(SID=FNDFS)) )

3. Added given two services in each tnsnames in the 8.0.6 ORACLE HOME of each instance in the applications server is generated by AutoConfig including these two services: FNDFS_ntest = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=nfinox)(PORT=1522)) (CONNECT_DATA=(SID=FNDFS)) ) FNDFS_ntest_nfinox = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=nfinox)(PORT=1522)) (CONNECT_DATA=(SID=FNDFS)) ) 4. Restarted the Concurrent Managers -- All the instances 5. Restarted the APPS Listener -- All the instances