Oracle Adapter Error
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 ora 12560 tns protocol adapter error 11g client a title. You can not post a blank message. Please type your tns-12560: tns:protocol adapter error linux message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived
Tns-00530: Protocol Adapter Error
9 Replies Latest reply on Sep 26, 2012 11:44 AM by EdStevens ERROR: ORA-12560: TNS:protocol adapter error 953769 Aug 3, 2012 3:26 PM OS: Windows 7 64-bit Oracle 11g installed Error
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
Message: SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: Ajinkya Enter password: ERROR: ORA-12560: TNS:protocol adapter error Please Help!! I have the same question Show 0 Likes(0) 271258Views Tags: none (add) This content has been marked as final. Show 9 replies 1. Re: ERROR: ORA-12560: TNS:protocol adapter error sb92075 ora-12560 sqlplus Aug 3, 2012 3:44 PM (in response to 953769) 950766 wrote: OS: Windows 7 64-bit Oracle 11g installed Error Message: SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: Ajinkya Enter password: ERROR: ORA-12560: TNS:protocol adapter error Please Help!!FAQ! are both OS Services for the listener & database started & running? Like Show 0 Likes(0) Actions 2. Re: ERROR: ORA-12560: TNS:protocol adapter error EdStevens Aug 3, 2012 4:42 PM (in response to 953769) 950766 wrote: OS: Windows 7 64-bit Oracle 11g installed Error Message: SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: Ajinkya Enter password: ERROR: ORA-12560: TNS:protocol adapter error Please Help!!Too bad you didn't show the command that generated this ... where you actuall invoked sqlplus at the command line.... That has a bearing on this error. Typically this will result from 1) not having ORACLE_SID properly set. Especially so on Windows. 2) not having the db service started. See the windows services applet, services.msc Like S
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle
Ora 12560 Tns Protocol Adapter Error Client Machine
Books Oracle Scripts Ion Excel-DB Don Burleson Blog ora-12560: tns:protocol adapter error sap
ORA-12560: TNS: protocol adapter error ora-12560 windows Oracle Database Tips by Burleson Consulting Question: I installed Oracle 10g on my server but there is a problem with error "ORA-12560:TNS:protocol adapter error". When I https://community.oracle.com/thread/2425280 sign on I get the error "ORA-12560:TNS:protocol adapter error"... Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Answer by Edward Stoever: http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm Is there a listener running? Have you run the netca program to configure and start the listener? The Oracle docs note that you should troubleshoot the ORA-12560 by tracing the connection: ORA-12560: TNS: protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete. If you are running Oracle on Windows, you may fi the ORA-12560 by running the oradim utility to create a service for the listener. MOSC Note: 117976.1 offers tips for diagnosing the TNS-12560 error noting that the TNS-12560 is in the TNS transport layer and the TNS-12560 may only be a symptom of a lower-level network error as listed in MOSC Note 39662.1. You can use MOSC Note 39774.1 to get a SQL*Net trace or follow these instrORA-12560 TNS:protocol adapter error ? Programming World SubscribeSubscribedUnsubscribe4343 Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to https://www.youtube.com/watch?v=7un8JoGOWbQ a playlist. Sign in Share More Report Need to report the http://techiesdigest.com/ora-12560-tns-protocol-adapter-error/ video? Sign in to report inappropriate content. Sign in Statistics 6,162 views 8 Like this video? Sign in to make your opinion count. Sign in 9 2 Don't like this video? Sign in to make your opinion count. Sign in 3 Loading... Loading... Loading... adapter error Rating is available when the video has been rented. This feature is not available right now. Please try again later. Published on Dec 14, 2015how to fix ORA-12560 TNS:protocol adapter error ? Category Education License Standard YouTube License Show more Show less Loading... Advertisement Autoplay When autoplay is enabled, a suggested video will automatically play next. protocol adapter error Up next Oracle - Understanding the tnsnames.ora and listener.ora files - Duration: 12:46. Chris Ostrowski 91,272 views 12:46 How To Solve TNS protocol Adapter Error Of Oracle Database!! - Duration: 3:44. Cecret Point 582 views 3:44 How to solve TNS: protocol adaptor error in oracle - Duration: 4:41. Tsega Zeab 5,520 views 4:41 how to solve ORA-12560: TNS:protocol adapter error - Duration: 1:26. Praveen Biyyapu 287 views 1:26 how to resolve oracle Error 1053 "The service did not respond in a timely fashion" - Duration: 3:31. Oracle in 182 views 3:31 Resolved: The Network Adapter could not establish the connection - Duration: 9:36. daniele perrotta 31,335 views 9:36 ora - 12514 and ora - 12505 tns listener error fixed in 90 seconds ✅ - Duration: 1:30. CBOT 1,746 views 1:30 How to Fix IO Error in sql oracle - Duration: 2:34. Adam Tech 26,380 views 2:34 How to resolve the ora 12154 error - Duration: 7:03. DBA Pro 49,006 views 7:03 insufficient privileges Problem solved
Facebook Twitter Google+ YouTube Google Products Gmail Google Apps Google Forms Google Drive Internet Android Reviews Fixed – ORA-12560: TNS: protocol adapter error Posted by Techies on June 29, 2015 Home 3 Comments This article will explain you how to resolve ORA-12560: TNS: protocol adapter error. Error Message: ORA-12560: TNS: protocol adapter error Resolution: Method-1: To resolve this issue, you need to make sure that you have set the correct oracle SID. Lets take the following example. C:\>sqlplus system/manager@xe SQL*Plus: Release 11.2.0.2.0 Production ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: I got the error "ORA-12560: TNS:protocol adapter error" Now what I did to resolve this issue. I set the Oracle SID on command prompt and tried to STARTUP again. Now this time my startup was successful. C:\>set ORACLE_SID=xe C:\>sqlplus system/manager@xe Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> startup ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1388352 bytes Variable Size 620757184 bytes Database Buffers 444596224 bytes Redo Buffers 4591616 bytes Database mounted. Database opened. SQL> If the above method doesn’t work, might be service of Oracle database is not running. Check for the service, if it is not running then starts the service. If it is running then restart the service. Method-2: C:\>sqlplus SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:34:24 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: / as sysdba ERROR: ORA-12560: TNS:protocol adapter error How to restart the Oracle Service? Go to Start > Run > Type Services.msc Now Start/Restart both Oracle service & listener service- OracleServiceXE & OracleXETNSListener Once both the services are started, try to start your database. C:\>sqlplus SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 22:41:30 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1071333376 bytes Fixed Size 1388352 bytes Variable Size 620757184