Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
From: Urs Metzger <urs_at_ursmetzger.de>
Date: Sun, 01 Jun 2008 16:30:09 +0200
Message-ID: <g1ubnc$sp$1@online.de>
>
> 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
This is ORA-12500, IIRC
Date: Sun, 01 Jun 2008 16:30:09 +0200
Message-ID: <g1ubnc$sp$1@online.de>
Robert Klemme schrieb:
> 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
This is ORA-12500, IIRC
Regards, Urs Metzger Received on Sun Jun 01 2008 - 09:30:09 CDT