Hi there,
Windows 2008 server x64
Oracle 11.2.0.3 x64
Client has been reporting very slow response time with the database; particularly with initial connection to the database. statspack reports do not appear to show anything unusual. What is though, and this may or may not have an effect on connection performance, is an abundant amount of ORA-12545 error messages in the alert.log from the database server, so much so that since May 1st the alert.log has grown 300MB in size for this error alone! The specific times do show messages in the listener.log however that log does not provide any error and just says that the connection had an "establish" flag.
Couple Questions
- Within the messages it states "Tracing not turned on." - which trace should be enabled and how so that I can further debug?
- When researching this error number, it seems as though this message should be on the client side and not in the database alert.log. This makes me believe that perhaps the database is trying to make connections to some other db or the like and is generating this error because the servers tnsnames.ora may not be configured for said connection. Is my premise wrong?
Here is the full error:
***********************************************************************
Fatal NI connect error 12545, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production
Time: 23-MAY-2014 10:37:57
Tracing not turned on.
Tns error struct:
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (7604) as a result of ORA-609
Thank you,
-joel