Home » RDBMS Server » Server Administration » ORA 12519
ORA 12519 [message #400218] Mon, 27 April 2009 03:28 Go to next message
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
Re: ORA 12519 [message #400220 is a reply to message #400218] Mon, 27 April 2009 03:33 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.
Re: ORA 12519 [message #400228 is a reply to message #400218] Mon, 27 April 2009 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA 12519 [message #400238 is a reply to message #400228] Mon, 27 April 2009 04:29 Go to previous messageGo to next message
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.
Re: ORA 12519 [message #400242 is a reply to message #400238] Mon, 27 April 2009 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alert.log, see background_dump_dest
listener.log, most often $ORACLE_HOME/network/log

Regards
Michel
Re: ORA 12519 [message #400244 is a reply to message #400238] Mon, 27 April 2009 05:04 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.
Re: ORA 12519 [message #400415 is a reply to message #400238] Tue, 28 April 2009 02:04 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
please find the attached trace file
Re: ORA 12519 [message #400419 is a reply to message #400415] Tue, 28 April 2009 02:17 Go to previous messageGo to next message
ThomasG
Messages: 3189
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 Go to previous messageGo to next message
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.

Re: ORA 12519 [message #400434 is a reply to message #400433] Tue, 28 April 2009 03:40 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member

Please find the attached recent sqlnet.log
  • Attachment: sqlnet.txt
    (Size: 90.68KB, Downloaded 386 times)
Re: ORA 12519 [message #400435 is a reply to message #400419] Tue, 28 April 2009 03:40 Go to previous messageGo to next message
ThomasG
Messages: 3189
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?


Re: ORA 12519 [message #400447 is a reply to message #400435] Tue, 28 April 2009 04:34 Go to previous messageGo to next message
nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE
Junior Member
Please find the atached trace file

orcljde_ora_2416.trc
Re: ORA 12519 [message #400453 is a reply to message #400435] Tue, 28 April 2009 04:52 Go to previous message
ThomasG
Messages: 3189
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.
Previous Topic: Challenges of Oracle 10G over oracle 9i
Next Topic: Install issues with Oracle XE setup
Goto Forum:
  


Current Time: Fri Dec 09 15:24:03 CST 2016

Total time taken to generate the page: 0.12775 seconds