on 11-11-2009 11:47 PM
I have the LOCAL_LISTENER parameter commented out in the init<SID>.ora profile. What is the LOCAL_LISTENER parameter used for? Are there any side effects if it is commented out?
Thanks.
Thanks to all that replied
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Jamal,
you will also need the parameter LOCAL_LISTENER, if want to use automatic registration and your listener is running on port 1521 but not on the ip address of the hostname. This is a common configuration in a HA environment.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jamal,
If you have a DEDICATED server config, then the LOCAL_LISTENER parameter is used for the instance registration with the listener. If you are using a default listener on port of 1521, then DBCA will not automatically set the LOCAL_LISTENER.
For more details please see the links below -
http://download.oracle.com/docs/cd/B10501_01/network.920/a96580/listener.htm
http://tardate.blogspot.com/2007/06/check-locallistener-if-you-run-rac.html
Thanks,
Nitesh Jain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jamal,
LOCAL_LISTENER is used to register the listener that is not on the default port (1521).
If you are using a default listener, you can let it commented.
For more informations:
http://download.oracle.com/docs/cd/A84870_01/doc/network.816/a76933/listener.htm
Regards,
Federico Biavati
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.