Oracle 12560 Protocol Adapter Error

Contents

from India hi, i am using oracle 8.1.7 on windows with 2GB RAM while connecting to svrmgrl it is giving ora-12560..though XXX database is there and working last day... This solved a problem for me a while back. MyOnlineEdu.com 70,231 views 18:16 Oracle10G installation on windows 7 - Duration: 16:51. OR go to command prompt and run lsnrctl, then enter 'start' to start the listener Thanx alot May 25, 2011 - 1:30 pm UTC Reviewer: A reader Thanx Arangaperumal G i Source

Words that are both anagrams and synonyms of each other Sound Mysteriously Died on Debian Desktop - How to get it back? On Windows (as you are) another common cause is that the ORACLE_SID is not defined in the registry. Search the control panel for "env", then create a New value We set TNS_ADMIN = /app/me.user/product/11.2.0/client_1/network/admin your path may vary. Get Free Blogging Tips & Technology updates in your Email !!! https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836

Plz follow the below steps in ur laptop/desktop Start-run-services.msc in that start Oracle Service ORCL manually It will work for sure.. john mass 74,670 views 16:51 How to install and configure Oracle 11g Release 2 in Windows 64 bit - Duration: 17:51. Join them; it only takes a minute: Sign up ORA-12560: TNS:protocol adaptor error up vote 33 down vote favorite 13 I Google[d] for this error ORA-12560: TNS:protocol adaptor error but not Tns-00530: Protocol Adapter Error 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 6 15:43:55 2007 Copyright (c) 1982,

Why did they bring C3PO to Jabba's palace and other dangerous missions? Instance "orcl", status READY, has 1 handler(s) for this service... Please tell me how to correct it in easy way. have a peek here And you suggested setting oracle_sid manually.

Is the listener only meant to service incoming client requests, excluding local sqlplus sessions? Ora 12560 Tns Protocol Adapter Error Windows Oracle Client Senior MemberAccount Moderator You need to have a correct OS configuration, that is NOT a Home Edition. and in 11g version i'm getting error "ORA-12560: TNS:protocol adapter error " i restarted all the services from service.msc but still same error os: windows 8 ram: 8Gb Followup September 04,

Please tell me why people still use this product? I run the default XE service. 1. All rights reserved. Ora 12560 Tns Protocol Adapter Error Client Machine Then go to sqlplus give ur username and password.

No net. For whatever reason the configuration lost the database entry I need. http://www.oracle.com/technetwork/products/express-edition/overview/index.html Thank you very much February 17, 2013 - 10:51 am UTC Reviewer: A reader from India Ora-12560 TNS Adapter error February 20, 2013 - 1:17 pm UTC Reviewer: clara from Check This Out Now open listener.ora file which is present in following directory: C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN Open that file and change the host parameter with you computer name You can get your computer name by right

Service "orcl" has 1 instance(s). Best of luck! All answers seem to be Services not running March 25, 2010 - 10:28 am UTC Reviewer: Edward from Indian Head, MD You seem to be saying that services not running is Setting this to an invalid connection alias will typically produce ORA-12154: TNS:could not resolve service name.

I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others. 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. ora 12560: TNS: Protocol adapter error for 11g November 05, 2011 - 4:32 am UTC Reviewer: CHAKRI from india pls any one can give me the answer ........