Error Ora-12560
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 error ora-12560 tns protocol adapter error sqlplus work properly but from couple of days i'm getting error stating "ORA-12560:
Oracle Error Ora-12560
TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we said... sounds like the
Oracle Ora-12560 Protocol Adapter Error
database is not up. you probably 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
Ora-12560 Tns Protocol Adapter Error 12c
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 Settings\tkyte>net stop oracleserviceora10gr1 The OracleServiceORA10GR1 service ora-12560 tns adapter error windows 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
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! ora 12154 error Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don ora 12560 tns protocol adapter error 11g client Burleson Blog
ORA-12560: TNS: ora 12560 tns protocol adapter error visual studio protocol adapter error Oracle Database Tips by Burleson Consulting Question: I installed Oracle 10g on my server but there is a problem with error https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 "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 password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter password: ERROR: http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm 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 tips for diagnosing the TNS-12560 error noting that the TNS-12560 is in the TNS transport layer and the TNS-12560 may only be a symptom of a lower-level network error as listed in MOSC Nlog 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 http://dba.stackexchange.com/questions/68939/error-ora-12560-when-trying-to-connect-windows-sqlplus-client-to-oracle-11g-lin and policies of 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 https://supportforums.cisco.com/document/9371/user-receives-ora-12560-tnsprotocol-adapter-error 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 in the adapter error 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 VM on protocol adapter error 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) (SID = orcl) ) )
Contact Us Help Follow Us Newsletter Instagram YouTube Facebook Twitter Google + LinkedIn DirectoryNetwork InfrastructureWAN, Routing and Switching LAN, Switching and Routing Network Management Remote Access Optical Networking Getting Started with LANs IPv6 Integration and Transition EEM Scripting Other Subjects SecurityVPN Security Management Firewalling Intrusion Prevention Systems/IDS AAA, Identity and NAC Physical Security MARS Email Security Web Security Other Subjects Service ProvidersMetro MPLS Voice Over IP XR OS and Platforms Video Other Subjects Collaboration, Voice and VideoIP Telephony Video Over IP Jabber Clients Unified Communications Applications TelePresence Digital Media System Contact Center Conferencing UC Migrations Other Subjects Wireless - MobilitySecurity and Network Management Wireless IP Voice and Video Getting Started with Wireless WLCCA Other Subjects ServicesCisco ServiceGrid Connected Analytics Smart Call Home Smart Net Total Care Operations Exchange Mobile ApplicationsCisco Proximity Cisco Technical Support Online Tools and ResourcesCisco Bug Discussions Technical Documentation Ideas Cisco CLI Analyzer Support Community Help Data CenterApplication Centric Infrastructure Application Networking Intelligent Automation Server Networking Storage Networking Unified Computing Wide Area Application Services (WAAS) Other Subjects Small BusinessNetwork Storage Routers Security Surveillance Switches Voice and Conferencing Wireless Solutions and ArchitecturesBorderless Networks Collaboration Cisco User GroupsSeattle Cisco User Group (SEACUG) Silicon Valley Cisco User Group (SVCUG) Southern California Cisco User Group (SCCUG) Cisco Certifications Cisco.com Idea Center Cisco Cafe Expert CornerTop Contributors Leaderboards Cisco Live! Events Events Community CornerAwards & Recognition Behind the Scenes Feedback Forum Cisco Certifications Cisco Press Café Cisco On Demand Support & Downloads Community Resources Security Alerts Security Alerts News News Video Cisco Support YouTube Cisco YouTube Blogs Technical Documentation Cisco Products Products Services Services Solutions Solutions Global Support Numbers Cisco Support Community Directory Network Infrastructure WAN, Routing and Switching LAN, Switching and Routing Network Management Remote Access Optical Networking Getting Started with LANs IPv6 Integration and Transition EEM Scripting Other Subjects Security VPN Security Management Firewalling Intrusion Prevention Systems/IDS AAA, Identity and NAC P