12560 Error Oracle
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 more about Stack Overflow the company Business Learn more about hiring developers or posting
Oracle Error 12154
ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the oracle error 12560 exp Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a ora 12560 minute: Sign up ORA-12560: TNS:protocol adaptor error up vote 32 down vote favorite 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
Oracle Error 12560 Encountered
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.6k2386127 add a comment| 13 Answers 13 active oldest votes up vote 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
Oracle Error 6550
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 is very useful. –Black Swan Jan 26 at 13:30 add a comment| up vote 15 down vote Seems like database is not up. It might be due to restarting machine and the instance is not set to autostart and it so not started munually after starting from services Screen. Just goto Command prompt Set Oracle SID C:>set oracle_sid=ORCL Now run Net start command. C:>net start oracleserviceORCL share|improve this answer answered Dec 6 '12 at 6:32 Yasir Ahmed 15112 2 Worked like a charm..Thanks Yasir –WebHrus
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books oracle error 12514 Oracle Scripts Ion Excel-DB Don Burleson Blog
Oracle Error 12560 Export
ORA-12560: TNS: protocol adapter error Oracle Tips oracle ora 12560 tns protocol adapter error by Burleson Question: I installed Oracle 10g on my server but there is a problem with error "ORA-12560:TNS:protocol adapter error". When I sign on I get the http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error 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: ORA-12560: TNS:protocol adapter error Answer by Edward Stoever: Is there a listener running? Have http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm 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 Note 39662.1. You can use MOSC Note 39774.1 to get a SQL*Net trace or follow these instructions for getting a SQL*Net trace. The "TNS-12560: TNS:protocol adapter
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 http://dba.stackexchange.com/questions/68939/error-ora-12560-when-trying-to-connect-windows-sqlplus-client-to-oracle-11g-lin the workings and policies of this site About Us Learn more http://www.cryer.co.uk/brian/oracle/ORA12560.htm 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 _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and oracle error 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 Windows SQL*Plus client to Oracle 11g Linux server up vote 2 down vote favorite 2 oracle error 12560 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/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 =
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=