Database Administration (MOSC)

MOSC Banner

Listener supports no services - tried everything, listener won't work

edited Jan 16, 2015 3:29AM in Database Administration (MOSC) 8 commentsAnswered ✓

Hi all ... this is baffling. I'm running 11g on a virtual windows 2008 server, and it's a clone of a working system. Whatever I try I get "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor" when I try to connect via a listener (it works fine if I connect while avoiding the listener).

The weird thing is that I had this same problem on the original machine before I cloned this, and fixed it. But I can't remember what I did to fix it, it might have been putting a SID list in the listener.ora file, it might have been changing the order of elements in the PATH variable, it might have been eye of newt and toe of frog for all I know, it's a baffling and bewildering maze of permutations of things that I've tried.

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