recreate listener.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: recreate listener.ora

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    recreate listener.ora

    Hi Friends,

    I accidentally deleted my listener.ora , how do I rebuild it?

    I tried copying from other running listener.ora from other server and
    edit the necessary path/dir,sid,host,etc like this below:

    # listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME = hsodbc)
    (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
    (PROGRAM = hsodbc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = orcl)
    (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
    (SID_NAME = orcl)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.56)(PORT = 1521))
    )
    )

    But i got error TNS-01150 : The address specified LISTENER name is incorrect

    Pls help....

    Thanks a lot
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Don't you have a backup of your filesystems?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    What about just running netmgr and setting the listener up again?

  4. #4
    Join Date
    Nov 2007
    Posts
    1
    The easiest is to from $ORACLE_HOME/bin enter:
    ./netca
    that will guide you through.
    If you are running windows go to Programs -> oracle -> configuration.
    One of the configurations is a network configuration.

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