Stored procedure compilation problem

comp.databases.oracle.server

Hey guys,

We recently moved two of our database servers to different boxes. We have also set up "Oracle Names Servers" in addition to our standard local TNS entries. Our local machines are set to check the ONS first and then the local TNS settings next. And for the record, we are using Release 8.1.7.0.0.

Even though we are using Oracle 8i rather than 9i, I have always been able to use Oracle9i JDeveloper successfully. Since the database transitions, I've recently tried to create stored procedures involving database links, and they will not compile through JDeveloper. But interestingly enough, they WILL compile through SQL Plus. But the errors that I'm getting in JDeveloper are:

ORA-04052: error occurred when looking up remote object
ORA-00604: error occurred at recursive SQL level 1
ORA-01891: Datetime/Interval internal error

The suggestive action for the ORA-04052 error is: "Fix the error. Make sure the remote database system has run KGLR.SQL to create necessary views used for querying/looking up objects stored in the database."

The KGLR.SQL script is not anywhere to be found on the servers. Does something on the servers need to be reconfigured/reinstalled?

The database links are currently set to public, but I have a feeling that there is still a privilege problem, a problem with the Oracle Names Servers, and/or the TNS files. I also should mention that the TNS files on the servers do contain the appropriate domain and SID settings for the "linked" servers that I am attempting to query.

I apologize in advance if I'm using incorrect terminology and/or confusing the hell out of everyone, but database administration is COMPLETELY new to me (I'm a developer).

I would greatly appreciate any help you may be able to provide!

Thanks,
Pat Received on Tue Jun 29 2004 - 15:38:53 CDT