From oracle-l-bounce@freelists.org Mon Jan 10 12:29:03 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0AIT3O18455 for ; Mon, 10 Jan 2005 12:29:03 -0600 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 j0AIT2n18449 for ; Mon, 10 Jan 2005 12:29:02 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AF71A72C1B3; Mon, 10 Jan 2005 13:35:37 -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 12290-80; Mon, 10 Jan 2005 13:35:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1585A72C7AD; Mon, 10 Jan 2005 13:32:25 -0500 (EST) Message-ID: <41E2C902.9040306@allegientsystems.com> Date: Mon, 10 Jan 2005 13:27:14 -0500 From: Mladen Gogala User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: dofreeman@state.pa.us Cc: "Oracle-L (E-mail)" Subject: Re: Verify Piipe Exists References: In-Reply-To: Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 14561 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mgogala@allegientsystems.com Precedence: normal Reply-To: mgogala@allegientsystems.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Freeman, Donald wrote: >I am trying to install a vendor application with an Oracle repository = >and not making much progress. The install has failed and the cleanup = >requires that the pipe be purged and removed or the database be bounced. = >I've been through this four times since Friday afternoon. I can't find = >any way to view whether or not a pipe exists. I know its not a = >conventional database object and that its some sort of memory structure. = > Is there a way to do this? Where do I look? > > > You can call a plumber or take a look into v$DB_PIPES. It looks like this: SQL> desc v$db_pipes Name Null? Type ----------------------------------------- -------- ---------------------------- OWNERID NUMBER NAME VARCHAR2(1000) TYPE VARCHAR2(7) PIPE_SIZE NUMBER SQL> That should reveal the intricate details of the plumbing in your database, so that you can then use DBMS_PIPE to obliterate the pipe. -- Mladen Gogala Oracle DBA Ext. 121 -- http://www.freelists.org/webpage/oracle-l