Re: phantom dblink
- From: Mike Hennesy <orcl9ps8dba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 7 Jul 2004 12:04:05 -0700 (PDT)
Ron:
I thought you got it. The Global_name was still PROD, I just issued the alter
to DEV. Select from global_name now shows DEV. Started a new session to the
instance but I am still seeing the same results. I wonder if the instance needs
to be cycled, will try that later. This would explain it, since other instances
created the same way on the same box and other boxes do not show this behaviour
and their global_name was altered, not sure how it got missed in DEV.
Thanks - Mike
Ron Thomas <rthomas@xxxxxxxxxxxx> wrote:
Did you remember to
alter database rename global_name to DEV ;
Ron Thomas
Hypercom, Inc
rthomas@xxxxxxxxxxxx
"To really screw up Linux you have to work at it...To really screw up Windows,
you have to work ON
it..."
orcl9ps8dba@xxxxxxxxx
Sent by:
oracle-l-bounce@xxxxxxxxxxx To
rg oracle-l@xxxxxxxxxxxxx
cc
07/07/04 10:47 AM Subject
phantom dblink
Please respond to
oracle-l@xxxxxxxxxxxxx
I routinely refresh my DEV instance with a backup of my PROD instance. After I
test recovering PROD
on the dev machine I create a new control file and rename the instance to DEV
with the following:
CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS ARCHIVELOG
Now for the strange part. In DEV there is NOT a dblink for PROD but the query
select * from APP_TABLE@PROD ;
returns rows. I would expect a ORA-02019 error. The returned rows are actually
coming from the DEV
instance and not PROD.
This isn't the end of the world for me by no means. The instance will be
refreshed over the weekend
and I told the programmers there isn't a dblink to PROD and to not try. I just
thought this was a
strange behavior and was wondering if anyone else had come across it.
8.1.7.3
Thanks - Mike
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
