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: sybrandb <sybrandb_at_gmail.com>
Date: 21 Aug 2006 02:27:22 -0700
Message-ID: <1156152442.532336.165160@i42g2000cwa.googlegroups.com> 






sures lear wrote:


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




If you are using


connect_data=(service_name=<service_name parameter in init.ora>) in
your tnsnames.ora


then you *must* change the local_listener init.ora parameter *and*
bounce the database, otherwise it won't register itself with the new
listener.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Mon Aug 21 2006 - 04:27:22 CDT












Original text of this message













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