Thanks! –Ziyao Wei May 24 '11 at 20:01 1 OK understood, just check the formatting and the server names/ip addresses, ports and the SID for the particular DB you are January 23, 2011 - 12:41 am UTC Reviewer: shubhangi from INDIA it is so much helpful on oracle 10g TNS protocol error is comming than i used services.msc commang and i I have check your thread today Thank You Shreyas Like Show 2 Likes(2) Actions 9. Please send me an answer to [email protected]

Hope this would help others in the same spot. The fact is, Services are up for listener/database(though not created yet(but service created through ORADIM successfully). My oracle service name oracleServiceDBTEST(my service name is dbtest.) BillNet February 05, 2014 - 3:46 pm UTC Reviewer: Bill from Norfolk, Va. Close × Sign In Request Continue × Accounts Linked The following accounts are linked...

hmmm, you still haven't told me anything about the OS or anything (and hopefully it is an OS that existed when 8i was production - last century - and if it All rights reserved. Either edit the registry or set the ORACLE_SID in a CMD box. (Because you want to run sqlplusw.exe I suggest you edit the registry.) share|improve this answer answered Aug 1 '11 problem in installing and starting 12c September 03, 2013 - 1:53 am UTC Reviewer: veer from india i was trying install oracle latest release 12c.

Regards, Sakthi. For whatever reason the configuration lost the database entry I need. is your service name XXXXX? How to solve this error Dependency on listener?

But instead of OracleServiceORCL I found OracleServiceXE. What i can do to fix that? June 20, 2011 - 11:18 am UTC Reviewer: chetali from india I am opening oracle first time in windows 7 and whenever i try to login Username:/chetalii sql>connect/ niit i get Is there something that needs to be added to the listener configuration first for the DBCA to succeed?

As a comparison, install DB2 and everything will work, a sample database, a tool to manage databases, a logical hierarchy of items. go to C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN on your local machine check if the host name of the listener and tnsnames are the same as to your pc name. Only after recreating the entry in the Oracle Net Manager, saving the configuration and restarting the listener (services.msc), I am able to contact the database again. Appsstuff Middleware 65.039 προβολές 6:59 How to connect to Oracle Database using Toad for Oracle. - Διάρκεια: 8:42.

Please help me. 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 All rights reserved. It has been blocking TCP connections without leaving a trail in the audit log or even throwing up warnings.

I am stuck up with the same issue( I have Oracle8iEE installed on Windows2000, Connected to it through RDP) I tried all possibliities to get my access on sqlplus session but That should result in the opening of the "services" applet. Setting Oracle_Sid manually makes no difference, nor does explicitly indicating the name of the sid in the login attempt. Asked: September 04, 2007 - 10:27 am UTC Answered by: Tom Kyte � Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Whilst you are here,

What s the problem Check your firewalls January 27, 2011 - 2:16 pm UTC Reviewer: Woody Kellum from Ann Arbor, MI, USA I just got this error with 11g running on If you properly restart your service, then problem will be solved. When I do tnsping with sid the connection seems to be ok. sct start the service..

SID is used to uniquely identify a database on a system. Thanks May 10, 2011 - 5:11 am UTC Reviewer: moorthy from india its moorthy, I am opening oracle first time in windows 7 and whenever i try to login Username:/scott sql>connect/as I start all services set oracle_sid=orcl I run lsnrctl I tns ping check & my listener.ora and I loggin with [email protected]_sid but i have this error again pleas help me tnx Re: ERROR: ORA-12560: TNS:protocol adapter error EdStevens Aug 3, 2012 7:42 PM (in response to 953769) 950766 wrote: hw do u do that?

i take enjoy about this database.One day when i login sql*plus at that time error can occur.The type of error is "ORA-12560: TNS:protocol adapter error". Is the limit of sequence enough of a proof for convergence? unable to start services. Κατηγορία Πρόσωπα και ιστολόγια Άδεια Τυπική άδεια YouTube Εμφάνιση περισσότερων Εμφάνιση λιγότερων Φόρτωση... Διαφήμιση Αυτόματη αναπαραγωγή Όταν είναι ενεργοποιημένη η αυτόματη αναπαραγωγή, το επόμενο προτεινόμενο βίντεο παίζει Error resolved after going in to services.msc and manually restarting the service.

This solved a problem for me a while back. if (λ x . yaa this one worked July 07, 2012 - 2:45 am UTC Reviewer: gopi from bermuda triangle well bro the problem is solved....servces.msc works Annoying July 09, 2012 - 10:46 pm UTC I seriously doubt he is watching this thread any more. > Thank You ShreyasEdited by: EdStevens on Sep 26, 2012 6:43 AM Like Show 0 Likes(0) Actions Go to original post

I have checked the env variable for ORACLE_SID and ORACLE_HOME on Win7 and all look good I tried restarting the DB as well as Listener. Defect ID QCM 33197 Additional Information Occurs in Toad 9.5 See More Toad for Oracle Articles Feedback submitted. From the client try pinging the server. (For general guidance on troubleshooting general network connectivity problems see my notes on General Network Connectivity Problems.) Brian Brooks (Encorus Technologies, USA) has highlighted Check the Services panel.

Installation folder shows this name: Oracle - OraClient11g_home1 Followup January 17, 2013 - 8:30 am UTC then you do not need any services running, the database server does. When I tried to start an application I developed using odp.net, I got the following error message: "Could not load file or assembly 'system.EnterpriseServices,Version=2.0.0.0, Culture=neutral, PublicKeyToken=bo3f5f7f11d50a3a' or one of its dependencies. RE: Unable to find oracle services January 16, 2013 - 11:04 pm UTC Reviewer: Arshad from INDIA ///Followup January 16, 2013 - 12pm Central time zone: are you on the database Click continue to be directed to the correct support content and assistance for *product*.

i tried to install 8 times. if not started automatically you can start it. Mosarraf Hossen from Bangladesh Your service name (oracle) is not started properly. Oracle Troubleshooting ORA-12560: TNS:protocol adapter error Symptom: When starting server manager the following error is generated: ORA-12560: TNS:protocol adapter error occurred Cause: Oracle classify this as a ‘generic protocol adapter error'.

i checked my services.msc also but there was no entry for the oracleservicename10g in that....so what should i do????? It will get connected. When I tried to start an application I developed using odp.net, I got the following error message: "Could not load file or assembly 'system.EnterpriseServices,Version=2.0.0.0, Culture=neutral, PublicKeyToken=bo3f5f7f11d50a3a' or one of its dependencies. Please check that the Connection String for the database exists in the TNSNAMES.ora File. Now ...

ORA-12560: TNS - PROTOCOL ERROR December 05, 2013 - 2:52 pm UTC Reviewer: Raju Edaboina from India Even after restarting the oracleserver service, i am getting the same error(ORA-12560: TNS - Please hep me out. In that try to find OracleServiceXe->Right click->Start. Please help me out. For whatever reason the configuration lost the database entry I need. O.S is Windows XP SP3 and I downloaded Oracle software from OTN. It works! DBCA normally asks for the passwords of SYS and SYSTEM us...

To turn-on tracing for the ORA-12560, use these settings. 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 This is not likely to be a problem on a local network where DNS will take care of name resolution issues, but where the database server is on a remote network The "TNS-12560: TNS:protocol adapter error" sometimes a transient error on ...