Home » RDBMS Server » Networking and Gateways » Failed to connect to database instance (Oracle 11.2.0.2 , Linux 2.6)
Failed to connect to database instance [message #620724] Tue, 05 August 2014 10:39 Go to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Hi ,
I am getting this alert
Failed to connect to database instance: ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach

I found the following in alert log file.
 VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.4.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
  Time: 05-AUG-2014 23:25:08
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12599

TNS-12599: TNS:cryptographic checksum mismatch
    ns secondary err code: 2526
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

Can you tell me how to fix this?

Regards,
Re: Failed to connect to database instance [message #620726 is a reply to message #620724] Tue, 05 August 2014 10:50 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
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.
Re: Failed to connect to database instance [message #620727 is a reply to message #620726] Tue, 05 August 2014 10:53 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Another thing,

You mentioned DB version as 11.2.0.2 in the topic title, however, your alert log says it is 11.2.0.4?
Re: Failed to connect to database instance [message #620732 is a reply to message #620724] Tue, 05 August 2014 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Quote:
Can you tell me how to fix this?


Can you tell us what you searched, read and tried before posting this?

Re: Failed to connect to database instance [message #620736 is a reply to message #620727] Tue, 05 August 2014 11:38 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Hi Lait,
Quote:
You mentioned DB version as 11.2.0.2 in the topic title, however, your alert log says it is 11.2.0.4?

Sorry its a typo error Razz

Anyway Thank you for your suggestions

[Updated on: Tue, 05 August 2014 12:00]

Report message to a moderator

Re: Failed to connect to database instance [message #620740 is a reply to message #620736] Tue, 05 August 2014 11:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Typo? I don't know why but I doubt...

Re: Failed to connect to database instance [message #620836 is a reply to message #620740] Wed, 06 August 2014 09:49 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
I received alert saying "Failed to connect to database instance " but i was able to connect to the database as below.

/ORCL/bdump>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 6 17:47:21 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>


I found following in the alert log file during the alert triggered.

Process P002 died, see its trace file
Wed Aug 06 17:30:25 EEST 2014
Process P003 died, see its trace file
Wed Aug 06 17:30:26 EEST 2014
Process P002 died, see its trace file
Wed Aug 06 17:30:53 EEST 2014
Process P002 died, see its trace file
Wed Aug 06 17:30:54 EEST 2014
Process P003 died, see its trace file
Wed Aug 06 17:30:55 EEST 2014
Process P002 died, see its trace file

Can you tell me what went wrong from database side ?

Regards,
Re: Failed to connect to database instance [message #620839 is a reply to message #620836] Wed, 06 August 2014 10:04 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Quote:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0


Because you are connecting to a different database.

First you said your DB version is 11.2.0.2 in the topic title, later in your post the alert log showed it's 11.2.0.4. And now you connected to 10.2.0.5?

Can you please explain?
Re: Failed to connect to database instance [message #620849 is a reply to message #620839] Wed, 06 August 2014 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Quote:
Can you please explain?


Is it necessary? He is just stupid.
Don't forget he is a liar and a fraud (in addition to be stupid).

Re: Failed to connect to database instance [message #620857 is a reply to message #620849] Wed, 06 August 2014 12:11 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Lalit,

I will explain you .Don't listen to that crap.waste of time..
Quote:

First you said your DB version is 11.2.0.2 in the topic title, later in your post the alert log showed it's 11.2.0.4. And now you connected to 10.2.0.5?

The alert i received this time for Oracle version 10.2.0.5 .Earlier it was for 11.2.0.4 version means i am getting same alert
from different databases.
How to stop this alert triggering from different databases ?

Regards,
Re: Failed to connect to database instance [message #620863 is a reply to message #620857] Wed, 06 August 2014 12:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You're On Your Own!
Re: Failed to connect to database instance [message #620864 is a reply to message #620857] Wed, 06 August 2014 12:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Quote:
How to stop this alert triggering from different databases ?


Drop the databases.

Re: Failed to connect to database instance [message #620898 is a reply to message #620864] Thu, 07 August 2014 00:02 Go to previous messageGo to next message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Quote:
Drop the databases.

Does this make sense ?

Dees this act like a professional ?
Re: Failed to connect to database instance [message #620901 is a reply to message #620898] Thu, 07 August 2014 00:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Does this make sense ?
It accomplishes the goal to eliminate the errors.
Re: Failed to connect to database instance [message #620915 is a reply to message #620901] Thu, 07 August 2014 03:18 Go to previous message
ora_2014
Messages: 41
Registered: July 2014
Location: india
Member
Quote:
It accomplishes the goal to eliminate the errors

Then what everybody can do is drop the databases they own so that no issue we encounter and we could relax ourselves. Smile

[Updated on: Thu, 07 August 2014 03:32]

Report message to a moderator

Previous Topic: Listener response to a TNS ping
Next Topic: SQLNET.AUTHENTICATION_SERVICES=(NTS,NONE)
Goto Forum:
  


Current Time: Tue Nov 26 22:05:56 CST 2024