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

From: Georg Scholz <georgscholz_at_gmail.com>
Date: Mon, 2 Jun 2008 09:25:51 -0700 (PDT)
Message-ID: <af585b09-af2e-40bd-b337-2a97960ae407@79g2000hsk.googlegroups.com>


On Jun 1, 12:29 pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On 01.06.2008 12:10, Georg Scholz wrote:
>
> > Hello,
>
> > I applied the patch from Oracle 10.2.0.1 to 10.2.0.3
> > (Machine: Windows XP, SP 2)
>
> > tnsping works fine.
>
> > However, wenn connecting with sqplplus or TOAD, I get the following:
>
> > ORA-12514: TNS:listener does not currently know of service requested
> > in connect descriptor
>
> > I get this on the server itself, and also on all client PCs.
>
> > Any help is highly appreciated!
>
> IIRC this can also happen if the listener thinks that no more
> connections are available.  In that case increasing PROCESSES is said to
> help.  In every case you should first do "lsnrctl status" to see whether
> the service is known to the listener.
>
> Kind regards
>
>         robert

Thank you! I played around with the lsnrctl tool, it simply was misconfigured due to the Patch.

Best regards
Georg Scholz Received on Mon Jun 02 2008 - 11:25:51 CDT

Original text of this message