This discussion is archived
1 2 3 4 Previous Next 52 Replies Latest reply: Dec 28, 2012 4:33 AM by EdStevens Go to original post RSS
  • 45. Re: NOt able to start the listener..
    Jairam Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points