From oracle-l-bounce@freelists.org Wed Jul 7 14:01:03 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i67J0mb26722 for ; Wed, 7 Jul 2004 14:00:58 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i67J0S626647 for ; Wed, 7 Jul 2004 14:00:48 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5E12F72CDDF; Wed, 7 Jul 2004 13:41:51 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23116-40; Wed, 7 Jul 2004 13:41:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A92F872CDC0; Wed, 7 Jul 2004 13:41:50 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2004 13:40:21 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7A43D72CD04 for ; Wed, 7 Jul 2004 13:40:19 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22067-96 for ; Wed, 7 Jul 2004 13:40:19 -0500 (EST) Received: from web52102.mail.yahoo.com (web52102.mail.yahoo.com [206.190.39.71]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 3318D72CCFD for ; Wed, 7 Jul 2004 13:40:16 -0500 (EST) Message-ID: <20040707190405.3186.qmail@web52102.mail.yahoo.com> Received: from [137.148.2.12] by web52102.mail.yahoo.com via HTTP; Wed, 07 Jul 2004 12:04:05 PDT Date: Wed, 7 Jul 2004 12:04:05 -0700 (PDT) From: Mike Hennesy Subject: Re: phantom dblink To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4586 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: orcl9ps8dba@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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 wrote: Did you remember to alter database rename global_name to DEV ; Ron Thomas Hypercom, Inc rthomas@hypercom.com "To really screw up Linux you have to work at it...To really screw up Windows, you have to work ON it..." orcl9ps8dba@yahoo.com Sent by: oracle-l-bounce@freelists.o To rg oracle-l@freelists.org cc 07/07/04 10:47 AM Subject phantom dblink Please respond to oracle-l@freelists.org 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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------