1 2 3 4 Previous Next 52 Replies Latest reply: Dec 28, 2012 6:33 AM by EdStevens Go to original post RSS
      • 45. Re: NOt able to start the listener..
        Jairam
        I am not sure about your IP and name is configured properly in the hosts file. Anyway, If this is a local server use "HOST=localhost" in both Listener and tnsnames files..,
        • 46. Re: NOt able to start the listener..
          981853
          I have already did that .. option as well...


          Please see my 15 post in the history...

          BUt for your confirmation i have done that again


          LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 28-DEC-2012 11:59:15

          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=localhost)(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 ~]$

          [oracle@test1 ~]$ cat /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
          # listener.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
          # Generated by Oracle configuration tools.

          LISTENER =
          (DESCRIPTION_LIST =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          )
          )

          [oracle@test1 ~]$ cat /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
          # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
          # Generated by Oracle configuration tools.

          ORCL =
          (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
          (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = orcl)
          )
          )

          [oracle@test1 ~]$
          • 47. Re: NOt able to start the listener..
            Jairam
            Try changing the permission for oracle directory by using below commands and then try..,

            $ cd $ORACLE_HOME/bin
            $ chmod 6751 oracle
            • 48. Re: NOt able to start the listener..
              Niket Kumar
              remove this line from hosts file

              127.0.0.1 test1.com

              and add this line into hosts file

              machine_ip test1.com
              • 49. Re: NOt able to start the listener..
                981853
                oracle@test1 bin]$ pwd
                /u01/app/oracle/product/11.1.0/db_1/bin
                [oracle@test1 bin]$ lsnrctl start

                LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 28-DEC-2012 12:36:54

                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=localhost)(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 bin]$ ls -l oracle
                -rwsr-s--x 1 oracle oracle 152028761 Dec 26 12:14 oracle
                • 50. Re: NOt able to start the listener..
                  981853
                  Caouls you please tell me which ip i enter in hostfile

                  [root@test1 ~]# ifconfig
                  eth0 Link encap:Ethernet HWaddr 08:00:27:E4:A4:5C
                  inet addr:172.18.233.72 Bcast:172.18.233.255 Mask:255.255.255.0
                  inet6 addr: fe80::a00:27ff:fee4:a45c/64 Scope:Link
                  UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
                  RX packets:24976 errors:0 dropped:0 overruns:0 frame:0
                  TX packets:3354 errors:0 dropped:0 overruns:0 carrier:0
                  collisions:0 txqueuelen:1000
                  RX bytes:2565411 (2.4 MiB) TX bytes:725568 (708.5 KiB)
                  Base address:0xd010 Memory:f0000000-f0020000

                  eth1 Link encap:Ethernet HWaddr 08:00:27:5D:DE:43
                  inet addr:192.168.2.4 Bcast:192.168.2.255 Mask:255.255.255.0
                  inet6 addr: fe80::a00:27ff:fe5d:de43/64 Scope:Link
                  UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
                  RX packets:1654 errors:0 dropped:0 overruns:0 frame:0
                  TX packets:109 errors:0 dropped:0 overruns:0 carrier:0
                  collisions:0 txqueuelen:1000
                  RX bytes:157099 (153.4 KiB) TX bytes:23156 (22.6 KiB)
                  Interrupt:209 Base address:0xd260

                  eth2 Link encap:Ethernet HWaddr 08:00:27:AC:5B:AF
                  inet addr:10.0.3.15 Bcast:10.0.3.255 Mask:255.255.255.0
                  inet6 addr: fe80::a00:27ff:feac:5baf/64 Scope:Link
                  UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
                  RX packets:198 errors:0 dropped:0 overruns:0 frame:0
                  TX packets:301 errors:0 dropped:0 overruns:0 carrier:0
                  collisions:0 txqueuelen:1000
                  RX bytes:27480 (26.8 KiB) TX bytes:41010 (40.0 KiB)
                  Base address:0xd240 Memory:f0820000-f0840000

                  lo Link encap:Local Loopback
                  inet addr:127.0.0.1 Mask:255.0.0.0
                  inet6 addr: ::1/128 Scope:Host
                  UP LOOPBACK RUNNING MTU:16436 Metric:1
                  RX packets:3039 errors:0 dropped:0 overruns:0 frame:0
                  TX packets:3039 errors:0 dropped:0 overruns:0 carrier:0
                  collisions:0 txqueuelen:0
                  RX bytes:7001289 (6.6 MiB) TX bytes:7001289 (6.6 MiB)


                  One is bridge adapter, other one is NAT and other is host-only adapter ..
                  • 51. Re: NOt able to start the listener..
                    981853
                    I have solved the issue......


                    In /etc/hosts/

                    we need to change the name as localhost.localdomain

                    after which i started evrything works fine :) :) :)

                    [oracle@test1 ~]$ tnsping orcl

                    TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 28-DEC-2012 13:19:14

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

                    Used parameter files:
                    /u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora


                    Used TNSNAMES adapter to resolve the alias
                    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
                    OK (0 msec)
                    [oracle@test1 ~]$ telnet test1.com 1521
                    Trying 127.0.0.1...
                    Connected to test1.com (127.0.0.1).
                    Escape character is '^]'.
                    ^]



                    Thanks all for your help ... you have guys been very helpful and kind ..
                    i am sorry if i have confused you guys .. as i am the beginner in DB ...
                    • 52. Re: NOt able to start the listener..
                      EdStevens
                      asidds wrote:
                      I have solved the issue......


                      In /etc/hosts/

                      we need to change the name as localhost.localdomain

                      after which i started evrything works fine :) :) :)

                      [oracle@test1 ~]$ tnsping orcl

                      TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 28-DEC-2012 13:19:14

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

                      Used parameter files:
                      /u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora


                      Used TNSNAMES adapter to resolve the alias
                      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
                      OK (0 msec)
                      [oracle@test1 ~]$ telnet test1.com 1521
                      Trying 127.0.0.1...
                      Connected to test1.com (127.0.0.1).
                      Escape character is '^]'.
                      ^]



                      Thanks all for your help ... you have guys been very helpful and kind ..
                      i am sorry if i have confused you guys .. as i am the beginner in DB ...
                      Well, as previously pointed out, no request to 127.0.0.1 ever leaves the machine from which the request originates. Think about what that means when your client is on a different machine than the database ....
                      1 2 3 4 Previous Next