problem in listner
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: problem in listner

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

    problem in listner

    I am not able to startup the listner, earlier it was running fine and i did't alter the listner file also.but when i shut down the db and started the listner i am getting this error.

    TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
    NL-00303: syntax error in NV string



    this is my listner.ora file

    # LISTENER.ORA Network Configuration File: /oracle/u01/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = blrgesun)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oracle/u01)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = blrgeora)
    (ORACLE_HOME = /oracle/u01)
    (SID_NAME = blrgeora)
    )
    )


    Thanks in advance

  2. #2
    Join Date
    May 2008
    Posts
    95
    try to check status of ur listener

    $ lsnrctl status

  3. #3
    Join Date
    May 2008
    Posts
    95
    You need to re-create the listener.ora using the Net8 Assistant/netca

  4. #4
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by muzammil.dba
    try to check status of ur listener

    $ lsnrctl status

    the listner is not up...
    when i try to startup i got that error .

  5. #5
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by muzammil.dba
    You need to re-create the listener.ora using the Net8 Assistant/netca
    S.. i will recreate it. CAn you tell me why you suggest to recreate it.Is there any problem in the listner.ora file.wht is the casue for this error ?

  6. #6
    Join Date
    May 2008
    Posts
    95
    couple of days back I face some problem, then I created Listener.ora file then its working file, that y i suggest you.

  7. #7
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    ya for me also the problem is solved, thanks for the solution,but i did't get what is the error in that.

  8. #8
    Join Date
    May 2008
    Posts
    95
    The listener.ora file was copied from a previous version of Oracle.
    The file contains different syntax for the database and environment
    variables. When you try to use this file with Oracle v8.0.5, it
    cannot understand the parameters listed in the listener.ora file.

  9. #9
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    i am not altered the listner,i shut down the db.and after starting up the database i tried to startup the listner, at that time i got that error.
    and my db i oracle 9i

  10. #10
    Join Date
    Oct 2006
    Posts
    175
    gopu_g,
    One possibility is that your original listener.ora file got deleted from OS. And when you started the listener next time, it got created with default parameters, which weren't as per your original listener's parameters. It could also be that your original listener's name was something else from the default LISTENER.

    HTH,
    gtcol

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width