Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2005
    Posts
    9

    Unanswered: ORA-12535 : Operation time out

    Hi, Experts

    I am new hier . I have installed Oracle 9i in my Server and 1 DB created . It works localy. And when I try to connect from another workstation it says ORA-12535.

    This is my tnsnames.ora from workstation
    Code:
    WEBSERVER =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = WEBSERVER )(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = OracleDB.webserver)
        )
      )
    and this is listener.ora from my testServer.

    Code:
    # LISTENER.ORA Network Configuration File: D:\oracle9\ora92\network\admin\listener.ora
    # Generated by Oracle configuration tools.
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521))
          )
        )
      )
    
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = D:\oracle9\ora92)
          (PROGRAM = extproc)
        )
        (SID_DESC =
          (GLOBAL_DBNAME = OracleDB)
          (ORACLE_HOME = D:\oracle9\ora92)
          (SID_NAME = OracleDB)
        )
        (SID_DESC =
          (GLOBAL_DBNAME = oracleDB.webserver)
          (ORACLE_HOME = webserver)
          (SID_NAME = OracleDB)
        )
      )
    
    CONNECT_TIMEOUT_LISTENER = 60
    CONNECTION_TIMEOUT = 60
    Event I increased connect_timeout and restart lnsrctl but Error comes again and again.

    Please help me

    Erdenemandal

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    12535, 00000, "TNSperation timed out"
    // *Cause: The requested operation could not be completed within the time out
    // period.
    // *Action: Look at the documentation on the secondary errors for possible
    // remedy. See SQLNET.LOG to find secondary error if not provided explicitly.
    // Turn on tracing to gather more information.
    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
    Dec 2005
    Posts
    9
    in SQLNET.LOG. There is no actual data. Last access it 22.12.2005. But I did so many access today ???

    I read this comment but I did not found useful information in SQLNET.LOG

    Regards,
    Erdene

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >// Turn on tracing to gather more information.
    One data point does not make any trend.
    The problem could be on the client or the problem could be on the server.
    All we (TINW) know for sure at this point in time is that a problem exists.
    Based upon previous posts, it appears the server in question is a Windows OS.
    I don't know what the Windows equivalent of Solaris' snoop Or Linux tcpdump;
    but the use of a "packet sniffer" might reveal more clues.
    Somebody is unhappy about something, but you've provided NO useful clues.
    EXACTLY - What operation is generating this error?
    Last edited by anacedent; 12-23-05 at 10:31.
    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.

  5. #5
    Join Date
    Dec 2005
    Posts
    9
    Yeah, you are right. Both of OS is Windows

    Regards,
    Erdene

Posting Permissions

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