ORA-00980 error when attempting export using the EXP command

Question

I'm trying to export a schema in an oracle 10 database using the EXP command. Let's call the schema "myschema" and the tns name "mydb" to protect the names of the innocent. Anyway, here's the command line that I'm using

exp myschema/mypassword@mydb file=myschema.dmp grants=y

This works when I try to run an export on other instances, but I get the following error when I try against "mydb".

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user MYSCHEMA
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 980 encountered
ORA-00980: synonym translation is no longer valid
EXP-00000: Export terminated unsuccessfully

Anybody have any ideas? If any further info is needed let me know and I'll edit this question accordingly.

Answer 1

This can happen if the JVM installation is corrupted. Try:

SELECT comp_id, schema, status, version, comp_name
  FROM dba_registry
 ORDER BY 1;

If this returns a row with the comp_id of JAVAVM with a status of 'INVALID' you'll need to reinstall the java VM.

Metalink document 276554.1 has the procedure for doing so. If you can recover easily, it might be easier to recreate the database and reload it.

EDIT: I found Oracle-base link where a poster claims this will uninstall and reinstall the JVM (on Unix), I presume it works on windows with slight mods:

(WARNING! You can seriously hose your database if things go wrong here. BACKUP first!)

cd $ORACLE_HOME/javavm/install
sqlplus / as sysdba
@rmjvm.sql
@initjvm.sql

-- Recompile invalid objects
@?/rdbms/admin/utlrp

The metalink note is quite a bit more involved.