Re: global_names false 11gR2
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 13 May 2010 15:04:58 -0500 (CDT)
Hey April,
> Need some advice on global_names.
> Cloned a database, upgraded the 10.2.0.4 clone to 11.2.0.1.
> Cannot drop any of existing database links -
> ERROR at line 1:
> ORA-02024: database link not found
On your cloned DB with the issue, does the following query have the same
values for each column reported (assuming non-RAC)?
SELECT SYS_CONTEXT('USERENV','INSTANCE_NAME'),
SYS_CONTEXT('USERENV','DB_NAME')
FROM dual;
Or, perhaps more correctly, how does the output from the above compare to
the original DB?
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
