SQL & PL/SQL

Hi all,

I was trying to understand the External procedure. This is first time i am doing this so i dont have any idea whats going wrong.

I have following setting in my listner.ora

# listener.ora Network Configuration File: C:\app\VinodR\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

EXTERNAL_PROCEDURE_LISTENER =
    (ADDRESS_LIST =
        (ADDRESS =
            (PROTOCOL=IPC)
            (KEY=epsid)
        )
    )

SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
    (SID_LIST =
        (SID_DESC= 
            (SID_NAME=epsid)
            (ORACLE_HOME=C:\app\VinodR\product\11.1.0\db_1)
            (PROGRAM=extproc)
        )
    )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = syncssh-4611.SYNCSS.LOCAL)(PORT = 1521))
    )
  )

and Tns.ora

# tnsnames.ora Network Configuration File: C:\app\VinodR\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
   (DESCRIPTION =
      (ADDRESS = 
         (PROTOCOL=IPC)
         (KEY=epsid)
      )
      (CONNECT_DATA=
         (SID=epsid)) 
      )
   )



EXTPROC_CONNECTION_DATA=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=ipc)(KEY=epsid))
(CONNECT_DATA=
(SID=epsid)))



VINOD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = syncssh-4611.SYNCSS.LOCAL)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = vinod)
    )
  )

but when i run my procedure i gives me following error

ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "PLSQL.RANDOM_UTL", line 17
ORA-06512: at line 9


can anyone please help me in resolving this error?

thanks