12560 Oracle Error
Contents |
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 ora-12560 error in oracle Overflow the company Business Learn more about hiring developers or posting ads with us ora 12560 tns protocol adapter error oracle 10g Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community ora-12560 tns protocol adapter error 10g of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-12560: TNS:protocol adaptor error up vote 32 down vote favorite 13 I Google[d] for this error
How To Solve Ora-12560 Error
ORA-12560: TNS:protocol adaptor error but not able to find the actual reason and how to solve this error ? Can anyone tell me a perfect solution to solve login problem. sql oracle oracle9i ora-12560 share|improve this question edited Jan 25 '14 at 7:58 asked Aug 1 '11 at 5:39 mr_eclair 14.6k2386127 add a comment| 13 Answers 13 active oldest votes up vote 47 down vote accepted Go to the windows machine that ora-12560 tns adapter error solution hosts the Oracle database server Go to Start -> Run -> Services.msc in windows. Locate OracleService (here OracleServiceORCL) and click on "Start" to start the oracle database service (if not already running) Once it is up and running, from the command prompt run the following: tnsping < tnsalias > (tnsalias entry you can find it in tnsnames.ora file) share|improve this answer answered Aug 1 '11 at 21:06 Bharathi 69857 9 In my case service is running but again this error ? what should i do? –Suhrob Samiev Sep 25 '12 at 10:38 So, this assumes you are running Oracle Server on Windows? –Jay Sullivan Sep 22 '14 at 13:50 I use Oracle 11g on Windows 8.1 . Before all, I set ORACLE_SID. sqlplus works, no problem, then I close it. I reopen, I try many times, but not working. Even, when service is running, sqlplus doesn't work. –Do Nhu Vy May 11 '15 at 16:11 I am using windows 8 and oracle 12c. Instead of "OracleServiceORCL" i have found "OracleServiceORACLE12C". I have just started it and i have to not run the command. Ur answer is very useful. –Black Swan Jan 26 at 13:30 add a comment| up vote 15 down vote Seems like datab
ORA-12560: TNS:protocol adapter error Deepak Soni SubscribeSubscribedUnsubscribe4343 Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to a playlist. Sign in Share More Report how to solve protocol adapter error in oracle 10g Need to report the video? Sign in to report inappropriate content. Sign in
Protocol Adapter Error In Oracle 11g
Transcript Statistics 108,392 views 207 Like this video? Sign in to make your opinion count. Sign in 208
Oracle Error 12154
21 Don't like this video? Sign in to make your opinion count. Sign in 22 Loading... Loading... Transcript The interactive transcript could not be loaded. Loading... Loading... Rating is available when http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error the video has been rented. This feature is not available right now. Please try again later. Published on Apr 12, 2014protocol error while login. unable to start services. Category People & Blogs License Standard YouTube License Show more Show less Loading... Advertisement Autoplay When autoplay is enabled, a suggested video will automatically play next. Up next how to fix ORA-12560 TNS:protocol adapter error https://www.youtube.com/watch?v=agx5uVIq3gw ? - Duration: 4:12. Programming World 4,918 views 4:12 Resolved: The Network Adapter could not establish the connection - Duration: 9:36. daniele perrotta 26,424 views 9:36 Oracle - TNS : Protocol Adapter Error Working Solution - Duration: 0:57. Srijit Banerjee 48,807 views 0:57 Oracle - Understanding the tnsnames.ora and listener.ora files - Duration: 12:46. Chris Ostrowski 87,736 views 12:46 How To Solve TNS protocol Adapter Error Of Oracle Database!! - Duration: 3:44. Cecret Point 457 views 3:44 How to solve TNS: protocol adaptor error in oracle - Duration: 4:41. Tsega Zeab 5,221 views 4:41 solving protocol adapter error in oracle 11g - Duration: 2:10. ANANTHAN N.A 18,350 views 2:10 Oracle tutorial 03: Connecting to oracle database through command prompt.mp4 - Duration: 4:03. navingupta52 48,205 views 4:03 how to solve ORA 12560 TNS protocol adapter error in oracle - Duration: 1:14. Anilkumar 455 1,544 views 1:14 Oracle username and password and Account unlocking - Duration: 8:37. Chandra Shekhar Reddy 111,857 views 8:37 How to resolve the ora 12154 error - Duration: 7:03. DBA Pro 47,459 views 7:03 Oracle DBA, TNS protocol Adapter Error, 1e11 - Durat
Google Products Gmail Google Apps Google Forms Internet Database Oracle Database SQL Tips PL/SQL Tips Oracle DBA Tips MySQL Database PostgreSQL Reviews Deals & Coupons Fixed – ORA-12560: TNS: http://techiesdigest.com/ora-12560-tns-protocol-adapter-error/ protocol adapter error Posted by Techies on June 29, 2015 Home http://itbloggertips.com/2013/11/fixed-ora-12560-tns-protocol-adapter-error/ 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 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 protocol adapter error 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 bytes Database Buffers 444596224 bytes Redo Buffers 4591616 bytes Database mounted. Database opened. SQL> If you are still getting the same issue, write us in comment section. We will try to solve your problem. Subscribe to
Anil Kumar on November 17, 2013 All Posts, Database, Oracle DBA 14 Comments Rate this post When you login into Oracle Database and it throws an error message: Ora-12560: TNS: protocol adapter error Then follow the below mentioned steps to solve this issue. First of all, make sure that you have set the correct ORACLE_SID: C:\>sqlplus system/manager@xe SQL*Plus: Release 11.2.0.2.0 Production ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: 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, may be the OracleService for the 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. 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 Now restart the service using below method. Start > Run > Type Services.msc Start/Restart both Oracle service & listener service- OracleServiceXE & OracleXETNSListener 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 bytes Database Buffers 444596224 bytes Redo Buffers 4591616 bytes Database mounted. Database opened. SQL> If you are still unable to resolve the issue, write below in comment section. We will try to solve your problem. Get Free Blogging Tips & Technology updates in your Email !!! Subscribe via RSS feed 0 Related PostsFixed - ORA-00844: Parameter not taking MEMORY_TARGET into accountFixed ORA-12518: TNS:listener could not hand off client connectionFixed - ORA-19809: limit exceeded for recovery filesFixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 errorORA-00600: internal error code - FixedResolved ORA-12154: T