ORA-12514: TNS:listener does not currently know of service requestedin connect descriptor

[Database Administrator]

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

[Database Administrator]

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

[Database Administrator]

On Sun, 1 Jun 2008 03:10:04 -0700 (PDT), 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!
>
>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

[Database Administrator]

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

[Database Administrator]

On Jun 1, 3:45*pm, sybra...@hccnet.nl wrote:
> On Sun, 1 Jun 2008 03:10:04 -0700 (PDT), 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!
>
> >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?

Because I didn't know that the lsnrctl program exists at all.
I don't know much about the listener. Up to now, it simply worked, so
it was never necessary for me to use any admin tools for it.
I'm mainly a database developer, not an administrator. In my place, I
am just maintaing a database for development purposes.

> Or are you too lazy to troubleshoot and dumping the error rightaway?

Or did you recently undergo brain surgery, thereby removing your
brain's social interaction area?

Anyway, thank you for your help. It helped me along, and I ways able
to solve the problem.
I am understanding the listener now better.

Georg Scholz


>
> --
>
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

[Database Administrator]

On Jun 1, 12:29*pm, Robert Klemme 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

[gaurav_jain12]

Hi,

I am also facing the same issue.
Yesterday i have also applied the patch from 10.2.0.1 to 10.2.0.3 and got same error.
i have already taken the backup but as I am not able to start the database, i am not even able to restore/recover the backup.

Thanks
Gaurav Jain