Oracle Tns Adapter Error Sqlplus
Contents |
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Whilst
Ora-12560 Tns Protocol Adapter Error In Oracle 11g
you are here, check out some content from the ora-12560 tns protocol adapter error sqlplus 11g AskTom team: Understanding scheduler syntax Latest Followup You Asked i'm running oracle on standalone
Ora 12560 Tns Protocol Adapter Error 11g Client
computer at home.it used to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should ora-12560 sqlplus i do? please help.. (scott/tiger) and we said... sounds like the database is not up. you probably restarted your machine and the instance is not set to autostart C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:43:55 2007 Copyright (c) ora 12560 tns protocol adapter error windows oracle client 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options C:\Documents and Settings\tkyte>net stop oracleserviceora10gr1 The OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started success
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
Ora 12560 Tns Protocol Adapter Error Client Machine
this site About Us Learn more about Stack Overflow the company Business Learn tns-00530: protocol adapter error more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Ora-12560 Windows
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; it only takes a minute: Sign up ORA-12560: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 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 question edited Jan 25 '14 at 7:58 asked Aug 1 '11 at http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error 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 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
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 http://stackoverflow.com/questions/8782842/tns-protocol-adapter-error-while-starting-oracle-sqlplus Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs 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 https://www.question-defense.com/2011/02/10/sqlplus-error-ora-12560-tnsprotocol-adapter-error you, helping each other. Join them; it only takes a minute: Sign up TNS Protocol adapter error while starting Oracle SQL*Plus up vote 2 down vote favorite 3 Whenever I try to login into SQL*Plus (11g Standar adapter error Edition Win 64) I get an error related to some connection error. I try to login as sys as sysdba and provide the password. All the services are started. I'm on Windows 7. Any help would be appreciated. oracle oracle11g sqlplus share|improve this question edited Jan 9 '12 at 4:33 Sathya 13.2k1667106 asked Jan 9 '12 at 0:49 Brian 548113371 1 seems like the listener service is not running –Sathya Jan 9 '12 at 4:35 protocol adapter error possible duplicate of Oracle Protocol Adapter Error –Sathya Jan 9 '12 at 4:35 See also: stackoverflow.com/a/1435949/59087 –Dave Jarvis Dec 31 '12 at 21:34 add a comment| 8 Answers 8 active oldest votes up vote 5 down vote Try sqlplus sys/
adapter error alex February 10, 2011 9 Comments Tweet Again I am fairly new to Oracle so it has been quite a learning process and typically I have been running into errors that are easy to resolve but being able to locate the answers easy has been challenging. While attempting to use sqlplus.exe from the Windows 7 command line I continued to receive a TNS protocol adapter error and it turns out it was simply from using the incorrect syntax. Below I describe the error in more detail as well as the correct syntax to use for sqlplus on Windows 7. SQLPlus Error On Windows 7 Computer Running Oracle: text C:\Program Files (x86)\instant-client>sqlplus system/password SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 17 01:16:30 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: C:\Program Files (x86)\instant-client> As you can see above I was receiving the ORA-12560: TNS: protocol adapter error. After some initial research I was baffled at what the issue could be as there appear to be numerous reasons this could be an issue including services not being started properly, incorrect environment variables, etc. Turns out in my case it literally was just a syntax error on my part. Somehow I had tried a half dozen syntax combinations but never fully read through the "-help" screen which is what ended up solving my issue. Use the below syntax to login to Oracle using sqlplus on a Windows 7 computer. Correct sqlplus Login Syntax For Oracle On Windows 7: text C:\Program Files (x86)\instant-client>sqlplus.exe system/password@localhost/ORC SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 17 01:15:24 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.