If you are using a port other than 1521 then this would help in registering the database with the listener. HTH GovindanK On Tue, 23 May 2006 13:43:51 -0500, "Joe Smith" <joe_dba@xxxxxxxxxxx> said: > In J Lewis's new book "Cost Based Oracle..." in his example initd10g.ora > he has this line: > > *.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))' > > > what is the advantage of putting this Listener.ora line in the init.ora? > > thanks. -- //www.freelists.org/webpage/oracle-l