12560 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 on standalone computer at home.it used to work properly but from
Ora-12560 Tns Protocol Adapter Error 12c
couple of days i'm getting error stating "ORA-12560: TNS:protocol adapter error " what tns 00530 protocol adapter error should i do? please help.. (scott/tiger) and we said... sounds like the database is not up. you probably tns 12541 tns no listener 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) 1982, 2005, Oracle.
Tns 12560 Tns Protocol Adapter Error Linux
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
Tns 00511 No Listener
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 OracleService name, Right Click, Start. ora-12560 August 27, 2008 - 8:20 am UTC Reviewer: Jain M. from India hi, i am using oracle 8.
ORA-12560: TNS:protocol adapter error Deepak Soni SubscribeSubscribedUnsubscribe4343 Loading... Loading... Working... Add to 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 tns 00583 valid node checking unable to parse configuration parameters report inappropriate content. Sign in Transcript Statistics 108,392 views 207 Like this video? Sign
Tns 12547 Tns Lost Contact
in to make your opinion count. Sign in 208 21 Don't like this video? Sign in to make your opinion count. tns admin Sign in 22 Loading... Loading... Transcript The interactive transcript could not be loaded. Loading... Loading... Rating is available when the video has been rented. This feature is not available right now. Please try again https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 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. Up next how to fix ORA-12560 TNS:protocol adapter error ? - Duration: 4:12. Programming World 4,918 views 4:12 Resolved: The Network Adapter could not establish the connection - Duration: 9:36. daniele https://www.youtube.com/watch?v=agx5uVIq3gw perrotta 26,424 views 9:36 Oracle - TNS : Protocol Adapter Error Working Solution - Duration: 0:57. Srijit Banerjee 48,807 views 0:57 Oracle - Understanding the tnsnames.ora and listener.ora files - Duration: 12:46. Chris Ostrowski 87,736 views 12:46 How To Solve TNS protocol Adapter Error Of Oracle Database!! - Duration: 3:44. Cecret Point 457 views 3:44 How to solve TNS: protocol adaptor error in oracle - Duration: 4:41. Tsega Zeab 5,221 views 4:41 solving protocol adapter error in oracle 11g - Duration: 2:10. ANANTHAN N.A 18,350 views 2:10 Oracle tutorial 03: Connecting to oracle database through command prompt.mp4 - Duration: 4:03. navingupta52 48,205 views 4:03 How to resolve the ora 12154 error - Duration: 7:03. DBA Pro 47,459 views 7:03 Oracle username and password and Account unlocking - Duration: 8:37. Chandra Shekhar Reddy 111,857 views 8:37 how to solve ORA 12560 TNS protocol adapter error in oracle - Duration: 1:14. Anilkumar 455 1,544 views 1:14 Database Video 3 - How to connect to Oracle 12c in windows 8.1 PC - Duration: 5:49. Sam Dhanasekaran 18,228 views 5:49 Oracle DBA, TNS protocol Adapter Error, 1e11 - Duration: 1:40. hammadshams 6,752 views 1:40 Oracle Forms 10g TNS Configuration - Duration: 3:39. Ravi shankar kumar 4,814 views 3:39 Install / Uninstall O
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions http://dba.stackexchange.com/questions/68939/error-ora-12560-when-trying-to-connect-windows-sqlplus-client-to-oracle-11g-lin 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 hiring developers http://www.cryer.co.uk/brian/oracle/ORA12560.htm 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 protocol adapter database professionals who wish to improve their database skills and learn from others 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 protocol adapter error Windows SQL*Plus client to Oracle 11g Linux server up vote 2 down vote favorite 2 I installed 11g on Centos 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/
as a ‘generic protocol adapter error'. In my experience it indicates that Oracle client does not know what instance to connect to or what TNS alias to use. Possible Remedies: If running on the server (or workstation) that is running the database (i.e. if the database is local to the machine) then try explicitly setting ‘ORACLE_SID'. e.g. set ORACLE_SID=