Re: In what order should processes be started/stopped?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Feb 2007 07:52:52 -0800
Message-ID: <1170777171.989941.204360@k78g2000cwa.googlegroups.com>

On Feb 5, 11:36 pm, "Ramon F Herrera" <r..._at_conexus.net> wrote:
> What is the recommended sequence for stopping the database server and
> the listener?
>
> I can modify the tnsnames.ora file at any time (just like its
> equivalent /etc/resolv.conf in Unix) and the changes will take effect
> immediately, right?
>
> OTOH, when the listener.ora file is modified, I should stop, modify,
> and then restart the listener, right? What about the database
> processes, should I restart them as well?
>
> Please see my related post "lsnrctl doesn't really stop the listener".
>
> Any pointer that helps me understand these issues is welcome and
> appreciated.
>
> TIA,
>
> -Ramon F Herrera

Look up the Listener command "reload". It reloads the listener.ora file so not stop/re-start is needed.

Oracle does provide a NET Services manual that covers the listener, listener.ora, tnsnames.ora, sqlnet.ora, and a few other tools. You may want to check the manuals out.

HTH -- Mark D Powell -- Received on Tue Feb 06 2007 - 09:52:52 CST