8 Replies Latest reply: Mar 19, 2008 3:57 PM by Sal RSS

    How to change the LISTENER.ORA location parameter

    user449216
      I had to move the ORACLE_HOME so I loaded Oracle into the new home and redirected the database to the new home and started the listener from the new location. Grid Control sees that the listener from home1 is down but there is a listener running in home2. The tool recommends changing the location parameter to point to the currently running listener.

      I cannot find where to change this location parameter.

      Has someone else made such a change?
        • 1. Re: How to change the LISTENER.ORA location parameter
          mnazim-Oracle
          paste the out put of lsnrtctl status from both the OH
          • 2. Re: How to change the LISTENER.ORA location parameter
            user449216
            Not certain that I understand. The listener from home1 is down. The listener from home2 is up and monitoring the databases.

            [oracle@h0424 ~]$ lsnrctl status

            LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 04-FEB-2008 07:04:06

            Copyright (c) 1991, 2006, Oracle. All rights reserved.

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx.xxxx.xxx)(PORT=1521)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
            Start Date 02-FEB-2008 19:52:33
            Uptime 1 days 11 hr. 11 min. 33 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP ON
            Listener Parameter File /u01/app/oracle/product/db10g/network/admin/listener.ora
            Listener Log File /u01/app/oracle/product/db10g/network/log/listener.log
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxx.xxxx.xxx)(PORT=1521)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
            Services Summary...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Service "aaaaaa" has 1 instance(s).
            Instance "aaaaaa", status UNKNOWN, has 1 handler(s) for this service...
            Service "aaaprd.world" has 1 instance(s).
            Instance "aaaaaa", status READY, has 1 handler(s) for this service...
            Service "aaaaaa_XPT.world" has 1 instance(s).
            Instance "aaaaaa", status READY, has 1 handler(s) for this service...
            Service "bbbbbb" has 1 instance(s).
            Instance "bbbbbb", status UNKNOWN, has 1 handler(s) for this service...
            Service "bbbbbb.world" has 1 instance(s).
            Instance "strprd", status READY, has 1 handler(s) for this service...
            Service "bbbbbb_XPT.world" has 1 instance(s).
            Instance "bbbbbb", status READY, has 1 handler(s) for this service...
            The command completed successfully
            • 3. Re: How to change the LISTENER.ORA location parameter
              mnazim-Oracle
              now what the tool recommed location
              • 4. Re: How to change the LISTENER.ORA location parameter
                user449216
                It recommends changing it to the location from which the current running listener is executing.

                Do you know how to change it in Grid Control?
                • 5. Re: How to change the LISTENER.ORA location parameter
                  439126
                  What 'tool' are you referring to?

                  Has Grid picked up the fact there is a second listener (you might want to try a refresh)? If so, just delete the old one from grid.

                  If not, you can still delete the old listener and manually add the new one.
                  • 6. Re: How to change the LISTENER.ORA location parameter
                    rodneyli
                    you can just edit the properties for the listener in GC to point to the one you want to monitor. You can monitor both if you want.
                    • 7. Re: How to change the LISTENER.ORA location parameter
                      629452
                      Follow the steps below:

                      Go to 10g Grid Control
                      Click on Targets Tab
                      Click on All Targets tab
                      Select the particular listener and click on Configure
                      change the listener.ora directory and Oracle Home to point to the new home
                      Click ok.
                      Refresh the database page and you will see the correct listener is configured
                      • 8. Re: How to change the LISTENER.ORA location parameter
                        Sal
                        RENAME or REMOVE the listener.ora from the "OLD" ORACLE_HOME. Remove the "OLD" Listener target and then do a new discovery on the HOST. DISCOVERY is looking for listener.ora files in ORACLE_HOME.