OFA Report Review Agent

We have recently implemented the OFA 10.7 Smart Client 16.1 and are attempting to implement the OFA Report Review agent. The client is Windows NT 4.0 (w/16-bit Forms 4.5), the server is Solaris 2.5.1 (SPARC) running Oracle 7.3.3.5 with SQL*Net 2.3.3.

We have edited the client-side tnsnames.ora and server-side listener.ora (these are attached) as specified by the available documentation and have not met with much success to date.

LISTENER.ORA
> LISTENER =
> ( ADDRESS_LIST =
> ( ADDRESS =
> ( PROTOCOL = ipc )
> ( KEY = ofap107 )
> )
> ( ADDRESS =
> ( PROTOCOL = ipc )
> ( KEY = ofau107 )
> )
> ( ADDRESS =
> ( PROTOCOL = ipc )
> ( KEY = ofat107 )
> )
> ( ADDRESS =
> ( PROTOCOL = tcp )
> ( HOST = pollux )
> ( PORT = 1521 )
> )
> ( ADDRESS =
> ( PROTOCOL = ipc )
> ( KEY = FNDFS )
> )
> ( ADDRESS =
> ( PROTOCOL = ipc )
> ( KEY = FNDFS_POLLUX )
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = OFF
> SID_LIST_LISTENER =
> ( SID_LIST =
> ( SID_DESC =
> ( SID_NAME = ofap107 )
> (GLOBAL_DBNAME = ofap107)
> ( ORACLE_HOME = /ora/app/oracle/product/7.3.3 )
> ( PRESPAWN_MAX = 10 )
> )
> ( SID_DESC =
> ( SID_NAME = ofau107 )
> ( ORACLE_HOME = /ora/app/oracle/product/7.3.3 )
> ( PRESPAWN_MAX = 10 )
> )
> ( SID_DESC =
> ( SID_NAME = ofat107 )
> ( ORACLE_HOME = /ora/app/oracle/product/7.3.3 )
> ( PRESPAWN_MAX = 10 )
> )
> ( SID_DESC =
> (PROGRAM=/p167/app/papplmgr/product/10.7/fnd/6.1.1/bin/FNDFS)
> ( SID_NAME = FNDFS)
> ( ORACLE_HOME = /ora/app/oracle/product/7.3.3 )
> ( ENVS = 'LD_LIBRARY_PATH=/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/lib:$ORACLE_HOME/lib/libXm_sol2.4' )
> ( PRESPAWN_MAX = 10 )
> )
> )

TNSNAMES.ORA
> ofap107 =
> ( DESCRIPTION =
> ( ADDRESS_LIST =
> ( ADDRESS =
> ( PROTOCOL = tcp )
> ( HOST = 199.29.65.11 )
> ( PORT = 1521 )
> )
> )
> ( CONNECT_DATA =
> ( SID = ofap107 )
> )
> )
> ofaprod =
> ( DESCRIPTION =
> ( ADDRESS_LIST =
> ( ADDRESS =
> ( PROTOCOL = tcp )
> ( HOST = 199.29.65.11 )
> ( PORT = 1521 )
> )
> )
> ( CONNECT_DATA =
> ( SID = ofap107 )
> )
> )
> FNDFS_POLLUX =
> ( DESCRIPTION =
> (PROGRAM=/p167/app/papplmgr/product/10.7/fnd/6.1.1/bin/FNDFS)
> ( ADDRESS_LIST =
> ( ADDRESS =
> ( PROTOCOL = tcp )
> ( HOST = 199.29.65.11 )
> ( PORT = 1521 )
> )
> )
> ( CONNECT_DATA =
> ( SID = FNDFS )
> (GLOBAL_DBNAME=FNDFS_POLLUX)
> )
> )

Any assistance would be greatly appreciated.

regards,

Chuck Wolfe
Manager, Database Administration
PsiNet
wolfec_at_psi.com Received on Thu Jul 16 1998 - 10:15:14 CDT