Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Date: Sun, 01 Jun 2008 12:29:04 +0200
On 01.06.2008 12:10, Georg Scholz wrote:
> 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.
robert Received on Sun Jun 01 2008 - 05:29:04 CDT