Getting TNS-12545 and TNS-00515 in Sqlnet.Log Running OFSA Allocations
Last updated on MAY 24, 2017
Applies to:Oracle Profitability Manager - Version 4.5 to 4.5.39 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5 to 4.5.39
You get sporadic errors in the Sqlnet.log and Request Queue log when running 4.5 Performance Analyzer (PA) Allocations on the server after moving the Oracle Financial Services Applications (OFSA) installation from one server to another server. These errors only occur on the Server side local connections. Client-side connections do not get these errors.
The errors below are repeated over and over in the respective log files.
TNS-12206: TNS:received a TNS error during navigation
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: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 2
nt OS err code: 0
RQ log errors:
Tue Jul 20 09:34:31 2004 : Job number 25947 started with process id 24876.
Tue Jul 20 09:34:31 2004 : Process 24876: failed with unknown error. Status: 1009.
Tue Jul 20 09:34:31 2004 : Process ID 24876: completed with return code 1009.
Tue Jul 20 09:35:43 2004 : Job: 25948. Request: PING. User: OFSADEMO. Priority: 1. Application ID: 0.
Moved OFSA database instance to a new server.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms