Getaddrinfo Failed With Error 11001 Oracle
Contents |
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 site About Us Learn more about Stack Overflow the company Business Learn more ora-12535 operation timed out oracle about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask tns-12535: tns:operation timed out ns secondary err code: 12560 Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and
Tns-00505: Operation Timed Out
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:
Ns Secondary Err Code: 12606
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 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 tns 12535 tns operation timed out 11g 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 21041017 What is the status of the listener? –Andrew Brennan Apr 15 '14 at 15:27 Not sure how to check this. This is on a client side? I can't find lsnrctl.exe in my client folder... Please provide more details on how to check this if possible. –Mikhail Apr 15 '14 at 15:41 Though I guess listener is a server side thing and the fact that I capable to do TNSPing to the same database from another machine(s) confirms that listener status is OK. –Mikhail Apr 15 '14 at 15:47
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.
Tns-12535 Tns-00505
Please enter a title. You can not post a blank message. Please tns-12606 type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This ns secondary err code: 12609 discussion is 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. http://dba.stackexchange.com/questions/63251/tns-12535-tnsoperation-timeout Show 24 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 https://community.oracle.com/thread/2200884?start=15&tstart=0 Pavan Kumar) Pavan 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
2003, x86Oracle 11.1.0.7.0When trying to start the listener, it took more time than usual, and after a http://hrivera99.blogspot.com/2011/07/listener-supports-no-services.html 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 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 operation timed 32-bit Windows Error: 60: Unknown errorConnecting to (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 operation timed out 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 discrepancies appeared.Contents at the windows hosts file:192.168.50.78 echo.world echoipconfig output:C:\Oracle\app\product\11.1.0\db_1\NETWORK\ADMIN>ipconfigWindows IP ConfigurationEthernet adapter Loopback Adapter: Connection-specific DNS Suffix . : IP Address. . . . . . . . . . . . : 192.168.2.115 Subnet Mask . . . . . . . . . . . : 255.255.255.0 Default Gateway . . . . . . . . . :Ethernet adapter Local Area Connection: Connection-specific DNS Suffix . : world IP Address. . . . . . . . . . . . : 192.168.50.68 Subnet Mask . . . . . . . . . . . : 255