Forum OpenACS Q&A: Response to Problem with intermedia migrating acs3 instance
It's site-wide-search.sql that you need to run again, NOT recreate-site-wide-search.sql. Ignore any errors about objects already existing. The bit you're interested in is where the script connects as ctxsys and creates the sws_user_proc_&1 procedure (and does a few other things). After that, if the sws_user_proc_&1 procedure is there (and owned by the ctxsys user) and you still have problems, you can run recreate-site-wide-search.sql to rebuild the Intermedia indexes. Be warned, it can be slow!