How can I remove a lingering old listener reference?

From: Paul Vincent <Paul.Vincent_at_uce.ac.uk>
Date: Wed, 7 Jul 2004 12:29:37 +0100
Message-ID: <14C5F9616FF43F479F67E41A1DF4D94A76D3A9@exchangeb.staff.uce.ac.uk>

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_at_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
-----------------------------------------------------------------

Received on Wed Jul 07 2004 - 06:25:04 CDT