Oracle Sqlplus Protocol 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 a
Ora 12560 Tns Protocol Adapter Error 11g Client
title. You can not post a blank message. Please type your message and ora-12560 sqlplus try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 9 Replies
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
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 Message: SQL*Plus: tns-12560: tns:protocol adapter error linux 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) 271272Views Tags: none (add) This content has been marked as final. Show 9 replies 1. Re: ERROR: ORA-12560: TNS:protocol adapter error sb92075 Aug 3, 2012 3:44 tns-00530 protocol adapter error 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 Show 1 Likes(1) Actions 3. Re: ERROR: ORA-12560: TNS:proto
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the
Ora 12560 Tns Protocol Adapter Error Client Machine
workings and policies of this site About Us Learn more about Stack ora-12560: tns:protocol adapter error sap Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs
Ora-12560 Windows
Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; https://community.oracle.com/thread/2425280 it only takes a minute: Sign up ORA-12560: TNS:protocol adaptor error up vote 33 down vote favorite 13 I Google[d] for this 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 http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error question edited Jan 25 '14 at 7:58 asked Aug 1 '11 at 5:39 mr_eclair 14.7k2387127 add a comment| 13 Answers 13 active oldest votes up vote 47 down vote accepted Go to the windows machine that 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 ti
ads with YouTube Red. Working... No thanks Try it free Find out whyClose solving protocol adapter error in oracle 11g ANANTHAN N.A SubscribeSubscribedUnsubscribe55 Loading... Loading... Working... Add to http://www.youtube.com/watch?v=yW-bBujghPA Want to watch this again later? Sign in to add this video to a playlist. Sign in Share More Report Need to report the video? Sign in to http://techiesdigest.com/ora-12560-tns-protocol-adapter-error/ report inappropriate content. Sign in Statistics 18,796 views 12 Like this video? Sign in to make your opinion count. Sign in 13 10 Don't like this video? Sign protocol adapter in to make your opinion count. Sign in 11 Loading... Loading... Loading... Rating is available when the video has been rented. This feature is not available right now. Please try again later. Published on Nov 6, 2013Here i show you a simple method to solving protocol adapter error in oracle 11g Category People & Blogs License protocol adapter error 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 solve ORA-12560: TNS:protocol adapter error - Duration: 2:27. Deepak Soni 111,585 views 2:27 how to fix ORA-12560 TNS:protocol adapter error ? - Duration: 4:12. Programming World 5,581 views 4:12 Oracle - TNS : Protocol Adapter Error Working Solution - Duration: 0:57. Srijit Banerjee 49,307 views 0:57 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 ORACLE DBA Telephonic Round Interview - Duration: 41:57. Yasin Basha 68,488 views 41:57 Oracle - Understanding the tnsnames.ora and listener.ora files - Duration: 12:46. Chris Ostrowski 91,272 views 12:46 Oracle username and password and Account unlocking - Duration: 8:37. Chandra Shekhar Reddy 117,528 views 8:37 How to reset oracle SYS password - Duration: 11:14. Milos Nedbal 22,614 views 11:14 dbDao.
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 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 sectio