Oracle Tns Adapter Error 12560
Contents |
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 ora 12560 tns protocol adapter error 11g client more about Stack Overflow the company Business Learn more about hiring developers or ora-12560 sqlplus posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community
Ora-12560 Tns Protocol Adapter Error Sqlplus 11g
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: TNS:protocol adaptor error up vote 33 down vote favorite
Ora-12560 Windows
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 5:39 mr_eclair 14.7k2387127 add a comment| 13 Answers 13 active oldest votes up vote tns-12560: tns:protocol adapter error linux 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 windows 8 and oracle 12c. Instead of "OracleServiceORCL" i have found "OracleServiceORACLE12C". I have just started it and i have to not run the command. Ur answer
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 Share More Report Need to report
Tns-00530: Protocol Adapter Error
the video? Sign in to report inappropriate content. Sign in Transcript Statistics 111,825 ora 12560 tns protocol adapter error windows oracle client views 217 Like this video? Sign in to make your opinion count. Sign in 218 22 Don't like this video? ora-12560: tns:protocol adapter error sap Sign in to make your opinion count. Sign in 23 Loading... Loading... Transcript The interactive transcript could not be loaded. Loading... Loading... Rating is available when the video has been rented. This http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error 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. Up next how to fix ORA-12560 TNS:protocol adapter error ? - Duration: 4:12. Programming World 5,581 views 4:12 https://www.youtube.com/watch?v=agx5uVIq3gw 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 solving protocol adapter error in oracle 11g - Duration: 2:10. ANANTHAN N.A 18,626 views 2:10 ORACLE DBA Telephonic Round Interview - Duration: 41:57. Yasin Basha 68,488 views 41:57 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 MATHs 25,545 views 1:49 ora - 12514 and ora - 12505 tns listener error fixed in 90 seconds ✅ - Duration: 1:30. CBOT 1,746 views 1:30 how to solve ORA 12560 TNS protocol adapter error in ora
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 workings and policies of http://dba.stackexchange.com/questions/68939/error-ora-12560-when-trying-to-connect-windows-sqlplus-client-to-oracle-11g-lin this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ https://scn.sap.com/thread/3220642 Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes adapter error 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 VM on my mac.I have everything up and working on server.I protocol adapter error 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) (SID = orcl) ) ) ~ ~ ~ ~ On Centos server I can log in using sqlplus too. I changed tnsnames.ora on win
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementData Manageme