I am having errors with using dbms_olap package with extproc errors.
Database is Oracle 8i on Solaris:

SQL> exec dbms_olap.recommend_mv ('FT_INV',100000,NULL,10);
BEGIN dbms_olap.recommend_mv ('FT_INV',100000,NULL,10); END;

ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "SYS.DBMS_SUMADV", line 6
ORA-06512: at "SYS.DBMS_SUMMARY", line 559
ORA-06512: at line 1

I looked up some notes on metalink and tried changing the tnsnames.ora and listener.ora configuration to include extproc in the descriptors. I also checked extproc to see if it was working. Still get these errors. Has anyone run into this problem before? How can I resolve it ? Thanks