OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA 12519

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA 12519 [message #400218]

Mon, 27 April 2009 03:28

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Hi

I am getting the following error.

"Failed to connect to database: ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)."

Once i get this error I need to to restart the server.After that it will work for 1 day and again I will get the same problem.please let me know the reason

Report message to a moderator

Re: ORA 12519 [message #400220 is a reply to message #400218]

Mon, 27 April 2009 03:33

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Could be hundreds of reasons.

Check the alter log of the instance, and the listener log file.

Report message to a moderator

Re: ORA 12519 [message #400228 is a reply to message #400218]

Mon, 27 April 2009 03:56

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-12519: TNS:no appropriate service handler found
 *Cause: The listener could not find any available service handlers that
 are appropriate for the client connection.
 *Action: Run "lsnrctl services" to ensure that the instance(s) have
 registered with the listener, and are accepting connections

Regards
Michel

Report message to a moderator

Re: ORA 12519 [message #400238 is a reply to message #400228]

Mon, 27 April 2009 04:29

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

please let me know where and how can i check alter log of the instance, and the listener log file.

Report message to a moderator

Re: ORA 12519 [message #400242 is a reply to message #400238]

Mon, 27 April 2009 05:03

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

alert.log, see background_dump_dest
listener.log, most often $ORACLE_HOME/network/log

Regards
Michel

Report message to a moderator

Re: ORA 12519 [message #400244 is a reply to message #400238]

Mon, 27 April 2009 05:04

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Whoops, Typo. Should have been "alert log".

The alert log is in the background dump destination of the database. (Parameter background_dump_dest)

The location of the listener log file you can get with "lsnrctl status" on the database server.

Report message to a moderator

Re: ORA 12519 [message #400415 is a reply to message #400238]

Tue, 28 April 2009 02:04

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

please find the attached trace file

Attachment: Trace file 27 April.txt
(Size: 9.24KB, Downloaded 1425 times)

Report message to a moderator

Re: ORA 12519 [message #400419 is a reply to message #400415]

Tue, 28 April 2009 02:17

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

And what about the alert.log and the listener.log?

And what about the mentioned d:\oracle\product\10.1.0\db_1\rdbms\trace\orcljde_ora_2416.trc?

[Updated on: Tue, 28 April 2009 02:18]

Report message to a moderator

Re: ORA 12519 [message #400433 is a reply to message #400419]

Tue, 28 April 2009 03:39

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Today also I faced the same issues. Then I restarted again.

Attached is the recent trace file.

Attachment: trace file.txt
(Size: 4.70KB, Downloaded 1446 times)

Report message to a moderator

Re: ORA 12519 [message #400434 is a reply to message #400433]

Tue, 28 April 2009 03:40

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Please find the attached recent sqlnet.log

Attachment: sqlnet.txt
(Size: 90.68KB, Downloaded 1556 times)

Report message to a moderator

Re: ORA 12519 [message #400435 is a reply to message #400419]

Tue, 28 April 2009 03:40

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

ThomasG wrote on Tue, 28 April 2009 09:17

And what about the alert.log and the listener.log?

And what about the mentioned d:\oracle\product\10.1.0\db_1\rdbms\trace\orcljde_ora_2416.trc?

Report message to a moderator

Re: ORA 12519 [message #400447 is a reply to message #400435]

Tue, 28 April 2009 04:34

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Please find the atached trace file

orcljde_ora_2416.trc

Attachment: orcljde_ora_2416.trc.txt
(Size: 9.24KB, Downloaded 1433 times)

Report message to a moderator

Re: ORA 12519 [message #400453 is a reply to message #400435]

Tue, 28 April 2009 04:52

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

ThomasG wrote on Tue, 28 April 2009 10:40

ThomasG wrote on Tue, 28 April 2009 09:17

And what about the alert.log and the listener.log?

And what about the mentioned d:\oracle\product\10.1.0\db_1\rdbms\trace\orcljde_ora_2416.trc?

All those client-side trace files are useless. There you basically just see "database is gone".

You need to look in the alert.log of the SERVER to find the cause.

Report message to a moderator

Previous Topic:	Challenges of Oracle 10G over oracle 9i
Next Topic:	Install issues with Oracle XE setup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 14:57:51 CST 2024