Database Networking (MOSC)

MOSC Banner

TNS:NO LISTENER

edited Feb 28, 2012 11:39PM in Database Networking (MOSC) 4 commentsAnswered
Trying to tnsping to an 11G database.

I am connecting from a server with a 10G listener  to another server with 11.02 software and listener running.

tnsping orcl

I get tns no listener.

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.yy.x.zzz)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL)))
TNS-12541: TNS:no listener

The ORCL database resides on a server with 11.0.2 software .. This is from the lsnrctl services

Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this servi
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center