configuring the listener for new instance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: configuring the listener for new instance

  1. #1
    Join Date
    Mar 2000
    Location
    woodbridge,nj,USA
    Posts
    14
    DBA's


    I will be cloning an instance on the same unix box,
    my question is do I need to stop and restart the listener
    in order for this new database to be used from a client ?
    If so is there a listener command to start the listener for this
    additional instance without affecting any other instances ?

    Thanks
    Umesh

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You have to edit your listener.ora and tnsnames.ora and make an entry for new database that you have cloned and stop and restart the listener using 'lsnrctl' commands. For help on lsnrctl commands type in at the prompt "lsnrctl help"

    Until you don't edit/modify existing entries in listener.ora/tnsnames.ora stopping and starting will not affect your existing instances.

    When you restart all it does is reregister the new sid entry you made for new instance.

    Reddy,Sam

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    One addtion to reddy's point is that once after putting the changes inplace, issue a reload instead of stopping and restarting the listener. This would just reduce a step for you

    lsnrctl reload

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width