Oracle Getaddrinfo Failed With Error 11001
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions ora-12535 operation timed out oracle you might have Meta Discuss the workings and policies of
Tns-12535: Tns:operation Timed Out Ns Secondary Err Code: 12560
this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers tns-00505: operation timed out or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for ns secondary err code: 12606 database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a 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
Tns 12535 Tns Operation Timed Out 11g
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 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 w
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 tns-12535 tns-00505 enter a title. You can not post a blank message. Please type tns-12606 your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is
Ns Secondary Err Code: 12609
archived 1 2 Previous Next 24 Replies Latest reply on Mar 30, 2011 1:17 PM by 851175 Go to original post This content has been marked as final. Show 24 http://dba.stackexchange.com/questions/63251/tns-12535-tnsoperation-timeout replies 15. Re: Not able to resolve ORA-12154 issue orafad Mar 29, 2011 12:01 PM (in response to Pavan Kumar) Why does changes to the listener keep coming up in a thread related to ORA-12154? Like Show 0 Likes(0) Actions 16. Re: Not able to resolve ORA-12154 issue EdStevens Mar 29, 2011 12:22 PM (in response to Pavan Kumar) Pavan https://community.oracle.com/thread/2200884?start=15&tstart=0 Kumar wrote: Hi, AS you said that you tnsping is giving the response. Try to create a static listener and check. Presently your listener service is looking for external procedures but not db service. http://download.oracle.com/docs/cd/B28359_01/network.111/b28317/listener.htm - Pavan Kumar NOnce again .. if he's getting a 12154, he's not getting far enough for the listener to be in play. Like Show 0 Likes(0) Actions 17. Re: Not able to resolve ORA-12154 issue EdStevens Mar 29, 2011 12:27 PM (in response to 851175) 848172 wrote: Thanks for correcting me, but the result still remains the same. ORA-12154 listner.ora -------------------------------------------------------------------------------- SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=test1.example.com) (SID_NAME=svr1) (ORACLE_HOME=c:\oracle\product\11.2.0\dbhome_1)) )Pardon me for my skepticism, but so far you have not actually shown us the problem. Only your config fiiles (and the listener file has nothing to do with the reported problem). Please go to a command prompt and enter the following: sqlplus scott/tiger@orcl replaceing scott with your username replacing tiger with the password for your chosen username replacing orcl with the correct entry from tnsnames. copy and paste the entire session - your comm
2003, x86Oracle 11.1.0.7.0When trying to start the listener, it took more time than usual, and after a while it showed up the following messages on the console:Starting tnslsnr: please wait...TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) The listener operation timed supports no services The command completed successfullyAnd when trying to display the services this was shown by the lsnrctl services command:...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=echo.world)(PORT=1521)))TNS-12535: TNS:operation timed out TNS-12560: TNS:protocol adapter error TNS-00505: Operation timed out 32-bit Windows Error: 60: Unknown errorConnecting to operation timed out (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))The listener supports no servicesThe command completed successfullyThe trace was enabled and the stack of messages was recorded at the trace file. By taking a look at the file a particular message came to my attention:...2011-07-05 15:09:59.231337 : nsinh_hoff:connection inherited2011-07-05 15:09:59.231349 : nsinherit:connected2011-07-05 15:09:59.237138 : nsglma:Listener's pid=30562011-07-05 15:09:59.249332 : nsglbgetRSPidx:returning ecode=02011-07-05 15:09:59.249389 : nsc2addr:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=echo.oracle.com)(PORT=1521)))2011-07-05 15:09:59.249561 : snlinGetAddrInfo:getaddrinfo() failed with error 110012011-07-05 15:09:59.249633 : nttbnd2addr:looking up IP addr for host: echo.oracle.comFrom this point on, several other errors showed up, but this is the first point where everything began to be not normal.The call getaddrinfo() failed, which means there was an inconsistency when trying to resolve the host IP address.By taking a look at the hosts file and the ipconfig command output the disc