Ora 12560 Tns Protocol Adapter Error 11g Client
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please ora-12560 tns protocol adapter error in oracle 11g turn JavaScript back on and reload this page. Please enter
Ora-12560 Sqlplus
a title. You can not post a blank message. Please type your message and try ora 12560 tns protocol adapter error windows oracle client again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 9 Replies Latest reply on Sep 26, 2012 11:44 AM by
Ora-12560 Windows
EdStevens ERROR: ORA-12560: TNS:protocol adapter error 953769 Aug 3, 2012 3:26 PM OS: Windows 7 64-bit Oracle 11g installed Error Message: SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: Ajinkya Enter password: ERROR: ORA-12560: TNS:protocol adapter error Please Help!! ora 12560 tns protocol adapter error client machine I have the same question Show 0 Likes(0) 271250Views Tags: none (add) This content has been marked as final. Show 9 replies 1. Re: ERROR: ORA-12560: TNS:protocol adapter error sb92075 Aug 3, 2012 3:44 PM (in response to 953769) 950766 wrote: OS: Windows 7 64-bit Oracle 11g installed Error Message: SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: Ajinkya Enter password: ERROR: ORA-12560: TNS:protocol adapter error Please Help!!FAQ! are both OS Services for the listener & database started & running? Like Show 0 Likes(0) Actions 2. Re: ERROR: ORA-12560: TNS:protocol adapter error EdStevens Aug 3, 2012 4:42 PM (in response to 953769) 950766 wrote: OS: Windows 7 64-bit Oracle 11g installed Error Message: SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 3 20:52:24 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: Ajinkya Enter password: ERROR: ORA-12560: TNS:proto
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions
Tns-00530: Protocol Adapter Error
you might have Meta Discuss the workings and policies of
Tns Protocol Adapter Not Loadable
this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers tns 00511 no listener 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 https://community.oracle.com/thread/2425280 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 http://dba.stackexchange.com/questions/68939/error-ora-12560-when-trying-to-connect-windows-sqlplus-client-to-oracle-11g-lin 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/product/11.2.0/db_1/network/admin/tnsn
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 http://stackoverflow.com/questions/8782842/tns-protocol-adapter-error-while-starting-oracle-sqlplus hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community 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 TNS Protocol adapter error while starting Oracle SQL*Plus up vote 2 down vote favorite 3 Whenever I try to login into SQL*Plus (11g Standar Edition Win 64) I get an protocol adapter error related to some connection error. I try to login as sys as sysdba and provide the password. All the services are started. I'm on Windows 7. Any help would be appreciated. oracle oracle11g sqlplus share|improve this question edited Jan 9 '12 at 4:33 Sathya 13.2k1667106 asked Jan 9 '12 at 0:49 Brian 548113371 1 seems like the listener service is not running –Sathya Jan 9 '12 at 4:35 possible duplicate of Oracle Protocol Adapter Error tns protocol adapter –Sathya Jan 9 '12 at 4:35 See also: stackoverflow.com/a/1435949/59087 –Dave Jarvis Dec 31 '12 at 21:34 add a comment| 8 Answers 8 active oldest votes up vote 5 down vote Try sqlplus sys/