Ora-12560 Tns Protocol Error In 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: Will Oracle ruin the PL/SQL ora-12560 tns protocol adapter error in oracle 11g Challenge? Latest Followup You Asked i'm running oracle on standalone computer at ora-12560 sqlplus home.it used to work properly but from couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error
Ora 12560 Tns Protocol Adapter Error 11g Client
" what should 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
Ora-12560 Tns Protocol Adapter Error Sqlplus 11g
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 Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data ora-12560 windows 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 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 S
ORA-12560: TNS:protocol adapter error Deepak Soni SubscribeSubscribedUnsubscribe4444 Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to a playlist. Sign in
Ora 12560 Tns Protocol Adapter Error Windows Oracle Client
Share More Report Need to report the video? Sign in to report tns-00530: protocol adapter error inappropriate content. Sign in Transcript Statistics 111,811 views 217 Like this video? Sign in to make your opinion ora 12560 tns protocol adapter error client machine count. Sign in 218 22 Don't like this video? Sign in to make your opinion count. Sign in 23 Loading... Loading... Transcript The interactive transcript could not be loaded. https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 Loading... Loading... Rating is available when 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. https://www.youtube.com/watch?v=agx5uVIq3gw Up next how to fix ORA-12560 TNS:protocol adapter error ? - Duration: 4:12. Programming World 5,581 views 4:12 Resolved: The Network Adapter could not establish the connection - Duration: 9:36. daniele perrotta 31,335 views 9:36 How To Solve TNS protocol Adapter Error Of Oracle Database!! - Duration: 3:44. Cecret Point 582 views 3:44 Oracle - TNS : Protocol Adapter Error Working Solution - Duration: 0:57. Srijit Banerjee 49,307 views 0:57 Oracle - Understanding the tnsnames.ora and listener.ora files - Duration: 12:46. Chris Ostrowski 91,272 views 12:46 How to solve TNS: protocol adaptor error in oracle - Duration: 4:41. Tsega Zeab 5,520 views 4:41 Oracle username and password and Account unlocking - Duration: 8:37. Chandra Shekhar Reddy 117,528 views 8:37 ORACLE DBA Telephonic Round Interview - Duration: 41:57. Yasin Basha 68,488 views 41:57 solving protocol adapter error in oracle 11g - Duration: 2:10. ANANTHAN N.A 18,626 views 2:10 insufficient privileges Problem solved - Duration: 7:21. BunHong Hak 49,311 views 7:21 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor - Duration: 1:49. INNo MATH
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the http://dba.stackexchange.com/questions/68939/error-ora-12560-when-trying-to-connect-windows-sqlplus-client-to-oracle-11g-lin workings and policies of this site About Us Learn more about Stack http://www.orafaq.com/forum/t/185824/ Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others tns protocol in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server up vote 2 down vote favorite 2 I installed 11g on Centos protocol adapter error VM on my mac.I have everything up and working on server.I have included following command I ran on cenos. $lsnrctl status LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-JUN-2014 14:49:41 Copyright (c) 1991, 2009, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hayer)(PORT=1522))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 23-JUN-2014 14:03:58 Uptime 0 days 0 hr. 45 min. 42 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/hayer/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hayer)(PORT=1522))) Services Summary... Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully My tnsnames.ora file is as follows: # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = hayer)(PORT = 1522)) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hayer)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) (S
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 re