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 ?
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.
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
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width