ORA-12535-TNS-operation time out.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-12535-TNS-operation time out.

  1. #1
    Join Date
    Oct 2001
    Location
    GA, USA
    Posts
    79

    Angry

    Hi Guys,

    i just installe oracle 9i on my home pc windows xp os but I have problem with connecting sql *pluse 9i. i am getting error ORA-12535-TNS-operation time out.I check every thing in listner.ora,tnsname.ora,i can ping machine.i also tried to change listner_timeout = 0 ,i also chnge port from 1521 to 1526 but still nothing but weird thing is that i can connect with database without specifying service name just user name and password.i am not understanding why i can not connect with sql*plue or any thired party product like sqlnave or tode.here is my listner.ora and tnsname.ora file :
    # LISTENER.ORA Network Configuration File: C:\oracle\ora90\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

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

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = EMPAC)
    (ORACLE_HOME = C:\ORACLE\ORA90)
    (SID_NAME = EMPAC)
    )
    )

    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
    # Generated by Oracle configuration tools.

    EMPAC =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = WHITE)PORT= 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = EMPAC)
    )
    )

    I also change host name useing my ip address.

    Can any one solve my problem ? any oracle guru? that will be apcreciate.

    Minesh.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check your sqlnet.ora file

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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