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)
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
Thank you! I played around with the lsnrctl tool, it simply was misconfigured due to the Patch.
Georg Scholz Received on Mon Jun 02 2008 - 11:25:51 CDT