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
  • 30. Re: NOt able to start the listener..
    EdStevens Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I have three network cards..

    Eth0,1,and 2
    which ip i should consider...
  • 32. Re: NOt able to start the listener..
    sb92075 Guru
    Currently Being Moderated
    By eliminating listener.ora, then Oracle will decide for you!
  • 33. Re: NOt able to start the listener..
    EdStevens Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    Linux Error: 104: Connection reset by peer
    OS/networking mis-configuration.
  • 37. Re: NOt able to start the listener..
    981853 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    <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 Explorer
    Currently Being Moderated
    As Edstevens said, check your hosts file for proper host name or IP entry
  • 44. Re: NOt able to start the listener..
    981853 Newbie
    Currently Being Moderated
    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

Legend

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