1 2 3 4 Previous Next 52 Replies Latest reply: Dec 28, 2012 6:33 AM by EdStevens Go to original post RSS
      • 30. Re: NOt able to start the listener..
        EdStevens
        978850 wrote:
        Nope ... that did not work either :( :( :(
        <snip>
        >
        [oracle@test1 ~]$ 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
        ::1 test1.com

        127.0.0.1 test1.com
        192.168.2.4 test1.com
        172.18.233.72 test1.com
        10.0.3.15 test1.com
        That is one messed up hosts file.

        Is that from the database server, or from the client machine?

        What is the IP address of test1.com?

        your hosts file should look like this:
        127.0.0.1     localhost.localdomain    localhost
        <ip of test1.com>    test1.com       test1
        And please understand that 127.0.0.1 is the local loopback address. No request to 127.0.0.1 ever leaves the machine from which the request was made. And in the hosts file, 127.0.0.1 should never be referred to by anything other than localhost.
        [oracle@test1 ~]$ lsnrctl start

        LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-DEC-2012 17:30:00

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

        Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

        TNSLSNR for Linux: Version 11.1.0.6.0 - Production
        System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
        Log messages written to /u01/app/oracle/diag/tnslsnr/test1/listener/alert/log.xml
        TNS-01150: The address of the specified listener name is incorrect

        Listener failed to start. See the error message(s) above...

        [oracle@test1 ~]$
        Completely remove the listener.ora file. The listener is quite capable of starting without it. It will come up with all default values - listener name of LISTENER, listening port of 1521, and accepting dynamic registration from any databases running on the server. If it comes up saying 'supports no services' then you do not have a problem. It supports no services because the databases have not had a chance to self-register yet. Give them a couple of minutes. If they are not up when the listener starts, they will register when they are started.
        • 31. Re: NOt able to start the listener..
          981853
          I have three network cards..

          Eth0,1,and 2
          which ip i should consider...
          • 32. Re: NOt able to start the listener..
            sb92075
            By eliminating listener.ora, then Oracle will decide for you!
            • 33. Re: NOt able to start the listener..
              EdStevens
              asidds wrote:
              I have three network cards..

              Eth0,1,and 2
              which ip i should consider...
              I don't have any experience with more than one fixed-ip NIC, so do not know how to advise on that.
              • 34. Re: NOt able to start the listener..
                981853
                Nope this dis not work for me :(

                oracle@test1 ~]$ cd /u01/app/oracle/product/11.1.0/db_1/network/admin/


                [oracle@test1 admin]$ ls
                listener.back samples shrept.lst sqlnet.ora tnsnames.ora
                [oracle@test1 admin]$ lsnrctl start

                LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 28-DEC-2012 09:52:09

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

                Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

                TNSLSNR for Linux: Version 11.1.0.6.0 - Production
                Log messages written to /u01/app/oracle/diag/tnslsnr/test1/listener/alert/log.xml
                Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1.com)(PORT=1521)))

                Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                TNS-12547: TNS:lost contact
                TNS-12560: TNS:protocol adapter error
                TNS-00517: Lost contact
                Linux Error: 104: Connection reset by peer
                [oracle@test1 admin]$
                • 35. Re: NOt able to start the listener..
                  Jairam
                  Hi,

                  Do you find any clue in listener log file? (Located in $ORACLE_HOME/network/log/listener.log)



                  Regards,
                  Jai.
                  • 36. Re: NOt able to start the listener..
                    sb92075
                    Linux Error: 104: Connection reset by peer
                    OS/networking mis-configuration.
                    • 37. Re: NOt able to start the listener..
                      981853
                      There is no listener.ora file created after removing.
                      also no log file genrated .

                      [oracle@test1 admin]$ less $ORACLE_HOME/network/log/listener.log
                      /u01/app/oracle/product/11.1.0/db_1/network/log/listener.log: No such file or directory
                      [oracle@test1 admin]$
                      • 38. Re: NOt able to start the listener..
                        Jairam
                        Hi,

                        Post the output for the below command,
                        $ cd $ORACLE_HOME/network/admin
                        $ ls

                        Do you have any GUI tools? If yes use netca for creating the listener..
                        • 39. Re: NOt able to start the listener..
                          sb92075
                          asidds wrote:
                          There is no listener.ora file created after removing.
                          also no log file genrated .

                          [oracle@test1 admin]$ less $ORACLE_HOME/network/log/listener.log
                          /u01/app/oracle/product/11.1.0/db_1/network/log/listener.log: No such file or directory
                          [oracle@test1 admin]$
                          below is a free clue since you seem to have a problem to actually READ what YOU post!


                          TNSLSNR for Linux: Version 11.1.0.6.0 - Production
                          Log messages written to /u01/app/oracle/diag/tnslsnr/test1/listener/alert/log.xml
                          • 40. Re: NOt able to start the listener..
                            981853
                            oracle@test1 samples]$ cd $ORACLE_HOME/network/admin
                            [oracle@test1 admin]$ ls
                            listener.back samples shrept.lst sqlnet.ora tnsnames.ora

                            after Configuring listener using netca


                            [oracle@test1 admin]$ ls -l
                            total 40
                            -rw-r--r-- 1 oracle oracle 868 Dec 27 17:29 listener.back
                            -rw-rw-r-- 1 oracle oracle 333 Dec 28 10:31 listener.ora
                            drwxr-xr-x 2 oracle oracle 4096 Dec 27 14:09 samples
                            -rw-r--r-- 1 oracle oracle 187 May 9 2007 shrept.lst
                            -rw-rw-r-- 1 oracle oracle 226 Dec 28 10:29 sqlnet12122810AM2954.bak
                            -rw-rw-r-- 1 oracle oracle 226 Dec 28 10:30 sqlnet12122810AM3038.bak
                            -rw-r--r-- 1 oracle oracle 226 Dec 27 14:10 sqlnet.ora
                            -rw-rw-r-- 1 oracle oracle 324 Dec 28 10:29 tnsnames12122810AM2954.bak
                            -rw-rw-r-- 1 oracle oracle 324 Dec 28 10:30 tnsnames12122810AM3038.bak
                            -rw-r----- 1 oracle oracle 324 Dec 27 17:03 tnsnames.ora
                            [oracle@test1 admin]$ lsnrctl start

                            LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 28-DEC-2012 10:32:33

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

                            Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

                            TNSLSNR for Linux: Version 11.1.0.6.0 - Production
                            System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
                            Log messages written to /u01/app/oracle/diag/tnslsnr/test1/listener/alert/log.xml
                            Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1.com)(PORT=1521)))
                            Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test1.com)(PORT=1521)))
                            TNS-12547: TNS:lost contact
                            TNS-12560: TNS:protocol adapter error
                            TNS-00517: Lost contact
                            Linux Error: 104: Connection reset by peer
                            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                            TNS-12547: TNS:lost contact
                            TNS-12560: TNS:protocol adapter error
                            TNS-00517: Lost contact
                            Linux Error: 104: Connection reset by peer
                            [oracle@test1 admin]$
                            • 41. Re: NOt able to start the listener..
                              Jairam
                              As previously said, check the log file for any information.,
                              Log messages written to /u01/app/oracle/diag/tnslsnr/test1/listener/alert/log.xml
                              • 42. Re: NOt able to start the listener..
                                981853
                                <msg time='2012-12-27T14:33:22.002+05:30' org_id='oracle' comp_id='tnslsnr'
                                type='UNKNOWN' level='16' host_id='test1.com'
                                host_addr='127.0.0.1'>
                                <txt>TNS-12545: Connect failed because target host or object does not exist
                                TNS-12560: TNS:protocol adapter error
                                TNS-00515: Connect failed because target host or object does not exist


                                <txt>TNS-12545: Connect failed because target host or object does not exist
                                TNS-12560: TNS:protocol adapter error
                                TNS-00515: Connect failed because target host or object does not exist
                                Linux Error: 99: Cannot assign requested address


                                <msg time='2012-12-27T14:33:22.002+05:30' org_id='oracle' comp_id='tnslsnr'
                                type='UNKNOWN' level='16' host_id='test1.com'
                                host_addr='127.0.0.1'>
                                <txt>TNS-12545: Connect failed because target host or object does not exist
                                TNS-12560: TNS:protocol adapter error
                                TNS-00515: Connect failed because target host or object does not exist
                                • 43. Re: NOt able to start the listener..
                                  Jairam
                                  As Edstevens said, check your hosts file for proper host name or IP entry
                                  • 44. Re: NOt able to start the listener..
                                    981853
                                    This is after removing all the IP from three interface ..

                                    have mentioned only loop back

                                    [oracle@test1 ~]$ lsnrctl start

                                    LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 28-DEC-2012 11:46:16

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

                                    Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

                                    TNSLSNR for Linux: Version 11.1.0.6.0 - Production
                                    System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
                                    Log messages written to /u01/app/oracle/diag/tnslsnr/test1/listener/alert/log.xml
                                    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1.com)(PORT=1521)))
                                    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

                                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test1.com)(PORT=1521)))
                                    TNS-12547: TNS:lost contact
                                    TNS-12560: TNS:protocol adapter error
                                    TNS-00517: Lost contact
                                    Linux Error: 104: Connection reset by peer
                                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                                    TNS-12547: TNS:lost contact
                                    TNS-12560: TNS:protocol adapter error
                                    TNS-00517: Lost contact
                                    Linux Error: 104: Connection reset by peer
                                    [oracle@test1 ~]$ 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
                                    #::1 test1.com

                                    127.0.0.1 test1.com