14 Replies Latest reply: Feb 18, 2013 9:48 PM by yxes2013 RSS

    where is my linstener.ora

    yxes2013
      Hi all,

      Ora10g

      SLES 11

      I have installed my oracle db using gui and it completed successfully. I can startup lsnrctl start. But I can not find lisntener.ora in my network/admin folder :(
      Where is it hiding the default listener?

      Thanks a lot,

      Yxz
        • 1. Re: where is my linstener.ora
          sb92075
          yxes2013 wrote:
          Hi all,

          Ora10g

          SLES 11

          I have installed my oracle db using gui and it completed successfully. I can startup lsnrctl start. But I can not find lisntener.ora in my network/admin folder :(
          Where is it hiding the default listener?

          Thanks a lot,

          Yxz
          as you have discovered, the listener.ora file does not need to exist to start or use the listener.
          • 2. Re: where is my linstener.ora
            yxes2013
            I am amazed :), so i do not have to add more db name since I am installing another database? and I do not know what port was is it listening to? :(

            How do I know which port each of my databases listens?

            Is it advisable not to create a listener.ora file?


            Thanks,

            Edited by: yxes2013 on 18.2.2013 17:27
            • 3. Re: where is my linstener.ora
              asahide
              Hi,

              You can check via lsnrctl status.
              Check Listener Parameter File .
              LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 19-FEB-2013 09:40:59
              
              Copyright (c) 1991, 2004, Oracle.  All rights reserved.
              
              Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
              STATUS of the LISTENER
              ------------------------
              Alias                     LSNR_********
              Version                   TNSLSNR for Linux: Version 10.1.0.3.0 - Production
              Start Date                25-OCT-2012 11:39:23
              Uptime                    116 days 22 hr. 1 min. 35 sec
              Trace Level               off
              Security                  ON: Local OS Authentication
              SNMP                      OFF
              Listener Parameter File   /opt/app/oracle/product/10.1.0/db/network/admin/listener.ora
              Listener Log File         /opt/app/oracle/admin/bdump/lsnr_********.log
              Regards,
              • 4. Re: where is my linstener.ora
                sb92075
                yxes2013 wrote:
                I am amazed :), so i do not have to add more db name since I am installing another database? and I do not know what port was is it listening to? :(
                1521
                How do I know which port each of my databases listens?
                1521
                Is it advisable not to create a listener.ora file?
                There is no benefit to creating listener.ora file.

                Since V10, every DB tries to register itself to listener using port #1521 once every 60 seconds.
                • 5. Re: where is my linstener.ora
                  yxes2013
                  Yes dear I can see that :)
                  oracle@db51:/u01/app/oracle/product/10g/db_1/network/admin> lsnrctl status
                  
                  LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-FEB-2013 17:35:31
                  
                  Copyright (c) 1991, 2005, Oracle.  All rights reserved.
                  
                  Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                  STATUS of the LISTENER
                  ------------------------
                  Alias                     LISTENER
                  Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                  Start Date                19-FEB-2013 17:15:22
                  Uptime                    0 days 0 hr. 20 min. 8 sec
                  Trace Level               off
                  Security                  ON: Local OS Authentication
                  SNMP                      OFF
                  Listener Log File         /u01/app/oracle/product/10g/db_1/network/log/listener.                                                         log
                  Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db51.site)(PORT=1521)))
                  Services Summary...
                  Service "db51" has 1 instance(s).
                    Instance "db51", status READY, has 1 handler(s) for this service...
                  Service "db51XDB" has 1 instance(s).
                    Instance "db51", status READY, has 1 handler(s) for this service...
                  Service "db51_XPT" has 1 instance(s).
                    Instance "db51", status READY, has 1 handler(s) for this service...
                  Service "test1" has 1 instance(s).
                    Instance "test1", status READY, has 1 handler(s) for this service...
                  Service "test1XDB" has 1 instance(s).
                    Instance "test1", status READY, has 1 handler(s) for this service...
                  Service "test1_XPT" has 1 instance(s).
                    Instance "test1", status READY, has 1 handler(s) for this service...
                  The command completed successfully
                  I got 2 databases DB51 and TEST1, are they listnening to the same port 1521?

                  The listener.ora is not found in > /u01/app/oracle/product/10g/db_1/network/admin


                  Please helpppp....

                  Thanks
                  • 6. Re: where is my linstener.ora
                    asahide
                    $ lsnrctl status
                    $ lsnrctl services
                    And you can set your new database's local_listener parameter.

                    Regards,
                    • 7. Re: where is my linstener.ora
                      asahide
                      I got 2 databases DB51 and TEST1, are they listnening to the same port 1521?
                      YES,
                      Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                      • 8. Re: where is my linstener.ora
                        yxes2013
                        Thanks dear :)
                        Since V10, every DB tries to register itself to listener using port #1521 once every 60 seconds.
                        I am not used to linsteners without listener.ora :( It seems that I am crawling in the "dark".

                        In windows, I always create listener.ora using netca. even in 11gR2.

                        What if I install a higher db version? like 11gR2? Does my database still attached to a lower listener of 10g?

                        Thanksssssss
                        • 9. Re: where is my linstener.ora
                          sb92075
                          yxes2013 wrote:
                          Thanks dear :)
                          Since V10, every DB tries to register itself to listener using port #1521 once every 60 seconds.
                          I am not used to linsteners without listener.ora :( It seems that I am crawling in the "dark".

                          In windows, I always create listener.ora using netca. even in 11gR2.

                          What if I install a higher db version? like 11gR2? Does my database still attached to a lower listener of 10g?

                          Thanksssssss
                          when multiple versions of Oracle software support multiple DBs,
                          then start a single listener using the highest Oracle version and every DB will register itself to that listener.
                          • 10. Re: where is my linstener.ora
                            yxes2013
                            Wow Im impressed ;)

                            So If I install 11g, I need to disable 10g listener? But how can I disable it when I do not have a file of it? :(
                            • 11. Re: where is my linstener.ora
                              EdStevens
                              yxes2013 wrote:
                              Yes dear I can see that :)
                              oracle@db51:/u01/app/oracle/product/10g/db_1/network/admin> lsnrctl status
                              
                              LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-FEB-2013 17:35:31
                              
                              Copyright (c) 1991, 2005, Oracle.  All rights reserved.
                              
                              Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                              STATUS of the LISTENER
                              ------------------------
                              Alias                     LISTENER
                              Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                              Start Date                19-FEB-2013 17:15:22
                              Uptime                    0 days 0 hr. 20 min. 8 sec
                              Trace Level               off
                              Security                  ON: Local OS Authentication
                              SNMP                      OFF
                              Listener Log File         /u01/app/oracle/product/10g/db_1/network/log/listener.                                                         log
                              Listening Endpoints Summary...
                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db51.site)(PORT=1521)))
                              Services Summary...
                              Service "db51" has 1 instance(s).
                              Instance "db51", status READY, has 1 handler(s) for this service...
                              Service "db51XDB" has 1 instance(s).
                              Instance "db51", status READY, has 1 handler(s) for this service...
                              Service "db51_XPT" has 1 instance(s).
                              Instance "db51", status READY, has 1 handler(s) for this service...
                              Service "test1" has 1 instance(s).
                              Instance "test1", status READY, has 1 handler(s) for this service...
                              Service "test1XDB" has 1 instance(s).
                              Instance "test1", status READY, has 1 handler(s) for this service...
                              Service "test1_XPT" has 1 instance(s).
                              Instance "test1", status READY, has 1 handler(s) for this service...
                              The command completed successfully
                              I got 2 databases DB51 and TEST1, are they listnening to the same port 1521?
                              No. Databases don't "listen" at all. The listener listens for connection requests.

                              As you have discovered, the listener does not require a listener.ora file at all. If you issue a 'lsnrctl start' command you are telling the OS to load and pass control to an executable named 'lsnrctl'. That executable will then start the listener process. It will look for a file called 'listener.ora' to provide some some configuration information for that listener, but if it doesn't find the file, it will start a listener using all default values. One of those default values is the 'name' of the listener, defaulted to LISTENER. Another value is the port the listener (not the database) listens on. Default value of 1521. Databases will attempt to contact a listener every 60 seconds to register themselves with it. By default they will attempt to contact the listener on the same port the listener uses by default ... 1521. A listener.ora file is only required if you have a circumstance where you need to supply some non-default values to the listener and/or need to have databases statically registered.

                              One single listener, using all default values is quite capable of -- indeed, WAS DESIGNED TO -- service multiple databases of multiple versions running from multiple oracle homes. If you have multiple oracle homes, you should run the listener out of the highest version .. not necessarily because it is required, but simply because, being the newest, it will be the most capable.


                              read: [url http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] Help! I can’t connect to my database
                              read: [url http://edstevensdba.wordpress.com/2011/02/16/sqlnet_client_cfg/] Help! I can’t connect to my database (part duex)
                              read: [url http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/] ora-12154tns-03505
                              read: [url http://edstevensdba.wordpress.com/2011/02/27/tnsping-101/] tnsping-101
                              read: [url http://edstevensdba.wordpress.com/2011/03/19/ora-12514/] ora-12514
                              read: [url http://edstevensdba.wordpress.com/2011/03/05/ora-12545/] ora-12545

                              read: [url http://edstevensdba.wordpress.com/2011/07/30/exploring-the-local_listener-parameter/] exploring-the-local_listener-parameter

                              The listener.ora is not found in > /u01/app/oracle/product/10g/db_1/network/admin


                              Please helpppp....

                              Thanks
                              • 12. Re: where is my linstener.ora
                                yxes2013
                                Thanks Ed, That is brilliantly explained ;)
                                • 13. Re: where is my linstener.ora
                                  sb92075
                                  yxes2013 wrote:
                                  Wow Im impressed ;)

                                  So If I install 11g, I need to disable 10g listener? But how can I disable it when I do not have a file of it? :(
                                  from the 10g ORACLE_HOME do as below

                                  lsnrctl stop

                                  change PATH to use 11g ORACLE_HOME/bin & do as below

                                  lsnrctl start
                                  • 14. Re: where is my linstener.ora
                                    yxes2013
                                    Gracias! :)