can't start Listener on NT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: can't start Listener on NT

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    8

    Question

    I am trying to start listener on NT for the newly installed 8.1.5. I get the following error:
    TNS-12560: TNS Protocol adaptor error
    TNS-00530: Protocol adaptor error
    someone please tell me what exactly is the problem.
    Thanks
    Shobha

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Could you post your listener.ora file thats in /O_H/net80/admin location ? with your host/machin name and database name thats currently running on the host.
    Reddy,Sam

  3. #3
    Join Date
    Sep 2000
    Posts
    8

    listener.ora

    I am pasting here the contents of Listener.ora. Machine name is shobha and the database running at the time is Oracle8.

    Thanks
    shobha

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SHOBHA)(PORT = 1521))
    (PROTOCOL_STACK =
    (PRESENTATION = TTC)
    (SESSION = NS)
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = Oracle8.WORLD)
    (ORACLE_HOME = d:\oracle\ora81)
    (SID_NAME = oracle8)
    )
    )

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Try this...

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SHOBHA)(PORT = 1521))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = Oracle8.WORLD)
    (ORACLE_HOME = d:\oracle\ora81)
    (SID_NAME = oracle8)
    )
    )
    Reddy,Sam

  5. #5
    Join Date
    Sep 2000
    Posts
    8
    Sorry, even this doesn't work and I get the same error.

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Try with the following this is my server listener.ora. I modified it for you.
    <font face=courier>
    # LISTENER.ORA Network Configuration File: E:\Oracle\Ora816\network\admin\listener.ora
    # Generated by Oracle configuration tools.
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 60
    TRACE_LEVEL_LISTENER = OFF
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = shobha)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = oracle8.world)
    (ORACLE_HOME = d:\oracle\ora81)
    (SID_NAME = oracle8)
    )
    )</font>

    If it doesn't work you have to troubleshoot swtiching on tracing.
    Reddy,Sam

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