12 Replies Latest reply: Jul 17, 2011 3:10 PM by rukbat RSS

    Listener Port

    753818
      Hi All,

      I have installed Oracle 11gR2 (Software) on Linux on Vmware. Before creating the database I used NETCA to configure the listener. But getting the following error message;

      " Use another port number. The information provided is used by another software ". I am using port 1521.

      I have another installed Oracle 10gR2 on Linux version on another vmware guest but currently stopped.

      Now my question is ;

      1. Even if the port no 1521 is not used currently, is it blocked .

      2. I am trying port no. 1522, 1523..but all giving the same error. What is the range of port no. to be used

      3. So what is the workaround in this case.
        • 1. Re: Listener Port
          Dude!
          You probably already have a listener at that port or a firewall configured blocking ports. You can configure many listeners, but each named listener must use it's own port.

          For further analysis, please show the content of your listener.ora and tnsnames.ora files, which are located in $ORACLE_HOME/network/admin by default. You can also find the currently used listener.ora file by looking at the output of the lsnrctl status command.

          Edited by: Markus Waldorf on Sep 16, 2010 10:29 PM
          • 2. Re: Listener Port
            753818
            Hi Markus,

            There is no Listener, since I have installed the software only. I failed to create from netca since its asking for a valid port no.
            [oracle@localhost samples]$ lsnrctl status
            
            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2010 14:35:58
            
            Copyright (c) 1991, 2009, Oracle.  All rights reserved.
            
            Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
            TNS-12541: TNS:no listener
             TNS-12560: TNS:protocol adapter error
              TNS-00511: No listener
               Linux Error: 111: Connection refused 
            What port numbers can I use here other than 1521,1522.(non-default)
            • 3. Re: Listener Port
              Dude!
              You need to start the listener first in order to check the status:

              $ lsnrctl start

              Did you create a database?

              Edited by: Markus Waldorf on Sep 17, 2010 12:01 AM
              • 4. Re: Listener Port
                753818
                [oracle@localhost samples]$ lsnrctl start
                
                LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2010 15:05:31
                
                Copyright (c) 1991, 2009, Oracle.  All rights reserved.
                
                Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
                
                TNSLSNR for Linux: Version 11.2.0.1.0 - Production
                Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
                
                Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                STATUS of the LISTENER
                ------------------------
                Alias                     LISTENER
                Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
                Start Date                17-SEP-2010 15:05:31
                Uptime                    0 days 0 hr. 0 min. 1 sec
                Trace Level               off
                Security                  ON: Local OS Authentication
                SNMP                      OFF
                Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
                Listening Endpoints Summary...
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
                The listener supports no services
                The command completed successfully
                [oracle@localhost samples]$ lsnrctl status
                
                LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2010 15:06:00
                
                Copyright (c) 1991, 2009, Oracle.  All rights reserved.
                
                Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                STATUS of the LISTENER
                ------------------------
                Alias                     LISTENER
                Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
                Start Date                17-SEP-2010 15:05:31
                Uptime                    0 days 0 hr. 0 min. 28 sec
                Trace Level               off
                Security                  ON: Local OS Authentication
                SNMP                      OFF
                Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
                Listening Endpoints Summary...
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
                The listener supports no services
                The command completed successfully
                • 5. Re: Listener Port
                  753818
                  Hi,

                  But where is the lsnrctl.ora file..?

                  The listener service is up..but can't find the file.

                  If I start netca..can't see any listener..
                  • 6. Re: Listener Port
                    Dude!
                    When you start the database, PMON will automatically register your database in with listener.

                    Can you post the error from the netca log file: $ORACLE_BASE/cfgtoollogs/netca/

                    Edited by: Markus Waldorf on Sep 17, 2010 1:36 AM
                    • 7. Re: Listener Port
                      Rajesh Lathwal
                      online_dba@rediffmail.com wrote:
                      Hi,

                      But where is the lsnrctl.ora file..?
                      lsnrctl is a executable and it is present in $ORACLE_HOME/bin

                      are you talking about listener.ora . It is present in $ORACLE_HOME/network/admin

                      >
                      The listener service is up..but can't find the file.

                      If I start netca..can't see any listener..
                      In 11G , listener can be started even without listener.ora file.

                      please check :

                      http://it.toolbox.com/blogs/database-solutions/oracle-no-listenerora-and-no-tnsnamesora-needed-24241

                      http://download.oracle.com/docs/cd/B28359_01/network.111/b28317/listener.htm

                      Regards
                      Rajesh
                      • 8. Re: Listener Port
                        709920
                        Hi
                        try to edit the */etc/hosts* file with the correct ip address and hostname
                        once I have faced such issues and when i corrected the entries in /etc/hosts it was working fine

                        Note: u need to have root privileges to edit the file /etc/hosts
                        and it will look like this
                        [root@dbsrv2 ~]$ cat /etc/hosts
                        # Do not remove the following line, or various programs
                        # that require network functionality will fail.
                        127.0.0.1 localhost.localdomain localhost
                        192.168.163.129 dbsrv1.com dbsrv1
                        • 9. Re: Listener Port
                          user10637703
                          modify /etc/hosts .
                          add hostname and ip .
                          it's ok.
                          • 10. Re: Listener Port
                            833464
                            Hello to all,

                            I'm having the same problem, my question is:

                            Doesn't matter if my ip configuration is DHCP?

                            my hosts file has the following lines:

                            127.0.0.1 localhost.localdomain localhost
                            ::1 localhost6.localdomain6 localhost6

                            What are exactly the lines that I have to add in hotsts file, something like the following?:

                            HOSTNAME=localhost
                            IP=127.0.0.1

                            Thanks a lot
                            • 11. Re: Listener Port
                              sb92075
                              jcmanzano83 wrote:
                              Hello to all,

                              I'm having the same problem, my question is:

                              Doesn't matter if my ip configuration is DHCP?
                              YES!

                              when all else fails Read The Fine Manual

                              http://www.oracle.com/pls/db112/homepage?remark=tahiti

                              Installation Guide
                              • 12. Re: Listener Port
                                jcmanzano83 wrote:
                                Hello to all,

                                I'm having the same problem, my question is:
                                Moderator Advice:

                                Welcome to the forum. Please don't post in threads that are long dead and don't hijack other threads. When you have a question, start your own topic. Feel free to provide a link to an old post that may be relevant to your problem.

                                I'm locking this thread now.