Thursday, July 14, 2011

TNS-01151: Missing Listener Name, TST, in listener.ora

Hi All.
After R12 adcfgclone.pl appsTier unable To Start TNS Listener: 
TNS-01151: Missing Listener Name, TST, in listener.ora'  in new Linux server.


Please check /etc/hosts file.
Need to be:
127.0.0.1               localhost.localdomain localhost
<server_ip>            server_name.domain server_name


If it not correct, change it and re-run adcfgclone procedure for DB and APPL tiers.
Listener will start OK now.


Good luck...
Labels: ,

9 comments:

  1. AnonymousNovember 14, 2012 at 4:06 PM

    Thanks very much - I spent ages trying to fix this 'till I saw your post.
    AlanK

    ReplyDelete
  2. UnknownJuly 31, 2014 at 3:08 PM

    Hi Mr. Borulia, In my system also showing same error and but when i open /etc/hosts file it's showing like those lines, are they correct

    92.168.23.145 DBA1 # Added by NetworkManager
    127.0.0.1 localhost.localdomain localhost
    ::1 DBA1 localhost6.localdomain6 localhost6
    192.168.23.151 DBA #other hostname
    192.168.23.149 DBA2 #one more hostname

    ReplyDelete
    Replies
    1. Arty BoruliaJuly 31, 2014 at 4:04 PM

      can you please paste here your hosts ?

      Delete
    2. Arty BoruliaJuly 31, 2014 at 4:12 PM

      Your host file need to be:
      127.0.0.1 localhost.localdomain localhost
      .

      Pay attention, 127.0.0.1 localhost.localdomain localhost need to be first line.

      Delete
    3. UnknownJuly 31, 2014 at 4:19 PM

      actual my real host is DBA1 and remaining hosts are other o/s hosts

      Delete
    4. Arty BoruliaJuly 31, 2014 at 4:22 PM

      You need to change your /etc/hosts files to be :
      127.0.0.1 localhost.localdomain localhost
      server_ip dba1.your_domain dba1

      127.0.0.1 localhost.localdomain localhost need to be the first line

      Delete
  3. UnknownJuly 31, 2014 at 3:13 PM

    please give me as clearly and then when iam going for tnsping command, it's also gettin error

    [oracle11g@DBA2 ~]$ tnsping lsnr

    TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 30-JUL-2014 23:44:42

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

    Used parameter files:

    TNS-03505: Failed to resolve name

    ReplyDelete
  4. UnknownJune 20, 2019 at 6:40 PM

    Confirm sid=xxxxx for both listener.ora and tnsnames.ora

    ReplyDelete

Subscribe to: Post Comments (Atom)