| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Database Link Error
A copy of this was sent to nwilson_at_bdsinc.com (Ned Wilson)
(if that email address didn't require changing)
On Wed, 10 Jun 1998 12:15:49 -0400, you wrote:
>when i try to connect to a database on an nt machine from a solaris db
>using a stored function created in sql navigator pro, i get an error
>message, the text of which i relate below.
>
>ORA-04052: error occured when looking up remote object
>BIN.ADDRESS_EMERGENCY_at_BIN.WORLD
>ORA-04029: error ORA-904 occured when querying
>ORA_KGLR7_IDL_SB4_at_BIN.WORLD
>ORA-00604: error occured at recursive SQL level 1
>ORA-00904: invalid column name
>
>i am doing a basic select statement, trying to retrieve information from
>the database instance bin. i have created db links to and from bin in the
>public schema, so the links should be accessable to everyone. what am i
>doing wrong here?
>
>-ned
I think that some of the upgrade scripts have not been run on the other machine.
You need to run cat7303.sql on the other machine. This script is in $ORACLE_HOME/rdbms/admin. It should be run using svrmgrl when connected as INTERNAL or SYS.
It will add the needed obj# column to the KGLR views. It should have been run as part of the upgrade.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Jun 12 1998 - 09:34:35 CDT
 |
 |