DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ora 12535

  1. 01-09-2002, 01:26 PM #1
    Knarayan
    Knarayan is offline Senior Member
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    HI all,

    I am getting ora 12535: connection timed out error when I try connecting thru sqlplus from a client to the server.

    I am able to establish connection thru tnsping and is quite fast also.
    I tried putting connect_timeout_listener parameter to 0 and also to a very high value but didn't help.

    WHat could be the issue, please help this is urgent!!
    KN
    Reply With Quote Reply With Quote
  2. 01-09-2002, 02:06 PM #2
    Knarayan
    Knarayan is offline Senior Member
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    Any clue,please help!!!
    KN
    Reply With Quote Reply With Quote
  3. 01-09-2002, 02:42 PM #3
    gaegoori
    gaegoori is offline Member
    Join Date
    Jun 2001
    Posts
    243
    connect _timeout_listener_name=0 right?.... with _name
    Reply With Quote Reply With Quote
  4. 01-09-2002, 02:45 PM #4
    Knarayan
    Knarayan is offline Senior Member
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    Yes that's what I have added to listner.ora
    KN
    Reply With Quote Reply With Quote
  5. 01-09-2002, 02:54 PM #5
    gaegoori
    gaegoori is offline Member
    Join Date
    Jun 2001
    Posts
    243
    on your tnsnames.ora file:

    ALIAS =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(Host = 10.10.10.10)(Port = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME=HOSTNAME.DOMAINNAME.COM)
    )
    )

    Try to specify Host with IP address and spell out the SERVICE_NAME= full hostname and domain name instead of
    SID=SIDNAME...

    Also, on your listener.ora file,

    set your GLOBAL_DBNAME to full hostname and domain name as it appears in SERVICE_NAME in tnsname.ora

    not sure if it's gonna work or not, but you can give it a try...
    Reply With Quote Reply With Quote
  6. 01-09-2002, 09:06 PM #6
    sonofsita
    sonofsita is offline Member
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    please refer to doc id 119706.1 on metalink.
    sonofsita
    http://www.ordba.net
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width