ORA-12666 error w/database link

I have an Oracle 7.3.3.4 database instance and whenever I create a database link, I initially cannot access the other instance through it. I get this error:

ORA-12666: Message 12666 not found; product=RDBMS; facility=ORA

The error is some sort of SQL*Net error, but I've not found it listed in any of the online documentation.

Dropping and recreating the database link does nothing. But, I have discovered that if I connect to the other instance through the same SQL*Plus session, then reconnect to this instance, the database link magically works.

The sequence of events is something like this:

    	SQL> select count(*) from dba_tables_at_prod
                                *
    	ERROR at line 1:
    	ORA-12666: Message 12666 not found;  product=RDBMS; facility=ORA


    	SQL> connect system/password_at_prod
    	Connected.

    	SQL> connect system/password_at_test
    	Connected.

    	SQL> select count(*) from dba_tables_at_prod

    	  COUNT(*)
    	----------
    	      3100

Any thoughts?

Thanks, Glenn Stauffer Received on Thu May 13 1999 - 07:37:51 CDT