Failed to connect to database instance [message #620724] |
Tue, 05 August 2014 10:39 |
|
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 |
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 #620836 is a reply to message #620740] |
Wed, 06 August 2014 09:49 |
|
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 |
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?
|
|
|
|
|
|
|
|
|
|