From oracle-l-bounce@freelists.org Wed Jul 7 06:25:04 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i67BOXI07488 for ; Wed, 7 Jul 2004 06:24:43 -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 i67BON607434 for ; Wed, 7 Jul 2004 06:24:33 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 215EE72C675; Wed, 7 Jul 2004 06:05:49 -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 09225-18; Wed, 7 Jul 2004 06:05:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 69C7D72C61A; Wed, 7 Jul 2004 06:05:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 07 Jul 2004 06:04:25 -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 5B6BC72C4A2 for ; Wed, 7 Jul 2004 06:04:25 -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 09093-02 for ; Wed, 7 Jul 2004 06:04:25 -0500 (EST) Received: from falcon.uce.ac.uk (falcon.uce.ac.uk [193.60.133.100]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D3E2C72C11F for ; Wed, 7 Jul 2004 06:04:24 -0500 (EST) Received: from exchangeb.staff.uce.ac.uk ([10.255.50.153]) by falcon.uce.ac.uk with esmtp (Exim 4.24) id 1BiAaw-0002vo-7f for oracle-l@freelists.org; Wed, 07 Jul 2004 12:28:10 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Subject: How can I remove a lingering old listener reference? Date: Wed, 7 Jul 2004 12:29:37 +0100 Message-ID: <14C5F9616FF43F479F67E41A1DF4D94A76D3A9@exchangeb.staff.uce.ac.uk> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: analyze table versus DBMS_STATS.GATHER_TABLE_STATS(...) Thread-Index: AcRkCAvDYNeLLvc/Th2JUEy8bc9oogAC+Hkw From: "Paul Vincent" To: Cc: "Simon Baker" UCE-Spam-Score: -0.6 (/) X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4541 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Paul.Vincent@uce.ac.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hello all, well, my upgrade of a Windows 2000 8.0.6 database to 9.2.0.2 is now more or less complete, despite my problems with the DBUA which baffled myself, this group, and Oracle Support! Eventually I upgraded the database manually, and was successful. Hurray! However, we now appear to have a lingering reference to the old 8.0 Listener. I've disabled the 8.0 Listener service and the 8.0 Agent service, so now both the Agent and Listener services are 9.2. But under some circumstances, one of our developers has been getting "No Listener" errors (although connections to the upgraded DB, via the 9.2 Listener, are MOSTLY working fine). So something, somewhere, is still looking for the 8.0 Listener. When I look at the ora92\network\admin\snmp_rw.ora file, it contains: snmp.contact.listener =3D "" snmp.index.listener =3D 1 snmp.contact.listener1 =3D "" snmp.index.listener1 =3D 2 snmp.contact.DLIB.DIGLIB3 =3D "" snmp.index.DLIB.DIGLIB3 =3D 3 and the ora92\network\admin\snmp_ro.ora file contains: snmp.visibleservices =3D (listener, listener1, DLIB.DIGLIB3) snmp.shortname.listener =3D LISTENER snmp.longname.listener =3D listener_diglib3.staff.uce.ac.uk snmp.configfile.listener =3D d:\oracle\ora92\network\admin\listener.ora snmp.oraclehome.listener =3D d:\oracle\ora92 snmp.servicename.listener_diglib3.staff.uce.ac.uk =3D Oracleorahome92TNSListener snmp.shortname.listener1 =3D LISTENER snmp.longname.listener1 =3D listener1_diglib3.staff.uce.ac.uk snmp.configfile.listener1 =3D d:\oracle\ora80\net80\admin\listener.ora snmp.oraclehome.listener1 =3D d:\oracle\ora80 snmp.servicename.listener1_diglib3.staff.uce.ac.uk =3D = OracleTNSListener80 snmp.SID.DLIB.DIGLIB3 =3D DLIB snmp.oraclehome.DLIB.DIGLIB3 =3D d:\oracle\ora92 snmp.address.DLIB.DIGLIB3 =3D (ADDRESS=3D(PROTOCOL=3DBEQ)(PROGRAM=3DORACLE)(ARGV0=3DORACLEDLIB)(ARGS=3D= '(DESCRIP TION=3D(LOCAL=3DYES)(ADDRESS=3D(PROTOCOL=3Dbeq)))')) snmp.remoteaddress.DLIB.DIGLIB3 =3D (DESCRIPTION=3D(ADDRESS_LIST =3D (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D DIGLIB3)(PORT =3D 1521)) = (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D DIGLIB3)(PORT =3D 1521)) ) (CONNECT_DATA=3D(SID=3DDLIB)(SERVER=3DDEDICATED))) ifile =3D d:\oracle\ora92\network\admin\snmp_rw.ora ifile =3D d:\oracle\ora92\network\admin\sqlnet.ora By the way, I did force the recreation of these files, by deleting them, stopping all services, then restarting. So somehow, as you can see, when snmp_ro.ora is generated, it's still picking up references to the old listener. So can anyone explain why this is happening, and how I can prevent it? I've not uninstalled the old version of Oracle (8.0.6) yet, because I didn't think this was a necessary priority, but I certainly don't want anything "pointing" to the old 8.0 services. I hope one of you experts can come up with something, please! Regards, Paul Vincent Database Administrator University of Central England ---------------------------------------------------------------- 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 -----------------------------------------------------------------