Odbc Tns Protocol Adapter Error
Contents |
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Latest Followup You Asked i'm running oracle tns protocol adapter error in oracle 11g on standalone computer at home.it used to work properly but from ora-12560 tns protocol adapter error sqlplus 11g couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should i ora 12560 tns protocol adapter error 11g client 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 tns-00530: protocol adapter error 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) 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
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
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 successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 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> in the above ora10gr1 is my orac
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 about
Ora-12560 Sqlplus
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask ora 12560 tns protocol adapter error client machine 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 ora-12560 windows 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 Edition Win 64) I get an error https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 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 possible duplicate of Oracle Protocol Adapter Error http://stackoverflow.com/questions/8782842/tns-protocol-adapter-error-while-starting-oracle-sqlplus –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/
Facebook Twitter Google+ YouTube Google Products Gmail Google Apps Google Forms Google Drive Internet Android Reviews Fixed – http://techiesdigest.com/ora-12560-tns-protocol-adapter-error/ 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 protocol adapter 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 protocol adapter error 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