Re: Adding instances to listener

Rodney Schuler wrote:
>
> We are running version 7.3.3.0.0 on Solaris 2.5.1 with version 2.3.3.0.0 of the
> Listener. When we add a new database to the server I have been doing a LSNRCTL
> RELOAD after copying the new LISTENER.ORA & TNSNAMES.ORA files. Everything
> seems to be ok and you can connect to the new database. However, any new
> connections to instances using the multi-threaded server no longer use it. All
> new attaches start up their own process. If I shutdown everything and restart
> the listener everything works fine. However, this is on the production server
> and it is very hard to schedule even a brief downtime.
>
> My question is should the reload work? If not what should I be doing to add
> new instances to the listener.
>
> Thanks
> --
> ________________________________________________________________________
> Rodney Schuler Database Administrator | Department of Computing Services
> Internet: Rodney.Schuler_at_USask.CA | University of Saskatchewan
> Voice: (306) 966-4862 | 116 Science Place
> FAX: (306) 966-4938 | Saskatoon SK S7N 5E2 (Canada)

I ran into the same situation with Oracle 7.1.5, SQLNet 2.1.5, running on VMS.

I talked with Oracle Support and was basically told "that's the way it is" (i.e. I would have to shutdown/restart existing databases after the RELOAD). One possible solution might be to add a new listener rather than reloading an existing one (just an idea though - I haven't tried it and don't really know if it would work). Received on Tue Sep 16 1997 - 00:00:00 CDT