Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Do I have to shutdown and startup Oracle Instance after having the default 1521 listen port modified?

Re: Do I have to shutdown and startup Oracle Instance after having the default 1521 listen port modified?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Mon, 21 Aug 2006 23:54:24 +0100
Message-ID: <rpdke2pi9u9na6rp2a1276gsi9shhkc4o4@4ax.com> 





On 21 Aug 2006 02:14:05 -0700, "sures lear" <Sures.Lear_at_gmail.com> wrote:



>Or I can just stop and restart the listener by 'lsnrctl'?




 You don't have to restart the database for this, but you'll have to set
LOCAL_LISTENER. Since it's a dynamic parameter you don't have to restart for
that, either. You may also want to use "alter system register" once you've
changed it.


-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool


Received on Mon Aug 21 2006 - 17:54:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US