Ora 12560 Tns Protocol Adapter Error Windows
Contents |
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Whilst you are here, check out some content from the AskTom team: Tightening up your data model Latest ora-12560 sqlplus Followup You Asked i'm running oracle on standalone computer at home.it used
Ora 12560 Tns Protocol Adapter Error 11g Client
to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what should ora-12560 tns protocol adapter error sqlplus 11g 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 ora-12560 windows 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 Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options C:\Documents and
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
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 oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle. Reviews Write a Review Another method September 10, 2007 - 3:15 am UTC Reviewer: Arangaperumal G from Chennai,India Start --> Run--> type " services.msc" Select the Ora
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development tns-00530: protocol adapter error Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books tns-12560: tns:protocol adapter error linux Oracle Scripts Ion Excel-DB Don Burleson Blog
Ora 12560 Tns Protocol Adapter Error Client Machine
ORA-12560: TNS: protocol adapter error Oracle Database Tips by Burleson Consulting Question: I installed Oracle https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 10g on my server but there is a problem with error "ORA-12560:TNS:protocol adapter error". When I 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 http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm 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: 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
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 http://www.orafaq.com/forum/t/185824/ 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 protocol adapter 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 protocol adapter error 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 a
friend ORA-12560: TNS:protocol adapter error [message #575165] Sun, 20 January 2013 16:36 ganesh_gvn Messages: 33Registered: February 2012 Location: PUNE Member Dear All, I have installed Oracle 11gR2 on Window 7 (Home Basic). Now I am trying to access my database with named 'TEST', from cmd, but I am getting "TNS:protocol adapter error" Below is the error : ============================================================================================= Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Home>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 21 03:59:55 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: / as sysdba ERROR: ORA-12560: TNS:protocol adapter error ================================================================================================== When I start the service name 'OracleServiceTest', then I am not getting the error. But It won't allow me to 'startup' the database instead database get started with 'OracleServiceTest' service start. I am doing this as ADMINISTRATOR. I am not understanding where I am wrong. How this can be solved. Please suggest me. Thanks in advance. Ganesh [Updated on: Mon, 21 January 2013 13:51] by ModeratorReport message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #575174 is a reply to message #575165] Sun, 20 January 2013 22:19 rishwinger Messages: 132Registered: November 2011 Senior Member Ganesh I hope you googled about this error and tried everything I am not sure this would work for you but I resolved this error by fixing my environment variables Edit environment variable tns_admin and point it to your tnsnames.ora file location Report message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #575175 is a reply to message #575174] Sun, 20 January 2013 22:45 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member >I have installed Oracle 11gR2 on Window 7 (Home Basic). No Oracle version is ever supported on any Windows Home Edition. I don't know of an