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

From: <sybrandb_at_hccnet.nl>
Date: Sun, 01 Jun 2008 15:45:23 +0200
Message-ID: <ns95445pgmp533karpla8a74rhrk6laei1@4ax.com>


On Sun, 1 Jun 2008 03:10:04 -0700 (PDT), Georg Scholz <georgscholz_at_gmail.com> 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!
>
>Thank you
>Georg Scholz
>
>

You did look up the error message?
So why didn't you run
lsnrctl services
to verify whether this is true?
Or are you too lazy to troubleshoot and dumping the error rightaway?

--

Sybrand Bakker
Senior Oracle DBA
Received on Sun Jun 01 2008 - 08:45:23 CDT

Original text of this message