Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Unanswered: Unable to start Tns listener "LSNRCTL"

    Hi
    when im trying to start lsnrctl , its giving following errors
    failed to start service, error 1058.
    TNS-12560:TNSrotocal adapter error.
    TNS-00530:Protocal adapter error

    Im using windows vista and oracle version of 9i, i want to know how to resolve this issue, How to start tns listner so that my application can interact with oracle db

    Can any body please help me in getting out of this problem!

    Thanks for all your help!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Has this ever worked?
    Is this a brand new installation?
    using <code tags> as described in #1 STICKY post at top of this forum post the contents of the listener.ora file back here
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2007
    Posts
    2
    this is my listner.ora file
    # LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 4fb2c60ec73f4f3)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\Oracle\Ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = oracledb)
    (ORACLE_HOME = D:\Oracle\Ora81)
    (SID_NAME = oracledb)
    )
    )

    and this is the brand new installation, i want my java application to interact with oracle db, for this i have to start tnslistner, so please help how to start tnslistner here

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I see a couple of things that just don't seem right to me on the surface.
    >(HOST = 4fb2c60ec73f4f3)
    Usually the hostname resolves to an IP# via DNS or hosts file.
    is this true for your system "4fb2c60ec73f4f3"?

    >Im using windows vista and oracle version of 9i,
    >(ORACLE_HOME = D:\Oracle\Ora81)
    These two contradict each other and would be problematic if both are true.

    Too bad for all concerned that you are using obsoleted version(s) & not at least using V10; which does NOT require a listener.ora file at all!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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