Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
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