Oracle TNS: No Listener error while tnsping for my service

oracle oracle11g tns
Mohamed picture Mohamed · Feb 20, 2012 · Viewed 16.1k times · Source

I just Installed Oracle 11g on windows 7 64bit, and when I tried to ping using tnsping I faced this error TNS-12541: TNS:no listener.

So, I tried to start the listener using LSNRCTL> start also I faced this error:

TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error

Answer

Praveen Alur picture Praveen Alur · Oct 23, 2012

Set ORACLE_HOME and try starting the Listener again.

Related questions

Oracle listener not running and won't start

I am getting the following errors while from the lsnrctl status command: C:\Users\pna105>lsnrctl stat LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-OCT-2014 17:53 :55 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=…

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More
How do I do top 1 in Oracle?

How do I do the following? select top 1 Fname from MyTbl In Oracle 11g?

Read More