Oracle Database Error 12535
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not tns-12535 tnsping post a blank message. Please type your message and try again. More discussions tns-12535: tns:operation timed out ns secondary err code: 12560 in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 3 Previous Next 36 Replies Latest tns 12535 tns operation timed out 11g reply on Apr 20, 2007 4:37 AM by 572941 ORA-12535: TNS:operation timed out 572941 Apr 17, 2007 11:18 AM Hi All, I have a solaris server on which oracle 9 is installed. On
Tns-12535 Tns-00505
that server, I am able to connect to the database by sqlplus username/passwd. But when I am trying to connect from my client PC, it is throwing the error ORA-12535: TNS:operation timed out. ----------------------------------------------------------------------------------------------------------------- C:\Documents and Settings\amohanty.ADIGGN>sqlplus agcfdp/agcfdp@CSC43_dillip SQL*Plus: Release 8.1.7.0.0 - Production on Tue Apr 17 16:46:00 2007 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR: ORA-12535: TNS:operation timed out Enter user-name: ----------------------------------------------------------------------------------------------------------------- There tns-12535 tns-12560 tns-00505 is no issue of connectivity etc from the client to the server. Please suggest. 64035Views Tags: none (add) This content has been marked as final. Show 36 replies 1. Re: ORA-12535: TNS:operation timed out 572941 Apr 17, 2007 11:25 AM (in response to 572941) This i sthe result of tnsping. C:\Documents and Settings\amohanty.ADIGGN>tnsping CSC43_dillip TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 17-APR-20 07 16:55:15 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=172.21.142.239)(PORT=1521)) TNS-12535: TNS:operation timed out Like Show 0 Likes(0) Actions 2. Re: ORA-12535: TNS:operation timed out Eduardo Legatti Apr 17, 2007 11:26 AM (in response to 572941) Hi, Are you sure that the listener on the server is up ? Try lsnrctl status Did you test the connectivity between the machines ? Try ping utility Cheers Like Show 0 Likes(0) Actions 3. Re: ORA-12535: TNS:operation timed out Raman Apr 17, 2007 11:30 AM (in response to 572941) Hi, It says you could not reach your server. check your oracle_home set?? you are using "Version 8.1.7.0.0 - Production on 17-APR-20" in the ping utility.. set the path and oracle home correctly and try.. start>programs>oracle installed products>home selector in
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this tns-12535: tns:operation timed out ns secondary err code: 12606 site About Us Learn more about Stack Overflow the company Business Learn
Tns-12606
more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database
Tns-00505 Operation Timed Out Oracle 11g
Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a https://community.oracle.com/thread/499484 minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top TNS-12535: TNS:operation timeout up vote 1 down vote favorite I have Windows Server 2008 R2 with Oracle Client 11.1.0.7.0 client installed. TNSPing to 100% available databases (accessible from other machines, i.e. I can do TNS ping to these databases http://dba.stackexchange.com/questions/63251/tns-12535-tnsoperation-timeout from other machines) returns me following error: TNS-12535: TNS:operation timeout. At the same time I can telnet to database host/port and see that proper tnsnames file is being used. Environment variables are configured as appropriate (ORACLE_HOME, TNS_ADMIN, Path). Also I can connect via telnet using service/host name + port - so this is unlikely a firewall issue. After enabling Oracle client logging I can see following error related details in tnsping.trc: snlinGetAddrInfo: enrty snlinGetAddrInfo: getaddrinfo() failed with error 11001 snlinGetAddrInfo: exit The only strange/suspicious thing about this machine is that it had multiple versions of oracle client installed (10, 11.1, 11.2) - removal of all versions apart from 11.1 & reinstall/repair of 11.1 haven't resolved this issue. Also it seems to me that v10 of client was not removed properly - it disappeared from Programs and Features, but files in installation folder had not been deleted. Any advice on what to check / how to resolve this issue? oracle oracle-11g-r2 share|improve this question edited Apr 17 '14 at 8:40 asked Apr 15 '14 at 14:41 Mikhail 21541017 What is the status of the listener? –Andrew Brennan Apr 15 '14 a